I have a DB2 installed on a AIX machine and CMOD ver8.5 too. My client requires a report or a query to run on DB2 through which they can extract user generated event logs and store it in a db table.
They want to develop a report in which they want to find out that how many users have viewed a specific report on a required date and time?
Thanks!
Have you turned on Message Loggin for the specific Application Group the report is associated with? Right click the App Group and go to Message Logging Tab.
I recently did a project where I captured the ENTIRE system log for a certain time
Then I used sql queries like WHERE MSG_NUM = 66 and MSG_TEXT = REPORT1234 etc..Once this was done, I had db2 put it in a csv file, I wrote a quick macro, and boom...had what I was looking for. Not sure if this is what your asking but I am sure its probably a step in the right direction!!
You should be able to create a named query that produces the information you're looking for -- you can issue that query daily (by hand, or with "arsdoc query") and deliver it via (eMail?) from there.
From your description, this should satisfy most of your client's requirements.
-JD.
Or you can use arslog where the events incl. indexes (Severity, Message, User, MsgID,...) are directly given to arslog and you can do whatever you want (email it, write it to a file, store to a dif. db and so on).
I save Err + Warning Messages and send them every 10 Minutes to the admins.