Runaway QTP process

[Edis, Bob]

G'day Abraham

Please excuse my ignorance of the MPE platform.  What database engine are
you using?  Why can't you change the ACCESS statement to:

ACCESS ACK-OPERATIONS &
  LINK A-WORK-ORDER, ITEM-NUM  &
    TO A-WORK-ORDER, ITEM-NUM OF ACK-DIE-ITEM
SELECT IF DELETE-CODE OF ACK-DIE-ITEM <> ' '
(or CHOOSE 'a' TO 'z', 'A' TO 'Z', '0' TO '9')

This would work on a RDBMS.

Regards,
Blue

-----Original Message-----
From: Abraham Zwygart [mailto:azcognos@anodizing.com]
Sent: Wednesday, September 06, 2000 1:12 PM
To: PowerHouse ListServer (E-mail)
Subject: Runaway QTP process


Hi all,

I have been off this list for a long time.   It is good to be back.  Im
on a:
PH3000 os ver. 6.5
using Power House     ver 8.19.c1

I have the following job
!JOB JOBNAME,XXXX.XXX;OUTCLASS=LP14,1
!QTP PRI=ES
CAN CLE
SET DEF
ACC ACK-OPERATIONS LINK A-WORK-ORDER  TO &
                                A-WORK-ORDER OF ACK-DIE-ITEM

SELECT ACK-DIE-ITEM IF ITEM-NUM OF ACK-OPERATIONS = &
                       ITEM-NUM OF ACK-DIE-ITEM AND &
                       DELETE-CODE OF ACK-DIE-ITEM <> ' '

OUTPUT ACK-OPERATIONS UPDATE
ITEM DELETE-CODE OF ACK-OPERATIONS FINAL DELETE-CODE OF ACK-DIE-ITEM

SET PROCESS LIMIT 999999
GO
EXIT
!EOJ
files:
FILENAME  CODE  ------------LOGICAL RECORD-----------  ----SPACE----
--DAYS--
                  SIZE  TYP        EOF      LIMIT R/B  SECTORS #X MX
ACC  MOD

ACK-DIE-ITEM
BIFM1   * KSAM    256B  FAK     618314     943000  16  1067008 21  *

ACK-OPERATIONS
ACKOPER * KSAM     64B  FAK     727742    1247117  60   550448 32  *

This qtp pass will take all of the cpu (95%+) it can get and do very
little disc IO (used sos to monitor).  The cpu usage was so bad that I
was not able to abort the job.  After trying for just over a half hour
we had to reboot the HP3000 to break it free.  Has anybody else come
upon a qtp the seemed to have a runaway process?

Abraham Zwygart

PS.  I have got the job to work by using quiz to collect the changed
records then  using qtp with a unique key.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.