Interested to Buy Any Domain ? << Click Here >> for more details...
What is REORG? When is it used?
- 4 Answers
- 9990 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
REORG INDEX
The online REORG INDEX utility reorganizes an index space
to improve access performance and reclaim fragmented space.
You can specify the degree of access to your data during
reorganization, and you can collect inline statistics by
using the STATISTICS keyword.
REORG TABLESPACE
The online REORG TABLESPACE utility reorganizes a table
space to improve access performance and to reclaim
fragmented space. In addition, the utility can reorganize a
single partition or range of partitions of a partitioned
table space.
Traditionally, tablespace reorg consists of the following
steps:
• unload of the data
• redefinition of the tablespace
• reload of the data
• rebuild of the indexes
Now that we know what it dose, it is a DBA person to run
it as required.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / thiru
Yes What Vamsi said is right. But not only it will re-
organise or re arrange the occupied and un occupied space
of the perticular table. By default when we add a new
column to the existing table db2 V9 onwards the REORG is
compulsary. otherwise from any application the table will
not be accessed.
while doing the REORG after New column addition or Bulk
Insert/Load it will rearrange the data internally based on
the indexes available from the table. hence further search
as well as other operations will be faster.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vamsikrishnamraju
Calculates statistics on the database to determine if
tables or indexes, or both, need to be reorganized or
cleaned up.
| Is This Answer Correct ? | 1 Yes | 5 No |
max number of columns in a db2 table?
Explain about mirror activator disk mirroring?
What is the SQL Communications Area and what are some of its key fields?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
can we drop column from a table
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
If I have a view which is a join of two or more tables, can this view be updateable?
What else is there in the PLAN apart from the access path?
How can you find out the # of rows updated after an update statement?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is the syntax for creating a table in the db2 database?
What is an intent lock?
COBOL 
