| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC97738 | Status: Closed |
SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717) | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
Executing a query with an OLAP specification may cause the DB2
server to shutdown the database and terminate all connections to
the database however the DB2 instance does not shutdown.
The stack includes this function:
sqlsInitKeyfd__FP8sqeAgentP12SQLS_SORTDEFP10SQLD_FIELDP10SQLS_KE
YFDP11SQLD_COLUMNPii + 0xA40
db2diag would report the following:
2013-05-29-14.25.18.182300+600 I10400222A1217 LEVEL: Severe
PID : 12976130 TID : 50892 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : ABCABC
APPHDL : 0-411 APPID:
164.97.57.31.1431.130529042502
AUTHID : db2inst1
EDUID : 50892 EDUNAME: db2agent (ABCABC) 0
FUNCTION: DB2 UDB, sort/list services, sqlsInitKeyfd, probe:35
MESSAGE : ZRC=0x8704002F=-2029780945=SQLD_PARM "PARAMETER ERROR"
DIA8544C An invalid data type was encountered, the
value was "".
DATA #1 : String, 29 bytes
Unknown keypart type in sort.
DATA #2 : SQLS_SORTKEYDEF, PD_TYPE_SQLS_SORTKEYDEF, 24 bytes
SQLS_SORTKEYDEF: Address:700000010addf68, Size:x18, Size:24
x0000 collation NULL
x0008 keyPartID 0
x000A sortkdefFlags x0000
x000C sortkdefIntFlags x0000
x000E codepage 0
x0012 keyPart
SQLD_FIELD: Address:700000010addf7a, Size:x6, Size:6
x0000 type BOOLEAN
x0002 length 1
x0004 nullable x2
- SQLZ_NONULLS | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5 fix pack 3 * **************************************************************** | |
| Local Fix: | |
N/A | |
| available fix packs: | |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows | |
| Solution | |
Frst fixed in DB2 version 10.5 fix pack 3 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.11.2013 28.02.2014 28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.3 |
|
| 10.5.0.3 |
|