Hi,

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.
Anta

Need more informaiton about the program, type of SQL (dynamic, embedded, prepared, etc) and the DB2 interface used (CLI, SQLJ, java type 2, etc.).

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.
Anta