Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

System parameters.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Nov 04, 2009 6:25 pm    Post subject: System parameters.
Reply with quote

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.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7999
Location: Bellevue, IA

PostPosted: Wed Nov 04, 2009 6:40 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Wed Nov 04, 2009 7:36 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Nov 04, 2009 7:54 pm    Post subject:
Reply with quote

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. icon_biggrin.gif
That's y i was asking which pds to look into.

Please help if you have neother option for seeing the current system parameters.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7999
Location: Bellevue, IA

PostPosted: Wed Nov 04, 2009 7:57 pm    Post subject:
Reply with quote

Quote:
You need to contact your site support group
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Wed Nov 04, 2009 8:14 pm    Post subject:
Reply with quote

- 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 : http://db2dbazos.blogspot.com/2008/12/printing-zparms-of-db2-using-ibm.html
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Nov 04, 2009 8:24 pm    Post subject:
Reply with quote

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? icon_rolleyes.gif
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Wed Nov 04, 2009 8:28 pm    Post subject:
Reply with quote

Control Center
once you have selected a DB2 and logged in :
On top menu => Selected=> Display Subsystem Parameters...
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Nov 04, 2009 8:36 pm    Post subject:
Reply with quote

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

Thanx again..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Overlay the system date Danielle.Filteau SYNCSORT 4 Fri Mar 03, 2017 1:16 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts CICS NEW SIT PARAMETERS CICS BEHAVIOR... Kyle Carroll CICS 0 Fri Nov 04, 2016 11:55 pm
No new posts Get system time in micro second or cl... lind sh CICS 11 Mon Sep 05, 2016 11:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us