if one db2 pgm calls another db2 pgm.
how many plans do we need.
what r the steps involved..

Answer Posted / harish poomgame shivappa

Hi buddy,

one plan is reqired,,create 2 dbrms for two programs

steps

precompile with dsnhcob2
ikjeft01
create dbrm, then in next step using same ikjeft01 create
plan with this 2 dbrrm

pls let me know if u have any queries

HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is commit in db2?

596


What is scrollable cursor in db2?

586


What is cascading rollback?

625


Can you use max on a char column?

640


What r the comman abends in db2, jcl and cobol???????

1820






While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1824


Can one database have multiple instances?

583


What are foreign keys in db2?

617


What is db2 optimizer?

773


How can deadlocks be resolved?

544


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2690


Highlight all the advantages that are attached to a package.

630


Is schema the same as database?

633


Mention data types used in db2 ?

682


What type of database is db2?

527