Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
APAR status
Closed as program error.
Error description
After a SMS user temp tablespace hits disk full, a rollback operation starts. During rollback if the victim pages belong to the same full user temp table space, the page may not be flushed. This will cause database to be marked as bad. db2diag.log would have some messages similar to the following: 2008-02-12-15.03.27.304837-300 I113965216E457 LEVEL: Error PID : 23582 TID : 183030155104PROC : db2agent (NYCMPI03) 0 INSTANCE: nycmpi03 NODE : 000 DB : NYCMPI03 APPHDL : 0-1996 APPID: 10.224.0.150.46220.080212195442 AUTHID : GCTDEGL FUNCTION: DB2 UDB, data protection services, sqlptudo, probe:1710 RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. ................................ 2008-02-12-15.03.27.305695-300 I113966889E431 LEVEL: Severe PID : 23582 TID : 183030155104PROC : db2agent (NYCMPI03) 0 INSTANCE: nycmpi03 NODE : 000 DB : NYCMPI03 APPHDL : 0-1996 APPID: 10.224.0.150.46220.080212195442 AUTHID : GCTDEGL FUNCTION: DB2 UDB, data protection services, sqlptud1, probe:1880 MESSAGE : Due to error during UNDO, database will be brought down. 2008-02-12-15.03.27.305835-300 I113967321E480 LEVEL: Error PID : 23582 TID : 183030155104PROC : db2agent (NYCMPI03) 0 INSTANCE: nycmpi03 NODE : 000 DB : NYCMPI03 APPHDL : 0-1996 APPID: 10.224.0.150.46220.080212195442 AUTHID : GCTDEGL FUNCTION: DB2 UDB, data protection services, sqlpSpRb, probe:50 DATA #1 : String, 91 bytes Failed to rollback to savepoint. Error code: -2062614516 Request rollback savepoint type: 1 ....................... 2008-02-12-15.03.25.780780-300 E113250644E403 LEVEL: Severe PID : 23582 TID : 183030155104PROC : db2agent (NYCMPI03) 0 INSTANCE: nycmpi03 NODE : 000 DB : NYCMPI03 APPHDL : 0-1996 APPID: 10.224.0.150.46220.080212195442 AUTHID : GCTDEGL FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10 MESSAGE : ADM7518C "NYCMPI03" marked bad. The final stack dump of the above db2agent would be similar to the following: ---FUNC-ADDR---- ------FUNCTION + OFFSET------ 0000002A9A9F2140 ossDumpStackTrace + 0x0080 (/opt/IBM/db2/V9.1FP03/lib64/libdb2osse.so.1) 0000002A9A9EFE04 _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa (/opt/IBM/db2/V9.1FP03/lib64/libdb2osse.so.1) 0000002A97AAE9FB sqlo_trce + 0x033b (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A96959858 sqloDumpDiagInfoHandler + 0x0098 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000003D4AE0C430 do_sigwait + 0x0050 (/lib64/tls/libpthread.so.0) 0000003D4942E829 kill + 0x0009 (/lib64/tls/libc.so.6) 0000002A96959D73 sqloDumpEDU + 0x000b (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A967699B2 _Z12sqleMarkDBadP8sqledbcb + 0x0102 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A96666278 _Z15sqldDumpContextP20sqle_agent_privatecbiiiiiPcPvi + 0x0500 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A96024D7F _Z8sqldmundP20sqle_agent_privatecbP8SQLP_LSNPcjsjP8SQLP_TIDP15SQ LD_RECOV_INFO + 0x062f (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A9629F49C _Z8sqlptudoP20sqle_agent_privatecbP9SQLP_LSN8P15SQLD_RECOV_INFOP 11SQLP_TENTRY + 0x0174 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A9629EB29 _Z8sqlptud1P20sqle_agent_privatecbP9SQLP_LSN8 + 0x0219 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A971433FA _Z8sqlpSpRbP20sqle_agent_privatecbim + 0x0252 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A9724100D _Z19sqlrr_stmt_rbk_svptP8sqlrr_cbP19sqlr_savepoint_infoi + 0x010d (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A97C2DE40 _Z8sqlreespP8sqlrr_cbP19sqlr_savepoint_infoi + 0x0450 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A97C2D4A8 _Z15sqlr_end_saveptP8sqlrr_cbiijP19sqlr_savepoint_infoji + 0x0098 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1) 0000002A97212814 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x05f4 (/opt/IBM/db2/V9.1FP03/lib64/libdb2e.so.1)
Local fix
Monitor disk space usage and avoid SMS tablespace hits disk full situation.
Problem summary
DATABASE IS MARKED BAD AFTER ITS SMS TEMP TABLESPACE HITS DISK FULL AND ROLLBACK FAILS.
Problem conclusion
First fixed in DB2 UDB Version 9.1, FixPak 6
Temporary fix
Monitor disk space usage and avoid SMS tablespace hits disk full situation.
Comments
APAR Information
APAR number
LI73164
Reported component name
DB2 UDE ESE LIN
Reported component ID
5765F4104
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-02-20
Closed date
2008-11-04
Last modified date
2009-03-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDE ESE LIN
Fixed component ID
5765F4104
Applicable component levels
R910 PSY
UP
[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021