IBM Z and LinuxONE IBM Z

Expand all | Collapse all

QMF SQL Error -805

  • 1.  QMF SQL Error -805

    Posted Wed July 21, 2021 11:09 AM
    Trying to run QMF from the PDF panels I get the error below. I assume DB2 BIND's need to be run but I don't know where to find the BIND job, etc. Any help would be appreciated.

     DSQ10205 DBRM not found for DSQISDB2 module in DBCG database.  SQLCODE returned
     was -805.

    Thanks,

    Benny Ormson



  • 2.  RE: QMF SQL Error -805

    Posted Thu July 22, 2021 03:41 PM
    You can try the following jobs.

    If QMFC10 is being used run these:
       A. HOLDDATA ACTIONS FOR QMFC10:
         1. Run 'DBCGUTIL.SVSC.QMFC10.SAMPLE(DSQ1EPNL)'
         2. Run 'DBCGUTIL.SVSC.QMFC10.SAMPLE(DSQ1BPKG)'

    If QMFC20 is being used run these:
      B. HOLDDATA ACTIONS FOR QMFC20:
         1. Run 'DBCGUTIL.SVSC.QMFC20.SAMPLE(DSQ1EPNL)'
         2. Run 'DBCGUTIL.SVSC.QMFC20.SAMPLE(DSQ1BPKG)'


    ------------------------------
    Regards
    Jianfu Wang
    Cognizant - TZUSA
    ------------------------------