Ansicht
Dokumentation
03498 - Index reorganisation
ABAP Short Reference Vendor Master (General Section)This documentation is copyright by SAP AG.
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 )