Hi all
We went "live" on our N4000-100-330 hp e3000 (one cpu) on the weekend.
This system is running ver 7.0 pp1 as the OS.
We previously ran on an HP 992-200 (two cpu's) ver. 6.0 pp2.
I admit that running query on a production system is not the best thing to
do
but one of the fellows was searching out an orders problem and ran the
following
query. (A version of this query has run without major impact on the 992).
However on the new system, this job grabbed so much CPU that we did not have
console access. One of the operations group had Glance running and it was
still
getting response and so we managed to abort the job. This job was running in
the
D queue and the queues are setup using HP default parameters.
We called the response center and they said that it does not matter which
queue
Query runs in, it will bump itself up so that it can release the database if
another job wants it.
Is this true? Does this mean a query job can't be controlled?
I would have thought that users in the C queue should have still have
reasonable
response. If we put it in the E queue it should perk away in the background
even if it needs to run all day.
The following is the standard list for the query job.
This dataset has approx. 9,000,000 records in it. We open our datasets mode
1
ASSIGN LOCKOPTION=OFF for update and mode 5 for read.
:JOB QUERYKRN,MGR.SFD,DATA.
Priority = DS; HIPRI; Time = UNLIMITED seconds.
Job number = #j696.
MON, JUL 8, 2002, 11:00 AM.
HP3000 Release: C.70.01 User Version: C.70.01
MPE/iX HP31900 C.39.06 Copyright Hewlett-Packard 1987.
All rights reserved.
STREAMED BY KEVIN,KRN.SFD (#S271) ON LDEV# 169
STREAM DATE: MON, JUL 8, 2002, 10:59 AM
Welcome! You are now signed on.
:COMMENT
:PURGE QOUT.KRN
^
File "QOUT.KRN.SFD" not found. No purge done. (CIWARN 383)
:BUILD QOUT.KRN;REC=-132,,F,ASCII;DISC=500000
:FILE QSLIST=QOUT.KRN,OLD;DEV=DISC
:RUN QUERYNM.PUB.SYS
HP32216D.03.20 QUERY/NM MON, JUL 8, 2002, 11:00 AM
COPYRIGHT HEWLETT-PACKARD CO. 1976
B=AOSDB.DATA
PASSWORD =
MODE =
5
O=LP
S=ORDLINE
FIND STORE-PROM MATCHING "009123?+"
444 ENTRIES QUALIFIED
:COMMENT REPORT ALL NOPAGE
:COMMENT S1,CUSTOMER
:COMMENT D1,CUSTOMER,6
:COMMENT D1,AMT-TBAL,45,E1
:COMMENT E1,"$$,$$$,$$$.99-"
:COMMENT D1,AMT-GPYTD,60,E1
:COMMENT D1,NAME ,93
:COMMENT D1,ACCTREP ,96
:COMMENT D1,PHONE ,105,E2
:COMMENT E2,"999-9999"
:COMMENT END
EXIT
JOB aborted by system management. (CIERR 6027)
CPU sec. = 942. elapsed min. = 17. MON, JUL 8, 2002, 11:17 AM.
Listening for your comments.
Thanks
Reinhard Schilling
Sr. Technical Specialist
TruServ Canada Cooperative Inc.
1530 Gamble Pl
t. (204) 453-9697
f. (204) 452-6615
e. [log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|