User Template Parameters

The following are the available user template parameters.

  • Set transaction timeout in seconds for transactions created in a user session using transaction.timeout. This value can be set for a specific session. The default is 300 seconds. For example,
    transaction.timeout=300

  • Set whether the transaction commit log for a user or session should be flushed to disk on commit using transaction.flush_log_on_commit. This improves performance at a cost of possibly losing commited transations that may not be saved in the log. For example,
    transaction.flush_log_on_commit=true

  • To temporarily turn off IDENTITY inserts, set whether identity values should be inserted for identity columns while adding tuples to a table. This is controlled for the user session, unless it is set in DbPrefs (not advisable), in which case it is always off. The default is true. To turn off set template_parameter tuple.insert_identity to false. Don't forget to turn it back to true when required. For example,
    tuple.insert_identity=false

  • Set the default users directory (for server users), in the default.tpl. For example,
    users.dir=/home/users

  • You can set the default directory for individual user by defining user.dir. For example,
    user.dir=/home/serveradmin