Recovering from a QMF query failure

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

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 to new-function mode after completion of an installation or migration to a new QMF release.

Diagnosing the problem

User response:

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.