ADSM-L

Re: Select Stmt? or Query

2002-05-21 16:38:07
Subject: Re: Select Stmt? or Query
From: "Williams, Tim P {PBSG}" <Tim.Williams AT PBSG DOT COM>
Date: Tue, 21 May 2002 15:36:02 -0500
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
/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]>

<Prev in Thread] Current Thread [Next in Thread>