The Global Schema is the structure of the Content System database. It is a database that is separate from the document store databases, and controls connections and information to each of the document stores. The Global Schema Settings page allows the Administrator to modify the settings for database connection times and the size of the connection pool.
Please refer to the JDBC Settings section for a description of connection pools. The Global Schema requires its own pool of connections, and consumes significantly less connections than each document store.
Follow these steps to open the Global Schema Settings page.
Open the Administrator Panel.
Select Technical Settings under Content System. The Technical Settings page will appear.
Click Global Schema Settings.
The following fields are available on the Global Schema Settings page.
|
Field |
Description |
|
Global Schema Settings |
|
|
Dead connection timeout |
Enter the number of seconds before a ‘dead’ connection will time out and be removed from the pool. A dead connection is one that is not sending any activity between the database and the Blackboard Content System.
|
|
Live connection expiration |
Occasionally, a connection will remain open but unusable. This is sometimes referred to a “hung java connection”, and although the connection is not useable, it is not a dead connection. Automatically expiring all live open connections ensures that hung connections eventually close. Enter the number of minutes a database connection will remain open before the system automatically closes it. New connections are created dynamically when needed, up to the Maximum Connections setting (below). |
|
Maximum size of connection pool |
Enter the maximum number of connections that can exist in the connection pool. If this number is too high, performance may decrease because the database server consumes more resources. If it is too low, requests may take longer to process because they might wait in a queue until a connection becomes available. |
|
Minimum size of connection pool |
Enter the minimum size of the connection pool. Because the number of connections to the Global Schema is typically small, the default of 2 is adequate for most institutions. |