Re: what about DB2/400 reorg? -- MIDRANGE-L

We have a file that is 7.5G and it takes 24 hrs to reorg.
If you have ptf mf19047 (not sure which release - we're on r320) and are 
specifying "re-use deleted records" in your file description, you do NOT 
need to do a reorg. 
If you do not have this ptf, or its equivalent for your release, but are 
still specifying "reuse deleted records", you will still have to do a 
reorg.
Ash.
==============================

>From uucp@uucp1.mcs.net Tue Aug 11 04:01:55 1998
>Received: from uucphost.mcs.net (Uucp1.mcs.net [192.160.127.93]) by 
Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id GAA08476; Tue, 11 Aug 1998 
06:01:40 -0500 (CDT)
>Received: (from uucp@localhost)
>       by uucphost.mcs.net (8.8.8/8.8.8) id GAA22878;
>       Tue, 11 Aug 1998 06:01:29 -0500 (CDT)
>Received: (from majordom@localhost)
>       by midrange.com (8.8.8/8.8.8) id FAA04918
>       for midrange-l-outgoing; Tue, 11 Aug 1998 05:45:49 -0500
>Received: (from uucp@localhost)
>       by midrange.com (8.8.8/8.8.8) with UUCP id FAA04900
>       for midrange-l@midrange.com; Tue, 11 Aug 1998 05:30:23 -0500
>From: rwagner@zeunastaerker.de
>Received: from pop3.rmc.de (lukas.muc.rmc.de [194.162.146.70])
>       by uucphost.mcs.net (8.8.8/8.8.8) with ESMTP id FAA21859
>       for <midrange-l@midrange.com>; Tue, 11 Aug 1998 05:19:12 -0500 (CDT)
>Received: from sims.zeunastaerker.de (194.162.124.10.rev.rmc.de 
[194.162.124.10])
>       by pop3.rmc.de (8.8.8/8.8.8/Debian/GNU) with SMTP id MAA18254
>       for <midrange-l@midrange.com>; Tue, 11 Aug 1998 12:19:08 +0200
>Received: from notes.zeunastaerker.de by sims.zeunastaerker.de 
(SMI-8.6/SMI-SVR4)
>       id MAA23084; Tue, 11 Aug 1998 12:16:25 +0200
>Received: by notes.zeunastaerker.de(Lotus SMTP MTA v4.6.1  (569.2 
2-6-1998))  id 4125665D.003E20F7 ; Tue, 11 Aug 1998 12:18:36 +0100
>X-Lotus-FromDomain: ZS
>To: midrange-l@midrange.com
>Message-ID: <4125665D.003D8FE4.00@notes.zeunastaerker.de>
>Date: Tue, 11 Aug 1998 12:18:31 +0100
>Subject: what about DB2/400 reorg?
>Mime-Version: 1.0
>Content-type: text/plain; charset=us-ascii
>Content-Disposition: inline
>Sender: owner-midrange-l@midrange.com
>Precedence: normal
>Reply-To: MIDRANGE-L@midrange.com
>X-List-Name: Midrange Systems Mailing List (MIDRANGE-L@midrange.com)
>
>Folks,
>
>tomorrow we want to decide the platform of our SAP project. Now I have
>a question about DB reorgs.
>
>Oracle isn't reorg free. You have to do it periodically and it will 
need
>some time.
>I know of a company nearby that they need 2.5 hours for reorg of the
>largest
>table (they have round about 40 GB on ther SAP DB server).
>
>What would this meen on a AS/400. How long would this last (we plan
>150 GB of date) and is SAP available during reorg?
>
>Greetings
>
>Reinhold Wagner, Zeuna Staerker GmbH & Co. KG
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: 
david@midrange.com
>+---
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---