Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Utility to list Data Set Information Auryn JCL & VSAM 4 Tue Jul 17, 2018 5:03 pm
No new posts Getting information (RECFM/LRECL/BLKS... Tim Van Holder COBOL Programming 3 Wed Mar 14, 2018 2:10 pm
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 4 Thu Mar 08, 2018 12:38 pm
This topic is locked: you cannot edit posts or make replies. how to get Job information from IOF u... rsshanmugam CLIST & REXX 13 Mon Feb 05, 2018 4:22 pm
No new posts Need to obtain VTOC information via R... djeffbland CLIST & REXX 10 Thu Jan 11, 2018 4:13 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us