DB2 - Problem description
Problem IT20779 | Status: Closed |
DATA PROTECTION FOR SAP ON DB2: MAX_VERSIONS PURGES ONLY 1.COPY WHEN REDOLOG_COPIES ARE ON SEPARATE SERVERS | |
product: | |
DP-MY SAP W/DB2 / 5698ERPD2 / 71A - DB2 | |
Problem 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 | |
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: * **************************************************************** | |
Local Fix: | |
Use time based expiration by the IBM Spectrum Protect server using the archive copygroup parameter RETVer=days. | |
Solution | |
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. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.05.2017 27.07.2017 27.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |