|
Problem IC66590
|
Status: Closed |
"GET SNAPSHOT" COMMAND RECEIVES SIGSEGV WHEN LOAD TASK IS RUNNING AT THE SAME TIME |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| 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
......
================================= |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
First fixed in DB2 UDB Version 9.1 FixPak 10. |
| Workaround |
N/A |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72469 IC73659
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.02.2010
10.06.2011
10.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.1.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
