An important consideration is the usage of COMMIT/CONNECT statements to maximize performance and limit LOCKING and resource use.

Two design CONSIDERATIONS that should be taken care are:

Long running connections – if these are NOT ACCEPTABLE then the application should connect to the database only when necessary. If acceptable then COMMITs should be issued as OFTEN as possible so that the changes do in fact occur. More importantly COMMITs should be issued to release any locks placed on DB entities as a result of statements executed during the transaction.

Settrans/Settransobject function – if the application functionality requires connections to be kept open and issue periodic COMMITs then Settransobject () should be used or use Settrans () for many short-lived transactions.

An important consideration is the usage of COMMIT/CONNECT statements to maximize performance and limit locking and resource use.

Two design considerations that should be taken care are:

Long running connections – if these are NOT acceptable then the application should connect to the database only when necessary. If acceptable then COMMITs should be issued as often as possible so that the changes do in fact occur. More importantly COMMITs should be issued to release any locks placed on DB entities as a result of statements executed during the transaction.

Settrans/Settransobject function – if the application functionality requires connections to be kept open and issue periodic COMMITs then Settransobject () should be used or use Settrans () for many short-lived transactions.