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:[EMAIL PROTECTED]]On Behalf Of
>Don France
>Sent: Friday, May 24, 2002 9:39 PM
>To: [EMAIL PROTECTED]
>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:[EMAIL PROTECTED]
>
>Professional Association of Contract Employees
>(P.A.C.E. -- www.pacepros.com)
>
>
>
>-----Original Message-----
>From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
>Seay, Paul
>Sent: Wednesday, May 22, 2002 7:12 PM
>To: [EMAIL PROTECTED]
>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:[EMAIL PROTECTED]]
>Sent: Tuesday, May 21, 2002 11:52 AM
>To: [EMAIL PROTECTED]
>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
>[EMAIL PROTECTED]
Money is not the root of all evil - full backups are.
