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
 

 

how to see DSNZPARM information for DB2 8?

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

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed Nov 27, 2013 11:39 am    Post subject: how to see DSNZPARM information for DB2 8?
Reply with quote

I know DB2 supplied stored procedure ADMIN_INFO_SYSPARM can return DSNZPARM information , but there is no ADMIN_INFO_SYSPARM for DB2 8(I cannot find it from SYSIBM.SYSPARMS, and when I call the stored procedure in QMF, error message said: 'no stored procedure found')

so, how to see DSNZPARM information for DB2 8?
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Nov 27, 2013 4:51 pm    Post subject:
Reply with quote

INFO_SYSPARM was introduced though a PTF :
http://www-01.ibm.com/support/docview.wss?uid=swg1PK67794


before those days :
http://ibmmainframes.com/about44914.html
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Wed Nov 27, 2013 6:32 pm    Post subject:
Reply with quote

thanks, GuyC,
but below link you gave is no longer accessable.
Quote:
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
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Nov 27, 2013 7:27 pm    Post subject:
Reply with quote

dejunzhu wrote:
below link you gave is no longer accessable.

maybe this is the reason : Posted: Wed Nov 04, 2009

I'm sure you can google "dsnwzp rexx" icon_wink.gif

but more important:
* maybe you should ask your support team why forementioned PTF is not yet installed.
* be aware that DSNWZP is deprecated in V10 and just might not be available for much longer
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 Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm
No new posts Passing information through JCL as in... Pia Baruah JCL & VSAM 5 Wed May 25, 2016 2:22 pm
No new posts Extracting Information from DD Statem... Charles Wolters All Other Mainframe Topics 7 Wed Apr 13, 2016 10:21 pm
This topic is locked: you cannot edit posts or make replies. Job Offer: Information systems consu... Express Mainframe Jobs 0 Thu Mar 10, 2016 7:18 pm


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