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