The Database Parameters screen
The Server Tools Database Parameters screen displays information about the database configuration. You can view the information on-screen, or you can download a set of linked HTML reports that contain the same information.
To download and access the HTML reports, click Download Database Parameters Info, unzip the resulting file, and click index.html.
To view the information on-screen, select a view type from the View drop-down list. Depending on the database type, the View list contains the following items.
View |
Lists |
|---|---|
Database and Driver |
Versions of the database and its associated driver. |
Database Connection Pool Settings |
Connection pool settings as configured in database-config.xml if using PolicyCenter to manage the connection pool. See The <dbcp-connection-pool> database configuration element for more information on these parameters. If you use the application server to manage the connection pool, then this screen does not show connection pool parameters. Instead, tune the connection pool by using the Administrative Console of the application server. |
Database Connection Properties |
Properties related to the database connection. |
Guidewire Database Config |
Guidewire-specific database configuration parameters. The table lists the |
Guidewire Database Config Statistics Settings |
Guidewire-specific database configuration parameters related to statistics gathering. |
Guidewire Database Upgrade Configuration |
Guidewire-specific database configuration parameters related to upgrade as defined by the |
Guidewire Version |
Information about this specific version of PolicyCenter. |
Linguistic Search Options |
Options defined for linguistic searching in PolicyCenter. See Linguistic search and sort for more information. |
Linguistic Search Oracle Functions and Java Source |
Oracle functions, and Java source, for linguistic searching. |
Oracle DB Options and Features |
Oracle database options. |
Oracle DBA Auto Tasks |
Automated tasks defined for the Oracle database. |
Oracle DBA Scheduler Jobs |
Scheduled jobs for the Oracle database. |
Oracle NLS Instance Params |
Oracle database NLS (National Language Support) options. |
Oracle NLS Session Params |
Oracle database NLS (National Language Support) options. |
Oracle Patch History |
Patches applied to this Oracle database. |
Oracle Permanent NLS DB Params |
Oracle database NLS (National Language Support) options. |
Oracle Registry |
Oracle registry values. |
Oracle Session Init Params |
Initial parameters of the Oracle session for the current connection with PolicyCenter. |
Oracle SGA Summary Info |
Information about the Oracle System Global Area (SGA) shared memory. |
Oracle State of Current Instance |
Information on the current Oracle instance connected to PolicyCenter. |
Oracle System Statistics |
Information on Oracle database statistics. |
Queries Executed to Build Download |
SQL queries used to generate the information in the HTML download reports. |
SQL Server Database Options |
Options set on the SQL Server database, such as |
SQL Server Server Global Server Settings |
Global server settings for the SQL Server instance. |
SQL Server Server Instance Attributes and Values |
Attributes and values for the SQL Server instance connected to PolicyCenter. |
SQL Server Session Properties |
Properties of the SQL Server session for the current connection with PolicyCenter. |
Summary of Queries Executed to Build Download |
Number of queries used, and the execution time, to generate the information in the HTML download reports. |
