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 dbrm? What it contains? When it will be created?
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?
What can the SET option of the Repair Utility accomplish?
Is db2 a database?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
Is ibm db2 open source?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is cascading rollback?
What is concurrency?
What is the syntax of SELECT statement when embedded in a COBOL program?
What is sqlcode -922 ?