Version 1.0.17.1 release notes (May 2019)

What's new

Security

For IAS M4002-001 self-encrypting drives, the following enhancements were added:

• Backup and restore of local SED keystore facility
• Integrating the appliance with an external IBM SKLM server for AEK management
• Switching IAS from external ISKLM server back to local keystore for AEK management

For more information, see Storage hardware encryption for M4002-001 model.

Backup and restore

• Schema backups taken on one system can now be restored on a different system with a different topology as well. For example, backups taken on IAS can be restored on Db2® Warehouse and vice versa.
  Note: Make sure that the permissions/ownership on the backup directories and files are not altered while transferring the backups from one system to another.
• A new option, -tablefile has been implemented for db_restore command. It allows users to restore a subset of tables from a schema backup using a file that has case-sensitive table names with each table name on a separate line.
• Updated schema backup/restore path checks whether the delayed values (caused by extra space between paths) in EXTBL_LOCATION parameter are not skipped.
• IBM Spectrum Protect (TSM) client and storage agent version is updated to 8.1.7. IBM Spectrum Protect (TSM) server must be upgraded to 8.1.7 to be compatible for LAN-Free backups and restores.

Network

Static routing can now be enabled with additional configuration steps using apsetup.

Fast Data Movement v1.0.2

With the new version of Fast Data Movement for Hadoop, you can now run the data movement process from Db2 Warehouse. For more information, see What's new in Fast Data Movement.

Db2 support tools (dbtoolkit)

The dbtoolkit package is now updated. New options were added in the following scripts:

• db_migrate
  • db_migrate frombackup option allows you to migrate data from a Netezza backup to BLUDB.
  • Added BINARY format for data transfer. MIXED format in now deprecated.
  • Fixed bogus data integrity check failure for a specific case of NUMERIC()
• db_migrate_iias
  • Automatic creation of tables on target machine.
  • -where flag for migrating a subset of data.
  • Significantly improved user experience and debugging capabilities by adding summary with details to the logs, log files better organized.
  • Fixed issue with empty tables.
• dbload
  • Improved debugging capabilities in case of failed loading of data.
  • Fixed issue with single quote value for -escapeChar parameter.

For more information, see Db2 support tools overview

Components

You can use IAS with DSX Local Version 1.2. DSX is not pre-installed and IBM Support must be involved in the installation process. For more details, see What's new

Resolved issues

• The list of Red Hat CVEs patched in 1.0.17.1 release:

  CVE-2019-2422 CVE-2019-6454 CVE-2019-3835 CVE-2019-3838 CVE-2019-2422 CVE-2018-9568 CVE-2018-17972 CVE-2018-18445 CVE-2019-6454 CVE-2019-3855 CVE-2019-3856 CVE-2019-3857 CVE-2019-3863 CVE-2018-5407

• Fixed an issue with third party rpm packages installed by DSX on IAS causing the upgrade to fail.
• Fixed a known issue with adding SAN, when in some cases when attempting to add a SAN, the following error was seen:

  Checking multipath devices and populating GPFS stanza file...
  ERROR: No multipaths found...
  

• Updated db_backup to back up all the Grant statements and store the ownership information for schema objects like tables, views, stored procedures and references. Also, db_restore can now be used to preserve the permissions using those Grant statements and also restore the ownership for the above schema objects.
• Fixed an issue with db_restore, where it used to skip restoring the very first view in a schema. Now all the views in a schema can be restored successfully.
• Updated external table options to allow db_backup and db_restore to support backup and restore of the tables that have data with ASCII characters stored in binary format.
• Updated db_backup schema size check to get the size of tables in a schema using ADMIN_GET_TAB_INFO procedure, in place of ADMINTABINFO table, to avoid lock timeout issues during CTAS operations.
• Fixed a bug in multi-path size check for full database backup. Database size is now compared with the sum of space left in each given path instead of comparing the database size with the space left in individual paths.
• Fixed bogus data integrity check failure for a specific case of NUMERIC() in db_migrate.
• Fixed issue with empty tables in db_migrate_iias.
• Fixed issue with single quote value for -escapeChar parameter in dbload.

Known issues

• File system based disaster recovery solution is not supported on versions 1.0.17.0 and 1.0.17.1.
• In order to protect against a known issue with apupgrade, before upgrading to 1.0.17.1, upgrade apupgrade to its latest version by using the --upgrade-apupgrade flag first.
• On the Restore options in the web console, the backup list is missing schema-level backups. Only the database-level backups taken on the system are displayed.
• After the backup of the defined external tables in the schema, when the tables are restored, they are not restored as external tables. They are restored as normal tables.