RE: Events Processing - 6004 HP/Infx

Have you tried to update statistics high on the glh for those columns in the
select statement?

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com
PrimeSource Technologies
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM
 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  Curtis
.  Sent: Wednesday, June 16, 1999 7:23 AM
.  To: BPCS-L@midrange.com
.  Subject: Events Processing - 6004 HP/Infx
.
.
.  We are experiencing up to a 20 minute wait to get into a journal using
.  Events Processing.
.
.  Has anyone else had similar problems (I note BMR 49122 is down to address
.  this issue) ?
.
.  If you have and have solved it (e.g. by adding additional indexes) please
.  let me know as I am being moaned at daily by our accounts staff.
.
.  the culprit appears to be an SQL statement fired by the program :
.
.    SELECT
.
.  lhid,lhldgr,lhbook,lhyear,lhperd,lhjnen,lhjnln,lhian,lhdram,lhcra
.  m,lhdrat,l
.
.  hcrat,lhlsts,lhstat,lhldes,lhjrf1,lhjrf2,lhdref,lhddat,lhreas,lhb
.  kov,lhuser
.
.  ,lhdate,lhtime,lhlock,lhsumf,lhsln,lhtsn,lhtrnn,lhdrmr,lhcrmr,lhs
.  tmr,lhjnml
.       FROM GLH WHERE (LHLDGR BETWEEN ? AND ? AND LHBOOK BETWEEN ?
.  AND ? AND
.      LHYEAR BETWEEN ? AND ? AND LHPERD BETWEEN ? AND ? AND LHJNEN
.  BETWEEN ?
.  AND
.      ? AND LHJNLN BETWEEN ? AND ? AND LHID = ? AND LHLSTS BETWEEN ? AND ?)
.      ORDER BY LHLDGR,LHBOOK,LHYEAR,LHPERD,LHJNEN,LHJNLN
.
.  that causes a sequential scan of the whole GLH (500,000 + records in our
.  case)
.
.  Regards
.  Mark Curtis
.  IT Director
.  Hafele U.K. Limited
.  Tel : +44 (0)1788 542020
.  Fax : +44 (0)1788 541860
.  email : mailto:mark.curtis@hafele.co.uk
.  Web : http://www.hafele.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
.  +---
.

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