Results 1 to 5 of 5

Thread: db2 Error msg

  1. #1
    Join Date
    Apr 2007
    Posts
    26

    Unanswered: db2 Error msg

    I got this error while running a query which is so long that i cant paste here.The error is as follows " SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "bad outer compare".) SQLSTATE=58004 ". I am running the same query with a friend and surprisingly the query runs at her machine. I am using DB2 v7 in a windows platform. What could the issue be? Coz it seems that the issue is not with the query.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What version of DB2 is your friend using?

    Andy

  3. #3
    Join Date
    Apr 2007
    Posts
    26
    same version of db2

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Is the query from each client going against the same or different DBs?

    Andy

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    SQL0901 are DB2-internal errors (bugs). Your only option is to contact IBM support and open a PMR to get this fixed.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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