This Knowledge Collection is a focused compilation of links to documents for BigSQL 5.0.4 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 February 24, 2022, contact Support for more recent info.
APAR fixes included in DB2 Level s210522 & Bigsql-dist version 5.80.0.754
|
| APAR No. |
Abstract |
| PH40163 |
BIG SQL MIGHT PRODUCE INCORRECT RESULTS (DUPLICATE ROWS) WHEN EXECUTING QUERY WITH UNION ALL. |
APAR fixes included in DB2 Level s210522 & Bigsql-dist version 5.80.0.753
|
| APAR No. |
Abstract |
| PH38611 |
ANALYZE FAILS WITH SQLCODE -1227 COLCARD IS OUT OF RANGE FOR ITS TARGET COLUM |
APAR fixes included in DB2 Level s210522 & Bigsql-dist version 5.80.0.750
|
| APAR No. |
Abstract |
| PH36186 |
WHEN THE JAVA DFSIO FMP HITS THE POOLED THREAD LIMIT, IT IS MARKED UNSTABLE WHICH CAN STRESS MEMORY RESOURCES |
| PH36606 |
"BIGSQL.COMPATIBILITY_MODE" is not valid in the context where it is used.. SQLCODE=-206 returned by HCAT_AUTOSYNC or ANALYZE |
APAR fixes included in DB2 Level s210327 & Bigsql-dist version 5.80.0.741
|
| APAR No. |
Abstract |
| PH34836 |
UNEXPECTED HA FAILOVER TRIGGERED IF THE FAILOVER CONTROLLER CANNOT CONTACT ZOOKEEPER |
| PH35265 |
HCAT_TABLEPARTS() MAY SHOW AN INCORRECT COUNT OF PARTITIONS FOR TABLES WITH MORE THAN 32,676 PARTITIONS |
| PH34548 |
SELECT FROM TABLE(SYSHADOOP.BIGSQL_ENV()) WITH LIMIT CLAUSE CAUSES ROUTINE TO HANG AND BE NON-INTERRUPTABLE |
| PH34959 |
SQLCODE -901 WITH "REBIND PACKAGE. POSSIBLY DROP DBPARTITIONNUM WAS DONE." |
APAR fixes included in DB2 Level s210109 & Bigsql-dist version 5.80.0.733
|
| APAR No. |
Abstract |
| PH33724 |
ANALYZE WIPES OUT STATISTICS AND RETURNS WITHOUT ERRORS WHEN AUTHORITY IS GRANTED THROUGH A ROLE |
APAR fixes included in DB2 Level s201130 & Bigsql-dist version 5.80.0.728
|
| APAR No. |
Abstract |
| PH32150 |
CRASH OR PANIC IN FUNCTION DIAGNOSEMEMORYCORRUPTIONANDCRASH |
APAR fixes included in DB2 Level s201031 & Bigsql-dist version 5.80.0.726
|
| APAR No. |
Abstract |
| PH31029 |
BIGSQL MAY CRASH WHEN LOAD DATA VIA FEDERATION |
| PH30814 |
INSTALL_CUSTOM_ACTION.SH MAY END UP CORRUPTING SYSTEM_ACTION_DEFINITIONS.XML |
| PH31079 |
TRAP (SIGSEGV) IN SQLRWWLOINFOBUILDER::EXECUTE() WHEN INVOKING WLM TABLE FUNCTIONS |
APAR fixes included in DB2 Level s200910 & Bigsql-dist version 5.80.0.718
|
| APAR No. |
Abstract |
| 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 5.80.0.717
|
| APAR No. |
Abstract |
| 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 s200828 & Bigsql-dist version 5.80.0.712
|
| APAR No. |
Abstract |
| PH28725 |
BIGSQL QUERY MAY FAIL WITH SQL1229N WHEN ONE OR MORE WORKER NODES IS DOWN |
APAR fixes included in DB2 Level s200523 & Bigsql-dist version 5.80.0.694
|
| APAR No. |
Abstract |
| PH24515 |
BIG SQL START UP FAILS OR STATEMENTS FAIL WITH SQLCODE -1225 ON LINUX REDHAT 7.8 OR LATER |
| PH25377 |
PANIC MAY OCCUR WHILE FREEING MEMORY |
APAR fixes included in DB2 Level s200502 & Bigsql-dist version 5.80.0.692
|
| APAR No. |
Abstract |
| PH25073 |
JAVA I/O ENGINE OUT OF MEMORY ISSUES CAN CAUSES SYSTEM INSTABILITY (SQL0973N, SQL5199N RC 1, SQL5199N RC 4) |
APAR fixes included in DB2 Level s200418 & Bigsql-dist version 5.80.0.690
|
| APAR No. |
Abstract |
| PH23470 |
BIGSQL UPGRADE FAILS AT PRE-CHECK |
| PH20398 |
RANGER PLUGIN FOR BIGSQL NOT PULLING IN RANGER HADOOP POLICIES IN PLACE |
| PH24285 |
TRAP MAY OCCUR WHEN CLEANING UP TEMPORARY TABLES ON APPLICATION TERMINATION |
| PH24714 |
SQL0973N NOT ENOUGH STORAGE AVAILABLE IN THE "BIGSQL IO" HEAP RESULTS IN HANG OR SUBSEQUENT SQL5199N ERRORS |
APAR fixes included in DB2 Level s200208 & Bigsql-dist version 5.80.0.681
|
| APAR No. |
Abstract |
| 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 |
| PH19970 |
ANALYZE STATEMENT COLLECTING COLUMN STATS OCCASIONALLY FAILS WITH SQL5105N AND NUMBERFORMATEXCEPTION |
APAR fixes included in DB2 Level s200118 & Bigsql-dist version 5.80.0.676
|
| 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 |
| PH20355 |
HEAD NODE MAY CRASH WITH FODC_APPERR |
APAR fixes included in DB2 Level s191102 & Bigsql-dist version 5.80.0.657
|
| APAR No. |
Abstract |
| PH18338 |
BIGSQL RECURSIVE QUERY BEING SENT TO ALL BIGSQL WORKERS EVEN IF THE BIGSQL WORKER IS DISABLED/STOPPED |
| PH13608 |
CALLING THE SYSHADOOP.LOG_ENTRY FUNCTION RETURNS "$BIGSQL_LOG_DIR IS NOT SET!" |
APAR fixes included in DB2 Level s191019 & Bigsql-dist version 5.80.0.640
|
| APAR No. |
Abstract |
| PH18250 |
QUERY FAILS WITH SQLCODE -901 WITH "WRONG SIBLING" MESSAGE UNDER LOW MEMORY CONDITIONS |
APAR fixes included in DB2 Level s190921 & Bigsql-dist version 5.80.0.632
|
| 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 5.80.0.620
|
| APAR No. |
Abstract |
| PH15540 |
BIG SQL WORKER NODE CRASH DUE TO MEMORY CORRUPTION WHEN CALLING STORED PROCEDURE |
APAR fixes included in DB2 Level s190727 & Bigsql-dist version 5.80.0.609
|
| 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!" |
| PH13579 |
BIGSQL ENFORCES THE LINE TERMINATION ON DELIMITED HADOOP TABLES TO BE NEWLINE |
| PH15545 |
BIGSQL RECEIVES OUT OF RESOURCE ERROR ON ONE PARTICULAR WORKER NODE |
APAR fixes included in DB2 Level s190629 & Bigsql-dist version 5.80.0.589
|
| APAR No. |
Abstract |
| PH11973 |
BIG SQL HEAD NODE CRASHES AFTER SUBMITTING A RUNSTATS COMMAND ON A HADOOP TABLE |
| PH13525 |
KERBEROS TICKETS NOT RENEWED BY BIG SQL SERVICE |
| PH13377 |
SOME TABLE OPERATIONS INVALIDATE AND RELOAD THE BIGSQL SCHEDULER CACHE UNNECESSARILY |
| PH13808 |
SPLIT-BRAIN HADR FAILURE MAY OCCUR WITH AUTOMATED FAILOVER |
| PH14360 |
BIG SQL 5.0.4 UPGRADING TO INCLUDE CURRENT SET OF DB2 FIXES |
APAR fixes included in DB2 Level s190518 & Bigsql-dist version 5.80.0.538
|
| APAR No. |
Abstract |
| PH12085 |
BIGSQL MAY CRASH WITH "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" |
APAR fixes included in DB2 Level s190427 & Bigsql-dist version 5.80.0.505
|
| 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 |
| PH11595 |
BIGSQL CRASH DUE TO MEMORY CORRUPTION IN THE PACKAGE CACHE |
| PH13584 |
UNABLE TO QUERY PARQUET TABLE AFTER ALTERING COLUMN |
APAR fixes included in DB2 Level s190309 & Bigsql-dist version 5.80.0.485
|
| APAR No. |
Abstract |
| PH10060 |
TABLE TIMESTAMP COLUMN VALUE BECAME NULL AFTER UPGRADE |
APAR fixes included in DB2 Level s190309 & Bigsql-dist version 5.80.0.476
|
| APAR No. |
Abstract |
| PH10156 |
SQL0901N WITH UNEXPECTED AVGBUILDTUPLESIZE=0 IN JOIN QUERY |
| PH10325 |
TIMESTAMP COLUMNS DECLARED WITH A NON-DEFAULT SIZE DISPLAY INCORRECT MILLISECOND VALUES |
APAR fixes included in DB2 Level s190226 & Bigsql-dist version 5.80.0.464
|
| APAR No. |
Abstract |
| PH05978 |
BIGSQL HA ON STANDBY NODE - SOME FAILURES IN NETWORK OPERATIONS NOT HANDLED PROPERLY |
| PI95588 |
USER ID WITH INSUFFICIENT AUTHORITY TO RUN ANALYZE WIPES OUT STATISTICS AND RETURNS WITHOUT ERRORS |
| PH07586 |
QUERIES AGAINST PARQUET FILE FORMAT TABLES WITH COMPLEX TYPES (ARRAY, ROW or STRUCT) FAIL WITH ERROR |
| PH08563 |
CALLING A PS HIVE UDF, WHICH RETURNS A TEXT OBJECT, FAILS WITH SQL0430N WHEN THE FIRST ARGUMENT IS NOT ALSO NOT OF CLASS TEXT |
| PH07429 |
USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE |
APAR fixes included in DB2 Level s181208 & Bigsql-dist version 5.80.0.451
|
| APAR No. |
Abstract |
| PH05116 |
QUERY USING BUILT-IN FUNCTIONS MAY FAIL WITH SQL1229N DUE TO TRAP ON WORKER NODE |
| PH06246 |
BIGSQL INSTANCE HANGS DUE TO LOCK ON DB2DIAG.LOG |
| PH06245 |
QUERIES ON HADOOP TABLES FAIL WITH SQL0083C A MEMORY ALLOCATION ERROR HAS OCCURRED |
| PH03850 |
BIGSQL LEAVES HIVE SCRATCH DIRECTORIES UNDER THE HDFS PATH /TMP/HIVE/BIGSQL |
| PH07304 |
BIGSQL ADDITIONAL LOGICAL WORKERS MAY BE MISSING TABLESPACES AND CRASH WHEN GLOBAL TEMPORARY TABLES ARE CREATED |
| PH07960 |
DURING A BIGSQL HA FAILOVER INITIATED BY THE BIGSQL FAILOVER CONTROLLER THERE IS A CHANCE OF A SPLIT BRAIN SITUATION |
[{"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 5.0.4","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]