Ansicht
Dokumentation

03498 - Index reorganisation

03498 - Index reorganisation

ABAP Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

Index reorganisation

Hi Wade,

If you use RGZPFM on the host, it will rebuild dependent indexes after the
reorganization of the table compresses out deleted records, rebuilds
pointers, etc. I'm not sure what RCLSPACE actually does when it calls
COMPRESS, but my guess would be it does exactly that. I prefer rgzpfm. In
fact, we never use rclspace.

Rick
-----Original Message-----
From: Wade Barrance [mailto:wade.barranceZp...]
Sent: Tuesday, October 16, 2001 1:01 AM
To: 'Sap400 (E-mail)'
Subject: Index reorganisation



Hi All,

How do I reorganise indexes on DB2 tables.



I have just run a RCLSPACE on an archived table, but the index size did not
decrease when I expected it too. Is there some other process that I should
run to reorg indexes?



Configuration:

AS/400 S40

OS/400 V4R5M0

SAP R/3 31I (2 teir)

Kernel level 601



Regards,

Wade


Durban Tours - Südafrika Safari

BAL_S_LOG - Application Log: Log header data   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 1490 Date: 20240328 Time: 115655     sap01-206 ( 2 ms )