Re: What job requested use of a QZDASOINIT job?

I like this SQL from current active jobs


SELECT Aj.Subsystem
,Aj.Job_Name
,Aj.Authorization_Name AS "Current User"
,Ns.Remote_Address
,Aj.Cpu_Time AS "MilliSeconds Used"
FROM TABLE(Qsys2.Active_Job_Info('NO', '', 'QZ*', '')) AS Aj
,Qsys2.Netstat_Job_Info AS Ns
WHERE
-- Uncomment out and change to meet your needs
-- (Aj.Authorization_Name LIKE 'USER%'
-- and NS.REMOTE_ADDRESS like '10.%')
-- AND
Aj.Job_Name = Ns.Job_Name
ORDER BY Aj.Authorization_Name;


Bryan



Rob Berendt wrote on 2/8/2019 2:15 PM:

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