iSeries Audit Journal
Use the following command to display the contents of the audit journal on the iSeries:
DSPJRN JRN(QSYS/QAUDJRN) FROMTIME(092807 080000) JRNCDE((T *ALLSLT)) ENTTYP(AF)
This is very useful when researching security issues.
Author
Stewart Schatz
More Stories
Quick Tip: IBM Navigator for i Default URL
This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console
Server Manager Agent Not Connecting To SMC
After a Java update, the server manager agent may not connect to the SMC because of parameters in the java.security...
Quick Tip: How To Delete Multiple SQLPKGs
Run the following command to delete all the SQLPKG's in the QRECOVERY library with a name beginning with "OW" DLTSQLPKG...
Quick Tip: IBM i (iSeries / AS400) Spool File Navigation
The following commands can be used to navigate spool files after using a command similar to WRKSPLF. Just enter the...
Needle: IBM iSeries (AS400) Power Outage JDE Recovery
Crazy to think but this issue has come up a few times in my years as an Oracle JD Edwards...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Average Rating