Installing Db2 maintenance to enable Db2 Data Gate

Db2 Data Gate 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, Db2 Data Gate 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:

Db2 APAR PH00574
Important:
Make sure to apply both fixes, PH00574 and PH10672. Errors might occur if only one of these fixes is applied.
Db2 APAR PH00933
Db2 APAR PH06628
Db2 APAR PH10672
See the Important note under APAR PH00754 in this list. It also applies to this APAR fix.
Db2 APAR PH13109
Db2 APAR PH19181
Db2 APAR PH19886
Db2 APAR PH20587
Db2 APAR PH21187
Db2 APAR PH21419
Db2 APAR PH23895
Db2 APAR PH28849
Db2 APAR PH29443
Db2 APAR PH30397
Db2 APAR PH30783
Db2 APAR PH35805
Db2 APAR PH37808
Db2 APAR PH40261
Db2 APAR PH53700
Db2 APAR PI91620
Db2 APAR PI96258

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. Together, these fixes solve the following issue: "Queries running on Db2 for z/OS are unexpectedly executed on IBM Db2 Analytics Accelerator if QUERY ACCELERATION has been set to 'ENABLE' or 'ENABLE WITH FAILBACK'. This especially happens if queries have index access on tables with multiple indexes defined. A more costly access path will be chosen resulting in an execution of the query on the accelerator".

Installation hint:

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

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.
Run the SMP/E command REPORT MISSINGFIX on your z/OS systems and specify:
```
FIXCAT (IBM.DB2.AnalyticsAccelerator.V7R1, IBM.DB2.AnalyticsAccelerator.V7R5)
```
Note: Db2 Data Gate and IBM® Db2 Analytics Accelerator require the same Db2 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 Db2 Data Gate.

Procedure

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