IT41956: THE "BACKUP SPEED" IN SQL DATABASE BACKUP HISTORY REPORT IS NOT SAME AS THE THROUGHPUT VALUE IN JOB LOG

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus SQL Database Backup History report
  shows inconsistent value of "Backup Speed" compared with the
  throughput value displayed in the backup job log. For example,
  job log shows:
  
  CTGGA3120,[sql-host] Total data transferred is [2.50]GB  total
  time [00h:00m:13s]  throughput [195.00]MB/s.
  
  
  But SQL Database Backup History report shows Backup Speed as
  86.50 MB/s. The two fields are calculated in two different ways.
  
  
  Versions affected: IBM Spectrum Protect Plus 10.1.*
  
  Additional Keywords: SPP, SPPLUS, TS009805952
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.1 - 10.1.12             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.13. Note that this is subject to change at the          *
  * discretion of IBM                                            *
  ****************************************************************
  

Problem conclusion

• This problem has been fixed so that SQL backup throughput values
  reported in SQL Database Backup History report are consistent
  with that reported in the job log.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels