System parameters.

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

Hi,
i am working on db2 9.1 z/os

I found the dsnzparm properties in the member DSNTIJUZ.But it is present in two pds DSN920.SDSNSAMP and DSN920.NEW.SDSNSAMP.

Pls help me in knowing which PDS should i use if i need to change some parameters.

Robert Sample · Posted: Wed Nov 04, 2009 6:40 pm

You need to contact your site support group to find out the differences in the two PDS files and which one should be used. We don't know your site and have no idea which PDS is current.

GuyC · Posted: Wed Nov 04, 2009 7:36 pm

You do understand that these are systemwide parameters?
That any change you do could affect everybody that uses that DB2-system?

Managing the DSNZPARMs is rather critical for your DB2 system, not something where I would everybody fiddle around in.

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

HI guyc,
Thanx for ur concern.

I too understand the criticality of system parameters.We dont even have the previlege to run that job..and niether the job through which i can get the current sytem parameters report.
So i thought to have a look at the job with the changed parameters itself.

That's y i was asking which pds to look into.

Please help if you have neother option for seeing the current system parameters.

Robert Sample · Posted: Wed Nov 04, 2009 7:57 pm

GuyC · Posted: Wed Nov 04, 2009 8:14 pm

- If you have Control Center you can see them there.
- If you have Optimization Service Center you can see them there.

You can in QMF for windows :
CALL SYSPROC.DSNWZP('')
and copy the output in a word or excel .

there a very nice rexx that call DSNWZP for you : db2dbazos.blogspot.com/2008/12/printing-zparms-of-db2-using-ibm.html

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

i was trying calling dsnwzp from rexx but it will take time to manipulate....

we have Control Centre ..can u tell me ..where to see in control centre?

GuyC · Posted: Wed Nov 04, 2009 8:28 pm

Control Center
once you have selected a DB2 and logged in :
On top menu => Selected=> Display Subsystem Parameters...

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

Thanx man !!!!!!!!!!!
It really helped.....even the link that u gave is cool...

Thanx again..