IT26821: SPECTRUM PROTECT SNAPSHOT DB2 STANDBY DATABASE NAMES LONGER THAN 6 CHARS ENDS WITH AN ERROR FMM6825E

Download Information: Version 8.1.6 IBM Spectrum Protect Snapshot

APAR status

• Closed as program error.

Error description

• When Spectrum Protect Snapshot for DB2 performs a DB2 standby
  backup operation for databases with names that longer than 6
  chars it ends
  with an FMM6825E SQL1000N error indicating it is not a valid
  database alias name.
  
  
  $ ./fcmcli -f backup_db2standby
  
  IBM Spectrum Protect Snapshot offload agent  ...
  
  FMM6808I The production database 'ABCDEFG1' will be cataloged.
  FMM6825E A DB2 API call failed with the following error:
  ---- error report ----
  app. message = catalog db
  line = 523
  file = esd-db2ctl.cpp
  SQLCODE = -1000
  SQL1000N "R_ABCDEFG1" is not a valid database alias name.
  FMM6809E Unable to catalog production database 'ABCDEFG1' as
  'R_ABCDEFG1'.
  
  IBM Spectrum Protect Versions Affected:
  
  All versions on all platforms.
  
  Customer/L2 Diagnostics :
  
  The 'DB2 list db directory' shows database name with more than
  six characters,
  
  > db2 list db directory
  
   System Database Directory
  
   Number of entries in the directory = 2
  
  Database 1 entry:
  
   Database alias                       = ABCDE1
   Database name                        = ABCDEFG1
   Local database directory             = /db2/ABCDEFG1
  
  
  Database 2 entry:
  
   Database alias                       = ABCDEFG1
   Database name                        = ABCDEFG1
   Local database directory             = /db2/ABCDEFG1
  
  Initial Impact: Medium
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IBM Tivoli Storage FlashCopy Manager for Unix/Linux *
  * all versions on all supported platforms and users of IBM     *
  * Spectrum Protect Snapshot for Unix/Linux versions up to      *
  * 8.1.4 on all supported platforms when backing up a DB2       *
  * standby database with a database name longer than 6          *
  * characters.                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The problem has been corrected so that DB2 standby databases
  with names longer than 6 characters 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

  FLSHCPY DB2 AGE

• Fixed component ID

  5608AC6DB

Applicable component levels

• R81A PSY

     UP

• R81L PSY

     UP

• R41A PSN

     UP

• R41L PSN

     UP