DB2 - Problem description
Problem IT21827 | Status: Closed |
Snapshot backup might fail with error SQL2079N | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Snapshot backup using Tivoli Storage FlashCopy Manager might fail with error SQL2079N when following example backup command is being used: db2 "backup db SAMPLE online use snapshot options device_class=RES without prompting" In the database logs we can see following entries, that indicate DB2 is passing wrong parameter value to FlashCopy Manager: ... 2016-08-16-06.27.54.098447+120 E33933A489 LEVEL: Info PID : 7536688 TID : 21698 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-33355 APPID: *LOCAL.db2inst1.160816042753 AUTHID : USER HOSTNAME: hdhu0778 EDUID : 21698 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1897 MESSAGE : Starting an online snapshot db backup. 2016-08-16-06.28.14.403670+120 E34423A1058 LEVEL: Error PID : 7536688 TID : 21698 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-33355 APPID: *LOCAL.db2inst1.160816042753 AUTHID : USER HOSTNAME: hdhu0778 EDUID : 21698 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database utilities, sqluSnapshotPartition, probe:558 DATA #1 : String, 34 bytes /db2/db2inst1/sqllib/acs/libacsdb2.a MESSAGE : Vendor (return code / reason code / description): DATA #2 : signed integer, 4 bytes 11 DATA #3 : signed integer, 4 bytes 0 DATA #4 : String, 394 bytes FMM8323E IBM Tivoli Storage FlashCopy(R) Manager : Problem occurred while processing db2ACSPartition(). Please check log file for more information. Error information: 'FMM8601E The following device class sections are missing in the profile: FMM8602E The parameter DEVICE_CLASS is referring to device class section 'DEVICE_CLASS:RES......YY...........' which does not exist in the profile. ' ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to db2_v111m1fp2 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT19285 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 09.10.2017 09.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |