IBM Support

IT02729: WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When AUTHENTICATION on the database server is set to
    DATA_ENCRYPT, any data transferred between the server and the
    client is encrypted.
    
    It was found that, with DATA_ENCRYPT DB2 LUW client sometimes
    fails to parse the query result, and returns SQL0902C.
    
    db2diag.log:
    
    2014-06-12-02.47.07.163620+120 I2928367A587         LEVEL: Error
    PID     : 13107552             TID : 1              PROC : db2bp
    INSTANCE: db2inst1             NODE : 019           DB   :
    SAMPLE
    APPID   : *N22.db2inst1.140612004707
    HOSTNAME: Q4DE8PSAZDV
    EDUID   : 1
    FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca,
    probe:2356
    MESSAGE : SQL0902C  A system error occurred. Subsequent SQL
    statements cannot
              be processed. IBM software support reason code: "9".
    DATA #1 : String, 12 bytes
    
    This issue is incomplete fix for IC91371.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 LUW v10.5 Fixpack 4 or Higher.                *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 LUW v10.5 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02729

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-23

  • Closed date

    2014-09-15

  • Last modified date

    2014-09-15

  • APAR is sysrouted FROM one or more of the following:

    IT02727

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.5

Reference #: IT02729

Modified date: 15 September 2014