Hi buddy, one plan is reqired,,create 2 dbrms for two programs steps

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

Question Posted / harish poomgame shivappa

4 Answers
10501 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by union and union all?

949

What is a db2 cursor?

1009

Why do we need reorg in db2?

924

What is lock escalation in db2?

969

How do you pull up a query which was previously saved in qmf?

1101

What is explain plan in db2?

944

Which components manage deadlocks in db2?

1021

What type of database is db2?

913

What does db2 stand for?

961

What is the difference between oracle and db2?

1033

Mention the definition of cobol in varchar field.

1180

Before you give the explain statement, what are the prerogatives?

970

What is clone table?

999

Mention the different locking levels that are available in db2.

1073

What are the different types of base tables?

1029