Retrieval of current DSNZPARM and DSNHDECP settings

History:
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)
E.g.
"Macro Name"            DSN6SPRM
"Parameter Name"     STATSINT
"Current Setting"        00005
"Description ..."          REAL TIME STATS
"Install Panel ID"        DSNTIP8
"Fld No."                    11

Consider:
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.

Views: 1561

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Comment by Peter Hartmann on July 29, 2019 at 10:40

Hi Joe

The compatibility remark relates to: If this (e.g. stored procedure) is changed, then other customers may complain.

Comment by joe watson on July 23, 2019 at 15:43

Peter,  Thanks for the feedback. 

I do not quite understand the compatibility rational.  Compatible with what?

The suggestion for sql CASE implies, just to accommodate those few zparm items,  the zparm data would first have to translated and ported to a DB2 table. 

Then, a case would be constructed for all permutations of that binary string,  Again, just to get those few zparm items?  That seems, to put it mildly, rather bizarre. 

HA  So, here is an idea.  I will just use an IBM competitor product that already displays the data in a human readable fashion!

Comment by Peter Hartmann on July 23, 2019 at 5:25

Hi Joe

I discussed this IBM internally. The ADMIN_INFO_SYSPARM output is kept due to compatibility. You might use a CASE expression to format liek you want:

SELECT ...,
CASE T1.PARMVALUE
WHEN '00000000000000000000000000000000' THEN '0'
WHEN '10000000000000000000000000000000' THEN '1'
WHEN '10000010000000000000000000000000' THEN '1,7'
WHEN '11000000000000000000000000000000' THEN '1,2'

and so on.

The following link might be also interesting.

Comment by joe watson on July 17, 2019 at 14:31

Interesting aside.  ADMIN_INFO_SYSPARM (as well as DSNWZP before) does not translate the trace parms.internal format.  IE,

AUDITST=11000011001000000000000000000000

SMFACCT=11100011000000000000000000000000
SMFSTAT=10111100000000000000000000000000

Which makes that data pretty useless in general an very tedious to interpret specifically.  Some other vendor tools do make the conversion.  EG,

AUDITST                (1,2,7,8,11)

So it is strange that IBM retains that useless 'retrieval' format.  I suggested to DB2 Support to enhance those displays but they were not interested in doing so at the moment.

Comment by Peter Hartmann on July 16, 2019 at 17:18

Hi John

Thanks for making this clear.

My statement relates more to the compile and general usage. Of course the specific usage of the stored procedures requires some authorizations due to good reasons (hacking etc.).

Comment by John McIntosh on July 16, 2019 at 15:54

"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."

Not exactly. The user who calls SYSPROC.ADMIN_INFO_SYSPARM must have MONITOR1 privilege. Not all users hold that privilege.

Events

Latest Activity

A blog post by Surekha Parekh was featured

*NEW* Db2 12 Technical workshop, REGISTER NOW LIMITED PLACES

Get a head start by registering for this *NEW* Db2 12 Technical workshop, Hosted by John Campbell - IBM DE and Anthony Ciabattoni from the IBM Db2 SWAT Team.Secure your seats today http://ibm.biz/Db212TechnicalWorkshopFeb 9th and 10th 2021#db212  #Db2 #AI #Data #Analytics #ML #HybridJohn Campbell and Anthony CiabattoniJohn…See More
yesterday
An event by Annette Zawacki was featured
Thumbnail

IBM Db2 Analytics Accelerator Trends and Directions at ET

February 16, 2021 from 11am to 12pm
Register Today! Whether you are an existing Db2 Analytics Accelerator user or considering becoming one, you won’t want to miss this webcast! Join Daniel Martin, STSM, IBM Db2 Analytics Accelerator Development to hear details on the newest Accelerator capabilities that drive even deeper integration with Db2 for z/OS. …See More
Tuesday
Annette Zawacki posted an event
Thumbnail

IBM Db2 Analytics Accelerator Trends and Directions at ET

February 16, 2021 from 11am to 12pm
Register Today! Whether you are an existing Db2 Analytics Accelerator user or considering becoming one, you won’t want to miss this webcast! Join Daniel Martin, STSM, IBM Db2 Analytics Accelerator Development to hear details on the newest Accelerator capabilities that drive even deeper integration with Db2 for z/OS. …See More
Tuesday
2 events by Surekha Parekh were featured
Jan 12
Surekha Parekh updated an event

Modernize IBM Z Apps for Hybrid Cloud using APIs at webcast

