Data definition control support

If you want to use data definition statements for your plans and packages, you must install data definition control support on the Db2 DSNTIPZ installation panel.

As shown in the following example, you can specify appropriate values for several installation options to install the data definition control support and to control data definition behaviors.

Figure 1. DSNTIPZ installation panel with default values

 DSNTIPZ      INSTALL DB2 - DATA DEFINITION CONTROL SUPPORT
 ===>

 Enter data below:

  1 INSTALL DD CONTROL SUPT. ===> NO        YES - activate the support
                                            NO  - omit DD control support
  2 CONTROL ALL APPLICATIONS ===> NO        YES or NO
  3 REQUIRE FULL NAMES       ===> YES       YES or NO
  4 UNREGISTERED DDL DEFAULT ===> ACCEPT    Action for unregistered DDL:
                                            ACCEPT - allow it
                                            REJECT - prohibit it
                                            APPL   - consult ART
  5 ART/ORT ESCAPE CHARACTER ===>           Used in ART/ORT Searches
  6 REGISTRATION OWNER       ===> DSNRGCOL          Qualifier for ART and ORT
  7 REGISTRATION DATABASE    ===> DSNRGFDB          Database name
  8 APPL REGISTRATION TABLE  ===> DSN_REGISTER_APPL Table name
  9 OBJT REGISTRATION TABLE  ===> DSN_REGISTER_OBJT Table name

 Note: ART = Application Registration Table
       ORT = Object      Registration Table

 PRESS:  ENTER to continue   RETURN to exit   HELP for more information