Progress OpenEdge 10'1B

1
Progress OpenEdge 10.1B
Enhanced Large Scale Data Management Providing
a Technology Platform Enterprises can Depend on
Today and Grow with into Tomorrow
2
Progress OpenEdge 10.1B

• Introduction
• Whos Progress
• The needs of our growing customer
• OpenEdge 10.1B
• High-level Market opportunity
• Key product highlights
• The word on the street
• QA

3
Progress Software Corporation
Application Infrastructure SoftwareUsed to
develop, deploy, integrate and managebusiness
applications
Server-centric
Client-server
Web
SOA
4
OpenEdge, Maintaining The Focus On
Service-Oriented Architecture
5
What Does OpenEdge 10.1B Do Better

• OpenEdge 10.1B provides
• Standards based business platform enhanced to
  support enterprise-scale application development,
  data management and deployment
• OpenEdge RDBMS and ABL delivers
• Better scalability and availability across large
  disparate databases
• Better management and administration of
  enterprise data
• Better system performance
• Ensuring your business will not outgrow
  OpenEdgesurpassing customers needs

6
The Needs of Business were Simple

• Drive increased revenue
• Decrease the cost of doing business

7
The Needs of Business were Simple

• Drive increased revenue
• Decrease the cost of doing business

Macroeconomic trends lead to .
. More Sophisticated Business Requirements
. New IT imperatives
. OpenEdge enhancements
8
Business Trends lead to Business Challenges
Macroeconomic trends lead to .
. More Sophisticated Business Requirements

• Increased globalization
• Increasingly pervasive governmental regulations
• Increased competition from new sources
• Increased Merger and Acquisition activity
• Driving down profits

• Ability to play in global markets and through
  multiple channels
• Global operations and Supply Chain
• Security and Compliance
• Better visibility into the health of the business
• Business Intelligence to make better business
  decisions
• Integrated business operations
• Business Continuity
• Agility to respond to threats and opportunities

9
Sophisticated Business Requirements lead to
New IT imperatives
OpenEdge 10 enhancements
Migration
Upgrade
10
Upgrade vs. Migration
There are significant advantages, even if you
only upgrade

• Benefits

• Enhanced developer productivity
• Globalization support
• Compliance and security

• Support for n-tier architectures
• SOA support
• OERA guidance

• Greater uptime
• Higher performance
• Platform support

Level of effort
For the Operations team
For the Development team
For the Business
Transformation Update your applications
architecture to significant enhance its capability
Migration Leverage OpenEdge enhancements by
performing incremental development
Upgrade No development work required
11
Myths and Truths

• Myths about OpenEdge 10
• 1 Its a new product, not an evolution of
  Progress 9
• 2 Its hard to upgrade to OpenEdge 10
• 3 Its all about Service-oriented
  architectures (SOA) and application
  transformation if Im not ready, theres no need
  to upgrade

Truths about OpenEdge 10 1 Its an evolution
that builds on the benefits you already know 2
Upgrading is straight-forward and there are many
benefits that require no development work 3
Change is constant and OpenEdge continues to
provide our developers practical innovation to
keep up with change
12
Progress OpenEdge 10.1B

• Introduction
• Whos Progress
• Types of Customers
• The needs of our growing customer
• OpenEdge 10.1B
• High-level Market opportunity
• Key product highlights
• The word on the street
• QA

13
The needs of the business fall on the shoulders
of IT
Improve business processes Improve revenue
streams Decrease cost of business Comply with
governmental regulations
Deploy the applications with a minimum of
cost Maintain applications in production with
fewer resources and greater uptime
Constraints on human resource, time and
budget Develop new functionality
14
Enhanced development productivity
Benefits Satisfy business drivers through rapid
enhancementsLower development costsLeverage
existing assets skills

• OpenEdge 10 advances
• OpenEdge Architect
• Advanced Business Language
• Object-oriented language enhancements
• Allows combination of procedural and
  Object-oriented programming
• Business Tools
• ProDataSet Designer
• Enhanced debugging
• Addition of Common Infrastructure Services
• Auditing Security

15
Continued technology advances
Benefits Streamline business operations through
integrated IT systems Ability to compete in
global markets Compliant and secure
systems Enhance business intelligence

• OpenEdge 10 advances
• Platform independence
• Integration with .NET and Java-based systems
• Leverage multiple UI technologies
• XP look and feel added to character UI, Web,
  Java .NET
