Naming conventions for Database IDs, Area names, and Table IDs
search cancel

Naming conventions for Database IDs, Area names, and Table IDs

book

Article ID: 108587

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction



Is there a way to find the guidelines for naming conventions of CA Datacom Database IDs, Area names, and Table IDs?

Environment

Release: DATABB00200-14.0-Datacom/AD
Component:

Resolution

In general, any specific questions about various attributes and their values can be answered by looking at the Datadictionary Attribute Types Reference information in CA DocOps.

For database IDs, this is in the section of DATABASE Attribute-types, for DATACOM-ID:
A 5-digit ID for the database (also known as the DBID). The ID must be unique within the status. This ID is stored in the CA Datacom®/DB Directory (CXX) and is used by CA Datacom®/DB to identify a database.

Database IDs over 999 have a few special considerations:
  • If you have databases with IDs greater than 999 and want to secure them, you must use an external security package (CA ACF2, CA Top Secret, or IBM's RACF). You cannot use CA Datacom®/DB internal (or kernel) security for these databases. External security fully supports all database IDs.
  • Databases 1000, 2000, 3000, 4000, and 5000 have the rules of global databases. Other databases (such as 1001 through 1999, and so on) have the rules of 1 through 999.
  • You cannot change the CA Datacom® Datadictionary™ databases (the DATA-DICT and DDD-DATABASE which are IDs 2 and 15 when you first install CA Datacom®/DB) to IDs greater than 999.
  • For CA Dataquery™ for CA Datacom®, if you have tables in databases with IDs greater than 999 that need to be secured, then you must use external security. CA Dataquery™ for CA Datacom® cannot access a table in a database that is greater than 999, unless the database is externally secured.
  • The CA Datacom® CICS Services supports User Requirements Table (URT) numbers of 0 through 999. Therefore, if you use database IDs greater than 999, you cannot match URT numbers with those database IDs.
Restrictions:
Database IDs 00001 -- 00020, 1000 -- 1020, 2000 -- 2020, 3000 -- 3020, 4000 -- 4020, and 5000 are reserved for CA.

Length:         5
Valid Entries:  00001 to 0000 - leading zeros may be omitted.
Default Value:  (No default)

Area name information is in the section AREA Attribute-Types, for DATACOM-NAME:
The 3-character CA Datacom®/DB short name for the area. CA Datacom®/DB uses this name to identify the area.

Requirements:
  • This attribute-value must be unique among the areas in a DATABASE structure in a specific status/version and cannot contain leading, embedded, or trailing blanks (X'40').
  • The first byte must be alphabetic. The second and third bytes can be alphanumeric. Do not enter XX as the last two bytes. If the last two bytes are XX, the CATALOG or VERIFY function will result in a warning message.
Length:         3
Valid Entries:  Unique 3-character name
Default Value:  (No default)


The Table name is found in the TABLE Attribute-types, for DATACOM-NAME:
Enter a 3-character CA Datacom®/DB short name for the TABLE occurrence. For tables created within the Interactive SQL Service Facility, CA Datacom® Datadictionary™ creates this name.

Requirements
  • It cannot contain leading, embedded or trailing blanks (X'40').
  • The first byte must be alphabetic.
  • The second and third byte must be alphanumeric.
Restrictions
  • The DATACOM-NAME attribute-value must be unique among the tables in a DATABASE structure in a specific status/version.
  • If the last two bytes are XX, a warning is issued with the VERIFY or CATALOG function. This does not stop a database from being cataloged.
  • If the table has constraints, updating this attribute-value can affect the constraint.
Length:          3
Valid Entries:   3  characters
Default Value:  (No default)

Additional Information

The Datadictionary Attribute Types Reference information in CA DocOps contains a wealth of information about Datadictionary entity attribute values. For more information, please refer to this documentation.

Version 15.1 - Datadictionary Attribute Types Reference
Version 15.0 - Datadictionary Attribute Types Reference

As always, please contact CA Technologies support for CA Datacom if you have further questions.