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 |
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is with ur in db2?
When DB2 connection fails, will online program work or give errors.
What do you do to keep the cursor from closing after a commit?
What is cursor stability?
Where are plans stored?
What is an inner join, and an outer join ?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to run db2 command in windows?
What is a page in db2?
What is meant by repeatable read?