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
What is the default page size of buffer pools?
What are packages in db2?
What is cobol db2?
What is multi row fetch in db2?
Which are the db2 tools to protect integrity of the database?
What is lock escalation in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How many databases can be created inside an instance in db2 ?
Can we insert update delete in view?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What os does db2 run on?
Can you tell me how can you find out the # of rows updated after an update statement?
List out the data types available.
How can you do the explain of a dynamic sql statement?
What is netezza database?