Registration tables

If you use data definition control support, you must create and maintain an application registration table (ART) and an object registration table (ORT). You can register plans and package collections in the ART and objects that are associated with the plans and collections in the ORT.

Db2 consults these two registration tables before accepting a data definition statement from a process. It denies a request to create, alter, or drop a particular object if the registration tables indicate that the process is not allowed to do so.

Both ART and ORT contain the CREATOR and CHANGER columns. The CREATOR and CHANGER columns are CHAR(26) and large enough for a three-part authorization ID. You need to separate each 8-byte part of the ID with a period in byte 9 and in byte 18. If you enter only the primary authorization ID, consider entering it right-justified in the field (that is, preceded by 18 blanks).

In addition to the CREATOR and CHANGER columns, an ART also contains the following columns, some of which are optional and reserved for administrator use; Db2 does not use these columns.

Table 1. Columns of the ART
Column name Description
APPLIDENT Indicates the collection-ID of the package that executes the data definition language. If no package exists, it indicates the name of the plan that executes the data definition language.
APPLIDENTTYPE Indicates the type of application identifier.
APPLICATIONDESC1 Optional data. Provides a more meaningful description of each application than the eight-byte APPLIDENT column can contain.
DEFAULTAPPL Indicates whether all data definition language should be accepted from this application.
QUALIFIEROK Indicates whether the application can supply a missing name part for objects that are named in the ORT. Applies only if REQUIRE FULL NAMES = NO.
CREATOR1, 2 Optional data. Indicates the authorization ID that created the row.
CREATETIMESTAMP1 Optional data. Indicates when a row was created. If you use CURRENT TIMESTAMP, Db2 automatically enters the value of CURRENT TIMESTAMP When you load or insert a row.
CHANGER1, 2 Optional data. Indicates the authorization ID that last changed the row.
CHANGETIMESTAMP1 Optional data. Indicates when a row was changed. If you use CURRENT TIMESTAMP, Db2 automatically enters the value of CURRENT TIMESTAMP When you update a row.

An ORT also contains the following columns, some of which are optional and reserved for administrator use; Db2 does not use these columns.

Table 2. Columns of the ORT
Column name Description
QUALIFIER Indicates the object name qualifier.
NAME Indicates the unqualified object name.
TYPE Indicates the type of object.
APPLMATCHREQ Indicates whether an application that names this object must match the one that is named in the APPLIDENT column.
APPLIDENT Collection-ID of the plan or package that executes the data definition language.
APPLIDENTTYPE Indicates the type of application identifier.
APPLICATIONDESC1 Optional data. Provides a more meaningful description of each application than the eight-byte APPLIDENT column can contain.
CREATOR1, 2 Optional data. Indicates the authorization ID that created the row.
CREATETIMESTAMP1 Optional data. Indicates when a row was created. If you use CURRENT TIMESTAMP, Db2 automatically enters the value of CURRENT TIMESTAMP When you load or insert a row.
CHANGER1, 2 Optional data. Indicates the authorization ID that last changed the row.
CHANGETIMESTAMP1 Optional data. Indicates when a row was changed. If you use CURRENT TIMESTAMP, Db2 automatically enters the value of CURRENT TIMESTAMP When you update a row.