Transaction help

Posted in 1995

John C. Sinues — 10 Mar 1995 20:28:44 GMT — source: Informix-list mailing list archive (1991-1998)

In the Informix OnLine v5.0 Administrator's Guide, p. 1-32, it states: The minimum value of TRANSACTIONS is the value of USERS. The maximum value is the number of transactions that can fit into a checkpoint record, which for Online 5.0 is 1,364. Two questions: 1. Does this mean when you start a transaction with "BEGIN WORK" that you can only have 1,364 statements within the BEGIN WORK and COMMIT/ROLLBACK WORK statements? 2. What will Informix do if there are more then 1,364 statements within a transaction? ============================================================================ _/_/_/_/ _/_/_/_/ _/_/_/_/ John C. Sinues _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Inc. _/_/_/_/ _/_/_/_/ _/ eMail: sinues@prc.prc.mrms.navy.mil _/ _/ _/ _/ Phone: (804) 498-5666 _/ _/ _/ _/_/_/_/ Fax: (804) 498-5670 ======================================= | "...life is robust and meant to be | lived, joyfully...but not perfectly- | except by accident." ============================================================================