IBM Support

BigSQL 5.0.1 Known APARs

Flashes (Alerts)


Abstract

This Knowledge Collection is a focused compilation of links to documents for BigSQL 5.0.1 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.

Content

APAR fixes included in DB2 Level s170813 & Bigsql-dist version 5.79.3.228

APAR No. Abstract
PI86943 JAVA.LANG.INDEXOUTOFBOUNDS EXCEPTION AFTER ADDING COLUMN ON ORC DATA
PI89179 BIGSQL JAVA READER HITS ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN THE NUMBER OF BYTES IN CHAR/VARCHAR COLUMN EXCEEDS COLUMN LENGTH
PI89247 PERFORMANCE REGRESSION MOVING FROM 4.1 TO 4.2.5 TEXT TABLE INSERTS SHOULD USE JAVA WRITER

APAR fixes included in DB2 Level s171105 & Bigsql-dist version 5.79.3.240

APAR No. Abstract
PI89558 SQLCODE-901, HANGS, OR TRAPS IN THE BIG SQL READER WHEN EXECUTING A BIG SQL SELECT STATEMENT

APAR fixes included in DB2 Level s171105 & Bigsql-dist version 5.79.3.228

APAR No. Abstract
PI91700 SELECT * FROM PARQUET TABLE WITH DATE-STORED-AS-DATE COLUMN FAILS AFTER ADDING A NEW VARCHAR COLUMN TO THE TABLE
PI92282 DATA RETURNED BY A BIG SQL SELECT OF A COLUMN WITH A DATA VALUE LONGER THAN 65535 BYTES IS TRUNCATED
PI92937 SELECT ON PARQUET TABLE MAY FAIL WITH 'COULD NOT READ DATA PAGE BECAUSE PAGE HEADER EXCEEDED MAXIMUM SIZE OF 8.00 MB'
PI94282 STATEMENTS FAIL RETURNING SQL5197N - COMMUNICATION ERROR WITH THE SCHEDULER
PI94314 BIGSQL SCHEDULER DOES NOT RETRY LOADING METADATA WHEN IT FINDS A CATALOG EXCEPTION AFTER AN INSERT
PH03050 BIGSQL HBASE TABLE DELETE OPERATION IS SLOW OR MAY SKIP ROWS

Related Information

[{"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.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 April 2021

UID

ibm16260535