Updating Db2 Analytics Accelerator on Z

Follow the steps in this section to upload a new image (appliance) for Db2 Analytics Accelerator on Z and activate it.

Before you begin

Before the update, bring the entire system to a halt. That is, cancel all running tasks, such as load jobs and so on, and stop the accelerator.

If incremental updates are enabled, also stop replication before you proceed. Otherwise, the replicated tables end up in a state that requires a manual re-enablement, and, possibly also a reload.

Remember: You must complete the following steps for each Db2 subsystem or data sharing group that is connected to the accelerator.

Use the selected administration client to proceed:

  1. Cancel all running tasks.

    For more information, see Canceling tasks.

  2. Stop the accelerator.

    For more information, see Disabling an accelerator.

  3. Stop replication and wait a few minutes, so that pending incremental updates can be applied to the tables on the accelerator. Your wait time should roughly equal your replication latency period.

    For more information, see:

Procedure

Restriction:
  • For the following steps, you need Mozilla Firefox or Google Chrome. Other browsers are not supported.
  • If the Login page does not show all the controls needed to login successfully, or if after the logon an SSC installer window is not fully usable because controls are missing, change the browser language to English and try again.

  1. Open the Admin UI in a web browser. Enter the IPv4 address of the Secure Service Container (SSC) LPAR (see Figure 4).
  2. On the Login page, log in with the Master user ID and Master password that you specified as you defined the SSC LPAR. (see Figure 4)
    You see the Accelerator Components Health Status page:
    Figure 1. The Accelerator Components Health Status page
    This image shows the Accelerator Components Health Status page. This page is the first to be displayed after you log in. The Update button is in the middle, on the right-hand side.
  3. On the right side of the Accelerator Components Health Status page, click Update.
    The Update page is displayed. See Figure 2.
  4. To make sure that all accelerator operations are paused during the update, click Quiesce.
    Figure 2. The Update page
    This image shows the Update page. The Quiesce button is encircled.
  5. By clicking Download, you can save your current configuration to a local drive, so that it can be reloaded to complete the update. After the download, the Reboot button becomes active (clickable).
    Important:

    An export file is an encrypted file that not only contains the accelerator configuration (similar to the JSON configuration file), but also the keys required to access the data pools on the accelerator. All data on the accelerator disks is encrypted. The keys are only stored on the boot volume and in the export files you create. Without the keys, you cannot restore the accelerator data. Securely store all export files and refresh these files after every update and every configuration change. This way, you might be able to restore an accelerator without data loss even if you are facing a severe problem.

    If, after saving an export file from Db2 Analytics Accelerator on Z Version 7.5.5 or earlier, your accelerator does not restart properly, contact IBM support.

  6. Click Reboot.
    A confirmation window is displayed:
    Figure 3. The Confirm Reboot window
    The Confirm Reboot window
  7. Read the warnings and click Yes.
    A newly displayed page informs you about the start of the Secure Service Container Installer. The installer takes several minutes to launch fully. When the Secure Service Container Installer is online, the Login page is displayed:
    Figure 4. Login page of the Secure Service Container Installer
    This image shows the Login page of the Secure Service Container Installer
  8. On the Login page of the Secure Service Container Installer, log in with the Master user ID and Master password that you specified as you defined the SSC LPAR.
    For more information, see step 9 in Defining an LPAR for Db2 Analytics Accelerator on Z.
    You see the Welcome page:
    Figure 5. The Welcome page of the Secure Service Container Installer
    Welcome page of the Admin UI
  9. Click Plus icon on Welcome page on the Welcome page.
    You see the Install Software Appliance window:
    Figure 6. The Install Software Appliance window
    On this page, you specify the package (program image) to upload and the target disk for the upload.
  10. Make sure that Upload image to target disk is selected.
  11. Click Browse to select the appliance image (compressed file).
    The information in the Install Software Appliance window changes as follows:
    Figure 7. The Install Software Appliance window after selecting an image file
    On this page, you specify the package (program image) to upload and the target disk for the upload.
  12. Select the Device Type (disk type) and the Disk to upload the image to.
  13. Click Apply.
    A confirmation window comes up:
    Figure 8. Confirming the installation of the selected image
    Installation confirmation window
  14. In the confirmation window, click Yes.
    The upload process starts. This might take several minutes, depending on the network speed. When the upload has finished, the uploaded image is used to reboot your Db2 Analytics Accelerator on Z. This is indicated by the following page of the Secure Service Container Installer:
    Figure 9. Reboot message window
    Reboot message window
  15. After a successful reboot, you see the Login page of the Admin UI again. Log in with the Master user ID and Master password.
    Review step 8 for more information.
  16. Follow these steps:
    1. Read the Software License Agreement.
    2. Click Show non-IBM terms.
    3. Read the Non-IBM Terms.
    4. Click I Agree.
  17. A confirmation window is displayed. Click I Agree once more.
    The Welcome page of the Admin UI is displayed:
    Figure 10. The Welcome page of the Admin UI
    Welcome page of the Admin UI
  18. Click Finalize an Update.
    You revisit the Update page that is shown in step 4.
  19. Click Upload and select the encrypted configuration file that you exported in step 5.
  20. Confirm the export file upload by clicking Yes in the confirmation window:
    Figure 11. Confirming the export file upload
    Export file upload confirmation window
    The Db2 Analytics Accelerator on Z is rebooted again. After the reboot, the Login page of the Admin UI is displayed again.
  21. Log in to the Admin UI again with your Master user ID and Master password.
    You see a message window with a progress indicator:
    Figure 12. Update progress indicator on the Admin UI
    Admin UI window showing the update progress (circular progress indicator). The Logs tab on the left is encircled.

    While the update is running, you can follow the line of events by clicking the Logs tab. The page does not refresh automatically, but you can click the Refresh button in the upper right corner.

Results

When the update has finished, the Accelerator Components Health Status is displayed automatically. A working status (green icon) should be displayed for all required components. These are all components in the list, except for the GDPS® client component. For the latter component, an inactive status (gray icon) is shown if GDPS support is not installed. See the following figure:
Figure 13. The Accelerator Components Health Status page after a successful update
Accelerator Components Health Status page after a successful update

What to do next

  1. Restart replication. For more information, see Starting or stopping incremental updates.
  2. Re-enable query acceleration. For more information, see Enabling an accelerator