1. The ZPSAMON subsystem is up.
2. Query commands have been selected for auditing on the "Work with SQL auditing" screen (From PSMENU, take options 1,1,7
3. Instructions for possible STRDBMON outfile issues (e.g. NETIQKB70910) have been followed.
and data still does not appear on the SQL/QRY audit report, I am on OS/400 V5R4 or higher.
OS/400 V5R4 and higher uses proxy commands which do not include a CPP which the SQL/QRY monitor uses, our exit program needs to be added manually using command:
PGMDTA(*JOB 20 'STRSQL QSYS')
Moving forward, any new query commands setup should appear.