Answer Posted / sv kumar
it will delete that existing plan
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the role of data manager in the db2 database?
Outputs of explain are with matchcols = 0. What does this signify?
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 rct?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
List out the three types of page locks that can be held.
What is the role of schema in the db2 database?
What are the benefits of using the db2 database?
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?
Explain package in db2 and its advantages?
What are concurrency issues?
What is the syntax for FETCH in DB2 ?
What is an instance in db2?
What is runstats and reorg in db2?
Explain how can you do the explain of a dynamic sql statement?