Who shut down my Instance?
Is it possible to find out who or what shut down the instance? version 11.5
In the onstat - m log, I only see that it shut down on Friday at 11am.
10:56:43 Checkpoint Completed: duration was 0 seconds.
10:56:43 Fri May 25 - loguniq 13475, logpos 0x45f1018, timestamp: 0x711b88db
Interval: 833499
10:56:43 Maximum server connections 131
10:56:43 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0,
Plog used 2, Llog used 5
11:01:39 SCHAPI: thread dbWorker1 task mon_memory_system(8-33765) shutting down
11:01:39 SCHAPI: thread dbScheduler task mon_checkpoint(0-67484) shutting down
11:01:39 SCHAPI: thread dbWorker2 task mon_checkpoint(7-67483) shutting down
11:01:41 Shutdown Mode
11:01:42 Quiescent Mode
11:01:42 Checkpoint Completed: duration was 0 seconds.
11:01:42 Fri May 25 - loguniq 13475, logpos 0x45f60c0, timestamp: 0x711b90b2
Interval: 833500
11:01:42 Maximum server connections 131
11:01:42 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0,
Plog used 2, Llog used 5
11:01:43 IBM Informix Dynamic Server Stopped.
11:02:48 IBM Informix Dynamic Server Started.
11:02:48 Segment locked: addr=0x44000000, size=4609024000
No, Benji, there is not record kept of what session executed the onmode to
shutdown the instance.
Depending on your server configuration, check the logs, who logged in that period with user informis or did su - informix, if selinux is enabled, check /var/log/audit/audit.log or use ausearch, or any other available useful logs..or contact your system administrator to do an audit regarding this.