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?
Joined: 20 Oct 2006 Posts: 6967 Location: porcelain throne
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.