Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How do I optimize a query in db2?
What is database manager in db2?
Which components manage deadlocks in db2?
How do I start db2 in windows?
What is dbrm library?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Explain the function of data manager.
What is access path in db2?
What is cascading rollback?
What type of database is db2?
What is a Foreign Key?
Are views updateable?
What are the full forms of spufi and dclgen and why are they used?
What db2 400?
Explain package in db2 and its advantages?
