This Knowledge Collection is a focused compilation of links to documents for BigSQL 5.0.2 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.
Contact IBM Support to obtain the latest patch.
APAR fixes included in DB2 Level s180307 & Bigsql-dist version 5.79.4.451
|
| 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' |
| PI92936 |
BIG SQL TOPOLOGY CHANGES MAY FAIL WITH RANGER PLUGIN ENABLED |
| PI94168 |
FULLBIGSQLCLEANUP.SH WILL CLEAN UP ALL FILES OWNED BY BIGSQL USER UNDER THE DATA DIRECTORIES PATH |
| PI94401 |
ON A YARN ENABLED CLUSTER, NODE MANAGER GOES DOWN IF SERVER GETS REBOOTED |
| 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 |
| PI94973 |
DIFFICULTIES INSTALLING BIG SQL IN A CENTRALLY MANAGED ENVIRONMENT |
| PI95398 |
BIG SQL INSTALL OR UPGRADE FINALIZE PHASE FAILS WITH "SSH: COULD NOT RESOLVE HOSTNAME ... NAME OR SERVICE NOT KNOWN" |
APAR fixes included in DB2 Level s180605 & Bigsql-dist version 5.79.4.456
|
| APAR No. |
Abstract |
| PI98470 |
Big SQL MAY TRAP WHEN USING THE SPECIAL REGISTER CURRENT DECFLOAT ROUNDING MODE |
APAR fixes included in DB2 Level s180605 & Bigsql-dist version 5.79.4.457
|
| APAR No. |
Abstract |
| PI99229 |
SELECT STATEMENTS ON A TABLE WITH XML DATA MAY FAIL FOR A CUSTOM SERDE SETUP |
APAR fixes included in DB2 Level s180307 & Bigsql-dist version 5.79.4.465
|
| 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 |
| PH02936 |
DISABLING THE SCHEDULER CACHE BY SETTING THE TIMETOLIVE PARAMETER TO ZERO CAUSES AN ERROR |
| PH03050 |
BIGSQL HBASE TABLE DELETE OPERATION IS SLOW OR MAY SKIP ROWS |
| PH03850 |
BIGSQL LEAVES HIVE SCRATCH DIRECTORIES UNDER THE HDFS PATH /TMP/HIVE/BIGSQL |
APAR fixes included in DB2 Level s190131 & Bigsql-dist version 5.79.4.467
|
| APAR No. |
Abstract |
| PH06426 |
WIDE HBASE TABLES CANNOT BE READ BY BIGSQL |
| PH03945 |
FEDERATED QUERY WITH CASE/WHEN EXPRESSIONS ARE SLOW WHEN USING NETEZZA AS SOURCE DB. |
| PH07429 |
USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE |
APAR fixes included in DB2 Level s200110 & Bigsql-dist version 5.79.4.470
|
| APAR No. |
Abstract |
| PH20355 |
HEAD NODE MAY CRASH WITH FODC_APPERR |
[{"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.2","Line of Business":{"code":"LOB10","label":"Data and AI"}}]