ADSM-L

Re: TSM SQL Request

2002-11-07 11:43:02
Subject: Re: TSM SQL Request
From: Zig Zag <veritrash AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 7 Nov 2002 08:41:50 -0800
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

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