IT20262: APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY

IT20262: APPLICATIONS FAIL WITH ERROR SQL30020N "0X124C"("0100") WHEN CONNECTING THROUGH A GATEWAY

https://www.ibm.com/mysupport/s/defect/aCI3p000000kFjD/dt158090?language=en_US

• Description

  If you have an application that connects to a DB2 server through
  a gateway, your application may fail with the following error if
  one of your query is interrupted by a SQLCancel().              
  SQL30020N Execution of the command or SQL statement failed      
  because of a                                                    
  syntax error in the communication data stream that will affect  
  the successful                                                  
  execution of subsequent commands and SQL statements: Reason Code
                                                                  
  "0x124C"("0100")"". SQLSTATE=58009                              
                                                                  
  In your db2diag.log, you can also see this error message :      
  FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReadDssHdr, 
  probe:20                                                        
  MESSAGE : ZRC=0x8036008D=-2143944563=SQLJC_ERROR_SYNTAX "SYNTAX
  ERROR"                                                          
                                                                  
                                                                  
  This error happens when DRDA layer sends two buffers to IPC but 
  only one is received after the client interrupts the connection 
  while waiting a reply from the server.                          
                                                                  
  Show less

• Problem summary

   

  ****************************************************************

  * USERS AFFECTED:                                              *

  * ALL                                                          *

  ****************************************************************

  * PROBLEM DESCRIPTION:                                         *

  * See Error Description                                        *

  ****************************************************************

  * RECOMMENDATION:                                              *

  * Upgrade to Db2 10.5 Fix Pack 9 or higher                     *

  ****************************************************************

   

• Problem conclusion

  First fixed in Db2 10.5 Fix Pack 9                              

• Temporary workaround

  Connect your application directly to your DB2 server.           

   

   

  Status

  Closed

  Programming Error - Fix provided (PER)

  A fix is available

  DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and WindowsDB2 Version 10.5 Fix Pack 11 for Linux, UNIX, and WindowsDB2 Version 10.5 Fix Pack 10 for Linux, UNIX, and Windows

  Fixed Version(s) :

  Subscribe

  By subscribing, you receive periodic emails alerting you to the status of the known issue, along with a link to the fix after it becomes available.

  Notify me when a known issue for this product changes

  SubscribeManage my notifications

  • Document information

    Product

    Db2 Linux, Unix and Windows

    Software version

    10.5

    Document number

    DT158090

    Last modified

    2023年8月24日 GMT+8 18:50

  • Known Issue Information

    APAR Number

    IT20262

    Reported component id

    DB2FORLUW

    Reported component release

    A50

    Status

    Closed

    PTF in error

    NoPE

    HIPER:

    NoHIPER

    Special attention

    NoSpecatt

    -Product Specific

    Submitted date:

    2017年4月19日 GMT+8 11:00

    Closed date:

    2017年9月29日 GMT+8 11:00

    Last modified date:

    2023年8月24日 GMT+8 18:50

     

     

    ------------------------------------------------------------------------------------------
    如果你觉得文章有用，欢迎打赏