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

24 hours is obscenely long. I would be curious how much free space you had,
Processor Model, Main Memory, and work load. Also, key structure of physical 
file
and all logicals.  Of course, I am working with 88 & 12-Way machines, so I might
just be getting spoiled :)

Bob Larkin
blarkin@wt.net

Ashok Dave wrote:

> 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
> +---

begin:          vcard
fn:             Bob Larkin
n:              Larkin;Bob
org:            <A HREF="HTTP://web.wt.net/~blarkin/">Larkin Computer Consulting</A>
adr:            <A HREF="http://web.wt.net/~blarkin/">Bob and Diana's Page</A>;;;Houston;TX;<A HREF="http://web.wt.net/~blarkin/">;United States
email;internet: blarkin@wt.net
title:          Systems Consultant
x-mozilla-cpt:  ;4104
x-mozilla-html: FALSE
version:        2.1
end:            vcard