|
Problem IT30494
|
Status: Closed |
CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
In a Purescale environment a currently committed query that
needs to go to a different member may fail with SQL0952N (user
interrupt detected). This will only happen when the remote
member is in the middle of crash recovery.
If this error is hit, the following message will be in the
diaglog:
2019-10-03-12.21.01.051104-240 I627488E581 LEVEL:
Error
PID : 5393 TID : 140050398439168 PROC :
db2sysc 0
INSTANCE: user NODE : 000 DB : TEST
APPHDL : 0-138 APPID: *N0.user.191003162057
UOWID : 1 ACTID: 1
AUTHID : USER HOSTNAME: linux
EDUID : 432 EDUNAME: db2agent (TEST) 0
FUNCTION: DB2 UDB, catalog services, sqlrlSendRpcCurComRequest,
probe:20
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built" |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* users of v11.5 using currently committed in purescale *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to Fixed in v11.5 ifix 1 *
**************************************************************** |
| Local Fix: |
Re-run query after remote member is back online |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.10.2019
30.06.2020
30.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
