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 |
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....
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is CHECK PENDING ?
What is sqlca?
if i made sme changes in sub pgm wht r the things to be done for this ?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How to execute stored procedure in db2 command editor?
What is a composite index and how does it differ from a multiple index?
How to create db2 table in mainframe?
What are packages in db2?
How can we retrieve the total number of records in RPG & CLLE?
How connect db2 database to datastage?