IBM Support

IT26741: DB2 BACKUP FAILS WHEN DB2 DATABASE IS LOCATED ON XFS FILE SYSTEMS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An IBM Spectrum Protect Plus Db2 database backup running on
    Linux fails while mounting a LVM snapshot of a XFS file system.
    This problem only occurs on Linux when the Db2 database is
    located on XFS file systems.
    
    In the Joglog the following can error message can be found:
    SnapshotException occurred: SnapshotException('Mounting of
    snapshot volume snap-tblspcs-db2inst1-SPPDB2-0-20181003104517-0
    failed.' )
    Exception occurred in the Db2 scripted interface
    SnapshotException('Mounting of snapshot volume
    snap-tblspcs-db2inst1-SPPDB2-0-20181003104517-0 failed.' )
    Finished Db2 command with errors
    Error in Db2 backup database command
    Command line 'db2 backup database SPPDB2 online use snapshot
    script
    /tmp/cdm_guestapps_sppagent/db2agent/db2apiclient/db2_acs_script
    .sh options \'/mnt/spp/vsnap/vpool1/fs2/SPPDB2/db2backuprepo
    --options_file
    /tmp/c9df2eb0-f12e-4c62-a239-422dd79e6b0f/db2_options.json\''
    has ended with exit code 4.               stdout:  SQL2079N  An
    error was reported by the shared library "libdb2acssc.so".
    Return code: "4".    stderr:
    
    The corresponding command log shows the following error:
    XFS (dm-7): Filesystem has duplicate UUID
    7a2fb218-5f1f-4c33-8f59-783ee4a04a3b - can't mount
    
    Products & versions affected:
    IBM Spectrum Protect Plus Version 10.1.2 using Db2 Application
    Agent
    
    Platforms affected:
    Linux
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus level 10.1.2 using the DB2         *
    * database agent to backup the DB2 databases on Linux residing *
    * on the XFS file system.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed IBM Spectrum Protect Plus level        *
    * 10.1.2.271 and 10.1.3. Note that this is subject to change   *
    * at the discretion of IBM.                                    *
    ****************************************************************
    

Problem conclusion

  • The issue has been corrected so that DB2 databases located on
    the XFS file system can be backed up.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26741

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-25

  • Closed date

    2019-01-08

  • Last modified date

    2019-01-23

  • 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

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
30 January 2024