Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Schaumburg, IL
    Posts
    79

    Unanswered: Stored Procedure Crashing...

    We are working on UDB V7.1 (FixPack 3) and client version (fix pack 4).
    Some Stored Procedures just crash when called from db2spb or Java application.
    There is no fixed pattern, as when they crash, might be once in 10 times/20times or more than that.

    The number of parameters are 10
    out of which we have INT, CHAR & DATE datatypes.

    Did any one of you encountered this kind of a situation.

    Thanks
    Naveen Urs
    DBA Manager
    IBM Certified Solutions Expert - DB2 LUW V7, V9

  2. #2
    Join Date
    Apr 2003
    Location
    Trier, Germany
    Posts
    28

    Re: Stored Procedure Crashing...

    Hi,

    try to catch all conditions (e.g. using try ... catch in JAVA and C++) to figure out, if it is a DB2 problem or perhaps a bug in the stopro itself.


    Originally posted by urs_77
    We are working on UDB V7.1 (FixPack 3) and client version (fix pack 4).
    Some Stored Procedures just crash when called from db2spb or Java application.
    There is no fixed pattern, as when they crash, might be once in 10 times/20times or more than that.

    The number of parameters are 10
    out of which we have INT, CHAR & DATE datatypes.

    Did any one of you encountered this kind of a situation.

    Thanks

Posting Permissions

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