IC90724: DB2 10.1 ARCHIVE LOGS USING LOG COMPRESSION ARE CORRUPTED DURING BACKUP/RESTORE BY TSM FOR ERP 6.3

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 10.1 introduced a new configuration parameter for log
    backup: LOGARCHCOMPR1 and LOGARCHCOMPR2
    which specifies that log files written to the archive
    destination for logs are compressed.
    
    When Tivoli Storage Manager for Enterprise Resource Planning:
    (TSM for ERP) Data Protection for SAP for DB2 backs up and
    restores DB2 10.1 log files that use the LOGARCHCOMPR
    configuration parameter, the log files become corrupted and
    unusable by DB2.
    TSM for ERP archive and retrieve operations against this
    type of log file are also affected.
    .
    Customer/L2 Diagnostics:
    The error is reported when the log files are used for
    roll forward recovery.
    
     db2 recover database ab1
    
    SQL1268N Rollforward recovery processing has stopped because of
    error
    "SQL1042" while retrieving log file "S000001.LOG" for database
    "ab1"
    ondatabase partition "0" and log stream "0".
    
    
    In the DB2 diaglog the following error is reported:
    2013-03-07-18.21.13.402283+060 I92520493A580 LEVEL: Error
    PID : 17891344 TID : 3811 PROC : db2sysc 0
    INSTANCE: db2ab1 NODE : 000
    HOSTNAME: de-s-0192853
    EDUID : 3811 EDUNAME: db2logmgr (DG3) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogToTemp,
    probe:7680
    MESSAGE : expansion size not equal to the original
    DATA #1 : signed integer, 4 bytes
    130896
    DATA #2 : signed integer, 4 bytes
    131072
    DATA #3 : Dumped object of size 37789 bytes at offset 0, 43
    bytes
    /db2/DG3/db2dump/17891344.3811.000.dump.bin
    
    2013-03-07-18.21.13.403152+060 I92521074A475 LEVEL: Error
    PID : 17891344 TID : 3811 PROC : db2sysc 0
    INSTANCE: db2ab1 NODE : 000
    HOSTNAME: de-s-0192853
    EDUID : 3811 EDUNAME: db2logmgr (AB1) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveLogToTemp,
    probe:7680
    MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic
    Error"
    DIA8526C A fatal error occurred in data protection services.
    
    Tivoli Storage Manager Versions Affected:
    IBM Tivoli Storage Manager for Enterprise Resource Planning
    Version 6.3 and 6.2: Data Protection for SAP for DB2
    
    
    Initial Impact:
    High
    
    
    Additional Keywords:
    TSM checksum
    

Local fix

  • Do not use LOGARCHCOMPR1 or LOGARCHCOMPR2 when corresponding
    LOGARCHMETH1 or LOGARCHMETH2 is set to vendor.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: IBM Tivoli Storage Manager for Enterprise    *
    *                 Resource Planning (Data Protection for SAP   *
    *                 for DB2) v6.2 and v6.3 having DB2 archived   *
    *                 log files compression enabled.               *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    *
    

Problem conclusion

  • IBM Tivoli Storage Manager for Enterprise Resource Planning
    (Data Protection for SAP for DB2) will be fixed to correctly
    work with compressed archived log files
    

Temporary fix

  • A fix for this problem is available with interim fix package
    6.3.0.3.
    

Comments

APAR Information

  • APAR number

    IC90724

  • Reported component name

    DP-MY SAP W/DB2

  • Reported component ID

    5698ERPD2

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-11

  • Closed date

    2013-04-11

  • Last modified date

    2013-04-11

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

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

Fix information

  • Fixed component name

    DP-MY SAP W/DB2

  • Fixed component ID

    5698ERPD2

Applicable component levels

  • R63A PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager for Enterprise Resource Planning
Data Protection for SAP® for DB2

Software version:

6.3

Reference #:

IC90724

Modified date:

2013-04-11

Translate my page

Machine Translation

Content navigation