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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM74007

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-28

  • Closed date

    2013-01-30

  • Last modified date

    2013-03-04

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM74007

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation