Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2010
    Posts
    10

    Unanswered: Stored procedure failure in production region with SQL0969N error, SQLSTATE = -30108

    Hi,

    One of our stored procedure is failing again and again in production region with error code SQL0969N and SQLSTATE -30108.
    The description of this error on IBM site is as follows:
    "There is no message text corresponding to SQL error in the message file on this workstation. The error was returned from module name with original tokens token-list."

    Since, this stored procedure is failing in production region, many users are impacted due to this.
    Appreciate if anyone can suggest a way to resolve this error.
    If more details are required, kindly let me know.

    Regards,
    Upendra

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    db2 version? platform? it a sql stored proc?

    do you know which part of the procedure is causing the error ?

    have you tested it on a dev/test environment?

    do you have error handling in the stored procedure ?

    these are few of the things we need to know .. the more the better ..

    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    BTW, are you sure 30108 is SQLSTATE ? can you post the error as you get from db2/message file ?


    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Dec 2010
    Posts
    10
    Hi Sathyaram,

    First of all, thanks for your quick response on this.
    1) db2 version? platform? it a sql stored proc?
    ===> Version 9 Release 1. It is external stored procedure having COBOL as host language. I am not sure how to check platform though.

    2) do you know which part of the procedure is causing the error ?
    ===> No idea! What is the way to identify this? If you refer to the attached screenprint, it shows the error was returned from module SQLJRCRT. But I am not sure which part of stored procedure throws this error.

    3) have you tested it on a dev/test environment?
    ===> Yes. We have tested it in test region many times before implementation. But in test region we did not face this error as data is not huge.

    4) do you have error handling in the stored procedure ?
    ===> No. We only check SQLCODE after executing any query.

    5) Regarding SQLSTATE. Sorry, I think this is not SQLSTATE. Please find attached screenprint. Apologize for this.
    Attached Thumbnails Attached Thumbnails GDSP0099.969.ERROR.JPG  

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I guess this is DB2 9.1 on zOS. The -30108 is a SQLCODE which is used when client rerouting is setup. In the context of zos, this is likely to be sysplex config.

    Have you spoken with you dba or system dba ?


    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Did you check the WLM log sysout in spool? That gives an idea to look further into debug.

Posting Permissions

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