January 11, 2021 all day
Available on-demand now, this webinar will show you how to provide access to curated, proven and high-performance applications by turning your existing IBM Z® assets into security-rich, consumable and managed APIs. You will also learn some key considerations on how to choose among the numerous API and integration solutions available. Click the link to watch:…See More
Jan 11
francisco venegas liked Surekha Parekh's event Db2 12 Exploiting new functions and Migration Planning PART 1
Jan 11
Mark liked Surekha Parekh's video
Dec 17, 2020
Judith Talavera posted an event

Modernize IBM Z Apps for Hybrid Cloud using APIs at webcast

December 16, 2020 to February 16, 2021
Available on-demand now, this webinar will show you how to provide access to curated, proven and high-performance applications by turning your existing IBM Z® assets into security-rich, consumable and managed APIs. You will also learn some key considerations on how to choose among the numerous API and integration solutions available. Click the link to watch:…See More
Dec 17, 2020
An event by Janttu Lindroos was featured

Finland Db2 User Group (FiDUG) Seminar at IBM Finland

December 10, 2020 from 9am to 5pm
More info will be available later on. Stay tuned.See More
Dec 4, 2020
An event by Michael Strelczuk was featured
Thumbnail

MDUG - Michigan Db2 User Group Seminar at Four Points by Sheraton, Novi

December 9, 2020 from 8:15am to 4pm
Check out our MDUG web site for upcoming Seminar details and past Seminar presentations, etc.:http://www.mdug.org/New to MDUG?Please see content underHome About MDUGFor Seminar Reservations, please review the MDUG site content under…See More
Dec 4, 2020
An event by Surekha was featured
Thumbnail

Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the lab at http://ibm.biz/MoTownsend_IBM2020

December 7, 2020 from 11am to 12pm
Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the labIDUG EMEA 2020 Spotlight session Available today on replay  http://ibm.biz/MoTownsend_IBM2020 Db2 12 for z/OS® took Db2 to a new level, by extending the core capabilities and empowering the future. IBM extended the core with new…See More
Dec 4, 2020
Jonathan Sloan posted an event

IBM Z and IBM Cloud Pak for Data - Better Together at Webcast - East Coast U.S. time zone

December 3, 2020 from 11am to 12pm
Register at http://ibm.biz/IBMZandBetterTogetherWoD.IBM Cloud Pak for Data is a fully integrated data and AI platform that modernizes how businesses collect, organize and analyze data and infuse AI throughout their organization. And now IBM has introduced IBM Cloud Pak for Data on IBM Z, a highly secure private cloud for your enterprise data that allows you to adapt, transform and compete more effectively. Join this webcast to learn how IBM…See More
Dec 4, 2020
Surekha posted an event
Thumbnail

Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the lab at http://ibm.biz/MoTownsend_IBM2020

December 7, 2020 from 11am to 12pm
Surprise in store! Join the Db2 for z/OS Spotlight session for REALLY new news from the labIDUG EMEA 2020 Spotlight session Available today on replay  http://ibm.biz/MoTownsend_IBM2020 Db2 12 for z/OS® took Db2 to a new level, by extending the core capabilities and empowering the future. IBM extended the core with new…See More
Dec 4, 2020
Dragica Smintic liked Mateja Jankovič's event SQLAdria Virtual Event
Nov 25, 2020
Jonathan Sloan posted an event

IBM Z and IBM Cloud Pak for Data - Better Together at Webcast - East Coast U.S. time zone

December 3, 2020 from 11am to 12pm
Register at http://ibm.biz/IBMZandBetterTogetherWoD.IBM Cloud Pak for Data is a fully integrated data and AI platform that modernizes how businesses collect, organize and analyze data and infuse AI throughout their organization. And now IBM has introduced IBM Cloud Pak for Data on IBM Z, a highly secure private cloud for your enterprise data that allows you to adapt, transform and compete more effectively. Join this webcast to learn how IBM…See More
Nov 23, 2020
Massimo Verzì liked Adrian Collett's group DUGI - Db2 User Group Italia
Nov 20, 2020

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Replaying past database activities

Started by Shaun Hide in Security and DB2. Last reply by Alexander Dashevsky Nov 17, 2020. 1 Reply

I would need to know who modified table data on a certain day.I do have my backups and database logs available.DB2audit was however not activated at this point.How would i  be able to access this information?Continue

Tags: #DataAccess

Db2 is developer inclusive and preview of Db2 11.5.5

Started by Kip in What's hot ? Nov 4, 2020. 0 Replies

This digital event examines how enterprises can become smarter with a data management system that is developer-inclusive. During this session, participants will get to learn how Db2 integrates with a broad array of programming languages, employs…Continue

© 2021   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service