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

How to find the maximum value in a column in the db2 database?

1083

What parameters are used to control the free space in DB2?

1056

What is a bind in db2?

1042

How do I create a view in db2?

1023

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3154

What does reorg do in db2?

1029

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

What is buffer pool in the db2 database?

1104

What is the difference between plan and package in db2?

1112

Are view updateable?

1043

What are host variables in db2?

1072

Which are the db2 tools to protect integrity of the database?

1121

Highlight all the advantages that are attached to a package.

1119

Mention the location where the output received from explain statement is stored.

1127

What is the picture clause of null indicator variable?

1138