A fix is available
APAR status
Closed as program error.
Error description
INCORRECT HANDLING OF SQL CODE -805 CONDITION IN QMF
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All QMF for TSO/CICS V10.1 users starting in * * a DB2 for z/OS V8.1 data base. * **************************************************************** * PROBLEM DESCRIPTION: Users invoking QMF in a DB2 for z/OS * * V8.1 data base may experience missing * * home panel information or get message * * DSQ20946 'You have no more storage * * space.' when running QMF queries. * **************************************************************** * RECOMMENDATION: * **************************************************************** For the problem reported in this APAR, QMF initialization had encountered a SQL code -805 (missing data base package) error for package DSQGSDB2. QMF did not properly recover from that SQL code -805 error and instead of terminating, it continued to initialize. Because QMF had errors during initialization, it could not execute properly and various error symptoms were reported. QMF needs to terminate the initialization process when it encounters a SQL code -805 for DSQGSDB2 (or any QMF runtime package) and report the error to the end user.
Problem conclusion
If QMF encounters an SQL code -805 for package DSQGSDB2 during initialization, it will terminate and issue the message: DSQ10204 'DBRM not found for DSQISDB2 module in xxxx database. SQLCODE returned was -805.' QMF administrators will need to run QMF1010.SDSQSAPE(DSQ1BPKG) to bind the QMF application packages to fix this problem. MSGDSQ10204
Temporary fix
Comments
APAR Information
APAR number
PM71065
Reported component name
QMF-QUERY MGMT
Reported component ID
566872101
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-08-16
Closed date
2012-08-23
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81281
Modules/Macros
DSQCRSNC DSQGSDB2 DSQISDB2
Fix information
Fixed component name
QMF-QUERY MGMT
Fixed component ID
566872101
Applicable component levels
RA10 PSY UK81281
UP12/08/24 P F208
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":"10.1.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
05 September 2012