Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IT01991	Status: Closed
PERFORMING A BACKUP INCREMENTAL DELTA TO TSM WITH THE DEDUP_DEVICE ON DPF INSTANCE MAY FAIL WITH SQL2038N (-91).
product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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"
Problem Summary:
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 LUW v9.7 Fixpack 10 or Later. * ****************************************************************
Local Fix:
db2 "backup db sample on dbpartitionnum (1) ONLINE INCREMENTAL DELTA USE TSM OPEN 2 SESSIONS DEDUP_DEVICE INCLUDE LOGS without prompting" or db2 "backup db sample on all dbpartitionnums ONLINE INCREMENTAL DELTA USE TSM OPEN 2 SESSIONS INCLUDE LOGS without prompting"
Solution
First fixed in DB2 LUW v9.7 Fixpack 10.
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	23.05.2014 17.11.2014 17.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10