When system down or some time system automatically throw some error this kind of info is logged in cogserver.log and audit database. EX: systemshut down code is CM-SYS-5094. On which table this info can be captured
I'm not sure if this helps, but you can get an alert when the system goes down.
http://www-01.ibm.com/support/docview.wss?uid=swg21370598
How can I be notified when the Cognos 8 service is shutdown?
Technote (troubleshooting)
Problem(Abstract)
How can I have Cognos 8 send me an email when the service is shutdown?
Environment
Windows and Unix operating systems.
Steps:
1. Run the logconsole.exe program from the bin folder. On UNIX, you can use X windows for the GUI.
2. Click on the Alert File menu and select Alert Management...
3. Click the "Add Alert" button.
4. For the Message Code, you will add CM-SYS-5094. (This is the shutdown message code)
5. Set the occurrences to 1.
6. Enter the email address of the recipient to be alerted.
7. Enter the SMTP server name. ie: mail.server.com (you can also get this information from the notification section in the Cognos Configuration. You do not need to add the port number)
8. Click the save and close button.
9. Restart your Cognos 8 service.
10. Again, in the bin folder, you must also run the runLogMonitor.bat file (On Unix, the files is called runLogMonitor.sh). You can minimize the command window but it must be running so it can monitor the cogserver.log file.
11. You may also wish to add the runLogMonitor.bat file to the Startup folder on Windows, or in the .profile, so that monitoring will resume if the server is rebooted for any reason.
Resolving the problem
Steps:1. Run the logconsole.exe program from the bin folder. On UNIX, you can use X windows for the GUI.
2. Click on the Alert File menu and select Alert Management...
3. Click the "Add Alert" button.
4. For the Message Code, you will add CM-SYS-5094. (This is the shutdown message code)
5. Set the occurrences to 1.
6. Enter the email address of the recipient to be alerted.
7. Enter the SMTP server name. ie: mail.server.com (you can also get this information from the notification section in the Cognos Configuration. You do not need to add the port number)
8. Click the save and close button.
9. Restart your Cognos 8 service.
10. Again, in the bin folder, you must also run the runLogMonitor.bat file (On Unix, the files is called runLogMonitor.sh). You can minimize the command window but it must be running so it can monitor the cogserver.log file.
11. You may also wish to add the runLogMonitor.bat file to the Startup folder on Windows, or in the .profile, so that monitoring will resume if the server is rebooted for any reason.
Hi,
I did test , this is not working. IBM conveyed by raising PMR this tool has defect. so they are not supporting this in c8.4. support is removed in c8.4 and replaced as logonconsole GUI in c8.4.1.