Re: search in q actlog

2002-05-22 Thread Seay, Paul

The search option does not allow for this, but the select command does allow
you to do anything you want.  If you make the select a script or macro you
can just about create your own 'q actlog' command with variables as input.
These are the fields you can search on:

 DATE_TIME:
 MSGNO:
  SEVERITY:
   MESSAGE:
ORIGINATOR:
  NODENAME:
 OWNERNAME:
 SCHEDNAME:
DOMAINNAME:
SESSID:
SERVERNAME:

This is a sample select statement to do what you want.

select * from actlog where (lower(message) like '%error%' or lower(message)
like '%fail%') and date_time current_timestamp - 2 hour

This one generates output more like the q act command:

select cast(date_time as char(16)), message as Message
 from actlog where (lower(message) like '%error%' or lower(message) like
'%fail%') and date_time current_timestamp - 2 hour

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180


-Original Message-
From: Chuck Lam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 6:31 PM
To: [EMAIL PROTECTED]
Subject: search in q actlog


Hello,

TSM 4.1.4 running in AIX 4.3.3

If I want to search error and fail in 'q actlog',
is there any way I can put multiple searching strings
in one command, rather than one at a time?

TIA

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com



Re: search in q actlog

2002-05-22 Thread Rick Harderwijk

Chuck,

You might want to look into 'select' queries from the 'summary' table, using
the correct errorcodes (instead of the word) you're interested in.

Regards,

Rick

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Chuck Lam
Sent: donderdag 23 mei 2002 0:31
To: [EMAIL PROTECTED]
Subject: search in q actlog


Hello,

TSM 4.1.4 running in AIX 4.3.3

If I want to search error and fail in 'q actlog',
is there any way I can put multiple searching strings
in one command, rather than one at a time?

TIA

__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com