Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    Unhappy Unanswered: Fetching data fails on

    Hi there,

    I've been searching the net for possible solutions or even the cause of the following problem:

    Unfortunately the SQL Message is not being displayed.

    The only thing that I could find is that REORG needs to be run on the respective table. Does anyone else have another suggestion?

  2. #2
    Join Date
    Jun 2006


    can you speify, when and where these messages are produced -
    starting the connection / connection pool - starting the application
    specific statement for application
    in an application, always print out the sqlca if error occured.
    check log if application server is involved...
    specify a bit of detail, so we don't have to guess what is going on..
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2006
    Hi there, and thanks for the reply.

    The error occurs on a specific statement.

    Unfortunately, this error is happening in a production system, and the sqlca is not being printed.
    I've deployed a change to the system last night to get the error code.

    I've run a REORG on the table that I thought was causing the problem, but it doesn't seem to have helped.

    Furthermore, the error is intermittent.

    Will try to get more detail...

    Thanks again...

Posting Permissions

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