Managing the dba/m database manager profile – HP NonStop G-Series User Manual

Page 41

Advertising
background image

Managing dba/m Profiles

4-2

Managing the dba/m Database Manager Profile

The dba/m Database Manager profile contains configuration parameters.
Use the dba/m Database Manager Profile window to change the dba/m
Database Manager profile and add or delete nodes. You must be a super
user to access the dba/m Database Manager Profile window. To display the
dba/m Database Manager Profile window, click on Profile in the Main
window, then click on Options. The dba/m Database Manager Profile
window is displayed, as shown in Figure 4-1.

Figure 4-1. dba/m Database Manager Profile Window.

Change dba/m Database Manager Profile

You can change only the SQL Operation Cost in the System. The other
attributes in this pane cannot be changed. If the cost to perform an SQL
operation is greater than the value you specify, the user performing the
operation is warned that the actual cost is higher than the maximum cost
allowed. This capability is available only if queries are performed under
dba/m Database Manager control.

Use the dba/m Database Manager Profile window as shown in figure 4-1 to
change the maximum cost for an SQL operation.

Advertising