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
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
When do you specify the isolation level?
What type of database is db2?
How can we retrieve the total number of records in RPG & CLLE?
What is scrollable cursor in db2?
Explain dclgen.
What are the contents of a dclmgen?
Define check constraint.
Define sqlca.
Is db2 a programming language?
How to rename a table in DB2 ?
What is rct?
How do I connect my db2 database to ibm?
What is the default page size of buffer pools?
What is the purpose of using commit?
