OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Virtualisation best practices

    I'm missing documentation, whitepapers and best practices around virtualisation. Like it or not but big parts of large systems are running in virtual environments and VMWare, OpenStack, NetApp, 3PAR, SAN-solutions etc is very common in everything...
  • Option for probkup to remove target file before backing up

    On Windows, if the target backup file already exists, the backup can take a lot longer to complete. This is known, so we have to script for this by deleting the target file before backing up. It would be nice to remove this step with an optional parameter...
  • Make it easier to report on actual free space in a storage area

    Currently the information in VSTs doesn't show a true reflection of free space as blocks that previously had records in them that have been deleted are still reported in the used space. You can get the real ustilisation of a storage area from the...
  • Change field POSITION from SQL/resurrect the PRO_RPOS attribute

    The real-world problem here is that without the ability to change field POSITION, schema changes can't be reverted from SQL. If you delete a column from the middle of a table and re-add it, it's position will be different. That causes the CRC...
  • Password Policy Management Implementation directly at Openedge Database Level

    • Under Review
    In the context of different security audit point, the auditors are always pointing the following shortcoming : "when accessing directly the Openedge database, a password is required to authenticate the user but no password policy applies (for example...
  • Areas dedicated only for tables or indexes

    • Under Review
    We have tables and indexes separated in different areas. But unfortunately it is possible to accidentally add a table to an index area or an index to a table area. It would be nice if there is for example an area property that tells OpenEdge that only...
  • Allow database logging to be turned off

    db.lg contains information that has been deemed sensitive. Would like the ability to turn this off so that no information is put into db.lg.
  • Allow changing the physical database name

    • Under Review
    As of now the only support way I know to change the physical database name is via probkup / prorest. While this is a valid approach it consumes a lot of downtime on large database - up to some 20 hours on a 2 TB large database. Manually renaming all...
  • Allow character data type field to be initialized as GUID

    • Under Review
    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 prostrct list when db path is wrong

    • Under Review
    If you copy the DB to different path and you have no valid .st file there is no way to repair the db. The list command should always work and just export the .st files with the current paths (or maybe just with dots). The user can then correct them manually...