Database Connection

This set of governors can be set by modifying a project source's database instance and then modifying either the number of Job Prioritization connections or the Database connection. For more details on each governor, see the page references in the table below.

ODBC Settings

Governor	Description	See page
Number of database connection threads	The total number of High, Medium, and Low database connections that are allowed at a time between Intelligence Server and the data warehouse (set on the database instance's Job Prioritization tab).	Manage Database Connection Threads
Maximum cancel attempt time (sec)	The maximum amount of time that the Query Engine waits for a successful attempt to cancel a query.	Manage Database Connection Threads
Maximum query execution time (sec)	The maximum amount of time that a single pass of SQL may execute on the data warehouse.	Manage Database Connection Threads
Maximum connection attempt time (sec)	The maximum amount of time that Intelligence Server waits to connect to the data warehouse.	Manage Database Connection Threads

Database Connection Caching

Governor	Description	See page
Connection lifetime (sec)	The amount of time that an active database connection thread remains open and cached on Intelligence Server.	Manage Database Connection Threads
Connection idle timeout (sec)	The amount of time that an inactive database connection thread remains cached until it is terminated.	Manage Database Connection Threads