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 <database> element attributes specified in file database-config.xml or lists the default value if file database-config.xml does not specify a value.

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 <upgrade> element in file database-config.xml.

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 auto create statistics and auto update statistics, the recovery model, collation, and so forth.

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.