IBM Support

IT17588: "CREATE_CLONE" COMMAND FAILS FOR DB2 DATABASES IF LOGARCHCOMPR1 AND/OR LOGARCHCOMPR2 ARE SET TO ON

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Error Description:
    The IBM Spectrum Protect snapshot command "fcmcli -f
    create_clone" will fails for DB2 databases if on the production
    server the DB2 options LOGARCHCOMPR1 and/or LOGARCHCOMPR2 are
    set to ON
    
    Example:
    First log archive method                 (LOGARCHMETH1) =
    DISK:/sample-archive/
    Archive compression for logarchmeth1    (LOGARCHCOMPR1) = ON
    Options for logarchmeth1                  (LOGARCHOPT1) =
    Second log archive method                (LOGARCHMETH2) = TSM
    Archive compression for logarchmeth2    (LOGARCHCOMPR2) = ON
    Options for logarchmeth2                  (LOGARCHOPT2) =
    -servername=SAMPLE_ARCH
    
    
    The command will return the following error:
    FMM6825E A DB2 API call failed with the following error:
    ---- warning report ----
    SQL1663W  Log archive compression is not fully enabled for
    "LOGARCHMETH1".
    --- end warning report ---
    FMM6524I Stopping database instance 'sample'.
    FMM6525I Database instance ?sample? was stopped successfully.
    FMM1060E Failed to set the DB2 database configuration for
    database
    'SAMPLE'.
    FMM1554W The agent 'tsm4acs V. 4.1.3.0' terminated with exit
    code 1.
    FMM6504E The 'recover_clone' request failed.
    FMM0020I End of program at: Mon Oct 10 14:49:59 SAST 2016.
    FMM0021I Elapsed time: 07 min 41 sec.
    FMM0024I Return code is: 2.
    
    Customer/L2 Diagnostics:
    
    IBM Spectrum Protect Versions Affected: IBM Spectrum Protect
    Snapshot for DB2 agent v4.1.x on UNIX platforms
    
    Initial Impact: Low
    
    Additional Keywords: FMM6825E SQL1663W  LOGARCHMETH1 FMM6504E
    create_clone db2 recover_clone
    

Local fix

  • On the production server set archive compression for
    LOGARCHCOMPR1 and LOGARCHCOMPR2 to OFF. Contact your DB2
    administrator for doing so.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of IBM Spectrum Protect Snapshot v4.1 or v8.1.0.0 for  *
    * DB2 using the cloning functionality to create or refresh a   *
    * clone of a DB2 database while logarchcompr1 or logarchcompr2 *
    * is set to on in the database configuration (functions        *
    * create_clone or refresh_clone)                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in IBM Spectrum Protect Snapshot       *
    * v8.1.0.1. Note that this information may be subject to       *
    * change at the discretion of IBM.                             *
    ****************************************************************
    

Problem conclusion

  • The code is changed to still log warnings received from DB2, but
    to continue processing in spite of these warnings. In order to
    avoid seeing such warning messages in the IBM Spectrum Protect
    Snapshot log files, the database administrator can switch off
    both logarchcompr1 and logarchcompr2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT17588

  • Reported component name

    FLSHCPY DB2 AGE

  • Reported component ID

    5608AC6DB

  • Reported release

    41A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-20

  • Closed date

    2017-01-24

  • Last modified date

    2017-01-24

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

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

Modules/Macros

  • tsm4acs
    

Fix information

  • Fixed component name

    FLSHCPY DB2 AGE

  • Fixed component ID

    5608AC6DB

Applicable component levels

  • R41A PSN

       UP

  • R81A PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS36V9","label":"Tivoli Storage FlashCopy Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"41A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
24 January 2017