DB2 - Problem description
Problem IC65807 | Status: Closed |
BACKUP MAY HANG DUE TO DB2VEND NOT BEING INITIALIZED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
A backup process may hang under Solaris operating system because one of the child db2vend process may be waiting to acquire an AIO lock. This will only affect the backup processing. You can identify this issue if the backup seems not to respond and by running "db2ptree". The db2ptree will show some db2vend processes started and others being db2sysc at the same tree level as highlighted with "<<<<<<<<<<<<<" in the output below: 5844 db2wdog 0 5845 db2sysc 0 5846 db2ckpwd 0 5847 db2ckpwd 0 5848 db2ckpwd 0 26338 db2vend (db2med - 1067 (ECA)) 26339 db2vend (db2med - 1069 (ECA)) 26340 db2vend (db2med - 1068 (ECA)) 26341 db2vend (db2med - 1070 (ECA)) 26342 db2vend (db2med - 1072 (ECA)) 26343 db2sysc 0 <<<<<<<<<<<<<<< 26344 db2vend (db2med - 1071 (ECA)) 26345 db2sysc 0 <<<<<<<<<<<<<<< 5933 db2acd 0 7506 db2fmp (C) 0 7720 db2fmp (idle) 0 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All under Solaris operating system * **************************************************************** * PROBLEM DESCRIPTION: * * A backup process may hang under Solaris operating system * * because one of the child db2vend process may be waiting to * * acquire an AIO lock. This will only affect the backup * * processing. You can identify this issue if the backup seems * * not to respond and by running "db2ptree". The db2ptree will * * show some db2vend processes started and others being db2sysc * * at the same tree level as highlighted with "<<<<<<<<<<<<<" * * in the output below: * * * * 5844 db2wdog * * 05845 db2sysc * * 05846 db2ckpwd * * 05847 db2ckpwd * * 05848 db2ckpwd * * 026338 db2vend (db2med - 1067 (ECA)) * * 26339 db2vend (db2med - 1069 (ECA)) * * 26340 db2vend (db2med - 1068 (ECA)) * * 26341 db2vend (db2med - 1070 (ECA)) * * 26342 db2vend (db2med - 1072 (ECA)) * * 26343 db2sysc 0 <<<<<<<<<<<<<<< * * 26344 db2vend (db2med - 1071 (ECA)) * * 26345 db2sysc 0 <<<<<<<<<<<<<<< * * 5933 db2acd * * 07506 db2fmp (C) * * 07720 db2fmp (idle) 0 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 FP2 or above * **************************************************************** | |
Local Fix: | |
Cancel the backup and retry might circumvent the issue. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 version 9.7 FP2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.01.2010 17.05.2010 17.05.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |