Answer Posted / a
What vamshi is said is incorrect .i.e he told about
RUNSTATS utility.
Where in REORG is used to re organise the table after huge
manipulation say insert,delete of records etc.It provides
free space also.
Correct me if i wrong vamshi/anyone
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
When do you specify the isolation level?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 purescale?
What is the advantage in De-normalizing tables in DB2?
Comment whether the cursor is closed during commit or not.
What action db2 takes when a program aborts in the middle of a transaction?
What are catalog tables in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is cascading rollback?
What is table space in db2?
What is cobol db2?
What is sqlca’s maximum length?
What do you mean by commit and rollback?
What is commit in db2?
What is the difference between nvl and coalesce?