Ansicht
Dokumentation
03506 - Index reorganization
RFUMSV00 - Advance Return for Tax on Sales/Purchases ROGBILLS - Synchronize billing plansThis documentation is copyright by SAP AG.
Index reorganization
Ok guys heres a question for youHow much extra disk space is required if doing a reorg to a 50 gig table ?
To my understanding it requires the equivalent space so if you reorg a 50
gig table you need 50 gigs extra space for the reorg.
Am I right or wrong ?
>From: CSTRUCK <cstruckZe...>
>Reply-To: DoNotReply@consolut.eu
>To: Ron Schmerbauch <rschmerbZu...>
>CC: sap400Zm...
>Subject: RE: Index reorganization
>Date: Tue, 16 Oct 2001 13:11:54 -0400
>
>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
>
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Durban Tours - Südafrika Safari
CPI1466 during Backup Vendor Master (General Section)
This documentation is copyright by SAP AG.
Length: 5334 Date: 20240424 Time: 051437 sap01-206 ( 2 ms )
