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
 

 

Related to RUN command !!

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

New User


Joined: 28 Apr 2009
Posts: 89
Location: Noida , Dublin

PostPosted: Wed Jun 02, 2010 8:26 pm    Post subject: Related to RUN command !!
Reply with quote

Hi ,

The syntax of RUN cmd is
RUN(program name) plan(name) library(libraryname)

Now my question is if suppose I am using DSNTIAD program and I dont know what plan name is associated with it and I want to use it in create a table.
Will the DSNTIAD will automatically call its associated plan name ? I know plan name is optional part. How do we know what plans are associated with a program?

Some basic queries will be obilized if get some ref link for reading?
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 02, 2010 8:36 pm    Post subject:
Reply with quote

This kind of thing is site dependent.
the site dba's set up the plannames, and the libraries.

i have always asked the dba's what plan should an application programmer use when using DSNTIAD or any other db2 utility.

never had a problem receiving accurate info.

I have never had to search through the sysibm.... tables to determine pgm/plan name relationships,
but I am sure some one on the board can provide you the sql necessary.
But you may try to use a plan name that you have no authority for.
which means another look at the sysibm... tables to determine which plans you have authority to execute.

as far as links:

Finding the most current DB2 documentation and answers to other documentation questions

DB2 database product documentation

the above will point you in the right direction for absolute URL's of
any db2 document, which you can bookmark in your browser,
if you don't want to download the doc.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Thu Jun 03, 2010 2:37 pm    Post subject:
Reply with quote

Code:
select name,pdsname,plname
from sysibm.sysdbrm where name = 'DSNTIAD'


gives me :

Code:
DSNTIAD DB2.V8R1M0.DBRMLIB.DATA DSNTIA81
DSNTIAD DB2.V9R1M0.DBRMLIB.DATA DSNTIAD
Back to top
View user's profile Send private message
mjadwani2785

New User


Joined: 28 Apr 2009
Posts: 89
Location: Noida , Dublin

PostPosted: Tue Jun 08, 2010 1:04 pm    Post subject: Related to RUN command !!
Reply with quote

thanks icon_smile.gif
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 TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
No new posts SDSF Command Avtrix CLIST & REXX 4 Fri Sep 30, 2016 11:13 am


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