DB2 - Problem description
Problem IT36285 | Status: Closed |
INSTANCE TRAPPED DURING SNAPSHOT MONITORING IN FUNCTION SQLPGETDBMONLOG() | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When taking database snapshot, there is a small timing condition that can cause the instance to trap. A sample stack dump of the trap is shown below: sqlpGetDbMonLog(sqeLocalDatabase*, sql_static_data*, SQLP_DBMON_LOG_INFO*) sqlmindb(sqm_agent_entity*, sqeLocalDatabase*, char const*, unsigned int, sqlm_dbase*, sqm_snapshot_buffer*, sqlm_bp_int_info const&, unsigned long, unsigned long, unsigned long, sqlm_header_info*) sqm_snap_dbase(sqm_agent_entity*, sqlo_gmt const&, sqeLocalDatabase*, char const*, unsigned int, sqm_snapshot_buffer*, sqlm_dbase**, sqlm_header_info*) sqlmonssagnt(unsigned int, sqm_entity_id, sqlmai*, unsigned int, void*, sqlm_collected*, unsigned short, unsigned short, sqlca*) sqlmPdbRequestRouter(sqeAgent*) sqleSubRequestRouter(sqeAgent*, unsigned int*, unsigned long*) sqleProcessSubRequest(sqeAgent*) sqeAgent::RunEDU() sqzEDUObj::EDUDriver() sqlzRunEDU(char*, unsigned int) sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * AIX/LINUX * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v11.5.4.0 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * AIX/LINUX * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v11.5.4.0 * **************************************************************** | |
Comment | |
We need to cache some variables here and use cached values throughout function to avoid anything changing underneath us. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.03.2021 19.03.2021 19.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |