× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 1998

Re: what about DB2/400 reorg?

  • Subject: Re: what about DB2/400 reorg?
  • From: "Ashok Dave" <ashdave@xxxxxxxxxxx>
  • Date: Wed, 12 Aug 1998 05:54:23 PDT
 
Bob, you are spoilt ! I wish I could get my hands on 1 12 way machine ! 
Ours is a 4 way, 205G at 80% util., 1.5G memory, model 320-2052. The PF 
in question has dozens of LFs over it and nothing is optimised, in terms 
of best practices of creating files, maintaining the system, etc. So I 
guess we would expect long reorg times.
Ash.


>From uchgoptr@uucp1.mcs.net Wed Aug 12 01:04:15 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 DAA13248; Wed, 12 Aug 1998 
03:04:10 -0500 (CDT)
>Received: (from uchgoptr@localhost)
>       by uucphost.mcs.net (8.8.8/8.8.8) id DAA28048;
>       Wed, 12 Aug 1998 03:04:09 -0500 (CDT)
>Received: (from majordom@localhost)
>       by midrange.com (8.8.8/8.8.8) id CAA10546
>       for midrange-l-outgoing; Wed, 12 Aug 1998 02:46:00 -0500
>Received: (from uucp@localhost)
>       by midrange.com (8.8.8/8.8.8) with UUCP id CAA10523
>       for MIDRANGE-L@midrange.com; Wed, 12 Aug 1998 02:30:36 -0500
>Received: from pan.wt.net (pan.wt.net [205.230.159.31])
>       by uucphost.mcs.net (8.8.8/8.8.8) with ESMTP id CAA25085
>       for <MIDRANGE-L@midrange.com>; Wed, 12 Aug 1998 02:07:06 -0500 (CDT)
>Received: from wt.net (wt-d6-186.wt.net [208.211.141.186]) by 
pan.wt.net (8.8.5/8.7.3) with ESMTP id CAA03143 for 
<MIDRANGE-L@midrange.com>; Wed, 12 Aug 1998 02:07:03 -0500
>Message-ID: <35D14BE3.D2B8A6DC@wt.net>
>Date: Wed, 12 Aug 1998 01:01:40 -0700
>From: Bob Larkin <blarkin@wt.net>
>X-Mailer: Mozilla 4.05 [en] (Win16; I)
>MIME-Version: 1.0
>To: MIDRANGE-L@midrange.com
>Subject: Re: what about DB2/400 reorg?
>References: <19980811130355.24361.qmail@hotmail.com>
>Content-Type: multipart/mixed; 
boundary="------------6020F153DD98F1D919F98F92"
>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)
>
>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
>> +---
>
>
>


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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.