This Knowledge Collection is a focused compilation of links to documents for BigSQL 5.0.3 known APARs.
Here are the commands to check the db2level and BigSQL rpm levels.
1) db2level
2) rpm -qa | grep bigsql-dist
The page is current as of December 9, 2020 , contact Support for more recent info.
APAR fixes included in DB2 Level s180816 & Bigsql-dist version 5.79.5.464
|
| APAR No. |
Abstract |
| PI99773 |
BIG SQL HA ENABLEMENT WILL FAIL WHEN BIGSQL USER IS AN LDAP USER AND THE HOME DIRECTORY FOR THE USER IS NON-DEFAULT |
| PH02154 |
JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION: ARRAY INDEX OUT OF RANGE: 255 RUNNING SELECT STATEMENT FROM BIGSQL 503 |
| PH02633 |
CREATE TABLE <TABLE> AS SELECT OR INSERT INTO <TABLE> SELECT INTO AN HBASE TABLE MAY RESULT IN MISSING ROWS |
APAR fixes included in DB2 Level s180816 & Bigsql-dist version 5.79.5.471
|
| APAR No. |
Abstract |
| PH02936 |
DISABLING THE SCHEDULER CACHE BY SETTING THE TIMETOLIVE PARAMETER TO ZERO CAUSES AN ERROR |
| PH03050 |
BIGSQL HBASE TABLE DELETE OPERATION IS SLOW |
| PH04334 |
LOAD HADOOP FAILS WITH I/O ERROR, MR JOB LOG SHOWS ARRAYINDEXOUTOFBOUNDSEXCEPTION |
| PH04201 |
SQL WITH A VERY LONG IN-LIST CLAUSE AGAINST PARQUET TABLES MAY CAUSE JAVA.LANG.STACKOVERFLOWERROR IN WORKER NODE |
APAR fixes included in DB2 Level s181022 & Bigsql-dist version 5.79.5.472
|
| APAR No. |
Abstract |
| PH04859 |
SQL10003, POSSIBLY OTHER OOM ERRORS DUE TO LACK OF CLEANUP OF JAVA DFS READER/WRITER PROCESSES |
APAR fixes included in DB2 Level s181208 & Bigsql-dist version 5.79.5.476
|
| APAR No. |
Abstract |
| PH03050 |
BIGSQL HBASE TABLE DELETE OPERATION IS SLOW OR MAY SKIP ROWS |
| PH06426 |
WIDE HBASE TABLES CANNOT BE READ BY BIGSQL |
| PH03850 |
BIGSQL LEAVES HIVE SCRATCH DIRECTORIES UNDER THE HDFS PATH /TMP/HIVE/BIGSQL |
| PH03945 |
FEDERATED QUERY WITH CASE/WHEN EXPRESSIONS ARE SLOW WHEN USING NETEZZA AS SOURCE DB |
| PH05116 |
QUERY USING BUILT-IN FUNCTIONS MAY FAIL WITH SQL1229N DUE TO TRAP ON WORKER NODE |
| PH06245 |
QUERIES ON HADOOP TABLES FAIL WITH SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED |
APAR fixes included in DB2 Level s181208 & Bigsql-dist version 5.79.5.478
|
| APAR No. |
Abstract |
| PH07901 |
UNABLE TO SELECT FROM A PARQUET FORMAT TABLE AFTER ADDING A COLUMN |
APAR fixes included in DB2 Level s181208 & Bigsql-dist version 5.79.5.482
|
| APAR No. |
Abstract |
| PH07586 |
QUERIES AGAINST PARQUET FILE FORMAT TABLES WITH COMPLEX TYPES (ARRAY, ROW or STRUCT) FAIL WITH ERROR |
| PH13584 |
UNABLE TO QUERY PARQUET TABLE AFTER ALTERING COLUMN |
APAR fixes included in DB2 Level s201031 & Bigsql-dist version 5.79.5.485
|
| APAR No. |
Abstract |
| PH07429 |
USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE |
| PH20568 |
CUSTOMER MAY SEE -5199 ON SOME QUERIES INTERMITTENTLY |
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"ARM Category":[{"code":"a8m500000008XKWAA2","label":"Install \/ Uninstall->Patch Application"}],"ARM Case Number":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"5.0.3","Line of Business":{"code":"LOB10","label":"Data and AI"}}]