how to check for when a db2stop command is last issued

[db2dbdba]

Hi All,

How can I check for when a db2stop command is last issued?

Or when a db2 force applications all command is last issued?

Thanks in advance

R

[docdiesel]

Hi,

check the db2diag.log (on *nix systems in ~/sqllib/db2dump/ ). DB2 logs starts and stops there. If you find some information about "force application" I can't say at the moment.

Regards,

Bernd

[db2dbdba]

Hi,

check the db2diag.log (on *nix systems in ~/sqllib/db2dump/ ). DB2 logs starts and stops there. If you find some information about "force application" I can't say at the moment.

Regards,

Bernd

Sorry it was my bad.
I tried using the db2diag.
I am checking whether there is any other option.

Thanks,
R

[cburnett]

If you are on V9, you can check this from within DB2 using:

select timestamp from SYSIBMADM.pdlogmsgs_last24hours where function = 'DB2StopMain'

Alternatively, if you want to look for stops over, say the last week:

select timestamp from table(pd_get_log_msgs(current timestamp - 7 days)) as x where function = 'DB2StopMain'

[db2dbdba]

If you are on V9, you can check this from within DB2 using:

select timestamp from SYSIBMADM.pdlogmsgs_last24hours where function = 'DB2StopMain'

Alternatively, if you want to look for stops over, say the last week:

select timestamp from table(pd_get_log_msgs(current timestamp - 7 days)) as x where function = 'DB2StopMain'

Thanks so much for your help.
Unfortunately My bad luck. I am still in V8.2


R