Ansicht
Dokumentation
03500 - Index reorganisation
Fill RESBD Structure from EBP Component Structure CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
Index reorganisation
I'll reiterate Volker's earlier comment.
RCLSPACE is not supported by IBM service. It is a "use at your own risk"
tool, and it isn't even shipped as a tool any more.
Use RGZPFM.
To get optimal performance...
If you have one table to RGZ, no problem.
If you have multiple tables, submit them to batch so the system can RGZ
them in parallel, about 1 per processor, so that the CPU intensive part
(index rebuild) goes quickly.
Or if you have multiple tables and SMP installed, submit the RGZ's one at a
time, so they can use parallel index rebuild...all processors work on an ix
at once.
Ron
Ron Schmerbauch 507-253-4880 rschmerbZu...
iSeries 400 - ERP Development - Rochester, MN
Rick Githens <RGithensZg...> on 10/16/2001 08:15:14 AM
To: "'SAP400 ListServer'" <sap400Zm...>
cc:
Subject: RE: 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
TXBHW - Original Tax Base Amount in Local Currency Addresses (Business Address Services)
This documentation is copyright by SAP AG.
Length: 2797 Date: 20240511 Time: 042037 sap01-206 ( 3 ms )