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
What is catalog database in db2?
What is node in db2?
How do you pull up a query which was previously saved in qmf?
What is null indicator in cobol db2?
Which is faster delete or truncate?
List out the three types of page locks that can be held.
What are the bind parameters ibm db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is access path in db2?
Is schema the same as database?
What's The Percentage Free Space ?
i want to maintain uniqueness on pdf without make lf??????????
What is reorg?
How do I delete a table in db2?
How can you count the number of rows from a table tab?
