Setting Transaction Log Properties

The Transaction Log tab of the StarSQL Resource Manager Properties dialog allows you to specify the location and name of the transaction log file and to set the maximum number of transactions that are logged at one time.

The default location for the transaction log file is C:\Documents and Settings\All Users\Application Data\StarQuest\StarSQL\2PC\trans.log. To specify a different location or filename, enter the fully qualified pathname in the Transaction Log File text box.

In the Maximum Number of Transactions text box, enter the maximum number of indoubt transaction that can be recorded in the transaction log at one time. Enter 0 (zero) for the maximum number if you do not want to limit the number of indoubt transactions that can be logged at one time.

If you change any of the Resource Manager properties, you must restart the service for the new properties to take affect.