OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • 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 "...
  • Log a message for BI extend

    It would be nice to have the option, perhaps as a broker startup parameter, to log a message to the db log when the BI file is extended. The process of investigating excessive BI growth after the fact involves long, painstaking analysis of AI scans...
  • Add additional attributes to database files and fields

    I'd like to see SERIALIZE-NAME, SERIALIZE-HIDDEN, XML-NODE-NAME, XML-NODE-TYPE, XML-DATA-TYPE added to the Data Dictionary for Fields and Tables where relevant. Our field names were designed many years ago and not real user friendly when reading...
  • Separate Index Selection for WHERE and for BY

    The current implementation of Index Selection Rules practically excludes the BY phrase to be taken into consideration when selecting index(es). At least when developers make sure that it is the WHERE phrase that gets the attention as it limits the number...
  • Enable Large Files should be removed or default

    A newly created database should have LargeFile support as default or that option should be entierly removed. A 2 GB size limit in 2017 is rather laughable. Missing this out leads to unwanted shutdowns.
  • Add option startdate and enddate to rfutil aimage scan

    To scan an after image file, you can use the following command: rfutil db-name -C aimage scan [verbose] {-a ai-name | -ailist listfile} > output file name It would be very handy when you can use a start date and end date in case of a very large...