SAP DB2 Tables space Reorganization on UNIX

[Brindavan_M]

  SAP DB2 Tables-space Reorganization on UNIX

Summary:-

This document contains the steps that how to do DB2 tablespace reorganization on UNIX System.

Author: Brindavan Mookaiah

Designation: SAP BASIS Consultant

Steps to follow:-

1) Login into udt

2) #sudo  su – DB2SID

3) # cd dba/bin

4) # ksh

5) #db2reorgchk.ksh

6) Enter selection: a

Enter the value: 100(its show the last 100days table’s space to Reorg)

Continue y/n? (Default=y): y

😎 Enter your name :< Name>

Make the tables to group reorg ,its reduce the time.

9) Enter selection : g

Enter MINIMUM REORG_ SCORE to be grouped (default=7): 2

Enter YOUR NAME for the audit trail (default=<name>): name

Enter the value:40000 (its make two groups)

Enter selection: 12 (to list the table Reorg grouping)

Run the first group  to reorg

Enter : X

Enter: cd…

Enter: rr

#hostnameDB2SID:SID:NODE0:/db2/db2SID/dba/bin>nohup db2rr.ksh -run db2rr_reorg_grp1.cfg &

To stop the reorg use the command

#hostname: DB2:SID:NODE0:/db2/db2SID/bin> stop_num=y

Online Reorg in SAP level

------------------------------------------------------------------

Step 1) T-code Db02

Step2) Click the Tables and Index

Step3) Right hand side double click the table name which you want to Reorg

Step4) Click the option REORG Table

Step5) Click Online option to run the Reorg

By this way Online reorg will trigger in background in SAP Level