PM36925: RA - DRDA PROTOCOL ERROR THAT CAUSED DEALLOCATION OF THE CONVERSATION

APAR status

• Closed as fixed if next.

Error description

• ARI0503E An SQL error has occurred.
  
           Execution failed because of a DRDA protocol error
           that caused deallocation of the conversation.
           Reason Code = X'124C'(X'0104')
  
  the open will work with
  EXEC SQL DECLARE C4 CURSOR FOR
    SELECT * FROM IN_TRAY
        , (SELECT CURRENT DATE - 13 DAYS AS CHECK_DATE
           FROM SYSIBM.SYSDUMMY1) AS T
    WHERE  DATE(RECEIVED) = T.CHECK_DATE - 2 MONTHS
    FETCH FIRST 26   ROWS ONLY
  
  and fails with 27 rows.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for VSE v7.5 Client Edition users    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ARI0856E The following SQL error and/or *
  *                      warning conditions occurred for a       *
  *                      DBS-initiated SQL SELECT CURSOR OPEN    *
  *                      statement.                              *
  *                                                              *
  *                      ARI0503E An SQL error has occurred.     *
  *                               Execution failed because of    *
  *                               a DRDA protocol error that     *
  *                               caused deallocation            *
  *                               of the conversation.           *
  *                               Reason Code = X'124C'(X'0104') *
  *                      ARI0505I SQLCODE = -30020 SQLSTATE =    *
  *                               58009 ROWCOUNT = 0             *
  *                                                              *
  *                      ARI0504I SQLERRP: ARITPDE SQLERRD1:     *
  *                              -100 SQLERRD2: 0                *
  *                                                              *
  *                                                              *
  *                      This is the DBSU utility statements:    *
  *                      // JOB     ARIDBS                       *
  *                      // EXEC    PGM=ARIDBS,SIZE=AUTO         *
  *                      CONNECT FJSWARBR IDENTIFIED BY ******** *
  *                      SELECT CIF_NUMBER, REQUEST_DATE         *
  *                      FROM   NEW_ACCTS.CUSTOMER_FMP_INFO      *
  *                      WHERE  REQUEST_DATE > CURRENT TIMESTAMP *
  *                             - 13 MONTHS                      *
  *                         AND REQUEST_DATE < CURRENT TIMESTAMP *
  *                                                              *
  *                      The CURRENT TIMESTAMP (July 31, 2009)   *
  *                      - 13 MONTHS is being interpreted as Jun *
  *                       31, 2008, which is invalid             *
  ****************************************************************
  * RECOMMENDATION: None                                         *
  ****************************************************************
  DRDA PROTOCOL ERROR  THAT CAUSED DEALLOCATION OF THE
  CONVERSATION
  

Problem conclusion

Temporary fix

Comments

• To be resolved in a future release
  

APAR Information

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

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

Fix information

Applicable component levels

• R5NC PSN

     UP