DB2 - Problem description
Problem IT34517 | Status: Closed |
Newly created tablespace is missing on HADR standby due to disk full during replay | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
HADR standby encountered disk full error during log replay of a newly created table space. This resulted in not having this table space in the SQLSPCS file. The following error is reported to db2diag.log for the disk full error: 2020-09-08-10.01.06.124297+000 E38908749E1409 LEVEL: Error (OS) PID : 6176 TID : 46912958883584 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323 HOSTNAME: EDUID : 67 EDUNAME: db2redom 0 FUNCTION: DB2 UDB, oper system services, sqlowrite, probe:70 MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) ... [5] 0x00002AAAB26D95ED sqlowrite + 0x50D [6] 0x00002AAAACFDF797 _Z18sqlbWritePoolAsBlkR12SQLO_FHANDLES0_tbPcP12SQLB_GLOBALS + 0x137 [7] 0x00002AAAACFE001F _Z22sqlbWritePoolOnRefreshP12SQLB_POOL_CBtmPcP9sqeBsuEdu + 0x4FF [8] 0x00002AAAACFC6F66 _Z18sqlbPoolTblNewPooltjjiP9SQLP_LSN8P9sqeBsuEduPP12SQLB_POOL_CB + 0x1696 [9] 0x00002AAAAD19963C /mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x1F2963C [10] 0x00002AAAAD1903C9 _Z8sqlbRedoP8sqeAgentP8SQLB_LRHP9SQLP_LSN8b + 0xF09 [11] 0x00002AAAAD47838B _Z8sqldmrdoP8sqeAgenttP9SQLP_LSN8PcmmmmP8SQLP_TIDP15SQLD_RECOV_I NFO + 0xB0B 2020-09-08-10.01.06.170466+000 I38920614E582 LEVEL: Warning PID : 6176 TID : 46912958883584 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323 HOSTNAME: EDUID : 67 EDUNAME: db2redom () 0 FUNCTION: DB2 UDB, data management, sqldHandleBadPool, probe:700 DATA #1 : String, 92 bytes Tablespace 5 was not in the rollforward set. Request to remove it from the set is ignored. 2020-09-08-10.01.07.382032+000 I38967440E563 LEVEL: Error PID : 6176 TID : 46912958883584 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-15 APPID: *LOCAL.DB2.200905124323 HOSTNAME: EDUID : 67 EDUNAME: db2redom () 0 FUNCTION: DB2 UDB, buffer pool services, sqlbWritePoolCBToSPCS, probe:400 MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." DIA8312C Disk was full. This condition did not cause failure of the HADR standby database. Eventually, after TAKEOVER command this database becomes the new primary database, the following error will be reported. 2020-09-21-10.23.13.232783+000 I86952333E1667 LEVEL: Severe PID : 10572 TID : 46919208396544 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : APPHDL : 0-120 APPID: *LOCAL.DB2.200921102241 AUTHID : DB2INST1 HOSTNAME: EDUID : 127 EDUNAME: db2agent () 0 FUNCTION: DB2 UDB, buffer pool services, sqlbIsAllowed, probe:1064 DATA #1 : Invalid table space ID 5 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.1.4.6 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.10.2020 31.03.2021 31.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |