Data Definition Control Support (DSNTIPZ)

This topic shows detailed information about System Parameters - Data Definition Control Support (DSNTIPZ).

This shows the installation and configuration for data definition control support.

Two SQL tables (application 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.

Fields in this block can contain long names. When a long name exceeds the available space, it is truncated, the parameter identifier and the full name are printed in a separate list at the end of the report.

DATA DEFINITION CONTROL SUPPORT (DSNTIPZ)
-----------------------------------------
INSTALL DD CONTROL (RGFINSTL)................................NO
CONTROL ALL APPLICATIONS (RGFDEDPL)..........................NO
REQUIRE FULL NAMES (RGFFULLQ)...............................YES
UNREGISTERED DDL DEFAULT (RGFDEFLT)......................ACCEPT
REGISTER TABLE OWNER (RGFCOLID)........................DSNZPARM
DDL REGISTRATION DATABASE NAME (RGFDBNAM)..............DSNRGFDB
APPL REGISTRATION TABLE NAME (RGFNMPRT).......DSNZPARMRGFNMPRTD
OBJECT REGISTRATION TABLE NAME (RGFNMORT).....DSNZPARMRGFNMORTD
ESCAPE CHARACTER (RGFESCP)................................X'40'

INSTALL DD CONTROL (RGFINSTL)

Indicates whether data definition support has been installed.

Install parameter INSTALL DD CONTROL SUPT on panel DSNTIPZ, or ZPARM RGFINSTL in DSN6SPRM.

Field Name: QWP4REGI

CONTROL ALL APPLICATIONS (RGFDEDPL)

Indicates that the Db2 system is completely controlled by a set of closed applications identified in the application registration table.

Closed applications require their Db2 objects to be managed solely through the plans or packages registered in the application registration table.

Install parameter CONTROL ALL APPLICATIONS on panel DSNTIPZ, or ZPARM RGFDEDPL in DSN6SPRM.

Field Name: QWP4REGD

REQUIRE FULL NAMES (RGFFULLQ)

Indicates whether registered objects require fully qualified names.

Install parameter REQUIRE FULL NAMES on panel DSNTIPZ, or ZPARM RGFFULLQ in DSN6SPRM.

Field Name: QWP4REGQ

UNREGISTERED DDL DEFAULT (RGFDEFLT)

The action taken for DDL that names an unregistered object.

Options are REJECT, ACCEPT, or APPL, which rejects the DDL when the current application is not registered.

Install parameter UNREGISTERED DDL DEFAULT on panel DSNTIPZ, or ZPARM RGFDEFLT in DSN6SPRM.

Field Name: QWP4REGU

REGISTER TABLE OWNER (RGFCOLID)

The owner of the application registration table and the object registration table.

This identifier can be a long string. If there is insufficient space to show the complete string, the string is truncated in the report block. The complete string is shown in a separate list of long names at the end of the report.

Install parameter REGISTRATION OWNER on panel DSNTIPZ, or ZPARM RGFCOLID in DSN6SPRM.

Field Name: QWP4REGC

DDL REGISTRATION DATABASE NAME (RGFDBNAM)

The name of the database that contains the registration tables.

Install parameter REGISTRATION DATABASE on panel DSNTIPZ, or ZPARM RGFDBNAM in DSN6SPRM.

Field Name: QWP4REGN

APPL REGISTRATION TABLE NAME (RGFNMPRT)

The name of the application registration table.

Install parameter APPL REGISTRATION TABLE on panel DSNTIPZ or ZPARM RGFNMPRT in DSN6SPRM.

Field Name: QWP4REGA

OBJECT REGISTRATION TABLE NAME (RGFNMORT)

The name of the object registration table.

Install parameter OBJT REGISTRATION TABLE on panel DSNTIPZ, or ZPARM RGFNMORT in DSN6SPRM.

Field Name: QWP4REGO

ESCAPE CHARACTER (RGFESCP)

The escape character used in the application registration table (ART) or object registration table (ORT).

Sets of names in the ART and ORT can be represented by patterns that use the underscore (_) and percent sign (%) characters in the same way as in an SQL LIKE predicate.

Install parameter ART/ORT ESCAPE CHARACTER on panel DSNTIPZ, or ZPARM RGFESCP in DSN6SPRM.

Field Name: QWP4ESC