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
- 4437 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
Can you tell me how can you find out the # of rows updated after an update statement?
What is the max length of sqlca?
How can you count the number of rows from a table tab?
What is database alias db2?
What is netezza database?
What is a bind in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is a plan and package in db2?
What is sqlca?
Why db2 is called db2?
What is cloudant database?
When do you specify the isolation level?
Which component is responsible for db2 startup and shutdown?
Which is faster delete or truncate?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
