DB2 - Problem description
Problem IC97737 | Status: Closed |
SECURITY: QUERY WITH OLAP SPECIFICATION CAUSES DB2 SERVER TO SHUTDOWN DATABASE. (CVE-2013-6717) | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - 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 DB2 systems on all Linux, Unix and Windows platforms at * * service levels Version 10.1 GA through to Version 10.1 Fix * * Pack 3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See security bulletin: * * http://www.ibm.com/support/docview.wss?uid=swg21660041 * **************************************************************** | |
Local Fix: | |
N/A | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
Security Bulletin: Executing a query with an OLAP specification causes the DB2 server to terminate database connections. (CVE-2013-6717) http://www.ibm.com/support/docview.wss?uid=swg21660041 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.11.2013 03.06.2014 06.06.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.4 |