Upgrading SQL DI

Db2 releases new and enhanced SQL DI functions as they become available. If you have already installed SQL DI, install the latest maintenance packages (APARs/PTFs) to upgrade your SQL DI and exploit all the enhancements.

Before you begin

Important:
  • The upgrade procedure assumes that you have already installed SQL DI. Make sure that you have met all system requirements as described in Planning SQL DI installation.
  • Db2 APAR PH55212 includes the AI_COMMONALITY function, and the function requires Db2 application compatibility level V13R1M504.
  • The Db2 AI_COMMONALITY function requires that models be trained with the latest zADE updates. The zADE updates are available in APAR OA64845 for z/OS® 3.1 or OA64844 for z/OS 2.5.
  • The model retraining capability requires the application of the latest zADE updates. The zADE updates are available in APAR OA66166 for z/OS 3.1 or OA66166 for z/OS 2.5. The capability is not available on z/OS 2.4. Consider upgrading your z/OS system to 2.5 or later if you need to retrain models of your AI objects.

Procedure

  1. Apply the latest APARs in the following order:
    1. For zAIO and zADE in the zDNN stack on z/OS:
      • Apply OA64843 and OA66165 for z/OS 3.1 (HZAI310).
      • Apply OA64842 and OA66166 for z/OS 2.5 (HZAI250).
      • Apply OA63949 and OA63951 for z/OS 2.4 (HBB77C0).
    2. For OpenBLAS on z/OS:
      • Apply PH56723 for z/OS 3.1 (HLE77E0)
      • Apply PH49807 and PH50872 for both z/OS 2.5 and z/OS 2.4 (HTV77C0).
      • Apply PH50881 for z/OS 2.5 (HLE77D0).
      • Apply PH50880 for z/OS 2.4 (HLE77C0).
    3. For Db2 13 for z/OS, apply PH60870.
    4. For SQL Data Insights 1.1.1 (HDBDD18), apply PH60780 and PH60781.
  2. Verify that your SQL DI is successfully upgraded by completing some quick tasks as described in Verifying the installation and configuration of SQL DI.