How to rebuild or reorganize table

[Former Member]

Dear Expert,

I want to improve performance of some table please let us know on how to reorganize or rebuild the table as option available in oracle with rsoraisqn .

Please let us know the steps , it will be help full for us.

Regards

RK

[Former Member]

Hi,

If you want to reorg a table at OS level than please go through below command

1.      Ensure complete DB backup of <SID>

2.      Open putty session.

3.      db2 connect to <SID>

4.      db2 "CREATE SYSTEM TEMPORARY TABLESPACE <SID>REORGTEMP IN NODEGROUP IBMTEMPGROUP PAGESIZE 16K MANAGED BY SYSTEM USING ('path where you want to create temp tblspace') DROPPED TABLE RECOVERY OFF"

5.      db2 “REORG TABLE SAP<SID>.<TABLE_NAME> allow no access use <SID>REORGTEMP LONGBLOBDATA”

6.      db2 "drop tablespace <SID>REORGTEMP"

IBM Link: http://www-01.ibm.com/support/docview.wss?uid=swg21452146

You can also do this from SAP DB13.

Make sure you have enough space on file system with enough secondary log allocated to avoid failure of reorg.

Regards,

Prithviraj

[maria_shen]

Hello,

A best way is to use DB6CONV tool, where the table will be completely 'rebuilt'.

Note#1513862 DB6: Table conversion using DB6CONV Version 5.01 or higher
(There is a pdf guide attached to the note)

Kind regards
Maria

[Sriram2009]

Hi RK

Which version of DB2?

BR

SS

[Former Member]

Our DB2 9.7 FP5 .

rK

[Sriram2009]

Hi

1  Could you refer the SAP Note 169301 - DB6: Online Reorg with DB2 UDB

BR

SS

[Sriram2009]

Hi

Check this IBM link IBM Knowledge Center