Please call your Tivoli support rep back and ask about the status of APAR
IC33455. This is the correct APAR for this problem. I have included the
text below.

ERROR DESCRIPTION:
 Found on TSM Version 4.2.2.0
 Other Versions Affected  TSM Server V5.1
 OSs Effected All (recreated on WIN, AIX, Solaris)
 Happens with all TSM Client levels (tested 4.x thru 5.1 clients
 Impact: medium
 When backing up to a V4.2..2.0 or V5.1.0 TSM server the
 summary table is not being updated to show the correct amount
 of bytes received.  In the older versions of the server the
 bytes would display the amount of data received,however with
 versions 5.1.0 and 4.2.2.0 the bytes received is
 reflecting 0 bytes.  This is a problem for customers that
 verify backups with scripts querying the SUMMARY table:
 ..
 "select * from SUMMARY where ACTIVITY = 'BACKUP' "
 ..
 Examples:
   Server Version 4, Release 2, Level 1.11
 Total number of bytes transferred:     8.55 MB

 tsm: SOCRATES>select * from SUMMARY where ACTIVITY = 'BACKUP'
    START_TIME: 2002-04-29 14:42:49.000000
      END_TIME: 2002-04-29 14:44:06.000000
      ACTIVITY: BACKUP
        NUMBER: 3
        ENTITY: CHIPSHOT
      COMMMETH: Tcp/Ip
 SCHEDULE_NAME:
      EXAMINED: 54
      AFFECTED: 54
        FAILED: 0
         BYTES: 0
          IDLE: 76
        MEDIAW: 0
     PROCESSES: 1
    SUCCESSFUL: YES
   VOLUME_NAME:
    DRIVE_NAME:
  LIBRARY_NAME:
      LAST_USE:

   Server Version 4, Release 2, Level 2.0
 Total number of bytes transferred:     6.73 MB
 tsm: DUMPTRUCK>select * from SUMMARY where ACTIVITY='BACKUP'
 *** Older Backup when TSM server was at V4.2.1.0 **

    START_TIME: 2002-04-15 15:18:57.000000
      END_TIME: 2002-04-15 15:20:55.000000
      ACTIVITY: BACKUP
        NUMBER: 5
        ENTITY: COSMO
      COMMMETH: Tcp/Ip
 SCHEDULE_NAME:
      EXAMINED: 459
      AFFECTED: 459
        FAILED: 0
         BYTES: 10195527
          IDLE: 0
        MEDIAW: 0
     PROCESSES: 1
    SUCCESSFUL: YES
   VOLUME_NAME:
    DRIVE_NAME:
  LIBRARY_NAME:
      LAST_USE:
  *********After Upgrade to V4.2.2***************

    START_TIME: 2002-04-29 14:59:42.000000
      END_TIME: 2002-04-29 15:03:25.000000
      ACTIVITY: BACKUP
        NUMBER: 2
        ENTITY: CHIPSHOT
      COMMMETH: Tcp/Ip
 SCHEDULE_NAME:
      EXAMINED: 74
      AFFECTED: 74
        FAILED: 0
         BYTES: 0
          IDLE: 222
        MEDIAW: 0
     PROCESSES: 1
    SUCCESSFUL: YES
   VOLUME_NAME:
    DRIVE_NAME:
  LIBRARY_NAME:
      LAST_USE:
 LOCAL FIX:
 Please apply appropriate PTF when available.



At 09:38 AM 5/26/2002 -0400, you wrote:

We just went up to 4.2.2.2 and it's still broke. Actually that BROKE it for
us. We were at 4.1.2.5 before that. I have a PMR open and the tech said "Per
my research, this problem matches APAR IC31132 for AIX, and IC31296 for
Windows.  Per the README file for TSM 4.2.2, these apars
were supposed to be fixed at this level.  As such, I will need to escalate
this for further determination by our L2 group."

It's better than SMF...I don't need SAS and it's not RECFM=VBS! Just a nice
SQL query from Excel does the trick.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Don France
Sent: Friday, May 24, 2002 9:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: changeing bytes to gigabytes


BUT WAIT... have you not seen 4.2.2 and 5.1.x -- both have "broken" summary
table info, specifically the BYTES column is (mostly, not always) ZERO!  I
am still researching the other columns, they may be FUBAR'ed also;  I am
told there is an APAR open for this -- IC33455 -- anyone know when it will
get fixed?!?  (For capacity planning & workload monitoring, this is the
single BEST resource we've used in a long time, since the old SMF days!)

Don France
Technical Architect -- Tivoli Certified Consultant
San Jose, Ca
(408) 257-3037
mailto:don_france AT att DOT net

Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Seay, Paul
Sent: Wednesday, May 22, 2002 7:12 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: changeing bytes to gigabytes


Select entity, cast(bytes/1024/1024/1024 as decimal(8,2)) as "Gigabytes  "
from summary

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180


-----Original Message-----
From: Blair, Georgia [mailto:georgia.blair AT USAA DOT COM]
Sent: Tuesday, May 21, 2002 11:52 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: changeing bytes to gigabytes


I am using the summary table to monitor how much data migrates from disk on
a daily basis. What is the easiest way to find change the amount to
gigabytes versus bytes? Or does someone have a particular select statement
for this.

Thanks in advance
georgia.blair AT usaa DOT com

Money is not the root of all evil - full backups are.