Try OpenEdge Now
skip to main content
New and Revised Features
What's New in 11.7 : OpenEdge RDBMS
 

OpenEdge RDBMS

OpenEdge Release 11.7 includes the following new features for the OpenEdge RDBMS:
*Change Data Capture — The RDBMS fully supports CDC. See OpenEdge Change Data Capture for details.
*Replication — The RDMS supports enhancements to Replication. See OpenEdge Replication for details.
*Database Client Notification
Database Client Notification is a communication mechanism between clients and the database, informing clients of the need to refresh their schema cache. Notification enables a more timely completion of certain database administrative actions, such as activating an inactive index. Prior to OpenEdge Release 11.7, certain database utilities required clients to disconnect, even though the utility can execute while the database is online. The disconnect of the clients is required because these utilities update index schema. Database Client Notification allows clients to remain connected and refresh their schema in step with the utility execution. Notification enables the index activation processes to move to completion more rapidly.
Utilities supported by database client notification are
*PROUTIL IDXACTIVATE
*PROUTIL LOAD (with buildindexes)
*PROUTIL MTIDXBUILD
*PROUTIL TPIDXBUILD
Database client notification is controlled by a server startup parameter, -usernotifytime, that indicates how often a client polls for notification.
*Monitoring enhancements
Updates have been made to many VSTs and PROMON to provide greater access to data that can help programmatically monitor a running database for tuning, diagnostics, and health checking purposes.
The following table provides a list of fields added to existing VSTs. The VSTs are updated to provide greater access to data that can help programmatically monitor a running database for tuning, diagnostics, and health checking purposes.
VST Table name
Field name
_ActBuffer
_Buffer-Active
_Buffer-Area
_Buffer-Control
_Buffer-Free
_Buffer-Index
_Buffer-Master
_Buffer-Object
_Buffer-ObjList
_Buffer-RM
_Buffer-Seq
_AreaStatus
_AreaStatus-AIActivated
_AreaStatus-AI-Seq
_AreaStatus-State
_AreaStatus-LastOp
_AreaStatus-Type
_Checkpoint
_Checkpoint-Cluster
_Checkpoint-Number
_Connect
_Connect-NumSeqBuffers
_Connect-NumTrans
_Connect-UsedSeqBuffers
_Connect-UserMisc
_DbStatus
_DbStatus-ZeroStatsDate
_Logging
_Logging-AISequence
_Logging-BIClusterHWM
_Logging-CurrBICluster
_StatBase
_StatBase_BaseUserIndex
_StatBase_BaseUserTable
_UserIO
_UserIO-BiRecRead
_UserIO-BiRecWrite
_UserLock
_UserLock-HWM
_Trans
_Trans-BIRecReads
_Trans-BIRecWrite
_Trans-JTA-State
_Trans-JTA-Flags
_Trans-XID
Startup parameters to control the VSTs are also added:
Parameter name
Description
Base user index (-baseuserindex)
Specify the first index for which statistics are collected in the_UserIndexStat VST.
Base user table (-baseusertable)
Specify the first table for which statistics are collected in the_UserTableStat VST.
Number of checkpoint statistics (-numcheckpointstats)
Specify the number of rows maintained in the_Checkpoint VST.
Record free chain search depth factor (-recspacesearchdepth)
Specify how far into the record free chain the database engine searches for a block with enough free space to store the data associated with a record create or update before a new cluster of data is allocated.
User index range (-userindexrangesize)
Specify the number of rows maintained in the_UserIndexStat VST.
User table range (-usertablerangesize)
Specify the number of rows maintained in the_UserTableStat VST.
*DBTOOL — DBTOOL is enhanced with a new option to fix a rare case of schema corruption in the _user table when converting a database with PROUTIL CONV1011 that has over 65535 rows in the _user table.
*IDXCHECK — PROUTIL IDXCHECK is enhanced to detect index corruption caused by indexes straddling the 32/64 bit boundary.
*ZEROSTATS — PROUTIL ZEROSTATS is added to reset all runtime statistics for the database, including I/O statistics and latch and lock information.
*PROQUIET — PROQUIET is enhanced with the option to mark a database as backed up (similar to RFUTIL MARKBACKEDUP) when terminating a quiet point.
For more information on these topics, see:
Manual:
OpenEdge Data Management: Database Administration
Online help:
Database Administration Utilities