USRMONITOR is in charge of auditing the real users of the new jobs in the system. It creates a database in library called USHST01P where all historic data for new jobs in the system is stored with the effective user or real user and the job user.

 
The real user is used by SQLMONITOR in order to know who launched a specific SQL sentence. USRMONITOR provides the real user information to SQLMONITOR an other monitors which would need it.
First of all, we need to know which configuration values are in these system variables: QAUDLVL and QAUDCTL. We can do it with the following commands:
 
DSPSYSVAL QAUDCTL
 
DSPSYSVAL QAUDLVL
 
In a normal situation where the QAUDJRN object does not exist in QSYS library, the typical value we would find in system variable QAUDCTL is *NONE. And the typical value for the QAUDLVL system value is *AUTFAIL.
 
After checking these values we can create the QAUDJRN object with its journal receiver objects using the command:
 
CHGSECAUD QAUDCTL(*AUDLVL *OBJAUD *NOQTEMP) QAUDLVL(*AUTFAIL *SECURITY *SERVICE *CREATE *DELETE *OBJMGT *SAVRST *PGMFAIL)
The only thing you must take into account is not to miss any of the previous values of the system values QAUDCTL and QAUDLVL. That is, if we have any previous value in these system values which are not in the list of values in the CHGSECAUD command above then we need to add these existent values into the command before launching it.
 
Once the CHGSECAUD command has been executed you must check the QAUDJRN objet in library QSYS. You can do it with the following command:
 
WRKOBJPDM QSYS QAUDJRN
 
And now, the USRMONITOR will be ready to be launched.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: October 22, 2018