RE: Poor Performance in INV900

["Wolf, Roger" <Roger.Wolf@xxxxxxxxxx>]

Title: RE: Poor Performance in INV900

I am sorry I specified the wrong parameter  this is the command before INV900 begins

CHGLF FILE(XXXXX) MAINT(*REBLD)

Here is the command after.

CHGLF FILE(XXXXX) MAINT(*IMMED)

Best Regards,
Roger Wolf
Roger Wolf
AS400 Expert

-----Original Message-----
From:   Wolf, Roger
Sent:   Wednesday, November 18, 1998 8:34 AM
To:     'BPCS-L@midrange.com'
Subject:        RE: Poor Performance in INV900




One thing I have been experimenting on to improve performance is to set the all the logical files except the one's being used by INV900 to REBLD(*YES) at the beginning of the procedure and at the end of the procedure setting them back to REBLD(*IMMED).  That way it does not have to update the indexes of all the logical files over the ITH file while it runs.

Another thing that can be done is move the ITH purge to a separate program that can run when time is available - like the next weekend.

Best Regards,
Roger Wolf

-----Original Message-----
From:   Michael Ozanne [SMTP:mozanne@midori-no-ryu.demon.co.uk]
Sent:   Tuesday, November 17, 1998 6:47 PM
To:     BPCS-L@midrange.com
Subject:        Re: Poor Performance in INV900

In message <912f9aa8.3651ef07@aol.com>, Devinbowen@aol.com writes
>Does anyone know if INV900 is stricken with the same inefficient SQL
>statement(s) as ACR900 (earlier messages)?  We are in prototyping and are
>experiencing the same kind of poor performance in the inventory month-end
>close as was described for ACR900.  We're on v6.0.02 (HP Oracle).  Any
>specifics anyone can give on a fix would be appreciated.

INV900 has always been a dog, ITH is usually the biggest file in the
database, INV900 purges old records from ITH then re-indexes it and all
its 30 plus logical views.

--
Michael Ozanne (Also ozannem@pacific.co.uk)
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---