IBM Db2 - The Ultimate Database for Cloud, Analytics & Mobile
With DB2 Version 9.1 for z/OS a new system supplied stored procedure SYSPROC.ADMIN_INFO_SYSPARM was delivered. As the name suggests, this routine can be called to obtain the current settings of the Db2 subsystem parameters (DSNZPARM) and the application default parameters (DSNHDECP).
In DB2 11 for z/OS the supplied sample code of member DSN8ED7 in SDSNSAMP, which extracts the current settings of the Db2 subsystem parameters, was changed from SYSPROC.DSNWZP to SYSPROC.ADMIN_INFO_SYSPARM. Note that SYSPROC.DSNWZP is deprecated.
DSNTEJ6Z in SDSNSAMP prepares this sample code of member DSN8ED7 by compilation, binding, etc.
This compilation requires a C/C++ compiler.
New feature description:
PH06905 replaces the old SDSNSAMP member DSNTEJ6Z: By default, it does no longer compile the DSN8ED7 module, because this one is now part of SDSNLOAD. It only prepares DSN8ED7 by binding, etc. The pure C source is still available in DSN8ED7S and users, who prefer to compile it, can modify DSNTEJ6Z to do so by following instructions in the job prologue.
Extracting the current settings of the Db2 subsystem parameters DSNZPARM and application default parameters DSNHDECP is now available for all users and is easy to use.
The directory of subsystem parameters and application default values and the output of DSN8ED7 can be used to get a complete view.
The output is equal to previous versions: it generates a table with the following columns:
- "Macro Name" (of SDSNMACS)
- "Parameter Name" (of the previous mentioned macro)
- "Current Setting"
- "Description/Install Field Name" (refer to the Install Panel ID)
- "Install Panel ID" (member name of SDSNSPFP)
- "Fld No." (appropriate field number in the Install Panel ID)
"Macro Name" DSN6SPRM
"Parameter Name" STATSINT
"Current Setting" 00005
"Description ..." REAL TIME STATS
"Install Panel ID" DSNTIP8
"Fld No." 11
The IRLMRWT value can be changed by a MODIFY IRLMproc,SET,TIMEOUT=nnnn,subsystem-name command. Such a change is not reflected in the output of SYSPROC.ADMIN_INFO_SYSPARM.
Add a Comment