PM74007: INVALID DATA IN SQLCA WHEN DB2/Z IS ACTING AS A REQUESTER TO A REMOTE SERVER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA DB2SP defect pm74007 dpm74007
  A requester from a DB2/z system can get an SQLCA with invalid
  data even though the DRDA SQLCARD object returned from the
  server is correct. In the reported case, an SQL -444 error was
  detected, but in the SQLCA returned to the application, the
  first character in the SQLERRP field is overlaid with x'FF'.
  *************************************************************
  Additional Symptoms and Keywords:
   SQLCA SQLERRP and/or IFCID 53IFCID53 QW0053SQ field
   contains an erroneous FF FFX 'FF'X HEXFF as first character.
   SQLCODE -444 SQLCODE444 SQL444N SQL00444N SQLN444
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The first character of the SQLERRP      *
  *                      field in the SQLCA, or the first        *
  *                      character of the QW0053SQ field in the  *
  *                      IFCID 53 trace record, may contain an   *
  *                      invalid 'FF'x character after           *
  *                      executing a remote SQL statement.       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A DB2 for z/OS application connects to a remote server and
  calls a stored procedure. The remote server issues an SQLCODE
  -444 for the CALL request because the procedure could not be
  found. DB2 for z/OS, while parsing the DRDA SQLCARD object
  reflecting the SQLCODE -444 condition, overwrites the first
  character of the SQLCA SQLERRP field with an invalid 'FF'x.
   Note: This error can occur for any remote SQL statement where
    the SQLCA contains an SQLERRMT string that is 70-bytes long
    and character conversion is needed.
  

Problem conclusion

• DB2 for z/OS requester processing has been changed to handle
  the parsing of DRDA SQLCARD object correctly when conversion
  occurs.
  

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:

  UK91349 UK91350

Modules/Macros

•    DSNLZRCD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91349

     UP13/02/19 P F302

• R910 PSY UK91350

     UP13/02/19 P F302

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.