Results 1 to 4 of 4

Thread: db2batch error

  1. #1
    Join Date
    Nov 2007
    Posts
    27

    Unanswered: db2batch error

    db2v8.2 fp7 solaris

    when i am running a query using db2batch command i am getting the following error.
    SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code
    "". SQLSTATE=57033
    SQL0501N The cursor specified in a FETCH or CLOSE statement is not open.
    SQLSTATE=24501

    but when i run the same query by puting it in a file(i.e db2 -tvf i/p.sql > o/p.out) it runs fine.

    wat could be the possible reason for this difference?\

    any help would be appreciated
    thanks..

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have you tried it with the latest DB2 V8 FixPak? FP7 is rather old...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by stolze
    Have you tried it with the latest DB2 V8 FixPak? FP7 is rather old...
    That depends.

    It might be 8.1 FP7 or it might be 8.1 FP14 (which is the same as 8.2 FP 7).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jun 2009
    Posts
    1
    It might be 9.0

Posting Permissions

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