I have the following problem:
my appllication invoke a procedure via stored procedure that insert in a table a certain number of records.
If the application stopped during execution, records not committed are locked and another application can't use them.
I have to stopped DB2 and restart it.
There are some operation or paramenters that I have to use to avoid this problem?
Thank you.
my appllication invoke a procedure via stored procedure that insert in a table a certain number of records.
If the application stopped during execution, records not committed are locked and another application can't use them.
I have to stopped DB2 and restart it.
There are some operation or paramenters that I have to use to avoid this problem?
Thank you.