DB2 - Problem description
Problem IT17588 | Status: Closed |
"CREATE_CLONE" COMMAND FAILS FOR DB2 DATABASES IF LOGARCHCOMPR1 AND/OR LOGARCHCOMPR2 ARE SET TO ON | |
product: | |
FLSHCPY DB2 AGE / 5608AC6DB / 41A - DB2 | |
Problem 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 | |
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. * **************************************************************** | |
Local Fix: | |
On the production server set archive compression for LOGARCHCOMPR1 and LOGARCHCOMPR2 to OFF. Contact your DB2 administrator for doing so. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.10.2016 24.01.2017 24.01.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |