Fixes are available
APAR status
Closed as fixed if next.
Error description
Problem Description: -------------------- Online backup session fail because of error SQL0911N with rc=68, because other applications accessing the databases and do not commit very often. The backup of large data partition will run for long time and then it failed with -911. We could avoid this situation (force the lock-holder off) if we can observe that the backup is in locl-wait status. But the backup never shows lock-wait status, it is always in status "performing a backup". Note:- This is applicable only for DPF env. We find the following in db2diag.log entries: --------------------- 2010-01-04-04.43.26.325416+060 E59477468A874 LEVEL: Severe PID : 9953332 TID : 1 PROC : db2bm.16826442.2 2 INSTANCE: dwhprod NODE : 002 APPHDL : 2-593 APPID: *N2.dwhprod.100103190156 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, probe:613 MESSAGE : SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "". DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2 sqlerrmc: 68 sqlerrp : sqlubRea sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000002 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2010-01-04-04.43.36.423257+060 E59478343A373 LEVEL: Severe PID : 16826442 TID : 1 PROC : db2agent (DWHDB) 2 INSTANCE: dwhprod NODE : 002 DB : DWHDB APPHDL : 2-593 APPID: *N2.dwhprod.100103190156 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 MESSAGE : Backup terminated. . . . 2010-01-04-05.16.42.815942+060 I67624104A506 LEVEL: Error PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 INSTANCE: dwhprod NODE : 008 APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, SqlubTableLock::request, probe:73 DATA #1 : String, 48 bytes Error getting lock. PoolId: 219, ObjectId: 496 DATA #2 : Hexdump, 4 bytes 0x0FFFFFFFFFFFAE00 : 8010 0044 ...D 2010-01-04-05.16.42.816629+060 E67624611A475 LEVEL: Severe PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 INSTANCE: dwhprod NODE : 008 APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, probe:613 DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes -911 DATA #2 : Hexdump, 8 bytes 0x0000000111024820 : 8010 0044 0000 0044 ...D...D 2010-01-04-05.16.42.816976+060 E67625087A873 LEVEL: Severe PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 INSTANCE: dwhprod NODE : 008 APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, probe:613 MESSAGE : SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "". DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2 sqlerrmc: 68 sqlerrp : sqlubRea sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000008 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: . . . 2010-01-04-05.20.54.753529+060 E68835749A373 LEVEL: Severe PID : 4898828 TID : 1 PROC : db2agent (DWHDB) 8 INSTANCE: dwhprod NODE : 008 DB : DWHDB APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 AUTHID : DWH007 FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 MESSAGE : Backup terminated. -------------------------- -------------------------- # CMD = db2 get snapshot for application agentid 131665 global Application Snapshot Application handle = 131665 Application status = Performing a Backup Status change time = 01/03/2010 20:01:57.329930 Application code page = 819 Application country/region code = 0 DUOW correlation token = *N2.dwhprod.100103190156 Application name = db2bp Application ID = *N2.dwhprod.100103190156 Sequence number = 00002 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 01/03/2010 20:01:56.843801 Connect request completion timestamp = 01/03/2010 20:01:56.862016 Application idle time = 8 hours 38 minutes 41 seconds CONNECT Authorization ID = DWH007 Client login ID = dwh007 Configuration NNAME of client = apdwh1.nbg.sdv.sdvrz Client database manager product ID = SQL09018 Process ID of client application = 1110180 Platform of client application = AIX 64BIT Communication protocol of client = Local Client -------------------------- --------------------------- # CMD = db2 get snapshot for application agentid 524879 global Application Snapshot Application handle = 524879 Application status = Performing a Backup Status change time = 01/03/2010 20:01:53.517604 Application code page = 819 Application country/region code = 0 DUOW correlation token = *N8.dwhprod.100103190153 Application name = db2bp Application ID = *N8.dwhprod.100103190153 Sequence number = 00002 TP Monitor client user ID = TP Monitor client workstation name = TP Monitor client application name = TP Monitor client accounting string = Connection request start timestamp = 01/03/2010 20:01:53.029327 Connect request completion timestamp = 01/03/2010 20:01:53.051552 Application idle time = 8 hours 38 minutes 47 seconds CONNECT Authorization ID = DWH007 Client login ID = dwh007 Configuration NNAME of client = apdwh1.nbg.sdv.sdvrz Client database manager product ID = SQL09018 Process ID of client application = 7311362 Platform of client application = AIX 64BIT Communication protocol of client = Local Client ----------------------------------
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * Online backup session fail because of error SQL0911N with * * rc=68, * * because other applications accessing the databases and do * * not * * commit very often. The backup of large * * * * data partition will run for long time and then it failed * * with * * -911. We could avoid this situation (force the lock-holder * * off) * * if we can observe that the backup is in locl-wait status. * * But * * the backup never shows lock-wait status, it is always in * * status * * "performing a backup". * * * * * * * * Note:- This is applicable only for DPF env. * * * * * * * * We find the following in db2diag.log entries: * * * * * * * * --------------------- * * * * 2010-01-04-04.43.26.325416+060 E59477468A874 LEVEL: Severe * * * * PID : 9953332 TID : 1 PROC : db2bm.16826442.2 2 * * * * INSTANCE: dwhprod NODE : 002 * * * * APPHDL : 2-593 APPID: *N2.dwhprod.100103190156 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, * * probe:613 * * MESSAGE : SQL0911N The current transaction has been rolled * * back * * because of a * * * * deadlock or timeout. Reason code "". * * * * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes * * * * sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2 * * * * sqlerrmc: 68 * * * * sqlerrp : sqlubRea * * * * sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 * * * * (4) 0x00000000 (5) 0x00000000 (6) 0x00000002 * * * * sqlwarn : (1) (2) (3) (4) (5) (6) * * * * (7) (8) (9) (10) (11) * * * * sqlstate: * * * * * * * * 2010-01-04-04.43.36.423257+060 E59478343A373 LEVEL: Severe * * * * PID : 16826442 TID : 1 PROC : db2agent (DWHDB) 2 * * * * INSTANCE: dwhprod NODE : 002 DB : DWHDB * * * * APPHDL : 2-593 APPID: *N2.dwhprod.100103190156 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 * * * * MESSAGE : Backup terminated. * * * * . * * * * . * * * * . * * * * 2010-01-04-05.16.42.815942+060 I67624104A506 LEVEL: Error * * * * PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 * * * * INSTANCE: dwhprod NODE : 008 * * * * APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, * * SqlubTableLock::request, * * probe:73 * * * * DATA #1 : String, 48 bytes * * * * Error getting lock. * * * * PoolId: 219, ObjectId: 496 * * * * DATA #2 : Hexdump, 4 bytes * * * * 0x0FFFFFFFFFFFAE00 : 8010 0044 ...D * * * * * * * * 2010-01-04-05.16.42.816629+060 E67624611A475 LEVEL: Severe * * * * PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 * * * * INSTANCE: dwhprod NODE : 008 * * * * APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, * * probe:613 * * DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes * * * * -911 * * * * DATA #2 : Hexdump, 8 bytes * * * * 0x0000000111024820 : 8010 0044 0000 0044 ...D...D * * * * * * * * 2010-01-04-05.16.42.816976+060 E67625087A873 LEVEL: Severe * * * * PID : 17481968 TID : 1 PROC : db2bm.4898828.2 8 * * * * INSTANCE: dwhprod NODE : 008 * * * * APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, * * probe:613 * * MESSAGE : SQL0911N The current transaction has been rolled * * back * * because of a * * * * deadlock or timeout. Reason code "". * * * * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes * * * * sqlcaid : SQLCA sqlcabc: 136 sqlcode: -911 sqlerrml: 2 * * * * sqlerrmc: 68 * * * * sqlerrp : sqlubRea * * * * sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 * * * * (4) 0x00000000 (5) 0x00000000 (6) 0x00000008 * * * * sqlwarn : (1) (2) (3) (4) (5) (6) * * * * (7) (8) (9) (10) (11) * * * * sqlstate: * * * * . * * * * . * * * * . * * * * 2010-01-04-05.20.54.753529+060 E68835749A373 LEVEL: Severe * * * * PID : 4898828 TID : 1 PROC : db2agent (DWHDB) 8 * * * * INSTANCE: dwhprod NODE : 008 DB : DWHDB * * * * APPHDL : 8-591 APPID: *N8.dwhprod.100103190153 * * * * AUTHID : DWH007 * * * * FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:869 * * * * MESSAGE : Backup terminated. * * * * * * * * -------------------------- * * * * * * * * -------------------------- * * * * # CMD = db2 get snapshot for application agentid 131665 * * global * * * * * * * * * * Application Snapshot * * * * * * * * Application handle = 131665 * * * * Application status = Performing a Backup * * * * Status change time = 01/03/2010 20:01:57.329930 * * * * Application code page = 819 * * * * Application country/region code = 0 * * * * DUOW correlation token = *N2.dwhprod.100103190156 * * * * Application name = db2bp * * * * Application ID = *N2.dwhprod.100103190156 * * * * Sequence number = 00002 * * * * TP Monitor client user ID = * * * * TP Monitor client workstation name = * * * * TP Monitor client application name = * * * * TP Monitor client accounting string = * * * * * * * * Connection request start timestamp = 01/03/2010 * * 20:01:56.843801 * * Connect request completion timestamp = 01/03/2010 * * * * 20:01:56.862016 * * * * Application idle time = 8 hours 38 minutes 41 seconds * * * * CONNECT Authorization ID = DWH007 * * * * Client login ID = dwh007 * * * * Configuration NNAME of client = apdwh1.nbg.sdv.sdvrz * * * * Client database manager product ID = SQL09018 * * * * Process ID of client application = 1110180 * * * * Platform of client application = AIX 64BIT * * * * Communication protocol of client = Local Client * * * * * * * * -------------------------- * * * * * * * * --------------------------- * * * * # CMD = db2 get snapshot for application agentid 524879 * * global * * * * * * * * * * Application Snapshot * * * * * * * * Application handle = 524879 * * * * Application status = Performing a Backup * * * * Status change time = 01/03/2010 20:01:53.517604 * * * * Application code page = 819 * * * * Application country/region code = 0 * * * * DUOW correlation token = *N8.dwhprod.100103190153 * * * * Application name = db2bp * * * * Application ID = *N8.dwhprod.100103190153 * * * * Sequence number = 00002 * * * * TP Monitor client user ID = * * * * TP Monitor client workstation name = * * * * TP Monitor client application name = * * * * TP Monitor client accounting string = * * * * * * * * Connection request start timestamp = 01/03/2010 * * 20:01:53.029327 * * Connect request completion timestamp = 01/03/2010 * * * * 20:01:53.051552 * * * * Application idle time = 8 hours 38 minutes 47 seconds * * * * CONNECT Authorization ID = DWH007 * * * * Client login ID = dwh007 * * * * Configuration NNAME of client = apdwh1.nbg.sdv.sdvrz * * * * Client database manager product ID = SQL09018 * * * * Process ID of client application = 7311362 * * * * Platform of client application = AIX 64BIT * * * * Communication protocol of client = Local Client * * * * ---------------------------------- * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V9.1 FP10 * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IZ84489
Reported component name
DB2 UDB ESE AIX
Reported component ID
5765F4100
Reported release
910
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-09-08
Closed date
2011-06-14
Last modified date
2011-06-14
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
IZ86891 IC72011 IC72012
Fix information
Applicable component levels
R910 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]
Document Information
Modified date:
07 October 2021