Datacom

 View Only

CA Tech Tip: CA Datacom/DB SQL 15.0 - System Tables changes with 15.0

  • 1.  CA Tech Tip: CA Datacom/DB SQL 15.0 - System Tables changes with 15.0

    Posted Jan 12, 2016 04:55 PM

    Tech Tip from JD Paquet, Principal Support Engineer, for January 12, 2015

     

    There are some changes in the Datacom System Tables with Release 15.0:

     

    DIR_AREA (DRA)                - includes new columns for GENERATION and URI_REUSE

    DIR_DATABASE (DRB)       - the BASE_FORMAT column was updated

    DIR_DATASET (DRZ)         - includes new columns for GENERATION, and SECONDARY_CYLS

    DIR_DIRECTORY (DRD)    - includes new columns for GENERATION and CXX_VERSION

    DIR_KEY (DRK)                  - includes new columns for GENERATION and KEY_USE; changes were made to the CBS_IGNORE, KEY_STATUS, UNIQUE_SEARCHED and UNIQUE_TIME columns

    DIR_TABLE (DRT)              - includes new columns for GENERATION and SQL_INTENT

    MUF_LOGGING (MFL)       - includes new columns for GENERATION, LOG_BLOCK_SEQ, and LOG_RECORD_SEQ_G0. The format of the column LOG_RECORD_SEQ was changed.

     

    See CA Datacom/DB Release Notes 15.0 for more information on the Generation Number concept,

    See CA Datacom/DB System Tables Reference Guide 15.0 for more information on changes.