OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • fix idxcheck utility to finish scanning the entire index in the event that there...

    sequence corruption breaks the idxcheck utility by causing it to either loop indefinitely if the recid sequence corruption is pointing backwards to a previously scanned recid, or will cause it to skip past recids completely if pointed forward towards...
  • OpenEdge should support Cancel request for long running SQL queries through JDBC...

    A normal user runs a SQL query with a tool like Squirrel and noticed that a function needs longer than expected. (a bad written function can result in a full table scan!) Pressing "Cancel" has no effect because OpenEdge still doesn't not...
  • Make TDE tenant configurable

    At this point, since all multi-tenant objects need to reside in Type II areas, it's is not possible to configure TDE per area / tenant. It's only possible to enable TDE per table / index / LOB which means that each of those would result in encryption...
  • Add indexes to _file and _index

    I often want to iterate over the application-specific records in _file or _index, e.g.: for each _file no-lock where _tbl-type = 't': // do stuff end. for each _index no-lock where not _index-name begins "_": // do other stuff end...
  • Make offline and online backup to show same output.

    Probkup offline and online output different outputs. Could online backup gain those two lines in bold from offline backup? Offline backup: 0 BI blocks will be dumped. (6688) The blocksize is 8192. (6994) Backup requires an estimated 885.0...
  • Permit cross-platform database restore

    Restore of an OpenEdge database backup is currently only possible on the same platform (OS and hardware architecture) on which the backup was taken, e.g. from Windows to Windows, Linux x64 to Linux x64, Linux PPC to Linux PPC, etc. Enhancement request...
  • Add functionality to run script before db start

    We often have a situation where we identify some maintenance that needs to be done on a database that is offline. The problem is that often the person who ends up doing the database restart isn't someone who would know what they are doing to perform...
  • Provide index cursor statistics in VSTs or promon

    • Under Review
    • 0 Comments
    Although the 4GL client provides various logging options to record the creation and deletion of dynamic objects, we are finding in certain circumstances that it is very difficult to identify which specific client might be responsible for non-reproducible...
  • SQL Role: DataReader

    Currently it's very painful to grant read rights to all tables (now and in the future) for individual users. It's not possible and needs to be refreshed if new tables are added. It would be great to have a role DataReader which can be applied...
  • Improved database authentication (primarily Active Directory and LDAP)

    • Under Review
    • 0 Comments
    The lack of network authentication to the backend is a significant hole in the current database product, especially at scale. Other major databases generally allow for database authentication via Active Directory or LDAP (e.g. Oracle, MS SQL, etc.). Advantages...