What's new and changed in Db2 Big SQL

Db2® Big SQL updates can include new features, bug fixes, and security updates. Updates are listed in reverse chronological order so that the latest release is at the beginning of the topic.

You can see a list of the new features for the platform and all of the services at What's new in IBM Cloud Pak® for Data?

Installing or upgrading Db2 Big SQL

Ready to install or upgrade Db2 Big SQL?

Related documentation:

Cloud Pak for Data Version 4.6.4

A new version of Db2 Big SQL was released in March 2023 with Cloud Pak for Data 4.6.4.

Operand version: 7.4.4

This release includes the following changes:

Bug fixes

Version 7.4.4 of the Db2 Big SQL service includes various fixes.

Security fixes

This release includes fixes for the following security issues:

CVE-2023-22809, CVE-2023-23918, CVE-2023-23919, CVE-2023-23920, CVE-2023-23931, CVE-2023-23936

CVE-2022-1996, CVE-2022-2873, CVE-2022-2879, CVE-2022-2880, CVE-2022-2964, CVE-2022-3697, CVE-2022-3821, CVE-2022-4139, CVE-2022-4415, CVE-2022-21698, CVE-2022-23491, CVE-2022-24439, CVE-2022-25881, CVE-2022-32190, CVE-2022-35737, CVE-2022-36087, CVE-2022-40303, CVE-2022-40304, CVE-2022-40898, CVE-2022-41222, CVE-2022-41715, CVE-2022-41716, CVE-2022-41717, CVE-2022-42010, CVE-2022-42011, CVE-2022-42012, CVE-2022-43680, CVE-2022-43945, CVE-2022-45787, CVE-2022-47629

CVE-2021-46848

Cloud Pak for Data Version 4.6.2

A new version of Db2 Big SQL was released in January 2023 with Cloud Pak for Data 4.6.2.

Operand version: 7.4.2

This release includes the following changes:

Bug fixes

Version 7.4.2 of the Db2 Big SQL service includes various fixes.

Security fixes

This release includes fixes for the following security issues:

CVE-2023-0394

CVE-2022-1158, CVE-2022-1304, CVE-2022-1941, CVE-2022-2602, CVE-2022-28948, CVE-2022-32743, CVE-2022-3303, CVE-2022-33981, CVE-2022-3437, CVE-2022-3592, CVE-2022-3649, CVE-2022-37454, CVE-2022-37599, CVE-2022-37603, CVE-2022-37865, CVE-2022-37866, CVE-2022-37966, CVE-2022-37967, CVE-2022-38900, CVE-2022-39190, CVE-2022-40154, CVE-2022-40155, CVE-2022-40156, CVE-2022-41946, CVE-2022-45888, CVE-2022-46175, CVE-2022-46363, CVE-2022-46364

CVE-2021-28363, CVE-2021-3572, CVE-2021-38593

CVE-2020-15112

CVE-2018-16428

CVE-2016-3709

CVE-2015-20107

Cloud Pak for Data Version 4.6.0

A new version of Db2 Big SQL was released in November 2022 with Cloud Pak for Data 4.6.0.

Operand version: 7.4.0

This release includes the following changes:

New features

The 7.4.0 release of Db2 Big SQL includes the following features and updates:

Inferring the table structure from a remote file

You can now use the LIKE clause on the CREATE TABLE (HADOOP) statement to infer the table structure from a data file with a TEXTFILE or JSONFILE file format. For details, see Inferring the table structure from a remote file.

New object storage configuration options

When you connect Db2 Big SQL to an object store, the following configuration options are now available:

Vault support: You can now store credentials and certificates that are used to connect to an object store in a vault. For details, see Setting up a connection to a remote data source.
Trusted certificate for connections to internal services: Db2 Big SQL can now use the CA certificate that you can optionally provide for connections to internal services. If you use a CA certificate, you no longer need to provide a separate certificate for internal object store service connections. For details on using a CA certificate to connect to internal services, see Using a CA certificate to connect to internal servers from the platform.
Path-style access: You can now specify that an S3 object store bucket must be accessed by using path-style access instead of virtual-hosted-style access. With support for path style access, Db2 Big SQL can now connect to more object store services, such as MinIO. For details, see Setting up a connection from Db2 Big SQL to a remote data source.

Diagnostic logs are now stored in a dedicated persistent volume

In new Db2 Big SQL deployments, diagnostic logs for the Db2 Big SQL instance are stored in a dedicated persistent volume, which prevents overflow problems and improves reliability.

For more information about diagnostic logs, see Gathering diagnostic information.

Bug fixes

Version 7.4.0 of the Db2 Big SQL service includes various fixes.

