PM71065: INCORRECT HANDLING OF SQL CODE -805 CONDITION IN QMF

Obtain the fix for this APAR.

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 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.