home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC66590 Status: Geschlossen

"GET SNAPSHOT" COMMAND RECEIVES SIGSEGV WHEN LOAD TASK IS RUNNING
AT THE SAME TIME

Produkt:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problembeschreibung:
This problem occurs when: 
-- you issue "get snapshot" command to retrieve "LOCK" 
information like: 
   get snapshot for locks 
   get snapshot for applications 
   get snapshot for all 
-- and there is some LOAD task running at the same time 
As a result, the DB2 agent working on behalf of the "get 
snapshot" command receives a SIGSEGV and DB2 instance crashes. 
 
In the trap file for the DB2 agent which receives SIGSEGV, you 
see call stack similar to the following: 
================================= 
sqlplGetLockWaitInfo 
sqm_write_lock_waits 
...... 
=================================
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.1 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This problem occurs when:                                    * 
* -- you issue "get snapshot" command to retrieve "LOCK"       * 
* information like:                                            * 
* get snapshot for locks                                       * 
* get snapshot for applications                                * 
* get snapshot for all                                         * 
* -- and there is some LOAD task running at the same time      * 
* As a result, the DB2 agent working on behalf of the "get     * 
* snapshot" command receives a SIGSEGV and DB2 instance        * 
* crashes.                                                     * 
*                                                              * 
* In the trap file for the DB2 agent which receives SIGSEGV,   * 
* you see call stack similar to the following:                 * 
* =================================                            * 
* sqlplGetLockWaitInfo                                         * 
* sqm_write_lock_waits                                         * 
* ......                                                       * 
* =================================                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB Version 9.1 FixPak 10 or higher levels.   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Lösung
First fixed in DB2 UDB Version 9.1 FixPak 10.
Workaround
N/A
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC72469 IC73659 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.02.2010
10.06.2011
10.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.
Problem behoben lt. FixList in der Version
9.1.0.10 FixList