Security fixes

This release includes fixes for the following security issues:

CVE-2022-0168, CVE-2022-0261, CVE-2022-0318, CVE-2022-0359, CVE-2022-0361, CVE-2022-0391, CVE-2022-0392, CVE-2022-0413, CVE-2022-0494, CVE-2022-0617, CVE-2022-0778, CVE-2022-0854, CVE-2022-1016, CVE-2022-1048, CVE-2022-1055, CVE-2022-1154, CVE-2022-1184, CVE-2022-1271, CVE-2022-1292, CVE-2022-1353, CVE-2022-1621, CVE-2022-1629, CVE-2022-1785, CVE-2022-1852, CVE-2022-1897, CVE-2022-1927, CVE-2022-2068, CVE-2022-2078, CVE-2022-2097, CVE-2022-2509, CVE-2022-2526, CVE-2022-2586, CVE-2022-2588, CVE-2022-2601, CVE-2022-2639, CVE-2022-2938, CVE-2022-3515, CVE-2022-3775, CVE-2022-3787, CVE-2022-3857, CVE-2022-20368, CVE-2022-21499, CVE-2022-21604, CVE-2022-21611, CVE-2022-21619, CVE-2022-21624, CVE-2022-21626, CVE-2022-21628, CVE-2022-21635, CVE-2022-21637, CVE-2022-21698, CVE-2022-21724, CVE-2022-21797, CVE-2022-22576, CVE-2022-23308, CVE-2022-23437, CVE-2022-23816, CVE-2022-23825, CVE-2022-23960, CVE-2022-24407, CVE-2022-24448, CVE-2022-25255, CVE-2022-26373, CVE-2022-26520, CVE-2022-27404, CVE-2022-27405, CVE-2022-27406, CVE-2022-27774, CVE-2022-27776, CVE-2022-27782, CVE-2022-27950, CVE-2022-28390, CVE-2022-28893, CVE-2022-29162, CVE-2022-29581, CVE-2022-29824, CVE-2022-29900, CVE-2022-29901, CVE-2022-30698, CVE-2022-30699, CVE-2022-31197, CVE-2022-32081, CVE-2022-32082, CVE-2022-32084, CVE-2022-32086, CVE-2022-32089, CVE-2022-32091, CVE-2022-32206, CVE-2022-32208, CVE-2022-32212, CVE-2022-32213, CVE-2022-34903, CVE-2022-36087, CVE-2022-36946, CVE-2022-37434, CVE-2022-37601, CVE-2022-38177, CVE-2022-38178, CVE-2022-38791, CVE-2022-40674, CVE-2022-41973, CVE-2022-41974, CVE-2022-42889

CVE-2021-3426, CVE-2021-3445, CVE-2021-3468, CVE-2021-3521, CVE-2021-3572, CVE-2021-3634, CVE-2021-3640, CVE-2021-3712, CVE-2021-3737, CVE-2021-3778, CVE-2021-3796, CVE-2021-3872, CVE-2021-3984, CVE-2021-4019, CVE-2021-4122, CVE-2021-4189, CVE-2021-4192, CVE-2021-4193, CVE-2021-20266, CVE-2021-20329, CVE-2021-22876, CVE-2021-22898, CVE-2021-22925, CVE-2021-23840, CVE-2021-23841, CVE-2021-25214, CVE-2021-25219, CVE-2021-25220, CVE-2021-25317, CVE-2021-27645, CVE-2021-30002, CVE-2021-30465, CVE-2021-33574, CVE-2021-35515, CVE-2021-35516, CVE-2021-35517, CVE-2021-36090, CVE-2021-36373, CVE-2021-36374, CVE-2021-42574, CVE-2021-43784, CVE-2021-45940, CVE-2021-45941

CVE-2020-10543, CVE-2020-10878, CVE-2020-12413, CVE-2020-12723, CVE-2020-13435, CVE-2020-13790, CVE-2020-14338, CVE-2020-14392, CVE-2020-14393, CVE-2020-16135, CVE-2020-17533, CVE-2020-24370, CVE-2020-28241, CVE-2020-35525, CVE-2020-35527, CVE-2020-35538, CVE-2020-36516, CVE-2020-36558

CVE-2019-2201, CVE-2019-5827, CVE-2019-7317, CVE-2019-13750, CVE-2019-13751, CVE-2019-16869, CVE-2019-17594, CVE-2019-17595, CVE-2019-18218, CVE-2019-19603, CVE-2019-20444, CVE-2019-20445, CVE-2019-20919

CVE-2018-20406, CVE-2018-2773

CVE-2017-1000487

CVE-2016-9842

CVE-2014-10402