OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Need datatype for efficient usage of GUID unique ID

    Hi, currently we are using a CHARACTER - GUID ("eb149dfe-c01f-50ac-3a14-66c56c902384") in many tables for unique ID. Analyses of database storage shows that this is highly inefficient on storage and most likely on performance as well. ...
  • Allow 0 column size string parameters in the ODBC driver

    Currently, the ODBC throws an error if an application calls SQLBindParameter for a string parameter and specifies a column size of 0. This is common behavior for ODBC wrapper libraries, particularly in dynamic languages; there is a workaround option for...
  • Ability to query database and object sizes using VSTs or other similar mechanism

    • Under Review
    • 0 Comments
    We want to be able to query database size and individual object sizes. The prefered mechanism would be VSTs but something similar would be OK. It should be queryable remotely by ABL and SQL. This feature has a lot of applications, but right now our...
  • Renumber system indexes

    Currently there is a fairly orderly numbering of tables in OpenEdge databases: >32767: SQL views >0: application tables -1 to -79: metaschema/SQL-89 views/physical structure -80 to -125: SQL catalog -200 to ?: audit/auth/logging -300 to -361?...
  • Delete the database even if the index rebuild has failed

    When you do an index rebuild and it fails or it is aborted, you cannot delete the database with PRODEL. The folowing error will apear: "Index reconstruction utility was aborted. Rerun it to completion. (651)"
  • Remove extent on a target replica database

    It is not possible to remove an extent on a target replica database. Any Storage Area/Extent type cannot be removed on the target database when replication is enabled, as the before-image file needs to first be truncated before removing extents which...
  • Remove message 13705 when adding extent on target with AI enabled

    When adding an extent online on a target with AI enabled with PROSTRCT addonline, the folowing warning will apear: "Adding a new area online with ai enabled will cause the roll forward utility to fail unless the corresponding areas are also added...
  • 'rfutil -S scan verbove' to report the user numbers

    The recovery notes contain the user numbers but 'rfutil -S scan verbose' reports only user's names stored in the RL_TBGN notes. It's very inconvenient when we need to parse the transactions generated, for example, by batch processes that...
  • VST to report the fields stored in the object blocks

    The object blocks store the useful information about the objects resided in the type II storage areas: totalBlocks, hiWaterBlock, numBlocksOnChain[3] etc. This information, for example, can be used to a quick estimation of table’s and index’...
  • Create a protrace file for the specified errors

    It would help to debug the rare errors especially in production environment if we can specify the list of the errors to generate the protrace files when an error occurs. The list of the errors can be set as a db startup parameter, let’s say "...