Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Question Unanswered: autocommit problem in db2 v8


    sorry for bothering, but maybe someone can help me please.

    I faced the problem:
    there are some programs which do not contain COMMIT or CONNECT RESET.
    They worked fine with db2 v7.
    After upgrading to db2 v8 the changes in db2 tables made by these programs are not commited automatically.
    As I can see - autocommit option was set to ON.

    Does some other solution exist that can allow not to change the existing programs?

    db2 server is on aix.

    Thanks in advance.

  2. #2
    Join Date
    May 2003
    Need more informaiton about the program, type of SQL (dynamic, embedded, prepared, etc) and the DB2 interface used (CLI, SQLJ, java type 2, etc.).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Nov 2004
    Thank you, Markus. The progams contain embedded SQL (static, as a rule), some of them contains dynamic sql, too. They were written in C++, compiled and called from aix telnet sessions. Their first action is connection to db2.

Posting Permissions

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