Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

JDBC Module: Control

Buttons     Column Display     Related Tasks     Related Topics

Use this page to manually control each instance of this JDBC module.

Buttons

Name Description
Shrink

Shrinks the database connection pool in the data source to either the current number of reserved connections or the initial size of the connection pool, which ever is greater.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.shrink

Reset

Resets the connection pool in the data source by shutting down and recreating all available database connections in the pool.

Use when a data source is in the health state of Unhealthy and needs to be reinitialized.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.reset

Clear Statement Cache

For each connection in the connection pool, clears the statement cache of Prepared and Callable Statements.

MBean Attribute:
JDBCDataSourceRuntimeMBean.clearStatementCache

Suspend

Suspends a data source has the health state of Running and disables existing connections. If any connections from the data source are currently in use, the operation fails and the health state remains Running.

If successful, the health state is set to Suspended.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.suspend

Force Suspend

Suspends a data source that has the health state of Running, including disconnecting all current connection users. All current connections are closed and recreated.

If successful, the health state is set to Suspended.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.forceSuspend

Resume

Restores all access to and operations on a data source that has a health state of Suspended.

If successful, the health state is set to Running.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.resume

Shut Down

Shuts down a data source that has a health state of Running. If any connections from the data source are currently in use, the operation fails and the health state remains Running.

If successful, the health state is set to Shutdown.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.shutdown

Force Shut Down

Shuts down a data source that has a health state of Running, including forcing the disconnection of all current connection users.

If successful, the health state is set to Shutdown.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.forceShutdown

Start

Starts a data source that has a health state of Shutdown.

If successful, the health state is set to Running.

This is a privileged operation that can only be invoked by an authorized user.

MBean Attribute:
JDBCDataSourceRuntimeMBean.start

Column Display

You can show fewer or additional data points on this page by expanding Customize this table and modifying the Column Display list. Each data point displays in its own table column.

The following table lists all of the data points that you can display in columns on this page.

Name Description
Server Name

The server on which the data source instance is deployed.

State

The current state of the data source.

Possible states are:

  • Running

    - the data source is enabled (deployed and not Suspended). This is the normal state of the data source.

  • Suspended

    - the data source has been manually disabled.

  • Shutdown

    - the data source is shutdown and all database connections have been closed.

  • Overloaded

    - all resources in pool are in use.

  • Unhealthy

    - all connections are unavailable (not because they are in use). This state occurs if the database server is unavailable when the data source is created (creation retry must be enabled) or if all connections have failed connection tests (on creation, on reserve, or periodic testing).

  • Unknown

    - the data source state is unknown.

MBean Attribute:
JDBCDataSourceRuntimeMBean.State

Status of Last Action

Status information related to this task.

Related Tasks

Related Topics


Back to Top