Interested to Buy Any Domain ? << Click Here >> for more details...
What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 4209 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is syscat in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How does coalesce work?
Explain about mirror activator disk mirroring?
Mention the location where the output received from explain statement is stored.
What is the use of db2 optimizer?
How do you pull up a query which was previously saved in qmf?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a storage group (stogroup)?
What are the 2 sqlcodes that are returned?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain packages.
What is the latest version of ibm db2?
Explain in detail about buffer manager and its functionalities?
What is a system catalog table in db2?
