Preventive Service Planning

Abstract

This document lists the available patches for the Db2® for Big SQL service on IBM Cloud Pak® for Data. Not all versions include patches. Only versions that include patches are shown.

Content

cpd-3.5.0-bigsql-patch-390

Patch name	cpd-3.5.0-bigsql-patch-390
Released on	10 Mar 2022
Service assembly	big-sql
Applies to service version	Db2 Big SQL 7.1.1
Applies to platform version	Cloud Pak for Data 3.5.0
Patch type	Cumulative
Description	The cpd-3.5.0-bigsql-patch-390 service patch includes fixes for the following issues: PH40808 - CREATE TABLE AS SELECT can bypass data masking rules PH42765 - Vulnerability in Apache Log4j affects IBM Db2 Big SQL (CVE-2021-44228)
Instructions	See Applying a Db2 Big SQL patch.

cpd-3.5.0-bigsql-patch-379

Patch name	cpd-3.5.0-bigsql-patch-379
Released on	27 Jan 2022
Service assembly	big-sql
Applies to service version	Db2 Big SQL 7.1.1
Applies to platform version	Cloud Pak for Data 3.5.0
Patch type	Cumulative
Description	The cpd-3.5.0-bigsql-patch-379 service patch includes fixes for the following issues: PH42765 - Vulnerability in Apache Log4j affects IBM Db2 Big SQL (CVE-2021-44228) PH36186 - When the Java^TM 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
Instructions	See Applying a Db2 Big SQL patch.

cpd-3.5.0-bigsql-patch-371

Patch name	cpd-3.5.0-bigsql-patch-371
Released on	15 July 2021
Service assembly	big-sql
Applies to service version	Db2 Big SQL 7.1.1
Applies to platform version	Cloud Pak for Data 3.5.0
Patch type	Cumulative
Description	The cpd-3.5.0-bigsql-patch-371 service patch includes fixes for the following issues: PH38611 - ANALYZE fails with SQLCODE -1227 COLCARD IS OUT OF RANGE FOR ITS TARGET COLUMN PH38722 - Query returns inconsistent results from a table with a new column added
Instructions	See Applying a Db2 Big SQL patch.

cpd-3.5.0-bigsql-patch-367

Patch name	cpd-3.5.0-bigsql-patch-367
Released on	28 June 2021
Service assembly	big-sql
Applies to service version	Db2 Big SQL 7.1.1
Applies to platform version	Cloud Pak for Data 3.5.0
Patch type	Cumulative
Description	The cpd-3.5.0-bigsql-patch-367 service patch includes fixes for the following issues: PH34581 - DB2LOOK might 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!" PH36468 - UI error when you try to provision a Big SQL on Cloud Pak for Data instance that is connected to an AWS S3 service PH36469 - Authentication with Cloudera Manager fails for intermediate certificates PH36470 - Provisioning a Big SQL on Cloud Pak for Data instance that is connected to a Cloudera CDH 5.12 Hadoop cluster fails PH36471 - Provisioning a Big SQL on Cloud Pak for Data instance that is connected to a Cloudera CDH Hadoop cluster that was installed by using a blueprint might fail PH36472 - If a Big SQL on Cloud Pak for Data instance was previously deleted, provisioning a new instance might fail PH36606 - "BIGSQL.COMPATIBILITY_MODE" is not valid in the context where it is used. SQLCODE=-206 returned by HCAT_AUTOSYNC or ANALYZE PH36464 - Granting access to Big SQL on Cloud Pak for Data to a user with punctuation characters in their user name appears to work, but fails silently
Instructions	See Applying a Db2 Big SQL patch.

cpd-3.5.0-bigsql-patch-341

Patch name	cpd-3.5.0-bigsql-patch-341
Released on	14 April 2021
Service assembly	big-sql
Applies to service version	Db2 Big SQL 7.1.1
Applies to platform version	Cloud Pak for Data 3.5.0
Patch type	Cumulative
Description	The cpd-3.5.0-bigsql-patch-341 service patch includes fixes for the following issues: PH33724 - Analyze wipes out statistics and returns without errors when authority is granted through a role PH34581 - DB2LOOK might generate incorrect syntax for Big SQL tables PH34548 - SELECT FROM TABLE (SYSHADOOP.BIGSQL_ENV()) WITH LIMIT clause causes routine to hang and be noninterruptible PH34686 - Big SQL installation or upgrade fails because PIP could not be installed PH35265 - HCAT_TABLEPARTS() might 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 PH36462 - New worker nodes added to a Big SQL for Cloud Pak for Data instance by scaling up are not used by the cluster
Instructions	See Applying a Db2 Big SQL patch.

cpd-3.0.1-bigsql-patch-1984

Patch name	cpd-3.0.1-bigsql-patch-1984
Released on	4 November 2020
Service assembly	bigsql
Applies to service version	Db2 Big SQL 6.0.0
Applies to platform version	Cloud Pak for Data 3.0.1
Patch type	Cumulative
Description	The cpd-3.0.1-bigsql-patch-1984 service patch addresses the issue documented in DT085865 - QUERY FAILS WITH JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION ON PARQUET FILE
Instructions	See Applying patches.

cpd-3.0.1-bigsql-patch-1

Patch name	cpd-3.0.1-bigsql-patch-1
Released on	26 June 2020
Service assembly	bigsql
Applies to service version	Db2 Big SQL 6.0.0
Applies to platform version	Cloud Pak for Data 3.0.1
Patch type	Cumulative
Description	The cpd-3.0.1-bigsql-patch-1 service patch addresses vulnerabilities CVE-2017-7525, CVE-2017-17485, CVE-2018-5968 in libraries jackson-databind-2.2.3.jar and jackson-databind-2.4.2.jar.
Instructions	See Applying patches.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m0z000000GpDZAA0","label":"Services and Integrations"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Tips

Available patches for Db2 Big SQL for IBM Cloud Pak for Data