IBM Support

IC69477: UNIVERSAL JDBC TYPE 4 APPLICATION RECEIVES ERROR. A DRDA DATA STREAM SYNTAX ERROR WAS DETECTED. REASON: 0X2. ERRORCODE=-4499

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • V9.7 Fixpak 1 client running a JDBC Type 4 application receives
DRD Data Stream Syntax error. Reason: 0x2.  ERRORCODE=-4499,
SQLSTATE=58009.

This is a boundary condition which
only occurs when dealing with a large number of columns, input
or output, such that the length of the SQLDARD is exactly 65518
bytes. (Two DSS where the first DSS length is X'FFFF and the
second DSS length is X'7FFFF).

This problem occurs with a large number of columns, such that
the describe information for the columns expand exactly 2
complete, full drda blocks.


---- Begin backtrace for Nested Throwables

com.ibm.db2.jcc.am.uo: [jcc][t4][2034][11148][4.8.87] Execution
failed due to a distribution protocol error that caused
deallocation of the
conversation. A DRDA Data Stream Syntax Error was detected.
Reason: 0x2. ERRORCODE=-4499, SQLSTATE=58009
 at com.ibm.db2.jcc.am.gd.a(gd.java:317)
 at com.ibm.db2.jcc.am.gd.a(gd.java:365)
 at com.ibm.db2.jcc.t4.cb.l(cb.java:942)
 at com.ibm.db2.jcc.t4.cb.e(cb.java:324)
 at com.ibm.db2.jcc.t4.cb.d(cb.java:259)
 at com.ibm.db2.jcc.t4.fb.b(fb.java:2672)
 at com.ibm.db2.jcc.t4.fb.a(fb.java:2630)
 at com.ibm.db2.jcc.t4.fb.a(fb.java:172)
 at com.ibm.db2.jcc.t4.fb.b(fb.java:83)
 at com.ibm.db2.jcc.t4.t.b(t.java:69)
 at com.ibm.db2.jcc.t4.vb.c(vb.java:242)
 at com.ibm.db2.jcc.am.xm.mc(xm.java:2891)
 at com.ibm.db2.jcc.am.xm.pc(xm.java:2997)
 at com.ibm.db2.jcc.am.xm.vc(xm.java:3126)
 at com.ibm.db2.jcc.am.xm.a(xm.java:547)
 at com.ibm.db2.jcc.am.lb.a(lb.java:2183)
 at com.ibm.db2.jcc.am.lb.a(lb.java:2142)
 at com.ibm.db2.jcc.am.lb.prepareStatement(lb.java:1688)
 at com.ibm.db2.jcc.am.bf.prepareStatement(bf.java:243)
 at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(W
SJdbcConnection.java:2503)

Local fix

  • 



Problem summary


    

  • Fixed in DB2 V9.5 FP7 JDBC driver.

    



Problem conclusion


    

  • Upgrade DB2 JDBC driver to V9.5 FP7.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IC69477
    • 

  • Reported component name
    DB2 FOR LUW
    • 

  • Reported component ID
    DB2FORLUW
    • 

  • Reported release
    950
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-06-29
    • 

  • Closed date
    2014-03-26
    • 

  • Last modified date
    2014-03-26
    • 





    

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

    
IC69459
    

    • 

  • 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


    

  • R950  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            26 March 2014
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback