home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList