Answer Posted / naveen87ginjupalli
The Plan_table is created under the AUTHID.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the maximum length of sqlca?
How to resolve deadlock issue
How to find the number of rows in db2 tables?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is cursor in dbms?
What is meant by explain?
What is db2?
Which components manage deadlocks in db2?
What parameters are used to control the free space in DB2?
What is check constraint. Explain with example.
What is clone table?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What does db2 stand for?
What does a deadlock mean in DB2?
Explain in brief how does db2 determine what lock-size to use?