| |
Domain Apps: Control: Data Source Operations
Use this page to manually control each instance of a JDBC data source.
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.
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
Unhealthyhealth state and needs to be reinitialized.Clear Statement Cache For each connection in the connection pool, clears the statement cache of prepared and callable statements.
Suspend Suspends a data source has the health state of
Runningand disables existing connections. If any connections from the data source are currently in use, the operation fails and the health state remainsRunning. If successful, the health state is set toSuspended.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 toSuspended.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 toRunning.Stop 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 remainsRunning. If successful, the health state is set toShutdown.Force Stop 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 toShutdown.Start Starts a data source that has a health state of
Shutdown. If successful, the health state is set toRunning.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. This state includes conditions when the database server is not available and the data source is created (creation retry must be enabled) or when all connections have failed connection tests (on creation, on reserve, or periodic testing).Suspended- the data source has been disabled.
Shutdown- the data source is shutdown and all database connections have been closed.
Overloaded- all resources in pool are in use.
Unknown- the data source state is unknown.
MBean Attribute:
JDBCDataSourceRuntimeMBean.StateStatus of Last Action Status information related to this task.
|