Installing Db2 for z/OS maintenance to enable Data Gate on Cloud

Data Gate on Cloud supports different Db2 for z/OS versions. You have to install several program temporary fixes (PTFs) for the version that you use.

About this task

Currently, Data Gate on Cloud supports these versions of Db2 for z/OS:

  • Db2 for z/OS 13 (basic Function Level)
  • Db2 for z/OS 12, Function Level 505 or higher.
Note: The following lists of APAR fixes for Db2 for z/OS include links that take you directly to the APAR descriptions. These description pages provide you with a link to obtain the required PTFs from the IBM Shopz website. You can also search for particular APAR numbers from the IBM Shopz website.

Mandatory PTFs for Db2 for z/OS 13:

Recommended PTFs for Db2 for z/OS 13:

N/A

Mandatory PTFs for Db2 for z/OS 12:

Recommended PTFs for Db2 for z/OS 12:

Important:

Make sure to apply the fixes for both APARs, PH21726 and PH28050. You can apply these APAR fixes separately by using the FIXCAT keywords IDAAV5R1/K and IDAAV7R5/K.

Installation hint:

To install all required and recommended fixes, you can apply the latest fix category. To determine all Db2 for z/OS PTFs recommended for use with Data Gate on Cloud, use the SMP/E REPORT MISSINGFIX command in conjunction with FIXCAT HOLDDATA as follows:

  1. Acquire and RECEIVE the latest HOLDDATA file onto your z/OS system. Use your normal service acquisition portal or download the two (2) year HOLDDATA files here: Enhanced HOLDDATA for z/OS .

    Ensure you select 'FULL' from the Download NOW column (last 730 days) to receive the FIXCAT HOLDDATA, as the other files do not contain FIXCAT HOLDDATA.

  2. Run the SMP/E command REPORT MISSINGFIX on your z/OS systems and specify:
    FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1, IBM.DB2.AnalyticsAccelerator.V7R5)
    Note: Data Gate on Cloud and IBM Cloud® require the same Db2 for z/OS PTFs. Hence it is correct to specify FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1, IBM.DB2.AnalyticsAccelerator.V7R5).

    The report will identify missing PTFs associated with the categories on that system. For more information about the SMP/E command REPORT MISSINGFIX, see Example: Using REPORT MISSINGFIX.

The instructions work in much the same way for Data Gate on Cloud.

Procedure

Run SMP/E to apply the fixes. For each fix, follow the instructions on the IBM Shopz website.