A fix is available
APAR status
Closed as program error.
Error description
ABENDS0C4 in DSQGPRTT when user tries to DISPLAY or CONVERT a QMF Prompted Query query that references one or more temporal tables that do not exist.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS users who use * * Prompted Query. * **************************************************************** * PROBLEM DESCRIPTION: ABENDS0C4 can occur when users use a * * query that was created using QMF's * * Prompted Query feature and references * * temporal tables that do not exist in * * the DB2 subsystem in which QMF is * * running. * **************************************************************** * RECOMMENDATION: * **************************************************************** If a PQ query references multiple DB2 temporal tables, and the last table referenced exists but any one of the earlier referenced tables does not exist, QMF incorrectly builds a linked list of those tables. The pointer to the last table in the linked list is 00000000. This will result in an ABENDS0C4 during the processing of the query.
Problem conclusion
Code was amended to reject the use of PQ queries that reference invalid temporal table names.
Temporary fix
Comments
APAR Information
APAR number
PI54680
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-12-28
Closed date
2016-01-11
Last modified date
2016-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI34359
Modules/Macros
DSQGPRIL
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RB10 PSY UI34359
UP16/01/13 P F601
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 February 2016