PM38066: 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 users                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: ARI0856E The following SQL error        *
  *                      and/orwarning 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:                                              *
  ****************************************************************
  DRDA PROTOCOL ERROR  THAT CAUSED DEALLOCATION OF THE CONVERSATIO
  

Problem conclusion

Temporary fix

Comments

• To be resolved inn 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

• R5NN PSN

     UP