Installing data definition control support

You can install data definition control support that is available through the Db2 DSNTIPZ installation panel.

Procedure

To install data definition control support:

  1. Enter YES for option 1 on the DSNTIPZ installation panel, as shown in the following example. 
    1 INSTALL DD CONTROL SUPT. ===> YES
  2. Enter the names and owners of the registration tables in your Db2 subsystem and the databases in which these tables reside for options 6, 7, 8, and 9 on the DSNTIPZ installation panel.

    The default values for these options are as follows:

    6 REGISTRATION OWNER       ===> DSNRGCOL
7 REGISTRATION DATABASE    ===> DSNRGFDB
8 APPL REGISTRATION TABLE  ===> DSN_REGISTER_APPL
9 OBJT REGISTRATION TABLE  ===> DSN_REGISTER_OBJT

    You can accept the default names or assign names of your own. If you specify your own table names, each name can have a maximum of 17 characters.

  3. Enter an escape character for option 5 on the DSNTIPZ installation panel if you want to use the percent character (%) or the underscore character (_) as a regular character in the ART or ORT.

    You can use any special character other than underscore or percent as the escape character. For example, you can use the pound sign (#) as an escape character. If you do, the value for option looks like this: 

    5 ART/ORT ESCAPE CHARACTER ===> #

    After you specify the pound sign as an escape character, the pound sign can be used in names in the same way that an escape character is used in an SQL LIKE predicate.

  4. Register plans, packages, and objects in the ART and ORT.

    Choose the plans, packages, and objects to register based on whether you want to control data definition by application name or object name.

  5. Enter the values for the three other options on the DSNTIPZ installation panel as follows: 
    2 CONTROL ALL APPLICATIONS ===>
3 REQUIRE FULL NAMES       ===>
4 UNREGISTERED DDL DEFAULT ===>