RE: System Performance

The recommended approach is as follows:

1. Execute STRDBMON command for a suitable period of time while one or more of these programs are running.

2. Check any records in the output with QQIXDA (Index Advised) and use the fields in QQIDXD (Key Fields for the index advised) to build either Logical files or (the method we use) use SQL Statement CREATE INDEX.

Only one word of caution, the output file created can get very large very quickly, as it can (and if you take defaults, will) log every DB file open on the system.

Hope this helps,

Richard I. Payne
Analyst/Programmer/System Administrator/Operator of BPCS 6.1 GA on AS/400 model 720 OS/400 V4R3
(forerunner to IBM e-Server i-Series 400)  @ http://www.stanton-uk.com - Stanton Rubber and Plastics

-----Original Message-----
From: Guerra, Terri [mailto:tguerra@motherscookies.com]
Sent: Monday, December 18, 2000 8:17 PM
To: BPCS-L@midrange.com
Subject: System Performance

We are in the process of upgrading our BPCS 5.1 to 6.1 mixed mode and are
having serious performance issues with some of the BPCS programs.  There are
a few of them:

BIL540
ACP500/D
BIL500
INV300
SFC720
INV500
BIL550D
BIL560D

Would appreciate hearing from any of you as to your experience with these
programs and what you did to address them.   Our initial observation is that
it is interactive SQL related.  Thanks.

Terri Guerra
IT Director
Mother's Cake & Cookie Co.
tguerra@motherscookies.com

+---
| 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
+---

*********************************************************************************************************************

THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL AND MAY BE LEGALLY PRIVILEGED.  If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.  If you have received this transmission in error please notify the sender immediately and then delete this email.

Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses.  The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of email transmission.  If verification is required please request written confirmation of it from Stanton Rubber & Plastics Ltd.

*********************************************************************************************************************

Stanton Rubber & Plastics Ltd
Admiral House, London Road,
West Thurrock, Essex,  RM20 3NL, UK
Tel: (01708) 685685 Fax: (01708) 685686
www.stanton-uk.com