I know you are asking about iSeries and DB2 database, but in Oracle you include the sysdate function in the SQL:
<pre>SELECT SYSDATE, <COLUMN…>, FROM <TABLE>;</pre>
Sure there is an equivelant function in DB2.
If you’ve journalled the file and if the sql command changed the file then look to the file. I don’t know if the 400 keeps the date & time with SQL commands.
As with almost all audit or log functions, if you haven’t turned it on, you can’t retrieve information from it. In this case, if you have the database monitor running, you can retrieve statements from it along with timestamps. Use STRDBMON to start the monitor. You can monitor only specific jobs or all jobs. For basic logging, you probably only need *SUMMARY records. Request *DETAIL when you want more finely grained data. You can start monitors for specific jobs even if an *ALL jobs monitor is already running.