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:[EMAIL PROTECTED]] >Sent: Tuesday, May 21, 2002 1:59 PM >To: [EMAIL PROTECTED] >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 > >[EMAIL PROTECTED] > > > > > >----- Original Message ----- > >From: "Steve Harris" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >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 > > > > >>> [EMAIL PROTECTED] 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 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 ----------
