Integrated Analytics System 1.0.28.2 release notes (March 2024)

Version 1.0.28.2 replaces 1.0.28.1. Version 1.0.28.2 includes firmware updates, platform changes, and issue fixes.

What's new

Platform changes

Converted the Integrated Analytics System platform software from Python 2 to Python 3.

In 1.0.28.2, the Podman version is getting upgraded from 1.6.4-26 to 1.6.4-36.

Firmware updates

The following are the firmware updates:

  • Updated DSN to version 8.2.1.15.
  • Updated FSN to version 1.6.1.4.
  • Updated node HDD ST1200M (st1200mm0139) to version 9F26.
  • Updated node 8247-22L FC HBA to version 12.4.257.30.

Components

Db2 Warehouse 11.5.8.0
See What's New in Db2 Warehouse.
Db2 Engine 11.5.8
To learn more about the changes that are introduced in Db2 11.5.8.0, read What's new in the Db2 Documentation.

Limitations

Important: The Integrated Analytics System does not support AFMDR in this release.

Resolved issues

  • Clicking the Docs button from the Integrated Analytics System Web Console displays an error page with the message: 
    The page you are looking for may have been moved or deleted
    This issue is resolved by correcting the link.
  • The Aginity workbench link in the Integrated Analytics System Web Console loads an error page.
  • Updated DSN firmware to fix an issue that caused RAID array rebuild to stall after drive failure that left the array unprotected against other drive failures.
  • Due to the new firmware level requirement of node HBA card, the node 8247-22L firmware is updated on upgrade.
  • Before this release, the system became unstable rarely when externally provided fibre channel (FC) and storage area network (SAN) storage provided was attached and configured. The system became transiently nonresponsive, and a rare set of converging circumstances occurred within the kernel happened simultaneously on the IAS. For this scenario, the system stability is now improved.
  • Before this release, Magneto did not generate alerts when FCSW or FSN fiber channel ports experience connection issues due to poor signal from SFP transmitter and receiver. This issue is resolved.

Known issues

Integrated Analytics System Web Console page hangs after incorrect log in attempts
The Integrated Analytics System Web Console home page hangs indefinitely after repeated log in attempts. The home page appears blank after a reload.
WORKAROUND

Clear the browser cache and reload the Integrated Analytics System Web Console home page.

Integrated Analytics System Web Console accepts passwords with a space when you create a new user
The issue does not have a workaround. Integrated Analytics System Web Console accepts passwords that contain spaces to be consistent with Integrated Analytics System behavior.
Widgets in Integrated Analytics System Web Console home page appear stacked
The widgets in the Integrated Analytics System Web Console home page appear stacked toward left of the page.
WORKAROUND

Click the Personalize button in the Integrated Analytics System Web Console home page to restore the layout.

COISBAR schema level backs up to TSM inside the Integrated Analytics System container missing appropriate permissions to create directory
When backing up the COISBAR schema to TSM, an error message is displayed:
ERROR: SYSPROC.LOGICAL_BACKUP failed with error message: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXPPC64LE] SQL1797N  The "SYSPROC.LOGICAL_BACKUP" utility has failed with error "Could not create streaming subdirectory. Ensure".  SQLSTATE=5UA0Q SQLCODE=-1797
ERROR: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXPPC64LE] SQL1797N  The "SYSPROC.LOGICAL_BACKUP" utility has failed with error "Could not create streaming subdirectory. Ensure".  SQLSTATE=5UA0Q SQLCODE=-1797
Example
[bluadmin@node0101-fab - Db2wh ~]$ db_backup -type onl -tsm -schema lbar1
Acquiring a unique timestamp and log file...
Logging to /scratch/bluadmin_BNR/logs/20230908133128/backup20230908133128.log
ERROR: SYSPROC.LOGICAL_BACKUP failed with error message: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXPPC64LE] SQL1797N  The "SYSPROC.LOGICAL_BACKUP" utility has failed with error "Could not create streaming subdirectory. Ensure".  SQLSTATE=5UA0Q SQLCODE=-1797
ERROR: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXPPC64LE] SQL1797N  The "SYSPROC.LOGICAL_BACKUP" utility has failed with error "Could not create streaming subdirectory. Ensure".  SQLSTATE=5UA0Q SQLCODE=-1797
WORKAROUND

Run the following commands inside the dashDB container as the root user:

chown -R root:bluadmin /scratch/bluadmin_BNR
chmod -R g+rwx /scratch/bluadmin_BNR

After running these commands, a success message of running a COISBAR schema-level backup to TSM appears.

Example
[bluadmin@node0101-fab - Db2wh ~]$ db_backup -type onl -tsm -schema lbar1
Acquiring a unique timestamp and log file...
Logging to /scratch/bluadmin_BNR/logs/20230911090039/backup20230911090039.log
Logical backup utility has completed successfully, timestamp for the backup image is "20230911090042"
Upgrade might fail during the firmware installation on FSN

Upgrading to version 1.0.28.2 from 1.0.27.3 after applying 7.9.23.08.SP21 might fail during the firmware installation on FSN with the following error in log /var/log/appliance/platform/services/debug_sys_hw_config_fsn_*.log:

2024-03-03 10:01:05,888] INFO     _update_fsn_firmware: --------------------------------FIRMWARE UPDATE--------------------------------
[2024-03-03 10:01:05,890] INFO     run                 : Now watching state fw_install.
[2024-03-03 10:01:05,896] INFO     _monitor_upgrade_pro: fsn0103 canister (node) update status: left [start] - right [start]
[2024-03-03 10:01:38,964] INFO     _monitor_upgrade_pro: fsn0103 canister (node) firmware update is running, status: [hardware_failed], progress: [63%]
WORKAROUND
  1. Log in to the FSN where the update has failed:
    ssh superuser@fsn0x0x
  2. Resume the update manually:
    applysoftware -resume
  3. Monitor the updates for the status of completion:
    lsupdate
If the update is successful, log out from the FSN and restart the upgrade.
If the update fails, it might be a hardware failure. Contact FSN team for support.
When upgrading from SP24, SP25 or SP26 to IAS version 1.0.28.2, you might not be able to see the total estimated upgrade time in the precheck log.
WORKAROUND

Before you start the upgrade, perform the following steps:

  1. Create a directory for the upgrade bundle. Move the bundle inside the newly created directory. Create another directory that is named EXTRACT. Then, run the following command to extract the bundle:
    tar -xvf <bundle_name> -C EXTRACT
         |-- Version
          |-- EXTRACT
          |-- bundle
  2. On node 0101, run the following commands. Replace the directory name in the command <your-upgrade-dir> with the directory name that you used in your system:
    sed -i -e '152s,exit 1,#exit 1,g' /localrepo/<your-upgrade-dir>/EXTRACT/bundle/app_img/python3_dependencies/install-py3.sh
    sed -i -e 's,self.verify_bundle,#self.verify_bundle,g' /opt/ibm/appliance/apupgrade/bin/apupgrade
  3. After upgrading to the apupgrade component, the upgrade might fail with the following error:
    Verifying bundle integrity and authenticity Bundle integrity and authenticity verification failed. Aborting preliminary checks
  4. Run the following command again and restart the upgrade:
    sed -i -e 's,self.verify_bundle,#self.verify_bundle,g' /opt/ibm/appliance/apupgrade/bin/apupgrade