DSNTIPZ: Data definition control support panel

The entries on the DSNTIPZ panel allow you to install and tailor data definition control support.

Two SQL tables (application registration and object registration) are identified and created even if data definition control support is not installed. This simplifies future activation of the facility. Specified application identifiers (Db2 plans or collections of packages) can be registered in the application registration table, and, optionally, their associated Db2 object names can be registered in the object registration table. Db2 consults these two tables prior to accepting a given DDL statement to make sure that a particular application identifier and object name are registered.

Figure 1. Data definition control support panel: DSNTIPZ

 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