IT22319: SPECTRUM PROTECT SNAPSHOT FOR VMWARE GUI RETURNS FMM16094E VMCLIEXCEPTION DUE TO DERBY DATABASE SQL ERROR

Download Information: Version 4.1.6.4 Interim Fix: IBM Spectrum Protectâ„¢ Snapshot for VMware

APAR status

• Closed as program error.

Error description

• Spectrum Protect Snapshot for VMware GUI returns FMM16094E
  VmcliException due to DERBY database SQL error. This happens
  when the size of DERBY database is large, like exceeding 1.3GB.
  The DERDB database gets corrupted and is unable to insert data
  into table. When running either db_compact or db_backup, it
  returns FMM16012E which is caused by:
  
  org.apache.derby.client.am.SqlException: DERBY SQL error:
  SQLCODE: -1, SQLSTATE: XSDG0: Page Page(51919,Container(0,
  1104)) could not be read from disk.
  
  This is a problem reported by DERBY-5234:
  https://issues.apache.org/jira/browse/DERBY-5234
  

Local fix

• 1. Recreate DERBY database
     1.1 stop vmcli daemon by running:
         /etc/init.d/vmcli stop
     1.2 rename DERBY database folder
  /home/tdpvmware/tdpvmware/VMCLIDB to
  /home/tdpvmware/tdpvmware/VMCLIDB.xxx
     1.3 start vmcli daemon by running:
         /etc/init.d/vmcli start
     1.4 once vmcli is restarted, a new VMCLIDB folder is
  automatically generated and DERBY database is recreated
  (Note: After the DERBY database is deleted, there is no
  reference of existing Spectrum Protect Snapshot for VMware
  backups. The offload backups restore points are still
  available. If you need to keep the existing backup
  tasks definitions, please contact IBM support for instruction.)
  
  2. Download the db-derby-10.8.3.0-lib.tar.gz from link:
  https://db.apache.org/derby/releases/release-10.8.3.0.html
  
  3. To update the jars used by the vmcli do the following as
  tdpvmware user:
      3.1 stop the vmcli daemon by running:
          /etc/init.d/vmcli stop
      3.2 copy the downloaded tar.gz file to the Spectrum Protect
  Snapshot for VMware machine and extract it
      3.3 make a copy of /opt/tivoli/tsm/tdpvmware/common/lib
  folder
      3.4 copy the jar files from the lib folder in the extraction
  to /opt/tivoli/tsm/tdpvmware/common/lib by running:
          cp *.jar /opt/tivoli/tsm/tdpvmware/common/lib
      3.5 restart the vmcli daemon by running:
          /etc/init.d/vmcli start
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Spectrum Protect Snapshot for VMware that are using *
  * the DERBY database version 10.8.2.3 and larger than 1.3 GB   *
  * and using Web GUI to execute the backup.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available.                           *
  ****************************************************************
  

Problem conclusion

• Once the fix is in place, the backup operation started with Web
  GUI will be completed even if the DERBY database is larger than
  1.3 GB.
  

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

  FLSHCPYMGR VMWA

• Fixed component ID

  5608AC6VM

Applicable component levels

• R31L PSN

     UP

• R41L PSY

     UP