Recovering from a QMF query failure

Start of change Receipt of a -805 SQL code in a Db2 for z/OS® environment that includes Db2 Query Management Facility (QMF) might occur after you start QMF or issue a QMF command. If the Db2 subsystem was recently migrated to a new release, you might need to rerun certain QMF installation jobs. End of change

Symptoms

One of the following QMF messages is issued:

DSQ10202
DSQ10205
DSQ11205
DSQ12105
DSQ13005
DSQ14152
DSQ14153
DSQ14154
DSQ15805
DSQ16805
DSQ17805
DSQ22889
DSQ30805
DSQ31805
DSQ32029
DSQ35805
DSQ36805

Causes

Key QMF installation jobs were not run.

Environment

The Db2 for z/OS subsystem was migrated to a new release or migration to a new release of QMF. End of change

Diagnosing the problem

User response:

If your Db2 for z/OS subsystem was recently migrated to a new release, continue with "Resolving the problem."
If your Db2 for z/OS subsystem was not recently migrated, see other possible causes of the DSQxxxxx messages in Troubleshooting and correcting QMF bind problems associated with a -805 SQL code.

Resolving the problem

User response: Rerun QMF installation jobs as described in Tasks to perform when you upgrade Db2 for z/OS after you install QMF.