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

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 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