what is the input to PLAN?
what is the input to DBRM?
Answer Posted / anil reddy
DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.
PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List down the data types in the db2 database.
What is performance tuning db2?
What is deadlock in db2?
What is a db2 collection?
Explain the contention situations caused by locks?
Which component is responsible for db2 startup and shutdown?
What is check constraint in db2?
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?
What are db2 objects?
If I have a view which is a join of two or more tables, can this view be updateable?
What is dbrm? When it will be created?
What is dbrm in db2 database?
How to restart a DB2 program?
is it compulsory commitment control in journal?
What are the 2 sqlcodes that are returned?