This Knowledge Collection is a focused compilation of links to documents for BigSQL 7.1.0 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 Aug 25, 2025, contact Support for more recent info.
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.667
|
| APAR No. |
Abstract |
DT439517
|
Upgrade hits issue - missing backup config file when using a custom VAR_DIR
|
| DT445952 |
IndexError during BigSQL upgrade from 7.1.0.503 to 7.1.0.632 |
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.632
|
| APAR No. |
Abstract |
DT421784
|
SQL4302N encountered due to discrepancy in bigsql-conf.xml file |
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.616
|
| APAR No. |
Abstract |
DT398378
|
Big SQL HBase table DELETE FROM command does not work after INSERT INTO |
| DT394304 |
Queries failing with Invalid delimiter:
|
| DT398193 |
Autoanalyze truncating data |
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.593
|
| APAR No. |
Abstract |
DT389180
|
ENABLING PAM AUTHENTICATION FOR A NON-ROOT INSTALLATION OF DB2 BIG SQL MAY FAIL |
| DT391456 |
BIGSQL QUERY MAY FAIL WITH SQL5105N ERROR IF THERE IS AN EMPTY LINE IN THE DATA
|
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.589
|
| APAR No. |
Abstract |
DT188203
|
Files added directly to 'Location' path do not trigger auto-analyze |
| DT224009 |
INSERT INTO ... SELECT ... FROM intermittently hangs |
| DT365386 |
Primary node flipping every time Big SQL is being restarted |
| DT380738 |
Big SQL Load Hadoop runs into error in smoke test |
| DT381477 |
Big SQL create HBase Table fails |
| DT383119 |
Big SQL unable to write in Kafka ATLAS_HOOK topic |
| DT386527 |
Errors while auditing Ranger in Big SQL to Solr |
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.568
|
| APAR No. |
Abstract |
DT258525
|
Big SQL error : Procedure or user-defined function aborted with an exception "org/apache/atlas/hook/AtlasHook" |
| DT258730 |
When there is both a worker 1 and a worker 10 running bigsql-start -n 1 will not start the worker |
| DT258780 |
Applying Big SQL patch run into HA Failover Issues |
| DT261250 |
Big SQL analyze table fails when the table location path contains blank space(s) |
| DT271576 |
Patching Big SQL to latest 7.1 introduced a failover controller issue on HADR-enabled environment |
| DT363124 |
Patching to latest BigSQL patch 7.1 has introduced Ranger errors |
APAR fixes included in DB2 Level s231123 & Bigsql-dist version 7.1.0.549
|
| APAR No. |
Abstract |
| DT239679 |
Analyze operation fails with a null pointer exception |
| DT239614 |
LOG_ENTRY and LOGSEARCH does not return Big SQL Error Codes |
| DT243077 |
Atlas-application.properties is generated with hard code kerberos realm IBM.COM |
| DT244973 |
Enabling Big SQL Ranger Plugin permission issues |
| DT244975 |
When patching Big SQL fails copying the Big SQL model for Atlas to the Atlas node |
| DT224313 |
Big SQL console displaying inconsistent timestamps on 'Inflight Executions' and 'Individual executions' page |
| DT237982 |
DELETE from ORC ACID Hadoop table fails to delete all matching rows |
| DT248176 |
Select from transactional table shows nulls as empty strings |
APAR fixes included in DB2 Level s221203 & Bigsql-dist version 7.1.0.518
|
| APAR No. |
Abstract |
| DT216891 |
HA may not start up properly when the cluster is restarted through the Cloudera Manager user interface if the failover controllers are enabled |
| DT180122 |
Big SQL add worker unable to find classpath.cache |
APAR fixes included in DB2 Level s221203 & Bigsql-dist version 7.1.0.509
|
| APAR No. |
Abstract |
| DT187949 |
Auto-Analyze not working if Big SQL (Hadoop External) table is dropped and recreated |
APAR fixes included in DB2 Level s221203 & Bigsql-dist version 7.1.0.503
|
| APAR No. |
Abstract |
| DT202836 |
Select from a table stored as delimited text format returns incorrect results if the last column is null |
APAR fixes included in DB2 Level s221203 & Bigsql-dist version 7.1.0.497
|
| APAR No. |
Abstract |
| DT173830 |
Use of non-supported RID function triggers SQL0901N error instead of the expected SQL5115N error |
| DT179979 |
BigSQL 7.1 error ArrayIndexOutOfBoundsException |
| DT189517 |
BigSql restart through Cloudera Manager is failing |
| DT197767 |
HCAT AUTO SYNC is automatically enabled during Big SQL Upgrade/Patching regardless of the config setting |
| DT198099 |
Queries with predicates may fail or yield incorrect results on ORC or Parquet tables |
APAR fixes included in DB2 Level s221029 & Bigsql-dist version 7.1.0.476
|
| APAR No. |
Abstract |
| DT169883 |
Big SQL intermittent SQL5105N during Insert into partitioned table using Impersonation |
| DT169561 |
Big SQL instance abends with an SQLO_UNEXPECTED_SYSERR from sqloWaitEDUWaitPost() |
| DT169902 |
Big SQL instance panics with 'Corrupt pool free tree node' from sqloDiagnoseFreeBlockFailure() |
APAR fixes included in DB2 Level s220831 & Bigsql-dist version 7.1.0.474
|
| APAR No. |
Abstract |
| DT134340 |
Big SQL 7.1 query terminating with index out of bounds |
| PH16175 |
RUNNING TRUNCATE USING IBM_DB.PREPARE(CONN, SQL) CAUSES BIGSQL TO CRASH |
APAR fixes included in DB2 Level s220122 & Bigsql-dist version 7.1.0.466
|
| APAR No. |
Abstract |
| DT131901 |
Big SQL 7.1 bigsql-conf file missing or truncated |
| DT131899 |
Bigsql clean stop without failover on CDP7 |
APAR fixes included in DB2 Level s220122 & Bigsql-dist version 7.1.0.461
|
| APAR No. |
Abstract |
| PH43147 |
HIVESTATEMENTHANDLER#DROPTABLE() IS NOT EXCLUDING LOCATION CHECKS FOR TABLES RESIDING IN THE HIVE.METASTORE |
| DT130357 |
SQLCODE=-5105 ArrayIndexOutOfBoundsException with IN/NOT IN predicate query on ORC full transactional (ACID) tables |
APAR fixes included in DB2 Level s220122 & Bigsql-dist version 7.1.0.443
|
| APAR No. |
Abstract |
| PH40808 |
CREATE TABLE AS SELECT CAN BYPASS DATA MASKING RULES |
| PH42879 |
FROM CLOUDERA MANAGER WHEN BIGSQL START ATTEMPTS TO RUN THE KINIT IT USES THE WRONG CACHE FILE LOCATION. |
| PH44337 |
SQLCODE -964 RETURNED FROM ANALYZE AGAINST A LARGE NUMBER OF TABLES WITH HADR ENABLED ON BIG SQL VERSION 7.1 |
| PH44222 |
ERRORS RETURNED DURING BIG SQL INSTALL PRECHECK WHEN USING NON-DEFAULT USER HOME DIRECTORY |
| PH43990 |
FAILOVER SCRIPT MAY FAIL WHEN RUN MORE THAN ONE TIME CONSECUTIVELY |
APAR fixes included in DB2 Level s220113 & Bigsql-dist version 7.1.0.433
|
| APAR No. |
Abstract |
| PH42254 |
DURING UPGRADE TO BIG SQL VERSION 7.1, BACKUP PRECHECK FAILS DUE TO MISSING CONFIGURATION TYPE |
| PH42017 |
STOPPING A BIGSQL LOGICAL WORKER USING THE -N SWITCH STOPS ALL LOGICAL WORKERS ON THE HOST |
| PH42190 |
DURING UPGRADE TO BIG SQL VERSION 7.1, UPGRADE PHASE FAILS WITH NAMEERROR |
| PH42253 |
PATCHING BIG SQL VERSION 7.1.0 ON CDP WITH SPECTRUM SCALE FAILS WITH ERROR HDFS IS NOT RUNNING |
| PH42624 |
DURING UPGRADE TO VERSION 7, BIG SQL FAILS TO START ON WORKER NODES AFTER A RESTORE BECAUSE TEMPORARY TABLESPACE IS OFFLINE |
| PH42879 |
FROM CLOUDERA MANAGER WHEN BIGSQL START ATTEMPTS TO RUN THE KINIT IT USES THE WRONG CACHE FILE LOCATION |
| PH42765 |
VULNERABILITY IN APACHE LOG4J AFFECTS IBM DB2 BIG SQL (CVE-2021-44228) |
APAR fixes included in DB2 Level s210925 & Bigsql-dist version 7.1.0.407
|
| APAR No. |
Abstract |
| PH40303 |
BIGSQL 7.1 INSTALL FAILS WHEN ATLAS ENABLED IN CDP 7.1.X |
| PH40945 |
HA FAILOVER ON THE PRIMARY BRINGS DOWN THE STANDBY AFTER A CHANGE IN BIGSQL UID |
| PH40941 |
KERBEROS IS MISSING THE KEYTAB FOR BIG SQL CONSOLE NODE |
| PH40163 |
BIG SQL MIGHT PRODUCE INCORRECT RESULTS (DUPLICATE ROWS) WHEN EXECUTING QUERY WITH UNION ALL. |
| PH41477 |
FAILURE DURING INSTALLATION OF VERSION 7.1 DUE TO INCOMPLETE CLEANUP OF DATA DIRECTORIES FROM PRIOR VERSION |
| PH41478 |
VARIOUS ERRORS DURING UPGRADE TO BIG SQL VERSION 7.1 |
APAR fixes included in DB2 Level s210619 & Bigsql-dist version 7.1.0.398
|
| APAR No. |
Abstract |
| PH40227 |
INTERMITTENT CREDENTIAL EXPIRED ERROR SEEN RUNNING JOBS |
| PH40251 |
TABLE PARTITIONS RESCANNED UNNECESSARILY DURING INCREMENTAL ANALYZE |
APAR fixes included in DB2 Level s210619 & Bigsql-dist version 7.1.0.395
|
| APAR No. |
Abstract |
| PH38611 |
ANALYZE FAILS WITH SQLCODE -1227 COLCARD IS OUT OF RANGE FOR ITS TARGET COLUM |
| PH38722 |
QUERY RETURNS INCONSISTENT RESULTS FROM A TABLE WITH A NEW COLUMN ADDED |
| PH36186 |
WHEN THE JAVA DFSIO FMP HITS THE POOLED THREAD LIMIT, IT IS MARKED UNSTABLE WHICH CAN STRESS MEMORY RESOURCES |
| PH37959 |
RUNNING DB2LOOK TO COLLECT DDL WITHOUT SPECIFYING A SUBSET OF OBJECTS WILL FAIL WITH SQL0305N |
| PH40936 |
MULTIPLE ISSUES AFTER INSTALLING OR UPGRADING TO BIG SQL VERSION 7.1.0 |
APAR fixes included in DB2 Level s210403 & Bigsql-dist version 7.1.0.366
|
| APAR No. |
Abstract |
| PH34686 |
BIG SQL INSTALLATION OR UPGRADE FAILS BECAUSE PIP COULD NOT BE INSTALLED |
| PH35265 |
HCAT_TABLEPARTS() MAY SHOW AN INCORRECT COUNT OF PARTITIONS FOR TABLES WITH MORE THAN 32,676 PARTITIONS |
| PH35403 |
EXCEPTION LABEL: UNMAPPED(JAVA.LANG.ERROR: MAXIMUM PERMIT COUNT EXCEEDED) ERROR SEEN RUNNING SELECTS, INSERTS, OR ANALYZE |
| PH34581 |
DB2LOOK MAY GENERATE INCORRECT SYNTAX FOR BIG SQL TABLES |
| PH33733 |
Insert operations into a table that is partitioned by a column expression might return an error (SQL5105N) |
| PH34959 |
SQLCODE -901 WITH "REBIND PACKAGE. POSSIBLY DROP DBPARTITIONNUM WAS DONE." |
| PH33732 |
QUERY MIGHT FAIL TO COMPILE WITH SQL0901N "EMPTY PLAN LIST DETECTED!" |
| 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 s201215 & Bigsql-dist version 7.1.0.351
|
| APAR No. |
Abstract |
| 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 |
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"ARM Category":[{"code":"a8m500000008XKWAA2","label":"Install \/ Uninstall-\u003EPatch Application"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.0"}]