OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Avoid large log files

    Database log files often grow very large. Analysis inside a text or log-file editor is not so handy. I suggest you to manage database log files in a more conveniently way. A very basic enhancement would be the definition of a threshold size (just like...
  • VST field for date/time of last AI extent switch

    There is no field in _DbStatus or in _ActAILog to show the time stamp of the last AI extent switch. I would like to be able to monitor this as there are situations where the AIMD may stop switching extents, e.g. when it runs out of space in the last...
  • Allow character data type field to be initialized as GUID

    • Under Review
    • 0 Comments
    I know there are other discussions about adding a GUID data type or other such methods to accomplish this. However, several applications have already been using a GUID and storing it in a character field. This idea would allow for a character field...
  • Allow field extent change with drop/add field

    • Under Review
    • 2 Comments
    Allow changing the extent of a database field without dropping the field. Preferably on-line, through fast off-line schema change if on-line not possible
  • know where all the databases are on Windows

    • Under Review
    • 2 Comments
    On UNIX/Linux there is the "proutil -C dbipcs" command to show where all the running databases are on the OS. On WIndows there is no such command. Ideally, a command that uses conmgr.properties and then determines which one is running would...
  • Message numbers for *all* messages

    Please add message numbers for ALL log messages.
  • Support adding database triggers (schema change) on-line

    • Under Review
    • 0 Comments
    Customers demand very very high up-time and one thing we still cannot do is add a database table trigger on-line. We can add new tables and fields on-line which is excellent. We can also add Indexes on-line (not that easy but at least it can be done)...
  • Multi-segment word index

    • Under Review
    • 0 Comments
    Word indexes can not contain multiple fields. Change this to word indexing only allowed on the last segment (similar to abbrev). Use case, example on sports ; New table : ItemTranslation, translation table for item : Fields Itemnum LanguageCode...
  • Allow more data-type changes

    • Under Review
    • 0 Comments
    It is currently possible to change the data-type of a field from int to int64 without dropping the field. Please add support for date -> datetime / datetime-tz int / int64 -> decimal anything -> character see also PugChallenge database...
  • Allow local administrators group (including domain administrators) to run jobs against...

    • Under Review
    • 0 Comments
    Currently, on a Windows server, only a local server administrator can shut down, or run command-line jobs (proshut, etc.) against, a database if the database was started by the local administrator. One problem with that approach is that local administrator...