AVERAGE_L0_CHGS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data block changes in a DXX level index block. Contains zero unless CBS has performed certain types of selection, then is initialized as 204, but could possibly be set to a more accurate number if necessary and enough DXX level index blocks exist for this key.

AVERAGE_L0_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records in a DXX level index block. Contains zero unless CBS has performed certain types of selection, then is initialized as 300, but could possibly be set to a more accurate number if necessary and enough DXX level index blocks exist for this key.

AVERAGE_L1_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records represented in a level one IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 200, but could possibly be set to a more accurate number if CBS determines it necessary.

AVERAGE_L2_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records represented in a level two IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 200, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 200 in an index without two levels.

AVERAGE_L3_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records represented in a level three IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 200, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 200 in an index without three levels.

AVERAGE_L4_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records represented in a level four IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 200, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 200 in an index without four levels.

AVERAGE_L5_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Average data records represented in a level five IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 200, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 200 in an index without five levels.

CBS_IGNORE

CHAR(1)

No

Indicates whether CBS is allowed to use this key.. Column is provided for prior release compatibility. See the KEY_USE column.

CURRENT_RECORDS

INTEGER

No

The number of records indexed by this key. If a system failure has occurred during maintenance, this number can be inaccurate.

DBID

SMALLINT

No

The database ID of the database for the table that contains this key field.

DIR_NAME

CHAR(8)

No

Name of the Directory used by the MUF.

DIRECT

CHAR(1)

No

Indicates whether this key is a direct record access key definition.

DUPLICATE_MASTER

CHAR(1)

Yes

This field is null if this is not the master key. For a master key, this field indicates if duplicate master keys are permitted.

GENERATION

SMALLINT

No

Value returned is 1 for generation 1.

INDEX_NAME

CHAR(3)

No

This column contains the index name. It is either IXX (the default) or an index area name when using Multi-Dataset Indexes.

KEY_ID

SMALLINT

No

The key ID of this key.

KEY_LENGTH

SMALLINT

No

Total length of the key to index.

KEY_NAME

CHAR(5)

No

The name of this key.

KEY_STATUS

CHAR(8)

No

This column contains status information for the key. More than one status can be listed for a given key as appropriate. Status codes are as follows:

AD

AD signifies the key was added through an APPLYCXX but the process of populating the index which makes the key usable is not complete.

DL

DL indicates that the key was deleted through an APPLYCXX but the process of removing the key from the index is not complete.

LD

LD signifies that the key is loaded and ready for use.

NL

NL signifies that the key is not loaded or available to the user.

KEY_SQLNAME

CHAR(32)

No

The SQL name for this key. It contains blanks if the table is not SQLable, or if the database has not been cataloged since installation of Release 9.0.

KEY_USE

CHAR(8)

No

Contains the value specified for the KEY_USAGE attribute. Possible values are:

• ANY
• RAAT
• CBS/SQL
• NONE

MASTER

CHAR(1)

No

Indicates whether this key is the master key for this table.

NATIVE

CHAR(1)

No

Specifies whether this key is the native sequence key for this table.

NIL

CHAR(1)

No

Specifies whether this key is to have nil values placed in the index. Nil represents low values or blanks.

OCCURRENCE

CHAR(32)

No

The CA Datacom Datadictionary entity-occurrence name for this key definition.

PARENT_DBID

SMALLINT

Yes

This field is null if this key is not subject to an SQL referential integrity constraint. If this is a FOREIGN key, this field contains the database identifier of database for the table which is referenced.

PARENT_TABLE_NAME

CHAR(3)

Yes

This field is null if this key is not subject to an SQL referential integrity constraint. If this is a FOREIGN key, this field contains the short name (DATACOM-NAME attribute-value) of the table which is referenced.

STATUS

CHAR(1)

No

Status of the CA Datacom Datadictionary entity-occurrence for this key.

TABLE_NAME

CHAR(3)

No

Contains the short name (DATACOM-NAME attribute-value) of the table containing key field.

UNIQUE_KEY

CHAR(1)

No

Specifies whether this key is subject to the unique key constraint.

UNIQUE_SEARCHED

INTEGER

No

Number of rows indexed when the unique counts in this keys fields was generated. This is done during a LOAD, RETIX (except KEYNAME=*data), and REPORT ...,TYPE=G,UPDATE=YES.

Note: If a key is dynamically added through an APPLYCXX, these are updated after the key entries for the new key are added to the index.

UNIQUE_TIME

TIMESTAMP

Yes

This field can be null if a LOAD, RETIX (except KEYNAME=*DATA) or REPORT ...,TYPE=G,UPDATE=YES has not been done since this key was defined or added new to the Directory. Otherwise, it is the date when the index was scanned and the unique count fields were last computed.

Note: If a key is dynamically added through an APPLYCXX, these are updated after the key entries for the new key are added to the index.

USES_RAAT

INTEGER

No

A count of initial locate/read record-at-a-time commands against this key definition. The count is incremented by one for every LOC/RED/RDU/CNT command with KY/KG/KR/KL/KX/KI or GSETL command. This counter stops being incremented at one less than two gigs until reset to zero during the next LOAD, RETIX, or CXXMAINT with OPTION=ALTER,OPTION2=
RESET_KEY_USES.

USES_SAAT

INTEGER

No

Provides a general key usage count, the times a SELFR command selected this key for a traversal set. This does not include population counting or key usage to determine if the key is used in the completion of the request. This count does not include use of the command by SQL. This counter stops being incremented at one less than two gigs until reset to zero during the next LOAD, RETIX, or CXXMAINT with OPTION=ALTER,OPTION2=
RESET_KEY_USES.

USES_SQL

INTEGER

No

Provides a general key usage count, the times a SELFR command selected this key for a traversal set. This does not include population counting or key usage to determine if the key is used in the completion of the request. This count only includes use of the command by SQL. This counter stops being incremented at one less than two gigs until reset to zero during the next LOAD, RETIX, or CXXMAINT with OPTION=ALTER,OPTION2=
RESET_KEY_USES.

VARIANCE_L0_CHGS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a DXX level index block. Contains zero unless CBS has performed certain types of selection, then is initialized to zero, but could possibly be set to a more accurate number if CBS determines it necessary.

VARIANCE_L0_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a DXX level index block. Contains zero unless CBS has performed certain types of selection, then is initialized to zero, but could possibly be set to a more accurate number if CBS determines it necessary.

VARIANCE_L1_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a level one IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 20, but could possibly be set to a more accurate number if CBS determines it necessary.

VARIANCE_L2_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a level two IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 20, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 20 in an index without two levels.

VARIANCE_L3_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a level three IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 20, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 20 in an index without three levels.

VARIANCE_L4_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a level four IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 20, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 20 in an index without four levels.

VARIANCE_L5_RIDS

SMALLINT

No

Internal CBS information provided as a possible assist in support issues. Variance in the average data records represented in a level five IXX index block. Contains zero unless CBS has performed certain types of selection, then is initialized to 20, but could possibly be set to a more accurate number if CBS determines it necessary. Remains 0 or 20 in an index without five levels.

VERSION

SMALLINT

No

Version of the CA Datacom Datadictionary entity-occurrence for this key.