tdp sql backup stats discrepancies

Have any of you TDP for SQL TSMers seen the following and is it a bug or
working as designed?

When doing a full backup of a sql db the stats in the tsm server
activity log and the stats in tdpsdl.log are the same but the event
summary record shows different numbers.

act log shows        1,855,248 bytes sent
tdpsql.log shows     1,855,248 byte sent
event summary shows    722 Kb

I noticed this when we turned client side compression on and the act log
and tdpsql.log stats did not change but the event summary did change to
321 Kb which showed compression is now being used.

Why the discrepancies?

=====================================

TSM server v5.2.3.2 on Win2000.
TDP for DB v5.1.5.0
TSM client v5.2.2.9

=====================================

contents of tdpsql.log
12/03/2004 10:18:06 12/03/2004 10:18:06 Request   : FULL BACKUP
12/03/2004 10:18:06 Database Input List           : -
12/03/2004 10:18:06 Group Input List              : -
12/03/2004 10:18:06 File Input List               : -
12/03/2004 10:18:06 Number of Buffers             : 3
12/03/2004 10:18:06 Buffer Size                   : 1024
12/03/2004 10:18:06 Number of SQL Buffers         : 1
12/03/2004 10:18:06 SQL Buffer Size               : 1024
12/03/2004 10:18:06 Number of Stripes specified   : 1
12/03/2004 10:18:06 Estimate                      : -
12/03/2004 10:18:06 Truncate Log?                 : -
12/03/2004 10:18:06 Wait for Tape Mounts?         : Yes
12/03/2004 10:18:06 TSM Options File              : S:\Program
Files\Tivoli\TSM\TDPSql\dsm.opt
12/03/2004 10:18:06 TSM Nodename Override         : -
12/03/2004 10:18:06 Sqlserver                     : WANC15
12/03/2004 10:18:06
12/03/2004 10:18:25 Total SQL backups selected:               1
12/03/2004 10:18:25 Total SQL backups attempted:              1
12/03/2004 10:18:25 Total SQL backups completed:              1
12/03/2004 10:18:25 Total SQL backups excluded:               0
12/03/2004 10:18:25 Total SQL backups inactivated:            0
12/03/2004 10:18:25 Throughput rate:                          103.44 Kb/Sec
12/03/2004 10:18:25 Total bytes transferred:                  1,855,248
12/03/2004 10:18:25 Elapsed processing time:                  17.52 Secs


12/02/2004 21:07:25 12/02/2004 21:07:25 Request                       :
FULL BACKUP
12/02/2004 21:07:25 Database Input List           : stellent
12/02/2004 21:07:25 Group Input List              : -
12/02/2004 21:07:25 File Input List               : -
12/02/2004 21:07:25 Number of Buffers             : 3
12/02/2004 21:07:25 Buffer Size                   : 1024
12/02/2004 21:07:25 Number of SQL Buffers         : 1
12/02/2004 21:07:25 SQL Buffer Size               : 1024
12/02/2004 21:07:25 Number of Stripes specified   : 1
12/02/2004 21:07:25 Estimate                      : -
12/02/2004 21:07:25 Truncate Log?                 : -
12/02/2004 21:07:25 Wait for Tape Mounts?         : Yes
12/02/2004 21:07:25 TSM Options File              : S:\Program
Files\Tivoli\TSM\TDPSql\dsm.opt
12/02/2004 21:07:25 TSM Nodename Override         : -
12/02/2004 21:07:25 Sqlserver                     : WANC15
12/02/2004 21:07:25
12/02/2004 21:08:04 Total SQL backups selected:               1
12/02/2004 21:08:04 Total SQL backups attempted:              1
12/02/2004 21:08:04 Total SQL backups completed:              1
12/02/2004 21:08:04 Total SQL backups excluded:               0
12/02/2004 21:08:04 Total SQL backups inactivated:            40
12/02/2004 21:08:04 Throughput rate:                          157.54 Kb/Sec
12/02/2004 21:08:04 Total bytes transferred:                  1,855,248
12/02/2004 21:08:04 Elapsed processing time:                  11.50 Secs

=====================================

display node
                     Node Name: WANC15
                      Platform: WinNT
               Client OS Level: 5.00
                Client Version: Version 5, Release 2, Level 2.9
                   Compression: Client
                     Node Type: Client
                   TCP/IP Name: WANC15
=====================================

display of summary records
12/02/2004   11:32:16 PM   00:01:21            2            722 Kb

12/03/2004   10:18:07 AM   00:00:18            2            321 Kb


=====================================

