Explain what a plan is?
Answers were Sorted based on User's Feedback
Answer / bhavna
A plan is an executable module containing the access path
produced by DB2 optimizer.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
An application program cannot run without a plan. A Plan is
created by BIND PLAN, by binding DBRMS, packages or DBRMS
and packages together.
Is This Answer Correct ? | 1 Yes | 3 No |
what is Static and dynamic linking
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What are the contents of dclgen?
How many types of page locks can be held in db2?
Which isolation level provides maximum concurrency?
How do we specify index to include or not during bind process.
What is runstats db2?
Describe what a storage group(STOGROUP) is?
What are the levels of isolation available with DB2V4
how to execute qcmdexc in rpgle?plz write code also?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??