What's new in Db2 or Db2 Warehouse 12.1.2 for Red Hat OpenShift and Kubernetes

Db2 or Db2 Warehouse for Red Hat OpenShift and Kubernetes is enhanced for the 12.2 release.

Note: Db2uCluster Custom Resource is deprecated and will be discontinued in a future release. As a resolution, migrate from Db2uCluster to Db2uInstance. To migrate to Db2uInstance, perform a Db2 native backup on your Db2uCluster instance and then restore to a new Db2uInstance. For more information on this procedure, see Backing up a Db2 or Db2 Warehouse database offline and Restoring Db2 or Db2 Warehouse from an offline backup.
The following features and enhancements are available with the release of Db2 12.1.2:
  • Kerberos authentication
    • Kerberos authentication can be used on your Db2 containerized solution to reduce the risk of a security exposure. For more information, see Configuring Kerberos.
  • Using the GSS plug-in for LDAP authentication
  • Datalake table support enhancements:
    • sys_java_heap_dz configuration parameter
      • The Datalake table related SYSHADOOP routines are implemented in Java and use Java heap. Starting in version 12.1.2, the maximum size of this Java heap can be set using the new sys_java_heap_sz database manager configuration parameter.
    • The EXPIRE_SNAPSHOT stored procedure is improved in the following ways:
      • The procedure is enhanced to deleted unused statistic files. The number of statistic files deleted is returned in the response.
      • An optional input parameter has been added to enable callers of the procedure to specify a list of snapshot IDs that determine which snapshots are to be expired
    • UPDATE statements are now supported for Iceberg Datalake tables. For more information, see UPDATE (DATALAKE) statement.
    • Improved performance of iceberg DELETE statements.
    • Improved performance of selects of Iceberg tables after DELETE operations.
    • Improvements to REWRITE_TABLE_FILES procedure. The REWRITE_TABLE_FILES procedure provides support to remove unneeded delete files, improving performance. For more information, see REWRITE_TABLE_FILES.