If you are using Transaction mode, AQT will do a Commit prior to disconnecting. If you change this option during an AQT session, the value will come into effect immediately except when changing it from zero to a non-zero amount (this will only come into effect the next time you sign onto a database). Setting the period to zero will disable this feature (sessions will not time out). You specify the disconnect period in minutes.

Your system administrator may ask you to set this option, as it will prevent idle connections from holding resources on your database server. When this option is specified, AQT will automatically terminate a database connection if you have not used it for the specified period. Uncommitted Read is not available on all databases, and if that is the case Uncommitted Read will be ignored if specified. In this type of environment, it is recommended that Uncommitted Read is used. UnCommitted Read means you see rows even if they have not been committed.įor some databases (such as DB2), when Committed Read is used, a query will take “read locks” and can hang while running against a table which is being updated. Committed Read (the default) means you see only rows that have been committed. This parameter is relevant only if you are querying a table that is being updated at the same time you are running queries.

This is a technical parameter that specifies how your queries interact with other transactions being run on your database server. Options - Technical Parameters Uncommitted Read

Change odbc timeout