Interested to Buy Any Domain ? << Click Here >> for more details...
One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 18479 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
when u precompile a Db2 program you will get (n+1) DBRMs
where n indicates no. of subprograms. So in our case you
will get 6 DBRMs. Through Binding process you can get
minimum of 1 package and maximum of 6 packages. But finally
you will get only one plan.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / vat
Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.
You would have to do bind to even talk about packages/plans.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / snehasis
If it generate 6 DBRM, then there is no possibility to have
1 package. The reason is one package can contain only one
DBRM. But yes for all these DBRM and Packages it will be
only one plan.
| Is This Answer Correct ? | 9 Yes | 3 No |
Define db2.
How to know the primary key of a table without defining the primary key in the table?
Mention and explain the contention situations caused by locks?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
How many clustering indexes can be defined for a table?
Describe what a storage group(STOGROUP) is?
Why might full image copies be faster to implement than an incremental image copy?
What is db2 look?
What is Skeleton cursor table (SKCT)?
What does DML stand for and what are some examples of it?
How do you pull up a query which was previously saved in qmf?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
COBOL 
