pr********@gmail.com wrote:
Hi,
Whether is there any way to find stopped/started timestamp of a db2 udb
instance other than the db2diag.log files.Is there any catalog table
available to get the timestamp informations or by using stored
procedures we can get the information's.
Thanks in advance.
Hai Prince ...
As this is relating to the instance i guess there wont be any table
from where we can get the timestamp.B'cos to access a table we need a
database connection and the table will be specific to that database. As
Table is an object which is specific to a database i guess we cannot
get the information for the instance as a whole....
I guess this is the same with Stored procedures also...
So there are two options we have now
1. Command to find the timestamp when an instance is started/stopped
..---- not sure about this ---according to my knowledge we dont have any
such command
2. As u said db2diag.log.....
But ..
If there is any error when starting or stopping the instance a log is
created in the following locations with the timestamp.
Windows : C:\Program Files\IBM\SQLLIB\DB2\log
Linux or UNIX : <instance home dir >/sqllib/log
Format of the file is : db2start.<timestamp when it happened>.errlog
db2stop.<timestamp when it
happened>.errlog
This is my view please let me know if we have any other way to find
.....
Thanks
Kamal.....