OpenEdge Database - Products Enhancements - Progress Community

 OpenEdge Database

  • Location Parameter for Horizontal Partitioning

    • Under Review
    • 0 Comments
    If we allow a default first parameter for horizontal partitions set as TENANT/SITE we can set a default value for this parameter, it will then allow us to get similar benefit as vertical partitioning while still being able to use horizontal partitioning...
  • Logical Scatter metric

    As per this discussion: https://community.progress.com/community_groups/openedge_rdbms/f/18/p/21437/75562#75562 Please add a metric for "logical scatter".
  • 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 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
  • 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...
  • Prolog online to reinsert the database startup section

    The database log file can in certain cases bloat quite quickly. As a result we truncate the log online from time to time. But we are still interested in the database startup section for various reasons, not least the ProTop uses it to identify a number...
  • add remote host capability to proadsv

    We have multiple admin server installs across many unix servers. At times the admin server (11.3.2) will hang. Others services like OEM and app servers can still be active. When this happens we will not get alerts from that server. We need to know when...
  • Allow DataServer tool to generate SQL statement to change field width.

    • Under Review
    • 0 Comments
    I would like to just change the WIDTH for a field. I ran "Generate Delta.sql OpenEdge to ORACLE...". It does not generate SQL command to alter field width. To duplicate it, add the following lines to a Progress delta.df file (Note: repace {field...
  • ODBC/SQL: Allow dynamic, transactionally-safe sequence updates

    Sequences should be able to be updated to dynamic values in a transactionally-atomic manner (e.g. setting the current value to MIN(a, b)). Possible use-cases include using a self-join to find the first unused id and setting the index for other clients...
  • A new costing algorithm in the SQL optimizer, to eliminate performance issues noted...

    • Under Review
    • 0 Comments
    Several months ago a customer I support was having varying results using the SQL Optimizer tool. We opened a support ticket with Progress support and they indicated this was not an issue with the tool per se, but a problem how SQL coordinates among join...