IT20779: DATA PROTECTION FOR SAP ON DB2: MAX_VERSIONS PURGES ONLY 1.COPY WHEN REDOLOG_COPIES ARE ON SEPARATE SERVERS

Download Information: Version 8.1.4 IBM Spectrum Protectâ„¢ for Enterprise Resource Planning

APAR status

• Closed as program error.

Error description

• For increasing the data availability, IBM Spectrum Protect for
  Enterprise Resource Planning can be configured to use the
  feature of 'REDOLOG_COPIES 2' in initSID.utl with
  BRARCHIVEMGTCLASSes on separate IBM Spectrum Protect servers.
  
  Sample excerpt
  (omitting parameters which are unrelated to this symptom):
  
    MAX_SESSIONS 4
    REDOLOG_COPIES 2
    MAX_VERSIONS 7
    SERVER spect01
      SESSIONS 4
      BRARCHIVEMGTCLASS mgclass01
    SERVER spect02
      SESSIONS 4
      BRARCHIVEMGTCLASS mgclass02
  
  This setup will store the 1st redolog copy into
  BRARCHIVEMGTCLASS mgclass01 on SERVER spect01. The 2nd copy is
  simultaneously stored into BRARCHIVEMGTCLASS mgclass02 on
  SERVER spect02.
  
  Once the number of backup versions exceeds the maximum
  specified by the MAX_VERSIONS parameter, the oldest backup and
  the associated redologs become eligible for deletion.
  But it was found the product only purges the 1.COPY in
  BRARCHIVEMGTCLASS mgclass01 on SERVER spect01, leaving obsolete
  orphaned log copies in BRARCHIVEMGTCLASS mgclass02 on
  SERVER spect02.
  
  Product versions affected: Tivoli Storage Manager for Enterprise
                             Resource Planning: Data Protection
                             for SAP on DB2 version 6.4
                             IBM Spectrum Protect for Enterprise
                             Resource Planning: Data Protection
                             for SAP on DB2 version 7.1
             Initial impact: Medium
        Additional keywords: TSM, ISP, versioning, expiration,
                             obsolete, orphan
  

Local fix

• Use time based expiration by the IBM Spectrum Protect server
  using the archive copygroup parameter RETVer=days.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users that configured the feature of 'REDOLOG_COPIES 2' in   *
  * initSID.utl with                                             *
  * BRARCHIVEMGTCLASSes on separate IBM Spectrum Protect         *
  * servers.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The IBM Spectrum Protect for Enterprise Resource Planning is
  corrected so that redolog copies are expired from all configured
  and available IBM Spectrum Protect servers.
  

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

• prole
  

Fix information

• Fixed component name

  DP-MY SAP W/DB2

• Fixed component ID

  5698ERPD2

Applicable component levels

• R71L PSY

     UP

• R81L PSY

     UP

• R71A PSY

     UP

• R81A PSY

     UP