DSNZPARM Application Parameters
This panel shows information about the parameters that affect the default settings of the Db2® application.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.
________________ ZPAPP VTM O2 V610./I SE11 G 06/27/13 21:49:00 2
> Help PF1 Back PF3 Left PF10 Right PF11
> R.H.M
> 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 I-DDCS J-DATA SHARING K-STORED PROC L-UTIL
> *-APPL N-DATA O-PERF P-BUFFERPOOL Q-OTHERS
===============================================================================
> DSNZPARM APPLICATION PARAMETERS
ZAPP
+ Collection Interval: REALTIME SNAPTIME: 06/27/13 19:49:00.37
+
+ Member Name SE11 SE12
+ DSNZPARM Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+ Initial Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+ Previous Module DSNZPARM N/P
+ Assembly Date 03/18/13 N/P
+
+ DSNTIPF-Application Default 1
+------------------------------------
+ Language Default (DEFLANG) IBMCOB IBMCOB
+ Decimal Point (DECIMAL) PERIOD PERIOD
+ String Delimiter (DELIM) DEFAULT DEFAULT
+ SQL String Delimiter (SQLDELI) DEFAULT DEFAULT
+ Dist SQL Str Delimiter (DSQLDELI) APOST APOST
+ Mixed Data (MIXED) NO NO
+ Single Byte CCSID (SCCSID) 1148 1148
+ Mixed Byte CCSID (MCCSID) 65534 65534
+ Double Byte CCSID (GCCSID) 65534 65534
+ ASCII SBCS CCSID (ASCCSID) 819 819
+ ASCII MBCS CCSID (AMCCSID) 65534 65534
+ ASCII GBCS CCSID (AGCCSID) 65534 65534
+ UNICODE SBCS CCSID (USCCSID) 367 367
+ UNICODE MBCS CCSID (UMCCSID) 1208 1208
+ UNICODE GBCS CCSID (UGCCSID) 1200 1200
+ Def Encoding Scheme (ENSCHEME) EBCDIC EBCDIC
+ Application Encoding (APPENSCH) EBCDIC EBCDIC
+ Locale LC_TYPE (LC_TYPE)
+ (DEF_DECFLOAT_ROUND_MODE) ROUND_HALF_EVEN ROUND_HALF_EVEN
+
+ DSNTIP4-Application Default 2
+------------------------------------
+ Minimum Divide Scale (DECDIV3) NO NO
+ Decimal Arithmetic (DECARTH) DEC15 DEC15
+ Use for Dynamicrules (DYNRULS) YES YES
+ Describe for Static (DESCSTAT) YES YES
+ Date Format (DATE) ISO ISO
+ Time Format (TIME) ISO ISO
+ Local Date Length (DATELEN) 0 0
+ Local Time Length (TIMELEN) 0 0
+ Impl Time Zone (IMPLICIT_TIMEZONE) CURRENT CURRENT
+ STD SQL Language (STDSQL) NO NO
+ Pad Nul-Terminated (PADNTSTR) NO NO
+ (PACKAGE_DEPENDENCY_LEVEL) P P
+
+ DSNTIP41-Application Default 3
+------------------------------------
+ APPL COMPAT LEVEL (APPL_COMPAT) V11R1 V11R1
===============================================================================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.
DSNTIPF-Application Default 1
- Language Default (QWPBLANG)
- This parameter determines the programming language that is used for your site.
- Decimal Point (QWPBDEC)
- This parameter determines the decimal point for numbers.
- String delimiter (QWPBDL)
- This parameter determines the string delimiter that is used for COBOL.
- SQL string delimiter (QWPBSDL)
- This parameter determines the character that is used to delimit character strings in dynamic SQL.
- Dist SQL Str Delimiter (QWPBDSD)
- This parameter determines the string delimiter that is used for bind operations at this Db2 site if the requester does not provide this information for Db2.
- Mixed Data (QWPBGRAF)
- This parameter determines how the EBCDIC CCSID fields and the ASCII CCSID fields are interpreted by Db2. The MIXED DATA option does not affect the UNICODE CCSID field. Regardless of the setting for MIXED DATA, UNICODE UTF-8 data is considered as mixed data. Therefore UNICODE UTF-8 data is processed according to the rules for mixed data.
- Single Byte (QWPBSID), Mixed Byte (QWPBMID), and Double Byte (QWPBGID) CCSID
- The coded character set identifier (CCSID) for Single Byte Character Set (SBCS), Mixed Byte Character Set (MBCS), and Double Byte Character Set (DBCS).
- ASCII SBCS CCSID (QWPBASID), ASCII MBCS CCSID (QWPBAMID), and ASCII GBCS CCSID (QWPBAGID)
- Coded character set identifier (CCSID) for ASCII Single Byte Character Set, (ASCCSID), ASCII Mixed Byte Character Set, and ASCII Double Byte Character Set.
- UNICODE SBCS CCSID (QWPBUSID), UNICODE MBCS CCSID (QWPBUMID), and UNICODE GBCS CCSID (QWPBUGID)
- Coded character set identifier (CCSID) for ASCII Single Byte Character Set, ASCII Mixed Byte Character Set, and ASCII Double Byte Character Set.
- Def Encoding Scheme (QWPBENS)
- This parameter determines the default format in which the data is stored in Db2.
- Application Encoding (QWPBAPSC)
- This parameter determines the default application encoding scheme of the system. It determines how data is interpreted by Db2. For example, if your default application encoding scheme is set to 37 and your EBCDIC coded character is set to 500, Db2 converts all data coming into the system to 500 from 37 before using it. This includes, but is not limited to, SQL statement text and host variables.
- Locale LC_TYPE (QWPBLCTP)
- This parameter determines the system LOCALE LC_CTYPE.
- DEF_DECFLOAT_ROUND_MODE (QWPBDDRM)
- This parameter determines the default rounding mode for decimal floating-point values.
DSNTIP4-Application Default 2
- Minimum Divide Scale (QWP4DIV3)
- This parameter determines whether to retain at least three digits to the right of the decimal point after any decimal division.
- Decimal Arithmetic (QWPBARTH)
- This parameter determines the rules that are used if both operands in a decimal operation have a precision of 15 or less.
- Use for DynamicRules (QWPBDRLS)
- This parameter determines whether Db2 is using the application programming default values that are specified on this panel or the values of the Db2 precompiler options for dynamic SQL statements. These are bound by using DYNAMICRULES bind, define, or invoke behavior.
- Describe for Static (QWP4DSST)
- This parameter determines whether Db2 is building a DESCRIBE SQL descriptor area (SQLDA) when binding static SQL statements. With DESCRIBE SQLDAs, DESCRIBE requests for static SQL statements can be executed successfully.
- Date Format (QWPBDATE)
- This parameter determines the format that is used to represent dates in output.
- Time Format (QWPBTIME)
- This parameter determines the format that is used to represent time in output.
- Local Date Length (QWPBDLEN)
- If you use a locally defined date exit routine, this parameter determines the length of the longest field that is required to hold a date.
- Local Time Length (QWPBTLEN)
- This parameter determines the time length default for the local format.
- Impl Time Zone (QWPBIMTZ)
- This parameter determines the implicit time zone that is used when a time zone is not provided.
- STD SQL Language (QWPBSQL)
- This parameter determines the SQL standard that is used in writing application programs. Specifically, the parameter specifies whether the SQL language conforms to those portions of the 1992 ANSI SQL standard that are implemented by Db2.
- Pad Nul-Terminated (QWPBPAD)
- This parameter determines whether output host variables that are nul-terminated strings are padded with blanks and a nul-terminator.
- (PACKAGE_DEPENDENCY_LEVEL) (QWP4PKGDEPLVL)
- The PACKAGE_DEPENDENCY_LEVEL subsystem parameter specifies whether packages record package-level dependencies only or record both package-level and statement-level dependencies. The subsystem parameter sets the default value for the DEPLEVEL option of the BIND PACKAGE command. The value of the DEPLEVEL option on BIND or REBIND always overrides the value of the PACKAGE_DEPENDENCY_LEVEL subsystem parameter.
DSNTIPF-Application Default 3
- APPL COMPAT LEVEL (QWP4APCO)
- This parameter determines the default release level of the APPLCOMPAT BIND and REBIND option.
Tip:
- Set all Db2 data sharing members to the same value.
- This system parameter is the default value when binding packages without explicitly specifying the APPLCOMPAT bind option. Ensure that all applications are ready for new compatibility behavior before you change the default value.