DSNZPARM Data Definition Control Support Parameters
This panel shows information about the Data Definition Control Support (DDCS) installation parameters in the DSNZPARM module. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.
If a field is not available for the current Db2 release, the string N/A is displayed. For other conditions, for example,
if specific Db2 traces are not started or control block data
is not available, the string N/P is displayed.
________________ ZPDDC VTM O2 V540./C DB11 S 10/11/12 22:06:37 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.I
> DSNZPARM INFORMATION: Enter a selection letter on the top line.
> A-THREAD B-TRACE C-LOGGING D-ARCHIVING E-AUTH/RLF/DDF F-IRLM
> G-STORAGE H-DATASET *-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> M-APPL N-DATA O-PERF P-BUFFERPOOL Q-OTHERS
===============================================================================
> DATA DEFINITION CONTROL DSNZPARM PARAMETERS
ZDDC
+ Collection Interval: REALTIME SNAPTIME: 10/11/12 20:00:20.56
+
+ DSNZPARM Module DSNZPARM
+ Assembly Date 10/10/12
+ Initial Module DSNZPARM
+ Assembly Date 10/10/12
+ Previous Module DSNZPARM
+ Assembly Date 10/10/12
+
+ DSNTIPZ-Data Def Control
+------------------------------------
+ Install DD CntlSupt (RGFINSTL) NO
+ Control All Appl (RGFDEDPL) NO
+ Require Full Names (RGFFULLQ) YES
+ Unregist DDL Def (RGFDEFLT) ACCEPT
+ ART/ORT Escape Char (RGFESCP)
+ Registration Owner (RGFCOLID) DSNRGCOL
+ Regist Database (RGFDBNAM) DSNRGFDB
+ Appl Registration Table (RGFNMPRT) DSN_REGISTER_APPL
+ Object Registration Tabl (RGFNMORT) DSN_REGISTER_OBJT Navigation
For additional information about
- related topics, select one of the options on the top of the panel.
- other topics, use the PF keys.
Fields
The DSNZ command displays the following lines to reflect the usage of the DB2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.
- DSNZPARM Module
- The name of the DSNZPARM module that is specified for Db2 startup.
- Initial Module
- The name of the initial DSNZPARM load module.
- Previous Module
- The name of the previous DSNZPARM load module.
- Assembly Date
- The date on which this module was assembled.
DSNTIPZ-Data Def Control
- Install DDCNTL Support (RGFINSTL) (QWP4REGI)
- Determines whether data definition control support is used.
- Control All Applications (RGFDEDPL) (QWP4REGD)
- Determines whether only registered packages or plans can use DDL.
- Require Full Names (RGFFULLQ) (QWP4REGQ)
- Determines whether two-part names are required for every object that is registered in ORT.
- Unregistered DDL Default (RGFDEFLT) (QWP4REGU)
- This is a flag for unregistered DDL default.
- 00
- Unregistered DDL are prohibited.
- 1X
- Unregistered DDL can be used.
- X1
- Consult the art for unregistered DDL.
- ART/ORT Escape Char (RGFESCP) (QWP4ESC)
- The DDCS escape character for a search of the application registration table (ART) or the object registration table (ORT). This character is shown in both display and hexadecimal formats.
- Registration Owner (RGFCOLID) (QWP4REGC)
- Displays the owner of the application registration table and the object registration table.
- Registration Database (RGFDBNAM) (QWP4REGN)
- Specifies the name of the database that contains the registration tables.
- Appl Registration Table (RGFNMPRT) (QWP4REGA)
- Specifies the name of the application registration table.
- Object Registration Table (RGFNMORT) (QWP4REGO)
- Specifies the name of the object registration table.