|
View previous topic :: View next topic
|
| Author |
Message |
tarunflash
New User
.jpg)
Joined: 15 Oct 2005
Posts: 25
|
|
|
|
| Can anybody explain to me about REORG parameter? |
|
| Back to top |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
And where do we use that...
Can you post some example...
Regards,
Priyesh. |
|
| Back to top |
|
|
tarunflash
New User
Joined: 15 Oct 2005
Posts: 25
|
|
|
|
| i don't know.that question was asked in Keane interview |
|
| Back to top |
|
|
nuthan
Active User
Joined: 26 Sep 2005
Posts: 146
Location: Bangalore
|
|
|
|
| REORG UTILITY IN DB2 is used to reorganize DB2 tables and indexes and there by improving their efficiency of access re-clusters data, resets free space to the amount specified in the ?create DDL? ,statement and deletes and redefines underlying VSAM datasets for stogroup defined objects. |
|
| Back to top |
|
|
fixdoubts
New User
Joined: 21 Oct 2005
Posts: 54
|
|
|
|
Hi,
A search shows the following link
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.admin/bjndmstr37.htm
which say this
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. You can specify the degree of access to your data during reorganization, and you can collect inline statistics by using the STATISTICS keyword. If you specify REORG TABLESPACE UNLOAD EXTERNAL, the data is unloaded in a format that is acceptable to the LOAD utility of any DB2 subsystem. You can also delete rows during the REORG job by specifying the DISCARD option.
Regards, |
|
| Back to top |
|
|
|
|
