Database Management for DB2 for Z/OS: Display or change the DB2 DSNHDECP and DSNZPARM settings.
Article ID: 26787
Updated On:
Products
Issue/Introduction
The DSNHDECP and DSNZPARM settings are often critical factors in the behavior of the applications that run on DB2. They can make or break an application simply by the values being used or change the behavior entirely. Therefore knowledge of what these values are set at is important to a DBA. How can these values be displayed by the Database Management for DB2 for Z/OS tools?
Environment
Release: R20
Component: IDB2, PTT
Resolution
There are a two products in the Database Management for DB2 for Z/OS tools suite that are able to display the DSNHDECP and DSNZPARM settings and also one product that is able to alter them to a degree.
Display current settings
Sysview for DB2: A command written thus "D SYSPARMS" which produces the "DB2 Subsystem Parameters" report. This shows both the ZPARMS and the DSNHDECP settings under different headings all in one report particularly in the "APPLICATION PROGRAMMING DEFAULTS PANELS" section which is seen further down the report.
APPLICATION PROGRAMMING DEFAULTS PANELS ZPARM Name Value
Default language DEFLANG IBMCOB
Decimal point DECIMAL PERIOD
Default string delimiter DELIM DEFAULT
Default SQL string delimiter SQLDELI DEFAULT
Distributed SQL string delimiter DSQLDELI APOST
Mixed graphics MIXED YES
EBCDIC single-byte CCSID SCCSID 1027
EBCDIC mixed CCSID MCCSID 5035
EBCDIC graphic CCSID GCCSID 4396
ASCII single-byte CCSID ASCCSID 1041
ASCII mixed CCSID AMCCSID 942
ASCII graphic CCSID AGCCSID 301
UNICODE single-byte CCSID USCCSID 367
UNICODE mixed CCSID UMCCSID 1208
UNICODE graphic CCSID UGCCSID 1200
Encode Scheme ENSCHEME EBCDIC
Application encode scheme APPENSCH EBCDIC
Locale LC_CTYPE LC_TYPE
Decimal floating value rounding mode DEF_DECFLOAT_ROUND_MO+ 1/2 EVEN
Minimum divide scale DECDIV3 NO
Decimal arithmetic option DECARTH DEC15
Use for dynamic rules DYNRULS YES
Describe for static option DESCSTAT YES
Date Format DATE ISO
Time Format TIME ISO
Local Date Length DATELEN 0
Local Time Length TIMELEN 0
Implicit time zone IMPLICIT_TIMEZONE 9999999
Standard SQL language STDSQL NO
Pad null-terminated strings PADNTSTR NO
Application compatibility level APPLCOMPAT V12R1
Ignore trailing blanks in LIKE predicate LIKE_BLANK_INSIGNIFIC+ NO
Value Pack, Option TT Thread Term/Dynam DSNZPARM : U Update DB2 Parameters, Option 13 "Application programming defaults". These are the DSNHDECP values. This screen shows the original parameter value at DB2 start-up, the current value or setting and you may use the third column, the desired value, to change the current value. The ZPARMS are broken among the other menu items on this screen.
NOTE: There are 3 pages of these to page through.
---- Thread Terminator DB2 Application Prog. Defaults --- yy/mm/dd hh:mm
COMMAND ==>
DB2 SSID ==> ssid Page 1 of 3
USERID ==> authid1 More: +
Original Current Desired
Value Value Value
Decimal point is . . . . . . : . . . : . . . . ________
Minimum divide scale . . . . : NO . . : NO . . . ________
SQL string delimiter . . . . : DEFAULT . . : DEFAULT . . . ________
Mixed data . . . . . . . . . : YES . . : YES . . . ________
EBCDIC Single byte CCSID . . : 1027 . . : 1027 . . . ________
EBCDIC Mixed byte CCSID . . . : 5035 . . : 5035 . . . ________
EBCDIC Graphic byte CCSID . . : 4396 . . : 4396 . . . ________
Date format . . . . . . . . . : ISO . . : ISO . . . ________
Time format . . . . . . . . . : ISO . . : ISO . . . ________
Local date length . . . . . . : 0 . . : 0 . . . ________
Local time length . . . . . . : 0 . . : 0 . . . ________
Default encoding scheme . . . : EBCDIC . . : EBCDIC . . . ________
Additional Information
Feedback
