Integrated Analytics System 1.0.28.1 release notes (October 2023)

Version 1.0.28.1 replaces 1.0.28.0. Version 1.0.28.1 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.1, 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.

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"