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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.