Release Notes
Abstract
This document describes enhancements and fixes for the Stored Procedures used by
- Db2 Analytics Accelerator for z/OS
- Data Gate for z/OS, Data Gate for watson x, and Data Gate on cloud
Content
Stored Procedure maintenance levels
| PTF | APAR | Build label (YYYYMMDD-xxxx) | Supported maintenance levels | |||
| Accelerator | Data Gate for z/OS | Data Gate on Cloud | Data Gate for watsonx | |||
| UO08580 | PH72047 | 20260717-1751 | 7.5.14.x | 3.1, 2.1, 1.1 | 1.1 | 1.1 |
| UO05997 | PH68669 | 20250901-1514 | 7.5.14.x | 3.1, 2.1, 1.1 | 1.1 | 1.1 |
| UO03065 | PH66192 | 20250411-0841 | 7.5.14.x | 3.1, 2.1, 1.1 | 1.1 | 1.1 |
| UI97750 | PH61845 | 20240711-0604 | 7.5.13.x | 3.1, 2.1, 1.1 | 1.1 | 1.1 |
| UI93729 | PH57138 | 20230921-0928 | 7.5.12.x | 3.1, 2.1, 1.1 | - | - |
| UI91200 | PH53602 | 20230302-1422 | 7.5.11.x | 2.1, 1.1 | - | - |
| UI83471 | PH51109 | 20220929-1324 | 7.5.10.x | 2.1, 1.1 | - | - |
| UI81778 | PH48263 | 20220622-1151 | 7.5.9.x | 1.1 | - | - |
| UI80135 | PH45639 | 20220315-1454 | 7.5.8.x | 1.1 | - | - |
| UI78158 | PH42174 | 20211118-1441 | 7.5.7.x | 1.1 | - | - |
APARs fixed with PTF UO08580 (Jul 21, 2026)
| APAR # | Known Issue # | APAR description | Comments |
| PH72047 | DT475189 | When activating Db2 13 function level M509 after installing Db2 for z/OS PTF UO07568 (APAR PH70028), the accelerator's stored procedure job AQTTIJSP skips the processing ("Create", "Grant", and others) of stored procedure-related Db2 objects. |
APARs fixed with PTF UO05997 (Nov 30, 2026)
| APAR # | Known Issue # | APAR description | Comments |
| PH68669 | DT454345 | The Accelerator Loader terminates due to a timeout caused by unavailable resources (DSNT501I with reason code 00C9008E). |
APARs fixed with PTF UO03065 (May 30, 2025)
| APAR # | Known Issue # | APAR description | Comments |
| PH62080 | DT390641 | Running Stored Procedure ACCEL_LOAD_TABLES triggers a RUNSTATS call which can block other batch jobs working with DB2 for z/OS. |
APARs fixed with PTF UI97750 (Aug 26, 2024)
| APAR # | Known Issue # | APAR description | Comments |
| PH56590 | DT237991 | The stored procedure ACCEL_GET_TABLES_INFO does not return the new parameters lastAccessTimestamp and accessCount by default. | |
| PH59258 | DT258897 | Installation sample job AQTSJI03 (a member of installation library SAQTSAMP) has got duplicate //SYSTSPRT DD SYSOUT=* DD statements in the job steps TESTCON, CONTRACC, SETACC, SETREPL, and RMTABLE. | |
| PH59459 | DT259707 | The Visual Explain button in Data Studio doesn't show the explain graph of an accelerated query. | |
| PH60506 | DT365099 | An Accelerator Loader job using HALOAD fails with message HLOS0202E "ERROR ENCOUNTERED DURING XML PARSING" |
Additional information (Aug 28, 2024)
Additional information concerning UI97750
Stored procedure build label (as of Aug 28, 2024)
Concerning the Stored Procedure build label, there is a mismatch between the one specified in closing information of PTF UI97750 and the one contained in the program code:
The Recommendation-section of PTF UI97750 mentions the build label 20240703-1426: "...After installation of this PTF, the stored procedure build label expected to be seen is: 20240703-1426..." However, after installation of UI97750, both Data Studio and Admin Foundation show the build label 20240711-0604 which is the correct one.
Both the APAR PI61845 and the Accelerator V7.5 prereq web page have been updated to show the correct build label.
History of changes
29 July 2026:
- Added PH68669 (UO05997)
22 July 2026:
- Added PH72047 (UO08580)
28 August 2024:
- Additional information for UI97750: mentioning Stor Proc build label mismatches
Was this topic helpful?
Document Information
Modified date:
29 July 2026
UID
ibm17160295