• 64 bit environments
• Application modernization and integration
• Leverage Service Oriented Architectures
• Produce and consume Web services
• Tight integration with Sonic products
• Globalization support
• Unicode, codepage and datatype enhancements
• Compliance and security
• Auditing included as a Common Infrastructure
  Service
• Cryptographic functions, channel encryption

16
Continual uptime and high availability
Benefits Greater uptime to service the business
24x7 Ability to recover from disasters business
continuity

• OpenEdge 10 advances self-sustaining database
• On-line maintenance
• Schema changes
• Database extents
• Backup
• Failover and failback
• Management and replication

17
Database performance and scale
Benefits Greater ability to satisfy the business
needs through responsive applications Speedier
access to data for reporting Rapid administrative
functions

• OpenEdge 10 advances
• Increased performance in
• Joins
• Index rebuilds
• Checkpoints
• Dataservers are faster
• SQL engine performance increased
• Data clusters
• Connectivity
• Large table support

18
Compliance and security
Benefits Comply with governmental
regulation Secure business-critical data from
unauthorized use

• OpenEdge 10 advances
• Auditing service
• Security
• Channel encryption (on the wire)
• Channel encryption between OpenEdge components
  (e.g., OE10 client to OE10 AppServer using SSL)
• 4GL support for cryptographic operations
• DES, DES3, AES for encryption
• MD5, SHA for data integrity

19
Installation, configuration and platform support
Benefits Leverage existing hardware assets
server consolidation Rapidly upgrade applications
take advantage of technology advances

• OpenEdge 10 advances
• Simpler installation
• Rapid migration from V9
• Greater assistance through documentation and
  online help
• Install from network or DVD
• Platform support

20
OpenEdge Scales for Tomorrows Needs
Tenure withProgress
Customers
gt14 years
gt14 years
gt15 years
gt10 years
gt15 years
gt15 years
Carrier Logistics
gt20 years
21
RDBMS and Data Dictionary

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

22
10.1B The Enterprise Release
Keep the database running

• Improvements essential for enterprise customers
• Large database features
• INT64 data type
• 64-bit database keys
• 64-bit Sequences
• Large index entries
• 32000 areas per database
• Ongoing online maintenance improvements

23
Previous limits
24
The Need for Large Database Support

• 2 billion row limit
• A result of 32 bit structures
• High transaction volumes
• Auditing
• Can generate high volumes of records
• 24 365 environments
• Maximum database size of 32 exabytes
• 1 exabyte 260 or 10246 bytes
• 5 exabytes sum of all printed material

25
Agenda

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

26
Large Database Features

• INT64 data type
• 64-bit Sequences
• Large index key entries
• 1000 area number limit

27
INT64 Data Type
64-bit integer data type

• Available to all 10.1B databases
• Store integers gt 2GB
• INTEGER range
• -2,147,483,648
• 2,147,483,647
• INT64 range
• -9,223,372,036,854,775,808
• 9,223,372,036,854,775,807

28
INT64 Data Type
64-bit integer data type

• INT64 can be used for
• New database fields
• Existing INTEGER fields
• One way conversion only
• Dump and load NOT required
• No manual conversion required
• Index rebuild NOT required
• Exclusive schema-lock required
• Re-compile IS necessary

29
Enabling 64-bit Sequences

• Enabled by default on new databases
• Explicitly enable on migrated databases
• Physically alters Sequence block structure
• Converts fields to INT64
• Can be run online or offline

proutil dbname C enableseq64
30
Large Index Key Entries

• Removes the 192 byte limit
• 3 bytes per Unicode character
• Allows 1970 bytes of user data
• 4K and 8K block sizes only
• Includes temp-tables
• Large keys enabled by default on new databases

Includes component separator flags so not
necessarily the number of characters that can be
stored in an index entry
31
Enabling Large Index Key Entries
Enabling large index keys on migrated databases

• Enable with PROUTIL
• Run online or offline
• Enable with Data Admin / Data Dictionary
• Enable with OpenEdge Architect

proutil dbname C enablelargekeys
32
Removal of 1000 Area Limit

• Area numbers up to 32000 allowed
• Extents per area increased to 1024
• 32000 areas assumed
• Restrict maximum area number with startup
  parameter -maxAreas

-maxAreas nnnnn
33
Reverting a Database

• Back up the database before starting!!
• Run PROUTIL REVERT
• Changes internal structures back 10.1A
• Replaces VSTs
• Disables 2PC, JTA, Replication, AI Management
• Truncates the .bi file
• Backup the database again

proutil dbname C revert
34
Sometimes Theres No Going Back

• Cannot revert a database if
• INT64 data type in use
• Any Type 2 storage area has a 64-bit block HWM
• Including any LOBS have segments using 64-bit
  block values
• Large index keys enabled
• Large sequences enabled
• Highest database area number exceeds 1000

35
Agenda

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

36
Shared Memory Limits
Shared memory segment size 32 bit platforms

• Old limits

Shared memory
2GB
128MB
128MB
128MB
128MB
128MB
128MB
128MB
128MB

37
Shared Memory Limits
Shared memory segment size 32 bit platforms

• Old limits
• New Limits

Shared memory
2GB
4GB
128MB
4GB
128MB
128MB
128MB
128MB
128MB
128MB
128MB

38
Setting Shared Memory Segment Size
Examples

• Setting 4GB Segment size

proserve bigdb101B -H localhost -N TCP -S 3088
-shmsegsize 4G
proserve bigdb101B -H localhost -N TCP -S 3088
-shmsegsize 4096
39
Agenda

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

40
User I/O By Table and Index
New Virtual System Tables

• Monitor table and index activity per user
• What I/O are users doing?
• Creates, reads, updates, deletes
• How is a query performing?
• VSTs included in 10.1B databases
• Table I/O per user _UserTableStat
• Index I/O per user _UserIndexStat

proutil dbname C updatevst
41
PROMON and User I/O by Table and Index

• User I/O available from PROMON
• RD menu, Other Displays menu

42
Agenda

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

43
Enable AI Online

• Enable after imaging without taking the database
  down
• AI files must already exist
• Can be added online
• Online backup used as basis for roll-forward
• Must manually start
• AI writers
• Replication

probkup online Sports2000 enableai s.bkup
44
Enable AI Online with AI Management

• Enable AI Management when enabling AI
• Archive directory must exist or backup will fail
• On failure
• AI is not restarted
• AI Management not restarted

probkup online Sports2000 enableai s.bkup
enableaiarchiver aiarcdir ltarcdirgt
45
Agenda

• The Enterprise Release
• Large database features
• Shared memory limits
• User I/O by table / index
• After imaging
• Long dump names

46
Long Dump File Names
Create and Update Table Properties

• Up to 32 characters now supported

47
Summary

• OpenEdge 10.1B RDBMS Features
• Large databases
• Shared memory limitations removed
• User I/O by table / index
• Enable after imaging online
• Long dump names

48
The OpenEdge Platform
Development

• Application Development
• OpenEdge Architect
• Additional Developer Tools
• Application and Data Integration
• SonicMQ
• Sonic ESB

Operations

• Data Management
• OpenEdge RDBMS
• OpenEdge DataServers
• OpenEdge Application Servers
• OpenEdge Connectivity to Sonic
• Business Continuity
• OpenEdge Management
• OpenEdge Replication

49
OpenEdge 10.1B in the Spotlight

• Not a watered-down SMB solution, but a solution
  that scales with true enterprise performance

• Enterprise strength specifically for SMBs

• Keep data online in memory data storage
  increased to more than 9 quintillion! Meaning
  Progress could store all of the worlds written
  literature

• Enhanced support for 24X365 production
  environments

• Product components scale tomeet enterprise needs

• Ensuring customers will not outgrow
  OpenEdgesurpassing customers needs

• Leverage procedural programming object
  orientation without having to change the entire
  application

• Strengthened the marriage of ABL with Object
  Oriented concepts

• Extensible, standards-based development platform
  to accelerate productivity

• OpenEdge Architect built on Eclipse 3.2.

• Provides more screen real estate forimproved UIs
  enhancing application look feel and usability

• Support for high resolution displays

• Optimized to run on 64-Bit Linux PowerPC

• Broaden platform support

50
Questions?
51
Why Upgrade to OpenEdge ?
Security SSL Auditing
Large Database Support 64 bit Rowids 64
bit Sequences 64 bit Integer Datatype
Large Index Key Entries (1970) 32,000 areas
Datatype Support BLOB, CLOB Date/Time,
Date/Time w/tz int 64
Performance Type II Storage Areas Increased
addressable shmem Larger Shmem segment support
Internal protocol enhancements Buffers,
Locks, Indexing Auto Record Defrag
Maintenance .st file syntax checker AI
management More online maintenance Multi
threaded utilities Log File New format
Significant events Improved log file
management Db I/O by User by Object
High Availability Online Schema changes
Online space management Enabled/Disable ai
online