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 IC73659 Status: Geschlossen

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

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - 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.5 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.5 FixPak 8 or higher levels.    * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 UDB Version 9.5 FixPak 8.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.01.2011
05.07.2011
05.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.
Problem behoben lt. FixList in der Version
9.5.0.8 FixList