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 |
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is a db2 package?
What is DYNSLT keyword? How do you perform selection using DYNSLT
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
How are write I/Os from the buffer pool executed?
How is a typical DB2 batch program executed ?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What information can you find in SYSIBM.SYSLINKS table?
How does a cursor work?
What can the Locate option of the Repair Utility accomplish?