Skip to Content
avatar image
Former Member

Forcing reorg of all tablespaces in SAP? DB2 V9.1

Hello all,

I know I am very new here, and very new to SAP, so any help you can give would be great.

As info...the company I work for is implementing SAP on zLinux (SLES 10) and DB2 V9.1.

Is there any way to force SAP to reorg all of its tablespaces and indexes?

I would like to reorg all of the SAP tablespaces and indexes because our IBM reps say that the built in data compression will save about 50% disk space, and improve performance! However, they also tell us that it will not take effect until after the first reorg. Being that my systems are fresh installs, I dont have any tables or indexes that SAP wants to reorg yet. Does anyone have any ideas on how to "fake" SAP in to thinking tablespaces and indexes need to be reorg'd?

Thanks,

Andy Howard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 20, 2007 at 06:14 AM

    Andy,

    You can use transaction DB13 to run reorg on TS/IS that are recommended to be reorganized. Please run report RSDB2_COLLECT_DAILY before to gather the recommendations, stored procedure DSNACCOR is used for this.

    The Database Administration Guide ( http://service.sap.com/~sapidb/011000358700002040342006E ) contains detailed descriptions on all CCMS functions and their prerequisites.

    HTH.

    Regards,

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Vogt

      Thomas,

      Thanks for the fix. I was able to sucessfully implement this note! However, when I run the RSDB2_COLLECT_DAILY report I get an error. I have opened a new OSS note on this. If you are curious, here is the error message.

      Program RSDB2_COLLECT_DAILY

      ABAP-ReturnCode: 1

      Stored Procedure Returncode: 12

      Error Message:

      ***SQL error when executing EXECUTE IMMEDIATE :stmt#DSNT408I SQLCODE = -512, ERROR: STATEMENT REFERENCE TO REMOTE OBJECT

      IS INVALID #DSNT418I SQLSTATE = 56023 SQLSTATE RETURN CODE

      #DSNT415I SQLERRP = DSNXOTDA SQL PROCEDURE DETECTING ERROR

      #DSNT416I SQLERRD = -300 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION

      #DSNT416I SQLERRD = X'FFFFFED4' X'00000000' X'00000000' X'FFFFFFF

      F' X'00000000' X'00000000' SQL DIAGNOSTIC # INFORMATION

      #

      #

      #

      #

      #

      IFC Return Code: 0

      IFC Reason Code: 0

      XS Bytes: 0

      Last Statement:

      ***SQL error when executing EXECUTE IMMEDIATE :stmt