Re: TSM SQL Request
2002-11-07 11:43:02
Do you have PERL5 and are you running on AIX?
I have a script that produces this output if you like??
###############################################################
# CLIENT BACKUP TOTALS #
# FOR #
# S02F03N01 TSM SERVER #
# #
# These Totals are from 00:01 to 23:59:59 for the given date #
###############################################################
BACKUP DATE HOSTNAME DATA (MB)
10/28/2002 S02CWSP 49
10/28/2002 S02F02N01 3740
10/28/2002 S02F02N13 501
10/28/2002 S02F03N01 11
10/28/2002 S02F03N07 10
10/28/2002 S02F03N07DB2 941
10/28/2002 S02F03N09 12373
10/28/2002 S02F03N11 3805
10/28/2002 S02F04N07 125
10/28/2002 S02F04N09 677
10/28/2002 S02F04N11 1739
10/28/2002 S02F05N01 40
10/28/2002 S02F05N05 42
10/28/2002 S02F05N05DB2 1155
10/28/2002 S02F05N07 4478
10/28/2002 S02F05N09 863
10/28/2002 S02F05N13 2007
10/28/2002 S02F20N01 303
10/28/2002 S02F21N01 13161
--- "Fought,Tom" <foughtt AT OCLC DOT ORG> wrote:
> Request for sql script...
> A while back there was a posting of a very useful report.
> I have been able reproduce all the parts except for the one
> below.
> If anyone is aware of how to generate this content from the
> TSM sql databases I would really appreciate it.
> Thanks
> Tom Fought
>
>
> +---------------------------------------------------------------------------
> ------------------------------------------+
> & &
> &
> & 2.& TSM Backup Log the last 24 hours
> &
> & &
> &
> & & The following ifromation tells you how mutch data was sent over to
> TSM the last 24 hours. &
> & & The reason for this is for you to see if there is anything unusual
> with the data transfer to the TSM Server. &
> & &
> &
> & & Pay special attention to TDP product because they can say
> completed
> in schedules but dont send anything over &
> & & to TSM, because of some unknown error.
> &
> & &
> &
> & & This information alsow tells you how mutch data is sent over total
> to the system &
> & &
> &
> +---------------------------------------------------------------------------
> ------------------------------------------+
>
>
>
>
> NODE NAME DOMAIN PLATFORM
> MBYTES CONECTIONS
> ------------------ ------------------ ----------------
> ------------ -----------
> BAUG_CDB2 REKSTRAR DB2
> 12360.93 4
> FINGRANDI REKSTRAR WinNT
> 8789.06 1
> VEFUR2_NOTES REKSTRAR WinNT
> 8674.47 2
> PLUTO NYHERJI WinNT
> 6730.55 2
> VIT TITAN DB2/6000
> 5929.64 1
> CODINN TITAN AIX
> 4771.42 1
> NETV TITAN AIX
> 3395.24 1
> AIXNOTES1 NYHERJI TDP Domino AIX
> 3072.04 24
> BAUG_CWEBC REKSTRAR AIX
> 2437.61 2
> TONLIST TITAN Linux86
> 1448.93 1
> SS_PDC REKSTRAR WinNT
> 1369.52 3
> ISLENSKT REKSTRAR AIX
> 1297.98 3
> QBRMS REKSTRAR OS400
> 1170.43 9
> EXMAIL1 REKSTRAR WinNT
> 823.17 2
> SS_DOM REKSTRAR WinNT
> 768.01 5
> ORION NYHERJI WinNT
> 729.68 2
> FP TITAN WinNT
> 702.99 2
> LUMUR_NAVISION REKSTRAR WinNT
> 683.59 1
> ODINN TITAN AIX
> 676.75 1
> AXEL NYHERJI WinNT
> 668.59 2
> ISA1 REKSTRAR WinNT
> 654.20 1
> VEFUR2 REKSTRAR WinNT
> 614.36 2
> LYF_DOM REKSTRAR WinNT
> 576.00 6
> AFRITARI REKSTRAR AIX
> 551.97 2
> MENNT REKSTRAR WinNT
> 481.82 2
> NTLYF1 REKSTRAR WinNT
> 480.53 2
> GRANDIS01 REKSTRAR WinNT
> 473.74 1
> REKILL NYHERJI WinNT
> 434.84 1
> CNEO TITAN AIX
> 421.29 1
> VEFUR3 REKSTRAR WinNT
> 414.94 2
> SS_NOTES REKSTRAR WinNT
> 402.67 2
> SURTUR REKSTRAR DB2/6000
> 387.13 3
> CTRINITY TITAN AIX
> 337.09 1
> DC1 REKSTRAR WinNT
> 330.57 2
> TIMASKRANING REKSTRAR WinNT
> 307.26 1
> HEIM.IS REKSTRAR Linux86
> 254.30 2
> TS1 REKSTRAR WinNT
> 249.79 1
> MAGNADUR TITAN SCO
> 243.97 1
> GLYRNIR REKSTRAR WinNT
> 227.74 1
> SOL NYHERJI WinNT
> 211.18 2
> EXMAIL1_EXCHANGE REKSTRAR WinNT
> 190.00 6
> GRIC2RAD TITAN Linux86
> 186.99 1
> MARS NYHERJI WinNT
> 180.61 2
> SAPNSD NYHERJI WinNT
> 175.80 2
> NOTES1 NYHERJI AIX
> 154.95 1
> GYLFI NYHERJI WinNT
> 150.00 2
> LOKI TITAN AIX
> 144.20 1
> ETOP NYHERJI WinNT
> 135.68 2
> NEPTUNUS NYHERJI WinNT
> 134.43 2
> BAUG_EPLI REKSTRAR AIX
> 110.31 1
> ITS1 NYHERJI WinNT
> 94.29 2
> IDES2 NYHERJI WinNT
> 94.25 2
> JONAS NYHERJI WinNT
> 93.40 2
> MIKILL TITAN SCO
> 85.81 1
> DIRECTOR NYHERJI WinNT
> 80.36 2
> SIMASERVER1 NYHERJI WinNT
> 72.17 2
> SAPRNP REKSTRAR WinNT
> 68.36 2
> CTISERVER-01 NYHERJI WinNT
> 54.54 2
> NEO TITAN AIX
> 54.51 1
> SS_TSE2 REKSTRAR WinNT
> 51.74 2
> SS_TSE1 REKSTRAR WinNT
> 40.26 2
> ORACLE TITAN AIX
> 19.39 1
> LUMUR REKSTRAR WinNT
> 8.91 1
> SS1ADAL REKSTRAR WinNT
> 8.24 1
> BAUG_BANANI REKSTRAR AIX
> 3.09 1
> ?
>
> +------------------------------------------+
> & &
> & Total data sent to TSM the last 24 hours &
> & &
> +------------------------------------------+
>
>
> DATE MBYTES CONNECTIONS
> ---------- ------------ -----------
> 2002-04-22 76948.59 149
__________________________________________________
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
|
|
|