Related to RUN command !!

mjadwani2785 · Posted: Wed Jun 02, 2010 8:26 pm

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?

dbzTHEdinosauer · Posted: Wed Jun 02, 2010 8:36 pm

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.

GuyC · Posted: Thu Jun 03, 2010 2:37 pm

mjadwani2785 · Posted: Tue Jun 08, 2010 1:04 pm

thanks