Question & Answer
Question
Answer
The Audit Value *JOBDTA can be used to track connections to the IBM i database host server and DDM/DRDA server. This document uses that data to create an SQL report.
Note 1: This document can only be used for ODBC/JDBC and DDM/DRDA sessions, it does not provide data when the user Signs onto the system via other interfaces.
To get started, make sure that your System Value QAUDLVL already contains the *JOBDTA value, if the value is not listed, you can use the following command to add it:
CHGSECAUD press <F4> and add it to your current QAUDLVL system value.
Note 1: Use the command DSPSECAUD to verify your current Audit Values.
Note 2: If Security Auditing is not turned on your system, refer to Setting Up Security Auditing Using Security Tools
Once the system has been tracking Job Data information, you can get started using the following commands:
Step 1: On the operating system command line, type the following command and press <Enter>:
CPYAUDJRNE ENTTYP(JS)
Note 1: Press <F4> to specify date and time range criteria or specify an alternate output library. Specify *CURCHAIN for the "Starting journal receiver" parameter if you want to generate a report that contains data from multiple journal receivers. For example:
CPYAUDJRNE ENTTYP(JS) JRNRCV(*CURCHAIN) FROMTIME('date' 'time') TOTIME('date' 'time') OUTFILE(QGPL/QAUDIT)
Step 2: On the operating system command line, type the following commands and press the Enter key.
Using the Run SQL Scripts tool, run the statement:
SELECT JSJNAM,
JSJUSR,
JSJNUM,
JSUSRP,
JSTSTP,
JSRADR
FROM QGPL.QAUDITJS
WHERE JSETYP = 'M'
AND JSJTYP = 'B'
AND JSSTYP = 'J'
AND JSJNAM = 'QZDASOINIT'
AND JSUSRP <> 'QUSER'
Report produced by the sample SQL:
Note: Job names QRWTSRVR or QZDASSINIT may be substituted for QZDASOINIT.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 August 2021
UID
ibm16221266