Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    1

    Unanswered: Problem in DB2 StoreProc

    Hi All,

    I am calling a java method from a DB2 storedproc and I am using MQ API with in that java method it is giving exception as follows:

    ------------------------------ Commands Entered ------------------------------
    CALL SELECT_PROC3(1);
    ------------------------------------------------------------------------------
    CALL SELECT_PROC3(1)
    SQL4302N Procedure or user-defined function "DB2ADMIN.SELECT_PROC3", specific
    name "SELECT3" aborted with an exception "com/ibm/mq/MQEnvironment".
    SQLSTATE=38501

    SQL4302N Procedure or user-defined function "DB2ADMIN.SELECT_PROC3", specific name "SELECT3"
    aborted with an exception "com/ibm/mq/MQEnvironment ".

    Explanation:

    The procedure or user-defined function aborted with an exception.
    The administration notification log contains a stack traceback
    for the aborted routine.

    User Response:

    Debug the routine to eliminate the exception.

    sqlcode : -4302

    sqlstate : 38501


    Can some one help me to resolve the issue.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    or build the sp with debug option and call a java debugger
    or add code to intercept the exception and print some relevant data when the error occures
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •