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.
| 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.
| 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. |