This Knowledge Collection is a focused compilation of links to documents for BigSQL 6.0 known APARs.
Here are the commands to check the db2level and BigSQL rpm levels.
1) db2level
2) rpm -qa | grep bigsql-dist
Page is current as of July 1, 2021, contact Support for more recent info.
APAR fixes included in DB2 Level s210522 & Bigsql-dist version 6.0.0.986
|
| APAR No. |
Abstract |
| PH33717 |
BIGSQL FULLBIGSQLCLEANUP SCRIPT MAY FAIL TO DELETE BIGSQL REPOSITORY DETAILS FROM AMBARI DATABASE. |
| PH34841 |
BIGSQL UPGRADE MAY FAIL WITH 'DB2SET: ERROR WHILE LOADING SHARED LIBRARIES' |
| PH13955 |
UPGRADE TO BIG SQL VERSION 5.0.4 FAILED DURING THE UPGRADE PHASE WITH RC=4 |
| PH33724 |
ANALYZE WIPES OUT STATISTICS AND RETURNS WITHOUT ERRORS WHEN AUTHORITY IS GRANTED THROUGH A ROLE |
| PH34548 |
SELECT FROM TABLE(SYSHADOOP.BIGSQL_ENV()) WITH LIMIT CLAUSE CAUSES ROUTINE TO HANG AND BE NON-INTERRUPTABLE |
| PH35265 |
HCAT_TABLEPARTS() MAY SHOW AN INCORRECT COUNT OF PARTITIONS FOR TABLES WITH MORE THAN 32,676 PARTITIONS |
| PH34836 |
UNEXPECTED HA FAILOVER TRIGGERED IF THE FAILOVER CONTROLLER CANNOT CONTACT ZOOKEEPER |
| PH34959 |
SQLCODE -901 WITH "REBIND PACKAGE. POSSIBLY DROP DBPARTITIONNUM WAS DONE." |
| PH36606 |
"BIGSQL.COMPATIBILITY_MODE" is not valid in the context where it is used.. SQLCODE=-206 returned by HCAT_AUTOSYNC or ANALYZE |
| PH36186 |
WHEN THE JAVA DFSIO FMP HITS THE POOLED THREAD LIMIT, IT IS MARKED UNSTABLE WHICH CAN STRESS MEMORY RESOURCES |
APAR fixes included in DB2 Level s201130 & Bigsql-dist version 6.0.0.960
|
| APAR No. |
Abstract |
| PH32150 |
CRASH OR PANIC IN FUNCTION DIAGNOSEMEMORYCORRUPTIONANDCRASH |
APAR fixes included in DB2 Level s201031 & Bigsql-dist version 6.0.0.958
|
| APAR No. |
Abstract |
| PH31280 |
BIG SQL UPGRADE MAY FAIL WHILE COPYING BIGSQL-RANGER.JAR TO RANGER TAGSYNC HOSTS |
| PH30348 |
QUERY FAILS WITH JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION ON PARQUET FILE |
| PH31079 |
TRAP (SIGSEGV) IN SQLRWWLOINFOBUILDER::EXECUTE() WHEN INVOKING WLM TABLE FUNCTIONS |
| PH31029 |
BIGSQL MAY CRASH WHEN LOAD DATA VIA FEDERATION |
| PH30814 |
INSTALL_CUSTOM_ACTION.SH MAY END UP CORRUPTING SYSTEM_ACTION_DEFINITIONS.XML |
| PH29841 |
WARNINGS FROM BIG SQL SCHEDULER: HCATUTIL.GETHIVECLIENT IS UNSAFE AND CAN BE A RESOURCE LEAK |
APAR fixes included in DB2 Level s200910 & Bigsql-dist version 6.0.0.948
|
| APAR No. |
Abstract |
| PH28725 |
BIGSQL QUERY MAY FAIL WITH SQL1229N WHEN ONE OR MORE WORKER NODES IS DOWN |
| PH28874 |
IBM DB2 BIGSQL: BIGSQL HA SETUP FAILS WHEN SYSTEM LOCALE IS SET TO ANYTHING OTHER THAN EN_US.UTF-8 |
| PH27200 |
A BIG SQL WORKER NODE MAY CRASH WITH AN FMP ERROR DETECTING A MEMORY CORRUPTION WHEN RUNNING A STORED PROCEDURE. |
| PH27563 |
ENABLED RANGER PLUGIN FOR BIG SQL MISSING THE ATTRIBUTE CLIIP (CLIENT IP) IN THE THE AUDIT RECORD. |
| PH29290 |
WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N. |
| PH25606 |
NESTED SELECT STATEMENT WITH DISTINCT RETURNING DUPLICATE/INCORRECT RESULTS |
APAR fixes included in DB2 Level s200523 & Bigsql-dist version 6.0.0.929
|
| APAR No. |
Abstract |
| PH24285 |
TRAP MAY OCCUR WHEN CLEANING UP TEMPORARY TABLES ON APPLICATION TERMINATION |
| PH25073 |
JAVA I/O ENGINE OUT OF MEMORY ISSUES CAN CAUSES SYSTEM INSTABILITY (SQL0973N, SQL5199N RC 1, SQL5199N RC 4) |
| PH24515 |
BIG SQL START UP FAILS OR STATEMENTS FAIL WITH SQLCODE -1225 ON LINUX REDHAT 7.8 OR LATER |
| PH25149 |
BIGSQL UNIFIED CONSOLE: USERNAME WITH A .(DOT) CHARACTER CANNOT LOGIN |
| PH25377 |
PANIC MAY OCCUR WHILE FREEING MEMORY |
| PH25740 |
BIG SQL WITH YARN INTEGRATION FAILS TO RESTART WITH ERROR FROM YARN APP -STATUS |
| PH14925 |
SPLIT BRAIN OCCURRED ON BIGSQL USING AUTOMATIC FAILOVER DUE TO TEMPORARY DISCONNECTION |
APAR fixes included in DB2 Level s200208 & Bigsql-dist version 6.0.0.905
|
| APAR No. |
Abstract |
| PH20355 |
HEAD NODE MAY CRASH WITH FODC_APPERR |
| PH21594 |
BIGSQL_UPGRADE.PY -M RESTORE FAILS WHEN UNABLE TO OPEN UPGRADE-CHECK-FOR-RUNNING-DB2-INSTANCES LOGS |
| PH22023 |
QUERY HAS ZERO COST, BYPASSING WLM SETTINGS |
| PH22098 |
UNIFIED CONSOLE LOGIN FAILS WITH ERRORCODE=-4214. |
| PH19970 |
ANALYZE STATEMENT COLLECTING COLUMN STATS OCCASIONALLY FAILS WITH SQL5105N AND NUMBERFORMATEXCEPTION |
APAR fixes included in DB2 Level s191228 & Bigsql-dist version 6.0.0.895
|
| APAR No. |
Abstract |
| PH20350 |
BIGSQL HCAT_AUTOSYNC_OBJECTS DROPS THEN FAILS TO RECREATE TABLE DUE TO ROW LENGTH AFTER ALTER |
| PH20568 |
CUSTOMER MAY SEE -5199 ON SOME QUERIES INTERMITTENTLY |
| PH19774 |
IBM DB2 BIGSQL: BIGSQL INSTALL WITH EMC ISILON FAILS WITH "UNKNOWN RPC" EXCEPTION |
APAR fixes included in DB2 Level s191111 & Bigsql-dist version 6.0.0.867
|
| APAR No. |
Abstract |
| PH13608 |
CALLING THE SYSHADOOP.LOG_ENTRY FUNCTION RETURNS "$BIGSQL_LOG_DIR IS NOT SET!" |
| PH19658 |
UNABLE TO READ FROM BIGSQL HADOOP TABLES WITH CUSTOM STORAGE HANDLER |
APAR fixes included in DB2 Level s191102 & Bigsql-dist version 6.0.0.857
|
| APAR No. |
Abstract |
| PH18250 |
QUERY FAILS WITH SQLCODE -901 WITH "WRONG SIBLING" MESSAGE UNDER LOW MEMORY CONDITION |
| PH18338 |
BIGSQL RECURSIVE QUERY BEING SENT TO ALL BIGSQL WORKERS EVEN IF THE BIGSQL WORKER IS DISABLED/STOPPED |
| PH18716 |
ERROR WHILE RUNNING THE SQOOP JOB. SEE JOB LOG FILES" MESSAGE SEEN INTERMITTENTLY WITH A LOAD STATEMENT |
APAR fixes included in DB2 Level s190921 & Bigsql-dist version 6.0.0.851
|
| APAR No. |
Abstract |
| PH16635 |
EXECUTION OF A COMPLEX QUERY IN BIG SQL FAILS WITH AN OUT OF MEMORY ERROR |
| PH15247 |
BIGSQL DATA COLLECTION MAY NOT COLLECT ALL THE DB2DIAG.LOG FILES |
| PH16963 |
DB2LOOK OUTPUT DOES NOT INCLUDE THE SERDE CLAUSE |
APAR fixes included in DB2 Level s190817& Bigsql-dist version 6.0.0.839
|
| APAR No. |
Abstract |
| PH16482 |
BIGSQL CONSOLE UI LAUNCHING BUT METRICS ARE NOT DISPLAYED |
APAR fixes included in DB2 Level s190817 & Bigsql-dist version 6.0.0.836
|
| APAR No. |
Abstract |
| PH12778 |
LARGE INLIST IN QUERY FAILS WITH SQLCODE -901 CONTINUATION IS NOT SUPPORTED |
| PH13608 |
CALLING THE SYSHADOOP.LOG_ENTRY FUNCTION RETURNS "$BIGSQL_LOG_DIR IS NOT SET!" (partial fix only in this build - full fix in s191111/6.0.0.867) |
| PH13579 |
BIGSQL ENFORCES THE LINE TERMINATION ON DELIMITED HADOOP TABLES TO BE NEWLINE |
| PH15540 |
BIG SQL WORKER NODE CRASH DUE TO MEMORY CORRUPTION WHEN CALLING STORED PROCEDURE |
| PH15845 |
AFTER UPGRADE TO BIGSQL V6.0.0.0, PARQUET FILES MAY SHOW INCORRECT TIMESTAMP VALUES |
APAR fixes included in DB2 Level s190619 & Bigsql-dist version 6.0.0.809
|
| APAR No. |
Abstract |
| PH11723 |
BIGSQL UPGRADE FAIL WITH LIST INDEX OUT OF RANGE |
| PH06249 |
FODC_APPERR DIRECTORIES ARE CREATED ON THE HEAD NODE AFTER A TOPOLOGY CHANGE |
| PH10060 |
TABLE TIMESTAMP COLUMN VALUE BECAME NULL AFTER UPGRADE |
| PH11973 |
BIG SQL HEAD NODE CRASHES AFTER SUBMITTING A RUNSTATS COMMAND ON A HADOOP TABLE |
| PH13525 |
KERBEROS TICKETS NOT RENEWED BY BIG SQL SERVICE |
| PH13808 |
SPLIT-BRAIN HADR FAILURE MAY OCCUR WITH AUTOMATED FAILOVER |
| PH13377 |
SOME TABLE OPERATIONS INVALIDATE AND RELOAD THE BIGSQL SCHEDULER CACHE UNNECESSARILY |
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"ARM Category":[],"Platform":[{"code":"PF016","label":"Linux"}],"Version":"BigSQL Versions 6.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]