Ansicht
Dokumentation
03505 - Index reorganisation
RFUMSV00 - Advance Return for Tax on Sales/Purchases TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
Index reorganisation
RCLSPACE is a good option though if you have a disk space constraint whentrying 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 )