Re: IPP picker file

Chick,
.
In fact you do need to clear this file as the picking transactions use it,
and when it is large the transactions will slow down. You will see a big
improvement when the job has been done. Check first that nobody is in
mid-transaction of course! Don't forget to use RGZPFM after deleting
records, otherwise SQL will continue to read the deleted records and you
won't gain much.

This is also one of the files that benefits from additional indexes for
performance. (Run the database monitor during transactions and create what
it suggests.)

If you need an 'intelligent' way to clear this and other BPCS data without
leaving 'orphaned' transactions or 'orphaned' data in related BPCS files,
our Archiving can help you. If you are in the US, this is also known as
Locksmith from Unbeaten Path.


Hope this helps,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified iSeries Systems Professional
Email: Clare.Holtham@xxxxxxxxxxxxxxx


----- Original Message ----- 
From: "Chick Doe" <Cdoe@xxxxxxxxxxxxxxxxxxxxx>
To: <bpcs-l@xxxxxxxxxxxx>
Sent: Thursday, December 30, 2004 4:47 PM
Subject: [BPCS-L] IPP picker file


> version 6.1
>
> is there any program within bpcs that purges the IPP (picker) file? we
> have over 100,000 records in the file in PZ status. would there be any
> harm in just going out and deleting these? are any other files related
> to the IPP that would have to be purged also?
>
>
> chick doe
> prime measurement products
> -- 
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: Clare.Holtham@xxxxxxxxxxxxxx
>