query actlog

[Gormag]

Guys,

Can boolean operators be used when querying actlog? I am wanting to search for multiple items over a month and the volume of logs is just too painfull tot view in the cli.

ideas, options?

All I am trying to do is,

q actlog begind=03/01/2006 s=string1|string2|string3

anything like this an option?

 

[RMGBELGIUM]

the actlog can easily be read with a kind of SQL , see redbook "IBM Tivoli Storage Manager 5.1 Technical Guide" Appendix A or do a google on "S5735A.pdf".This will help you further a lot.


This is a little example of how to get certain errors between 2 dates :
@actlog=`dsmadmc -id=admin -pass=$passwd -commadelimited "select cast(DATE_TIME as char(19)),MESSAGE from ADSM.ACTLOG where (cast(ACTLOG.DATE_TIME as char(16)) like '%$vandaag%' or cast(ACTLOG.DATE_TIME as char(16)) like '%$gisteren%' ) and (ACTLOG.MESSAGE like '%ANR1405W%' or ACTLOG.MESSAGE like '%ANR8357I%' or ACTLOG.MESSAGE like '%ANR1411W%' or ACTLOG.MESSAGE like '%ANR8830E%' or ACTLOG.MESSAGE like '%8944E%' or ACTLOG.MESSAGE like '%8792E%' or ACTLOG.MESSAGE like '%ANR2186W%')"|grep -v cast|grep -v "|"|grep -v ANS8002I|grep -v trunc`;



rgds,

R.

 

[Gormag]

RMGBELGIUM,

Thanks, that is a workable option.

For the environment I am in, a few changes will have to be made as the only shell access we have is a direct dump into dsmadmc.

Thanks much!