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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is runstats db2?
What is the role of the data page in the db2 database?
What is commit in db2?
What is multi row fetch in db2?
What are the prerogatives?
What does sqlcabc has?
How to check table size in db2 sap?
What is a collection in db2?
What is db2 bind?
What is dclgen (declaration generator)?
How to create db2 table in mainframe?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is a db2 table?
What is the maximum number of columns in a db2 table?
