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 a SELECT statement?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What do the initials DDL and DML stand for and what is their meaning?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
How do you filter out the rows retrieved from a Db2 table ?
What is a DBRM, PLAN ?
Request to database but database is not available so what is was abend is raised?
What is the difference between base table and view?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is Reorg Recovery? when will you run it?
How many databases are there?