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
The following table shows the maintenance levels available for the Stored Procedures
(the most current one is emphasized in yellow):
| PTF | APAR | Build label
(YYYYMMDD-xxxx) |
Supported maintenance levels | |||
| Accelerator | Data Gate for z/OS | Data Gate on cloud | Data Gate for watsonx | |||
| UI97750 | PH61845 | 20240711-0604 | 7.5.13 | 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 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.
- Stored procedure build label (as of Aug 28, 2024)
History of changes
28 August 2024:
- Additional information for UI97750: mentioning Stor Proc build label mismatches
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"ARM Category":[{"code":"a8m0z0000000775AAA","label":"Db2 related products and functions-\u003EDb2 Analytics Accelerator for z\/OS"},{"code":"a8m0z000000072oAAA","label":"Install and Migrate"}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.5.0"}]
Was this topic helpful?
Document Information
Modified date:
28 August 2024
UID
ibm17160295