From database performance to high-availability to the development experience and security, the latest OpenEdge 12.1 release packs a lot of improvements. Check out everything that's new and how it can enhance your applications today.
The latest release of Progress OpenEdge 12 shipped in August this year. This release contains enhancements for database high-availability, increased database performance, strengthened security and improvements for developer productivity. I am very excited to share with you the high-level details of OpenEdge 12.1 enhancements and how they benefit your application in the following categories:
Updated database startup defaults and extended server-side joins and improved performance
Additional database parameters supported online and improved OpenEdge Replication integration
Enhanced development experience and updated deployment options
Enhancements in authentication and logging processes offer greater protection and easier debugging
As business applications continue to work with more users and more data, we continue to explore ways to make both your application and the database work faster and extensively scale, all while minimizing the changes required by you. In this release we delivered the following enhancements:
DBAs have increased flexibility with the ability to extend and mark variable-length extents as fixed as well as create and extend new variable-length extents.
The maximum number of unique shared sequences in an OpenEdge database has been increased to 32K regardless of block size. The maximum number of multi-tenant sequences is now 2000.
The server-side execution has been extended to dynamic queries with forward-only, no-lock joins on the database server to improve performance of ABL queries that join multiple tables. Because fewer records are returned to the client, database performance is improved.
-aibufs, -bibufs, -lruskips, -lru2skips, -pica, -prefetchDelay, -prefetchFactor, -prefetchNumRecs, -prefetchPriority, -Mm, -Mxs
Gone are the days when you can bring down a business application for long periods of time to perform maintenance. Users demand uninterrupted access. The following enhancements allow you to conduct maintenance activities with the database not only online but also without exclusive locks:
Eliminate disruption to users with continual database availability by modifying startup parameters on running databases with new menu options in PROMON or through Virtual System Tables (VSTs). Also modify encryption and security cache sizes -ecsize & -secsize) using PROUTIL INCREASETO.
Change fields in the _File and _Field tables and Modify Integer fields to Int64 without an exclusive schema lock.
Validate replication-enabled source and target databases as well as confirm the status of target database brokers. Validates [server], control-agent], and [transition]properties.
Readily identify the status of replication databases using new information useful for managing application failover thus reducing application downtime during a planned database failover. Fields have been added to the _Repl-Server field descriptions and _DbStatus VST field.
Along with expectations for the database to be updated online, users do not want to experience downtime for a new version of an application to be deployed. PAS for OpenEdge is designed to provide fault-tolerant ABL sessions. These enhancements provide various online capabilities to enable updates and troubleshooting without forcing users to disconnect:
The TCMAN refreshagents command terminates all sessions so that updates to an ABL application can be made in real-time. Refresh sessions with new features such as online schema changes without bringing the application offline. Can also be used to mitigate memory leaks in an ABL application.
Gain insight into any multi-session agent crash, even in production, with no performance impact. Using a rolling in-memory log that is automatically refreshed on request boundaries, diagnostics and troubleshooting information is always available in the event of an agent crash.
The GET-ACTIVE-REQUESTS-ON-SERVER API captures details about currently active requests to improve visibility into the requests being processed by a PAS for OpenEdge instance. Enhanced data to troubleshoot performance and availability issues.
Improved developer experience is always a goal and 12.1 added some useful and regulatory changes:
Improved coverage and AST (Abstract syntax Tree) accuracy simplifies ABL development and increases developer productivity while developing code in PDSOE.
Promote team development using relative paths to a schema when creating new Business Entities and Data Object Service catalogs.
In keeping with recent changes to Oracle’s licensing of Java, these are no longer included with OpenEdge and are now considered prerequisites for installation. You can:
A new JAVA_HOME environment variable has been added to $DLC/properties/java.properties file.
Deployment takes on many forms and can be very complicated for an enterprise business application. This release simplifies deployment with a newly architected PAS for OpenEdge container with logging, updated third-party components and a new Windows installer for Client Networking.
The Baseline PAS for OpenEdge container saves time with pre-built production-grade deployments. 12.1 uses a new side-car pattern so you can deploy your OpenEdge applications alongside a highly-available cluster of PAS for OpenEdge containers.
Fluent Bit support utilizing standard out with PAS for OpenEdge.
Provides monitoring capability for PAS for OpenEdge.
A separate Windows Install package is now available.
OpenEdge Client JARs are upgraded to support the latest Aurea Sonic 2018 release.
Release 12.0 already introduced numerous security improvements and new features. In this release you will find the following enhancements:
New tenancy log entry type Sec.TenancyTrace for the PAS for OpenEdge agent log file logs database access from ABL to tenant data. This provides:
PAS for OpenEdge supports client authentication where the digital certificate is managed by the client. Authentication is done over HTTPS which insures the security of the connection and encryption. This functionality strengthens authentication by requiring that ABL clients authenticate themselves to PAS for OpenEdge.
And last, but not least, are some miscellaneous enhancements:
Access Agents replaced by Core Licensing
The Solaris 64-bit is back in release 12.1!
You can find more details on these and other features on the Progress Information Hub:
Release 12.1 is the first release following a major OpenEdge platform upgrade. It contains bug fixes, performance enhancements as well as the feature enhancements identified in this article. Check out an overview of everything that’s new, and for a deeper dive, feel free to check out our on-demand webinar, Progress Talks OpenEdge 12.1 Live.
If you have been watching and wondering if you should move your OpenEdge application from a prior version to Release 12, I can tell you that the answer is an unequivocal YES. I can assure you that 12.1 is a powerful and exceptional release. Try 12.1 today or contact your account manager to learn more.
Shelley Chase, a Software Fellow with Progress Software for over 20 years, takes a whole product view over the company’s core product, OpenEdge. Her technical skills and customer-driven focus drive the architectural direction of the product. Shelley is extremely talented in system architecture, object-oriented programming, and cloud deployment technologies. Her passion is to provide a well-architected product with an excellent user experience and works with engineers, product managers and services to guarantee success. Shelley has a patent for her work on “Alternate Presentation Types for Human Workflow Activities.”
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
You have the right to request deletion of your Personal Information at any time.
You can also ask us not to pass your Personal Information to third parties here: Do Not Sell My Info
Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.