Ansicht
Dokumentation

03505 - Index reorganisation

03505 - Index reorganisation

RFUMSV00 - Advance Return for Tax on Sales/Purchases   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Index reorganisation

RCLSPACE is a good option though if you have a disk space constraint when
trying to reorg a large table.

Alex


>From: Rick Githens <rgithensZg...>
>Reply-To: DoNotReply@consolut.eu
>To: "'SAP400 ListServer'" <sap400Zm...>
>Subject: RE: Index reorganisation
>Date: Tue, 16 Oct 2001 09:15:14 -0400
>
>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

rdisp/max_wprun_time - Maximum work process run time   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2640 Date: 20240328 Time: 192449     sap01-206 ( 3 ms )