Database Enhancements
- Last Updated: September 9, 2024
- 2 minute read
- OpenEdge
- Version 12.8
- Documentation
OpenEdge provides Database Administrators with reduced database maintenance and improved operations, corruption repair, and operational productivity. They can perform storage optimizations without downtime.
This section details the enhancements introduced in
the OpenEdge 12.8 LTS release.
- Database Maintenance Database Administrators perform resource-efficient online reorganization of data, faster restore for compressed DB backups, and quicker record and key validation in index check to detect and repair integrity issues.
- Database OperationsOpenEdge elevates database management by providing more capabilities to Database Administrators such as, helping in monitoring and improving supportability.
- Back up the Running Databases Faster
- Configure Databases Persistently
- Monitor the Status of After-Image Management Daemon
- New VST Fields for OpenEdge Version and RDBMS Edition
- Obtain OS Read Counts at User Level
- Probe the Database Online State
- Provide Private Buffer VST Information
- Reorganize Table Using Sorting by Non-unique Indexes
- Resolve the Record Lock Conflicts Faster
- Validate Record Keys with Faster Index Check
- Database StorageOpenEdge provides the ability to clean up unused index blocks, large file support for all OpenEdge versions, and data storage areas to be truncated online.
- Operational ProductivityOpenEdge provides enhancements that speed up error detection and resolution, and immediately auto-recover to get systems up and running within seconds.
- After-image file summary
- Cancel SQL queries via ODBC clients
- Database backup with improved compression
- DataServer support for server-side single table aggregation
- Deactivate CDC feature on a database without a CDC license
- Describe basic information for a backup file
- Detect and match numeric and data formats to adjust runtime session settings
- Improved index compacting utility
- Improved performance for index fix utility
- Truncate and move LOB online
- Truncate the before-image file on a replication target database
- Uniquely identify the PAS session connected to a database
- VST datetime with time zone support
- Repair Database CorruptionOpenEdge detects and repairs database corruption by offering offline support for additional diagnostics utilities, expanded record deletion, reduced overhead processing, and more detailed data about corrupt records.