Updating a data source, Deleting a data source, Updating a data source deleting a data source – HP Integrity NonStop J-Series User Manual
Page 94

4.
Click MXCS Services.
5.
In the right pane, click Data Source Status.
6.
Select all of the services in which the data source is configured.
7.
Click Stop...
The Stopping Data Source dialog appears.
8.
In the Reason field, enter a reason for stopping the data source.
9.
Select one of the following options:
NOTE:
After you click one of the stop options, you cannot cancel the operation.
•
Stop on Client Disconnect
•
Stop Immediately
CAUTION:
Use Stop Immediately with caution. Stop Immediately stops the data source
without waiting for its associated MXCS servers to finish any current database statements
or sessions. The transaction manager rolls back all uncommitted transactions held by
these MXCS servers. All client connections are closed.
The data source stops.
Updating a data source
To update a data source:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2.
In the navigation tree pane, click Connectivity.
MXDM displays a list of existing systems.
3.
Expand the system for which you want to update a data source.
4.
Right-click the data source, and select Edit...
The Configuration tab appears.
5.
Modify the required fields.
•
“Using General Properties” (page 86)
.
•
“Using the DEFINEs and SETs tab” (page 88)
•
“Using the Control Query Defaults tab” (page 90)
•
“Using the Control Table Statements tab” (page 91)
NOTE:
If you made changes to the values in a tab, but you did not apply the changes, you
can reload the previously stored values on the server by clicking Reload.
6.
Click Apply.
The changes are applied.
Deleting a data source
You must stop a data source before deleting it. You cannot delete the default data source,
TDM_Default_DataSource
.
To delete a data source:
1.
Stop the data source by performing the steps described in
“Stopping a data source” (page 93)
2.
In the navigation tree pane, right-click the data source, and select Delete.
3.
Click Yes to confirm the deletion.
The data source is deleted.
94
Managing MXCS objects