Neoview Workload Management Services Guide (R2.5)

Display the Service in Effect
The GET SERVICE statement shows the service that is in effect for the current session and provides
some information about the service and the client session:
SQL>get service;
CUR_SERVICE PLAN TEXT CUR_SCHEMA RULE_NAME APPL_NAME
SESSION_NAME DSN_NAME ROLE_NAME
------------ ------------- -------------- ---------------- -------------- -----------
------------ ---------------------- --------------
HP_DEFAULT_SERVICE 1 1 NEO.USR NCI
TDM_Default_DataSource role.hr
--- SQL operation complete.
SQL>
For more information about GET SERVICE, see the Neoview SQL Reference Manual.
Export and Save the WMS Configuration
You can export the current WMS configuration and save it to a script file as a series of WMS
commands. To replicate the WMS configuration on a different Neoview system, you can run the
script file using the OBEY (or @) command in the Neoview Command Interface (NCI) while
connected to the new system.
To export and save the WMS configuration:
1. Use either of these methods to launch the Export Neoview WMS Configuration dialog box:
• Right-click the System at the top of the tree view, and then select Export Configuration
from the list:
Name of the
system
• In the Services, Rules, Connection Rules, Compilation Rules, Execution Rules, or Admin
Roles Summary pane, click the toolbar icon.
2. The Export Neoview WMS Configuration dialog box appears, and the Neoview Performance
Analyzer (or the Neoview Query Viewer) starts to generate WMS commands for the entire
WMS configuration. NPA (or NQV) displays its progress on the bottom status bar:
This table shows the WMS commands that NPA (or NQV) generates:
Table 4-4 Conversion of the WMS Configuration to WMS Commands
Equivalent WMS CommandWMS Configuration
ALTER WMSWMS system
ADD SERVICEUser-defined services
ALTER SERVICESystem-defined services (HP_DEFAULT_SERVICE,
HPS_MANAGEABILITY, HPS_TRANSPORTER)
ADD RULE CONNUser-defined connection rules
ADD RULE COMPUser-defined compilation rules
Export and Save the WMS Configuration 65