this is off the top of my head, but i think there was a discussion about this several months ago. many people replied that you should purge the IPP but there is no 'canned' BPCS program to do this. >>> sandys@xxxxxxxxx 04/13/05 11:28AM >>> Hello All, BPCS Version: 6.01.01 AS/400 Operating System: V4R4 % system ASP used: 47 IPL: 2 times a month When we run the program for Pick Release ORD550, the processing keeps getting slower and slower. We have been running the same programs for several years. No updates to BPCS or operating system. The response time was acceptable a year ago. We only select one order at a time. My only guess is that our databases have been growing and growing, but I don't know which one(s) would cause this to happen. How big of a database is to big? I've been told not to run the reorg. programs, so I have not done this. Should I do this manually? Which ones? The order purge program was run a couple years ago. Though ending in errors, so I haven't ran it since. Here are some record counts if that helps: ECL 158,000 ECH 72,000 ESN 130,000 IPP 102,000 ZPD 449,000 LLL 74,000 ELA 1,000 IIM 105,000 ILM 100 ILI 307,000 Any helpful direction would be greatly appreciated, since I'm getting beat up by the users... Thanks, Sandy Hydro Carbide, Inc. Latrobe, PA 15650 Voice 724-539-9701 Fax 724-539-0326 -- 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: cdoe@xxxxxxxxxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.