DB2 - Problem description
Problem IT36892 | Status: Closed |
SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5 | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
SNAPSHOT BACKUP fails randomly in DPF with SQL1550N rc 5, and seemingly whenever there is a LOAD running at the same time. Messages in db2diag.log: 2021-04-13-17.03.33.997859-240 E283619062E606 LEVEL: Error PID : 39923 TID : 140584190732032 PROC : db2sysc 5 INSTANCE: xxxxx NODE : 005 DB : xxxxx APPHDL : 1-45873 APPID: *N1.xxxxxxx.210426173226 AUTHID : MSDB2 HOSTNAME: xxxxxx EDUID : 137891 EDUNAME: db2agntp (MARCH) 5 FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:400 MESSAGE : ZRC=0x8005047B=-2147154821=SQLE_RC_SUSPEND_FAILED "Set Write Suspend failed" DATA #1 : String, 45 bytes Failed to acquire the preventSuspendIO lotch. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v111m4fp7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * fixed in db2_v111m4fp7 * **************************************************************** | |
Comment | |
fixed in db2_v111m4fp7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.05.2021 01.07.2021 28.12.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |