What does the REORG Utility do?

Answer Posted / guest

REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.

Is This Answer Correct ?    23 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for seeing the columns and data types of a table in the db2 database?

578


What are db2 objects?

641


What is copy pending status in db2?

636


What r the comman abends in db2, jcl and cobol???????

1820


what are bind concepts in db2 cobol?

651






How can you do the explain of a dynamic sql statement?

637


How can deadlocks be resolved?

542


Explain correlated sub-queries.

589


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1709


What is ibm db2 used for?

601


What is the purpose of rollback and commit?

595


What is a bind in db2?

592


What is a page in db2?

610


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

706


What is runstats and reorg in db2?

798