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 is SMP/E? and what are the major steps of it? thanks...
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is db2 and what is the use of db2 optimizer?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
what is the difference between join and union?
What is access path in db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How to view db2 table structure?
Explain packages.
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is a NULL value? What are the pros and cons of using NULLS?