Transactions per system

There's a limit of 63 read/write transactions per system. The following activities count against the transaction limit:

• Using a BEGIN statement or starting a transaction through ODBC, not followed by SET TRANSACTION READ ONLY, even if you have not submitted a query
• UPDATES, DELETES, and INSERTS, even if they have not begun execution
• An update that has not finished rolling back or is being recovered after a restart counts against the limit until the rollback completes
• Loading data with the nzload command

The following activities do not count against the read/write transaction limit:

• Committed transactions
• Transactions that have finished rolling back
• SELECT statements that are not inside a multi-statement transaction
• Transactions that create or modify temporary tables only, or modify only tables that are created within the same transaction (for example, CREATE TABLE …AS SELECT…)
• Multi-statement read-only transactions (BEGIN …SET TRANSACTION READ ONLY)