Activity log....your best friend evah!

Activity Log

Search in the activity log for missed schedules in the last 2 hours

tsm: SERVER1> SELECT date_time,message FROM actlog WHERE originator='SERVER' AND -

message LIKE'ANR2578W%' AND date_time>=current_timestamp-2 hours

DATE_TIME MESSAGE

------------------ ------------------

2007-07-26 ANR2578W Schedule

14:00:01.000000 ORACLE_HOME in

domain AIX for

node SERVER-1

has missed its

scheduled start

up window.

Search in the activity log for messages with Error severity in the last 1 hour

tsm: SERVER1> SELECT date_time,message FROM actlog WHERE originator='SERVER' AND severity='E' AND -

date_time>current_timestamp-1 hours

DATE_TIME MESSAGE

------------------ ------------------

2007-07-27 ANR2034E QUERY

10:22:17.000000 SPACETRIGGER: No

match found using

this criteria.(

SESSION: 252982)

Search in the activity log for successful, missed or failed schedules in the last 1 day

tsm: SERVER1> SELECT date_time,severity,message FROM actlog WHERE originator='SERVER' AND -

( message LIKE'ANR2507I%' OR -

message LIKE'ANR2751I%' OR -

message LIKE'ANR2578W%' OR -

message LIKE'ANR2579E%') AND -

date_time>timestamp(current_date)-(1)days

DATE_TIME SEVERITY MESSAGE

------------------ ------------------ -------------------

2007-07-25 I ANR2507I Schedule

00:14:48.000000 IN_APP1 for domain

NT started at

07/24/07 22:30:00

for node SERVER-2

completed

successfully at

07/25/07

00:14:48.(SESSIO-

N: 233833)

2007-07-25 E ANR2579E Schedule

00:30:03.000000 INC_APP2 in domain

NT for node

SERVER-3

failed (return

code 1).(SESSION:

234285)

2007-07-25 W ANR2578W Schedule

00:40:01.000000 ORACLE_HOME in

domain AIX for

node SERVER-1

has missed its

scheduled start

up window.

Search in the activity log for a specific ANR in the last 1 day

tsm: SERVER1> SELECT date_time,severity,message from actlog WHERE message LIKE'ANR8438I%' -

and date_time>timestamp(current_date)-(1)days

DATE_TIME SEVERITY MESSAGE

------------------ ------------------ ------------------

2007-07-27 I ANR8438I CHECKOUT

09:21:19.000000 LIBVOLUME for

volume R00135L3

in library 3584

completed

successfully.(SE-

SSION: 252515,

PROCESS: 470)

2007-07-27 I ANR8438I CHECKOUT

09:21:28.000000 LIBVOLUME for

volume R00049L3

in library 3584

completed

successfully.(SE-

SSION: 252515,

PROCESS: 471)