Performing a backup incremental delta to TSM with the
DEDUP_DEVICE on DPF instance may fail with SQL2038N (-91).
The following are required to run into this issue:
- DPF Instance.
- Use INCREMENTAL options on backup command.
- User DEDUP_DEVICE option on backup command.
- Use the on all dbpartitionnums on backup command.
db2 "backup db sample on all dbpartitionnums ONLINE INCREMENTAL
DELTA USE TSM OPEN 2 SESSIONS DEDUP_DEVICE INCLUDE LOGS without
prompting"
Fails with:
Part Result
----
----------------------------------------------------------------
--------
0000 SQL2001N The utility was interrupted. The output data
may be incomplete.
0001 SQL2001N The utility was interrupted. The output data
may be incomplete.
0002 SQL2038N A database system error "-91" occurred during
processing.
0003 SQL2001N The utility was interrupted. The output data
may be incomplete.
SQL2429N The database backup failed. The following database
partitions
returned errors: "2".
db2daig.log:
2014-05-02-12.16.07.482720+060 E8689A457 LEVEL: Info
PID : 40763440 TID : 2855 PROC : db2sysc
0
INSTANCE: db2inst5 NODE : 000 DB : SAMPLE
APPHDL : 0-62 APPID: *N0.db2inst5.140502111608
AUTHID : DB2INST5
EDUID : 2855 EDUNAME: db2agntp 0
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:1604
MESSAGE : Starting an online incremental delta db backup.
2014-05-02-12.16.07.506559+060 E9147A466 LEVEL: Info
PID : 3932236 TID : 6171 PROC : db2sysc
3
INSTANCE: db2inst5 NODE : 003 DB : SAMPLE
APPHDL : 0-62 APPID: *N0.db2inst5.140502111608
AUTHID : DB2INST5
EDUID : 6171 EDUNAME: db2agntp (SAMPLE) 3
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:1604
MESSAGE : Starting an online incremental delta db backup.
2014-05-02-12.16.07.534221+060 E9614A466 LEVEL: Info
PID : 27066488 TID : 6171 PROC : db2sysc
2
INSTANCE: db2inst5 NODE : 002 DB : SAMPLE
APPHDL : 0-62 APPID: *N0.db2inst5.140502111608
AUTHID : DB2INST5
EDUID : 6171 EDUNAME: db2agntp (SAMPLE) 2
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:1604
MESSAGE : Starting an online incremental delta db backup.
2014-05-02-12.16.07.568771+060 E10081A466 LEVEL: Info
PID : 30081178 TID : 6427 PROC : db2sysc
1
INSTANCE: db2inst5 NODE : 001 DB : SAMPLE
APPHDL : 0-62 APPID: *N0.db2inst5.140502111608
AUTHID : DB2INST5
EDUID : 6427 EDUNAME: db2agntp (SAMPLE) 1
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl,
probe:1604
MESSAGE : Starting an online incremental delta db backup.
2014-05-02-12.16.23.660026+060 E10548A395 LEVEL: Severe
PID : 3932236 TID : 6690 PROC : db2sysc
3
INSTANCE: db2inst5 NODE : 003
EDUID : 6690 EDUNAME: db2med.6171.0 (SAMPLE) 3
FUNCTION: DB2 UDB, database utilities,
sqluMCProcessMsgFromAgent, probe:1009
MESSAGE : Received unexpected message type.
DATA #1 : signed integer, 4 bytes
2
2014-05-02-12.16.23.660329+060 E10944A315 LEVEL: Severe
PID : 3932236 TID : 6690 PROC : db2sysc
3
INSTANCE: db2inst5 NODE : 003
EDUID : 6690 EDUNAME: db2med.6171.0 (SAMPLE) 3
FUNCTION: DB2 UDB, database utilities,
sqluMCProcessMsgFromAgent, probe:1014
2014-05-02-12.16.23.660505+060 E11260A525 LEVEL: Error
PID : 3932236 TID : 6171 PROC : db2sysc
3
INSTANCE: db2inst5 NODE : 003 DB : SAMPLE
APPHDL : 0-62 APPID: *N0.db2inst5.140502111608
AUTHID : DB2INST5
EDUID : 6171 EDUNAME: db2agntp (SAMPLE) 3
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse,
probe:990
MESSAGE : SQL2038N A database system error "" occurred during
processing.
DATA #1 : unsigned integer, 4 bytes
4294967205
REPRODUCTION:
db2 activate db sample
db2 "backup db sample on all dbpartitionnums ONLINE USE TSM OPEN
2 SESSIONS DEDUP_DEVICE INCLUDE LOGS without prompting"
db2 connect to sample
db2 drop table mbj
db2 "create table mbj like staff"
db2diag -A
db2 "backup db sample on all dbpartitionnums ONLINE INCREMENTAL
DELTA USE TSM OPEN 2 SESSIONS DEDUP_DEVICE INCLUDE LOGS without
prompting" |
