Ansicht
Dokumentation
03501 - Index reorganization
Vendor Master (General Section) CPI1466 during BackupThis documentation is copyright by SAP AG.
Index reorganization
Ron,We have our system set up to reorganize the physical files every
week before our offline backups. It takes about an hour and 50 minutes to
complete and that's really for the longest physical files. I have Qbatch
set to process 25 jobs concurrently. There are 3 files in our installation
that take 1.5 hours to reorganize (VBDATA, TST03 and MCSI). It is really
helpful on those weekend after SAP Archiving has been done to remove the
'dead wood' from the DB.
-----Original Message-----
From: Ron Schmerbauch [mailto:rschmerbZu...]
Sent: Tuesday, October 16, 2001 11:50 AM
To: sap400Zm...
Subject: RE: 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
CPI1466 during Backup CL_GUI_FRONTEND_SERVICES - Frontend Services
This documentation is copyright by SAP AG.
Length: 3723 Date: 20240425 Time: 015657 sap01-206 ( 4 ms )
