if one db2 pgm calls another db2 pgm.
how many plans do we need.
what r the steps involved..
Answers were Sorted based on User's Feedback
Answer / guest
Only one plan is bound for this program with 2 DBRMS : one
for the main program and one for the called program. The
steps involved in preparing the program is 1. Precompile
produces modified source code and DBRM 2. compile the
modified source code 3.Link-edit the resulting module to
create the load module 4.Binding the plan
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / abhay thakur
mr.harish i am not understandig for ur ans,plz send me ur number i want speak with you
Is This Answer Correct ? | 0 Yes | 0 No |
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is scrollable cursor in db2?
select 100 records from million records ?
What is a DB2 plan?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
How can you classify the locks in db2?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is sqlcode -922 ?
is it compulsory commitment control in journal?
How would one remove old reorg information from the DB2 catalog?