Version 1.0.18.0 release notes (July 2019)

What's new

3rd party software support

The appkg_install command can now be used to manage a number of new software items:

• Managing the EMC NetWorker client installation, as described in Managing EMC NetWorker client with appkg_install command.
• Installing and uninstalling IBM Tape Device Drivers for Linux, as described in Installing IBM Tape Device Drivers for Linux.
• Installing, managing, and uninstalling other 3rd party software packages, editing files, executing commands without the need for root access or special permissions, as described in Using AdHoc package manager.

Upgrade

You can now use a single file location to store and update your custom Db2 settings: /opt/ibm/appliance/storage/head/db2_config/. The location is persistent over apupgrade and apstop/apstart. For more information, see Preserving custom Db2 configuration settings between upgrades.

Migration tools

• A new script db_build_dictionary is now available in dbtoolkit, which allows you to build a dictionary before migrating data with db_migrate or db_migrate_iias. This improves compression and saves space on the target system. For more information on usage, see db_build_dictionary command
• Fast Data Movement version 1.0.3 is now available. For more information, see What's New.

Monitoring

Hardware inventory (ap hw -d) may now be retrieved via SNMP interface. This allows you to configure Platform Manager to send hardware metrics and other details to any data center management system via the SNMP interface. The SNMP interface is disabled by default. You can use apsnmpagent command to manage its state. For more information, see Enabling the SNMP interface to retrieve hardware information.

Backup and restore

• During a schema restore, -drop-existing option has to be specified if the schema exists in the database already, to drop and recreate it from the backup.
• In a schema backup, the data files for tables with Spatial and LOBs types can also be compressed using -compress gzip option. db_restore can be used to restore these tables from the compressed data files.
• Backup and restore to tapes using IBM Spectrum Protect is now supported. Installing and uninstalling IBM Tape Device Drivers for Linux can be done using appkg_install command and the tape configurations are persistent upon reboots and upgrades: Installing IBM Tape Device Drivers for Linux.
• IBM Spectrum Protect configuration enhancements:
  • Added a new parameter to manage_tsm to set SSL
  • Enhanced the manage_tsm --dsmsta-setstorageserver script
  • Updated IBM Spectrum Protect configuration checks in db_backup/db_restore, to differentiate between the nodes that are configured for LAN-Free operations vs the nodes that are configured for LAN-Based operations.
  • In db_backup, updated -sessions option to allow up to 6 sessions to perform a backup to IBM Spectrum Protect using -tsm option.

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

When you migrate from other databases, you can now use IBM Database Conversion Workbench 4.0.28 - see Release Notes for details.

Resolved issues

• Backup and restore:
  • For a given backup path, updated db_backup to only change permissions on the directories created by the script, leaving the permissions of the existing directories unaltered.
  • During a schema backup, modules and their aliases will be backed up. And during a restore, these objects will be left unaltered if they do not exist in the backup.
  • Updated db_backup and db_restore to limit the number of processes spawned during a schema backup or a restore.
  • For multi-table restore, updated -tablefile option to handle empty lines in the file that has the table names to restore.
  • db_backup now uses schema size instead of the database size to check if the given path has enough space for the schema backup.
  • Updated checks for schema backups: when multiple paths are specified with a comma (,) and no space separator is used, then these paths are now parsed correctly as multiple paths instead of a single path.
  • For a schema backup, the trigger and schema objects' ownership as well as the ownership type is now backed up. And during a restore, the ownership of these objects will be restored to its original owner.
  • All the backup directories will be owned by db2inst1 user and database admin group to allow non-bluadmin users to access the backup. A warning will be displayed instead of an error if db_backup fails to change the ownership on the backup directories to:

    db2inst1 : {admin_group}

  • Fixed a bug in db_restore, to allow restores when a table has the same name as the schema.
• The list of Red Hat CVEs patched in 1.0.18.0 release:

  CVE-2019-3839 CVE-2019-2602 CVE-2019-2684 CVE-2019-2698 CVE-2018-9568 CVE-2018-17972 CVE-2018-18445 CVE-2019-6974 CVE-2019-7221 CVE-2018-12126 CVE-2018-12127 CVE-2018-12130 CVE-2019-11091 CVE-2018-5743 CVE-2019-10132 CVE-2014-3565 CVE-2019-9636 CVE-2016-10745 CVE-2019-5953

Known issues

• When you use the console to attempt to back up or restore a database, the console displays a Check TSM status failed error message and the attempt fails. Consequently, you cannot use the console to back up or restore a database. Instead, use the db_backup and db_restore commands.
• EMC NetWorker backup/restore fails with SQL2062N. An error occurred while accessing the /usr/lib/libnsrdb2.so media. Reason code is 0. This is occurring due to two parameters that are added in the nmda_db2.cfg file on each node.WORKAROUND:
  1. As the root user, edit the /nsr/apps/config/nmda_db2.cfg file and comment out the NSR_LIBNSRDB2_DEBUG_LEVEL=9 and NSR_DEBUG_LEVEL=9 parameters. This must be done on every node in the container.
  2. Rerun backup/restore.