What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
Answer / sneha
Plan is an access path for your program to access the DB2 table. During precompilation process, the SQL queries are converted into executable statements and stored in DBRM (Database Request Module). This DBRM will have a consistency token. During the bind step, this DBRM will be read and a plan will be produced. Few important parameters we include in Bind job is ISOLATION LEVEL ( how one transaction needs to be separated from another transaction which does some data modification on the table), QUALIFIER etc.
Is This Answer Correct ? | 1 Yes | 0 No |
List some fields from sqlca?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Outputs of explain are with matchcols = 0. What does this signify?
What is lock escalation in db2?
Which component is used to execute the sql statements?
What is a predicate?
What is dpf in db2?
What is the syntax for FETCH in DB2 ?
What is the difference between cursor stability and repeatable read isolation levels?
wht happens if we close cursor with cursor with hold option?
What are host variables in db2?
Can one database have multiple instances?