display of activity log
12/02/2004 21:07:21   ANR0403I Session 15250 ended for node WANC15_SQL
(). (SESSION: 144)

12/02/2004 21:07:21   ANR2561I Schedule prompter contacting WANC15_SQL
(session 15250) to start a scheduled operation. (SESSION: 144)

12/02/2004 21:07:22   ANR0406I Session 15251 started for node WANC15_SQL
(WinNT) (Tcp/Ip wanc15.itg.ak.local(4973)). (SESSION: 15251)

12/02/2004 21:07:25   ANR0406I Session 15252 started for node WANC15_SQL
(TDP MSSQL) (Tcp/Ip wanc15.itg.ak.local(4977)). (SESSION: 15252)


12/02/2004 21:07:26   ANE4991I (Session: 15252, Node: WANC15_SQL)  TDP
MSSQL ACO3006 Data Protection for SQL: Starting backup for server
WANC15.  (SESSION: 15252)

12/02/2004 21:07:27   ANE4991I (Session: 15252, Node: WANC15_SQL)  TDP
MSSQL  ACO3000 Data Protection for SQL: Starting full backup of database
stellent from server WANC15.  (SESSION: 15252)

12/02/2004 21:07:38   ANE4991I (Session: 15252, Node: WANC15_SQL)  TDP
MSSQL ACO3001 Data Protection for SQL: full backup of database stellent
from server WANC15 completed successfully. (SESSION: 15252)


12/02/2004 21:08:04   ANE4991I (Session: 15252, Node: WANC15_SQL)  TDP
MSSQL ACO3008 Data Protection for SQL: Backup of server WANC15 is
complete.
Total SQL backups selected: 1
Total SQL backups attempted: 1
Total SQL backups completed: 1
Total SQL backups excluded: 0
Total SQL backups inactivated: 40
Throughput rate: 157.54 Kb/Sec
Total bytes transferred: 1,855,248
Elapsed processing time: 11.50 Secs   (SESSION: 15252)


12/02/2004 21:08:04   ANR0403I Session 15252 ended for node WANC15_SQL
(TDP MSSQL). (SESSION: 15252)

12/02/2004 21:08:05   ANR2507I Schedule WANC15_SQL_FULL for domain
ITG_DOMAIN started at 12/02/2004 21:07:00 for node WANC15_SQL completed
successfully at 12/02/2004 21:08:05. (SESSION: 15251)


12/02/2004 21:08:05   ANR0403I Session 15251 ended for node WANC15_SQL
(WinNT). (SESSION: 15251)

12/02/2004 21:08:05   ANR0406I Session 15253 started for node WANC15_SQL
(WinNT) (Tcp/Ip wanc15.itg.ak.local(4978)). (SESSION: 15253)
12/02/2004 21:08:06   ANR0403I Session 15253 ended for node WANC15_SQL
(WinNT). (SESSION: 15253)

12/03/2004 10:18:07   ANR0406I Session 15804 started for node WANC15_SQL
(TDP MSSQL) (Tcp/Ip wanc15.itg.ak.local(1530)). (SESSION: 15804)


12/03/2004 10:18:07   ANE4991I (Session: 15804, Node: WANC15_SQL)  TDP
MSSQL ACO3006 Data Protection for SQL: Starting backup for server
WANC15.  (SESSION: 15804)

12/03/2004 10:18:07   ANE4991I (Session: 15804, Node: WANC15_SQL)  TDP
MSSQL ACO3000 Data Protection for SQL: Starting full backup of database
stellent from server WANC15.  (SESSION: 15804)

12/03/2004 10:18:25   ANE4991I (Session: 15804, Node: WANC15_SQL)  TDP
MSSQL ACO3001 Data Protection for SQL: full backup of database stellent
from server WANC15 completed successfully. (SESSION: 15804)


12/03/2004 10:18:25   ANE4991I (Session: 15804, Node: WANC15_SQL)  TDP
MSSQL ACO3008 Data Protection for SQL: Backup of server WANC15 is
complete.
Total SQL backups selected: 1
Total SQL backups attempted: 1
Total SQL backups completed: 1
Total SQL backups excluded: 0
Total SQL backups inactivated: 0
Throughput rate: 103.44 Kb/Sec
Total bytes transferred: 1,855,248
Elapsed processing time: 17.52 Secs   (SESSION: 15804)

12/03/2004 10:18:25   ANR0403I Session 15804 ended for node WANC15_SQL
(TDP  MSSQL). (SESSION: 15804)





--

Steve Bennett, (907) 465-5783
State of Alaska, Enterprise Technology Services, Technical Services Section