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



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

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

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

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

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

Answer / baalu

hi,
mr.harish i am not understandig for ur ans,plz send me
clarity ans.k bye

Is This Answer Correct ?    2 Yes 2 No

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

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

Post New Answer

More DB2 Interview Questions

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  


Is ibm db2 open source?

0 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


what are bind concepts in db2 cobol?

0 Answers  


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..

5 Answers   CTS,






what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  


How to run db2 command in windows?

0 Answers  


What is dpf in db2?

0 Answers  


What type of database is db2?

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  


Explain about rct in db2?

0 Answers  


Categories