IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to see DSNZPARM information for DB2 8?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
Reply with quote

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


before those days :
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
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 : 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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Extract all the TWS scheduler informa... IBM Tools 1
No new posts Table Information - DB2 DB2 1
No new posts Remove additional information in SUPE... TSO/ISPF 10
This topic is locked: you cannot edit posts or make replies. Control-M Information. CLIST & REXX 1
Search our Forums:

Back to Top