RE: what about DB2/400 reorg?

[Wiesmayr Rudolf <Rudolf.Wiesmayr@xxxxxxxxxxx>]

Hello Reinhold!

I do not know of a MUST REORG in DB/400.
The normal reason is to regain the space allocated to deleted
records. Having LARGE tables with a HIGH percentage of deleted
records is not only costly waste of disk space but can also 
cause bad performance...
Another reason could be to get the records in a specific
order for faster processing; but I think this is not a SAP admin
issue...

We have only 12 GB of data at the moment.
But I do not think that a RgzPFM of the largest SAP table
will take more than 2 hours on a AS/400.

I recently did a small, selective reorg of the 8 tables with
the most deleted space reported by DB02. Just a few minutes
and the job was done...
... so watch out for your 'swiss cheese tables' and give them
a manual SbmJob Cmd(rgzpfm....) in your maintenance slot.

Regards,
-------------------------------------------------------------------
Dipl.-Ing. Rudolf Wiesmayr  /\ Tel:     +43 - 0732 / 7070 - 1720
SAP R/3 BASIS &             /\ mailto://Rudolf.Wiesmayr@mag.linz.at
AS/400 System Administrator /\ IBMMAIL: at3vs7vs@ibmmail.com
Magistrat Linz, ADV/SB      /\ Fax:     +43 - 0732 / 7070 - 1555
Gruberstrasse 40-42         /\
A-4041 Linz                 /\ http://www.linz.at
-------------------------------------------------------------------

> -----Original Message-----
> From: rwagner@zeunastaerker.de [SMTP:rwagner@zeunastaerker.de]
> Sent: Tuesday, August 11, 1998 1:19 PM
> To:   midrange-l@midrange.com
> Subject:      what about DB2/400 reorg?
> 
> 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
> +---

application/ms-tnef