SELECT message_id, message_type, severity, from_job,
message_timestamp, message_text, message_second_level_text
FROM
TABLE (
qsys2.history_log_info( START_TIME => CURRENT DATE - 8 days)) as x
where (x.from_job like('%QZDASOINIT%') and (x.message_id = 'CPIAD09')) or
(x.from_job like('%QRWTSRVR%') and (x.message_id = 'CPI3E34'))
order by x.message_timestamp desc;
Sample results will all begin with
User xxxx from client ##.##.##.## connected ...
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor
Sent: Friday, February 8, 2019 1:11 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: What job requested use of a QZDASOINIT job?
QZDASOINIT job are typically for remote DB access (think ODBC). If the job's active, Properties->Server will give you the client IP. Connections should also be logged to the History Log, so you can search for the job#.
-----Original Message-----
From: Steinmetz, Paul via MIDRANGE-L [mailto:midrange-l@xxxxxxxxxxxxxxxxxx]
Sent: Friday, February 08, 2019 8:27 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Subject: What job requested use of a QZDASOINIT job?
I noticed, via my performance tools, that one of my QZDASOINIT jobs, was taking 30% of CPU, for a 12 1/2 hour period.
From the performance data/graphs, the process started 2/6 15:00, ended 2/7 3:16, due to an error.
Only thing in the QZDASOINIT joblog is CPIAD07 Host server error occurred with reason code 7.
How can I find what job requested the use of the QZDASOINIT job?
Message ID . . . . . . : CPIAD07
Date sent . . . . . . : 02/07/19 Time sent . . . . . . : 03:16:50
Message . . . . : Host server error occurred with reason code 7.
Cause . . . . . : A error with reason code 7 occurred during host server
processing; the reason codes and their meanings are as follows:
1 -- Resolve to the host server daemon program failed.
2 -- Retrieval of the host server daemon program lock failed.
3 -- Submit job to start the host server daemon job failed.
4 -- Allocation of the host server daemon program failed.
5 -- Starting of the host server job failed.
6 -- Ending of the host server daemon job failed.
7 -- Activation of the host server job failed.
8 -- Processing of exchange random seed request failed.
9 -- Processing of start server request failed.
10 -- Reallocation of server buffer failed.
11 -- Deallocation of the host server daemon program failed.
12 -- Resolve to the server specific user space failed.
13 -- Resolve to the trace buffer user space failed.
14 -- Resolve to the trace buffer user queue failed.
15 -- Read operation from the server specific user space failed.
16 -- Read operation from the trace buffer user space failed.
17 -- Write to server specific user space failed.
18 -- Write to server trace buffer space failed.
19 -- Enqueue operation to the trace buffer user queue failed.
99 -- Unknown processing error occurred.
Recovery . . . : Determine the cause of the error; if necessary, correct
the error and retry the request.
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
