PK86139: SQLCODE246 IS RECIEVED FROM DB2 WHILE QMF IS DOING MULTI-ROW INSERT (MRI) STMT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running QMF 9.1, DB2 9.1 on zOS 1.10. SQLCODE246 from DB2
  is received, for a Multi-Row Insert (MRI) stmt and the
  defined host variable for the "N" value in the FOR N ROWS clause
  is NULL or negative.  QMF is doing a simple QMF SELECT query and
  a SAVE DATA.
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V8.1 and V9.1 users     *
  *                 that start QMF with MR=YES and use the SAVE  *
  *                 DATA command.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users that start QMF with the multi row *
  *                      fetch feature turned on (DSQSMRFI=YES   *
  *                      or MR=YES), issue the CONNECT command   *
  *                      to a remote DB2 for z/OS V8 or higher   *
  *                      database server and issue repeated SAVE *
  *                      DATA commands can possibly recieve      *
  *                      MSGDSQ10496 (DSQ10496),                 *
  *                      MSGDSQ10498 (DSQ10498) or MSGDSQ20005   *
  *                      (DSQ20005) including a SQL code -246    *
  *                      (SQLCODE246 or MSGDSN00246 or           *
  *                      DSN00246). The problem has only been    *
  *                      observed in a remote DRDA situation but *
  *                      could possibly happen in a local        *
  *                      situation as well.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The QMF multi row insert feature used in the SAVE DATA command
  processing was reusing SQLDA area from a previous insert which
  had not been cleared out. Because of this, invalid data appeared
  at the end of the SQLDA making it invalid and caused the SQL
  code -246.
  

Problem conclusion

• Module DSQISDT8, which controls the multi row insert feature of
  QMF, has been modified to clear out the SQLDA area prior to
  reuse.
  

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:

  UK46563 UK46562

Modules/Macros

• DSQESDT8 DSQFSDT8 DSQISDT8
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK46562

     UP09/05/15 P F905

• R910 PSY UK46563

     UP09/05/15 P F905

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.