One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
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 |
Which components manage deadlocks in db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What is a base table?
Can you tell me how can you find out the # of rows updated after an update statement?
Can you search give an array in the WHERE clause of a db2 query?
If I have a view which is a join of two or more tables, can this view be updateable?
What is EXPLAIN?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is JOIN and different types of JOIN.
How can you do the explain of a dynamic sql statement?
What is the role of data manager in the db2 database?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.