By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,198 Members | 950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,198 IT Pros & Developers. It's quick & easy.

how to check for when a db2stop command is last issued

P: 19
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
Apr 25 '08 #1
Share this Question
Share on Google+
4 Replies


docdiesel
Expert 100+
P: 297
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
Apr 28 '08 #2

P: 19
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
Apr 30 '08 #3

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

Expand|Select|Wrap|Line Numbers
  1. select timestamp from SYSIBMADM.pdlogmsgs_last24hours where function = 'DB2StopMain'
Alternatively, if you want to look for stops over, say the last week:

Expand|Select|Wrap|Line Numbers
  1. select timestamp from table(pd_get_log_msgs(current timestamp - 7 days)) as x where function = 'DB2StopMain'
May 15 '08 #4

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

Expand|Select|Wrap|Line Numbers
  1. select timestamp from SYSIBMADM.pdlogmsgs_last24hours where function = 'DB2StopMain'
Alternatively, if you want to look for stops over, say the last week:

Expand|Select|Wrap|Line Numbers
  1. 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
May 21 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.