How to reorganize the DB2 tablespace TABSPAC1 to reclaim fragmented space?



The tablespace reorganization is used to reorganize the data present in the system in order to reclaim the free space. This free space can be utilized to store the new data and therefore reorganization is very useful from a memory utilization point of view. We can reorganize any tablespace using DB2 REORG utility in JCL step as below.

//STEP1 EXEC DSNUPROC,UID='IUJLU101.REORG',
//UTPRINT DD SYSOUT=*
//SYSIN DD *
REORG TABLESPACE (DBSET1.TABSPAC1)
//*

The REORG TABLESPACE statement is followed by the name of the tablespace which needs to be reorganized qualified by dabasebase.


Advertisements