These kind of selects you can run per node or with a wildcard * mostly will
run a few minutes or so.

Peter

At 15:36 21-05-2002 -0500, you wrote:

How long does this take. For us, it takes forever (we have LOTS of logs in
24 hours...
Anyway we just do a q actlog begintime=now-24 (actlogscan.mac), then I use
awk...
dsmadmc -id=xxx -pa=xxxx -itemcommit
-outfile=/var/tsm/report_data/actlogtmp1 macro /flapps
/adsm/macros/actlogscan.mac
awk '$3 ~ /D/|| $3 ~ /W/|| $3 ~ /[0-9,0-9,0-9]E/'
/var/tsm/report_data/actlogtmp1 > /var/tsm/re
port_data/actlogtmp2
awk 'substr($1,1,1) ~ /[0-9]/' /var/tsm/report_data/actlogtmp2 >
/var/tsm/report_data/actlogtmp
3
#
# this is the message elimination step
#ANR2457E BACKUP STGPOOL: Backup of primary storage pool  NOTETAPE to copy
storage pool NOTETAP
E_CP
# already in progress.
# ANR2209W Volume /dev/radsmstglv06 contains no data.
# ANR0944E QUERY PROCESS: No active processes found.
# ANR2034E QUERY SESSION: No match found using this criteria.
#  ANE4987E (Session: 14832, Node: US504S16)  Error processing
'\\us504s16\c$\WINNT\system32\co
nfig
# \SAM.LOG': the object is in use by another process
# ANE4007E (Session: 14475, Node: PLANXI04)  Error  processing
'\\planxi04\c$\WINNT\Profiles\
#   corpxchgsvc\NTUSER.DAT': access to the object is denied
# ANR1423W Scratch volume 001223 is empty but will not be
#           deleted - volume access mode is "offsite". you get a slew of
these after
# a tsm recycle pretty much for every volume in courierretrieve atleast.
#  ANR2841W Server is NOT IN COMPLIANCE with license terms.
awk '$3 !~ /ANR2457E/&&$3 !~/ANR2209W/&&$3 !~/ANR0944E/&&$3 !~/ANR2034E/&&$3
!~/ANE4987E/&&$3!~
/ANE4007E/&&$3 !~/ANR1423W/&&$3 !~/ANR2841W/'
/var/tsm/report_data/actlogtmp3 > /var/tsm/report
_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxxt < /var/tsm/report_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxx < /var/tsm/report_data/actlog_to_email
mail -s "TSM - SCANLOG report" xxx < /var/tsm/report_data/actlog_to_email
#
dsmadmc -id=xxxx -pa=xxx macro /flapps/adsm/macros/showtime.mac
[pbsxsz00004][/flapps/aix/prod.script]>

-----Original Message-----
From: tsm [mailto:tsm AT PLCS DOT NL]
Sent: Tuesday, May 21, 2002 1:59 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select Stmt? or Query


hi, maybe you will have something usefull on this script:

select severity,count(*) as "TOTAAL" from actlog where severity in
('E','W') AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24
group by severity select date(date_time) as "DATUM" , time(date_time) as
"TIJD" , message as "MESSAGE" FROM actlog WHERE severity = 'E' AND msgno
NOT in
(0944,1455,1463,1464,1469,2000,2020,2022,2034,2165,2166,2305,2904,2905,2906,
2908,2909,2911,2916,2938,2940)
AND cast((current_timestamp-date_time)hours as decimal (8,0)) <24

or

select nodename,message from actlog where (msgno=4961 or msgno=4964)AND
nodename='$1' AND cast((current_timestamp-date_time)hours as decimal (8,0))
<24 order by nodename

Look in the messages guide 5.1 Messages GC32-0767-00.pdf for other
messagenumbers you would like to see.


At 10:13 21-05-2002 -0700, you wrote:
>Also, there *may* be other messages of interest (if b/a-client, 4961, 4959,
>and others in close numeric proximity are the session statistics messages).
>
>
>Don France
>Technical Architect - Tivoli Certified Consultant
>Professional Association of Contract Employees (P.A.C.E.)
>San Jose, CA
>(408) 257-3037
>don_france AT att DOT net
>
>
>----- Original Message -----
>From: "Steve Harris" <STEVE_HARRIS AT HEALTH.QLD.GOV DOT AU>
>To: <ADSM-L AT VM.MARIST DOT EDU>
>Sent: Tuesday, May 07, 2002 7:26 PM
>Subject: Re: Select Stmt? or Query
>
>
>Try something like
>
>select date_time, message
>from actlog
>where nodename='MYNODE'
>and date_time > current timestamp - 12 hours
>and msgno in (1234, 5678, 9876)
>
>Just tune the where clause to select the messages that you want.  Run this
>in commadelimited mode and pipe the output through your scripting tool of
>choice to give you a pretty report.
>
>Steve Harris
>AIX and TSM Admin
>Queensland Health, Brisbane Australia
>
> >>> Bud.Brown AT DHHA DOT ORG 08/05/2002 3:35:57 >>>
>Hello All:
>
>I have a unix client that kicks off an incremental backups thru tivoli
>using an internal dump process for a sql database.  I want to provide a
>report to the group that monitors its backup.  The only information they
>care about is whether a filespace backed up successfully, what files
>failed, and how much data was transferred.  For the time being I am
>running 'q actlog begind=-1 begint=18:00:00 sea='nodename', because we
>try to schedule our backups between 6 p.m. and 6 a.m.  This is too much
>information to run thru on a daily basis for them and they were hoping I
>could trim down a report.  Does anybody have a select statement or query
>that comes close to the needs I have?
>
>Thanks,
>
>Bud Brown
>Information Services
>Systems Administrator
>
>
>
>**********************************************************************
>This e-mail, including any attachments sent with it, is confidential
>and for the sole use of the intended recipient(s). This confidentiality
>is not waived or lost if you receive it and you are not the intended
>recipient(s), or if it is transmitted/ received in error.
>
>Any unauthorised use, alteration, disclosure, distribution or review
>of this e-mail is prohibited.  It may be subject to a statutory duty of
>confidentiality if it relates to health service matters.
>
>If you are not the intended recipient(s), or if you have received this
>e-mail in error, you are asked to immediately notify the sender by
>telephone or by return e-mail.  You should also delete this e-mail
>message and destroy any hard copies produced.
>**********************************************************************

met vriendelijke groet,
with regards,

Peter Pijpelink


----------
Bezoek onze website op http://www.plcs.nl

P.L.C.S. Storage Consultants

----------
Postadres:                              Bezoekadres:

PLCS B.V.                               PLCS B.V.
Postbus 292                             Het Tasveld 23
3340 AG Hendrik Ido Ambacht                     3342 GT Hendrik Ido Ambacht
Tel.: 078-6823685 Fax: 078-6823686              mobiel 06-24821621

Op deze email is een disclaimer van toepassing.
http://www.plcs.nl/disclaimer.html
On this email is subject to a disclamier. http://www.plcs.nl/disclaimer.html


----------

met vriendelijke groet,
with regards,

Peter Pijpelink


----------
Bezoek onze website op http://www.plcs.nl
Bezoek onze website op http://www.plcs.nl

P.L.C.S. Storage Consultants