3.2.6 Changing the database connection environment
This subsection describes the procedure for tuning the database connection environment, and changing the settings to optimize the database accessing method after the system operations are started. For the concept of tuning the database connection environment, see 8.5.Optimizing the database access method in the uCosminexus Application Server System Design Guide.
The procedure for setting the tuning parameters of the connection pooling for the following main items is as follows.
-
Minimum connection value that pools in the connection pool
-
Maximum connection value that pools in the connection pool
- Reference note
-
For details on the windows used in the description, see 5. Windows, Commands, and Files used in the System Setup and Operations.
- Organization of this subsection
(1) Startup and login of the management portal
Once you have logged in to management portal, proceed to (2) Stopping the resource adapter.
-
Start the Web browser, connect to http://localhost:28080/mngsvr/index.jsp, and then run the management portal.
-
Enter "admin" to management user ID on the Login to Management Server window, and click the Login button.
(2) Stopping the resource adapter
-
Click Application Management of the Logical server in the Management Portal window.
-
Click DefaultDomain - Logical J2EE server - J2EE server - MyJ2EEServer - Resource - Resource adapter and then click the Start/Stop tab.
-
When Status on the Start/Stop the Resource Adapter window is "Operating", click the Stop anchor of Operation.
-
Click the Yes button on Stop the Resource Adapter window.
-
If "Success" is displayed in the Execution result, click the Back anchor.
If "Failure" is displayed in the Execution result, click the Display log tab, check the message in the Display Log window, remove the cause of the failure, and then stop the resource adapter again.
(3) Changing the property settings of resource adapter
-
Click Application Management of the logical server in the Management Portal window.
-
Click DefaultDomain - Logical J2EE server - J2EE server - MyJ2EEServer - Resource - Resource adapter, and then click the Property setting tab.
-
In the Property setting of the resource adapter, click the Basic Settings anchor of Operation.
-
In the Basic Settings of Resource Adapter window, specify the following values, and then click the Settings button:
-
Minimum pool value (MinPoolSize)
-
Maximum pool value (MaxPoolSize)
-
-
Check the message displayed in the Basic Settings of Resource Adapter window, and then click the Back anchor.
If a message showing failure appears, remove the cause of failure and then reset the property.
-
Click the Back anchor in the Basic Settings of Resource Adapter window.
You return to the Property Settings of the Resource Adapter window.
- Reference note
-
For specifying the tuning parameters not existing in the Basic Settings of Resource Adapter window, click the Edit connector property file anchor, and set the parameter directly in the file, through the Edit Connector Property File of Resource Adapter window.
(4) Starting the resource adapter
-
Click the Application Management of the Logical server on the Management Portal window.
-
Click DefaultDomain - Logical J2EE server - J2EE server - MyJ2EEServer - Resource - Resource adapter, and then click the Start/Stop tab.
-
In the Start/stop the Resource adapter window, click the Start anchor of Operation.
-
Click the Yes button on the Start the Resource Adapter window.
-
If "Success" is displayed in the Execution result, click the Back anchor.
If "Failure" is displayed in the Execution result, click the Display log tab, check the message in the Display Log window, remove the cause of the failure, and then start the resource adapter again.
(5) Logout from the management portal
-
Click the Logout anchor.
-
Check the displayed message, click the Login window, and close the Web browser.