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.
'
... |
