And if it runs much longer, with that amount of logs, you might consider upgrading your hardware, if you can get the budget ofcourse :)
Regards, Rick ----- Original Message ----- From: "Peter Pijpelink - P.L.C.S. BV Storage Consultants" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 10:29 PM Subject: Re: Select Stmt? or Query > 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 > > > ----------
