A fix is available
APAR status
Closed as program error.
Error description
QMF hangs. The DB2 Master log shows the following messages over and over DSN3201I -DST2 ABNORMAL EOT IN PROGRESS FOR CONNECTION-ID=DB2CALL CORRELATION-ID=iiiiii The QMF DSQDEBUG trace shows something like the following. - During QMF initialization, - QMF tries to execute a PREPARE of the statement then DB2 returns ABEND04E - QMF tries to recover from the abend by reconnecting, QMF reconnects and then goes to run the same SQL abends, ....reconnects..abends ... over and over. (getting the same abend04E over and over on the same SQL).
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS users. * **************************************************************** * PROBLEM DESCRIPTION: QMF can loop during initialization if a * * database abend occurs during server * * initialization. During the loop, the * * user can see the database abending * * repeatedly as QMF executes the * * same SQL to the database that causes * * the abend. No QMF messages are * * issued, but the session indicator on * * the emulator's Operator Information * * Area indicates the keyboard is locked, * * as QMF tries to initialize. * **************************************************************** * RECOMMENDATION: * **************************************************************** During certain segments of QMF server initialization, QMF error logic was not recovering properly from fatal errors (such as the database's abending). QMF tried to recover and reconnect and had no logic to stop the reconnect process during initialization.
Problem conclusion
QMF initialization has been corrected to exit if a database abend is encountered on the first attempt to connect to the server.
Temporary fix
Comments
ž**** PE14/07/16 FIX IN ERROR. SEE APAR PI22135 FOR DESCRIPTION
APAR Information
APAR number
PM98142
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-09-30
Closed date
2013-10-29
Last modified date
2014-07-28
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI11864 UI11865
Modules/Macros
DSQIDOPT DSQIELI DSQISDB
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
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:
28 July 2014