ODBC Server Installation and Management Manual

HP NonStop ODBC Server Installation and Management Manual—429395-002
4-1
4
Managing the NonStop ODBC Server
This section describes how to manage a NonStop ODBC Server system. You should
read this section in conjunction with Section 2, Installing the NonStop ODBC Server.
The following topics are covered in this section:
•
Configuring a server class and reading server class statistics.
•
Using statement caching; how to improve your SQL execution performance and
how to limit resource consumption by a query.
•
Techniques for improving performance; the options available for configuring ODBC
datasources.
•
Security implications.
•
Using Event Management Service (EMS) events from the SQL Communication
Subsystem (SCS) and some EMS messages generated by the NonStop ODBC
Server to diagnose problems based on EMS events.
•
Using the Subsystem Control Facility (SCF) interface to check on the status of an
SCS process.
•
Using the trace features provided by the NonStop ODBC Server
•
Developing user applications and scripts for reading the NonStop ODBC Server
catalog tables.
Configuring and Managing SCS
This subsection describes the considerations, methods, and tools used to configure
and adjust the SCS process for optimum operation.
Configuring SCS Server Classes
First, review the server class statistics available from SCF. Entering the command
STATUS PROCESS $ZYX, where $ZYX represents an SCS process, yields the
following display:
Process Name State Num of Sessions Num of Classes Accepting
$ZYX STARTED 0 3 YES
Connected Listening
ServerClass | Total High Current|Current Hit |
ZZTDMMAPPER | 2 1 0| 1 2 |
CLASS1 | 9 2 0| 5 5 |
CLASS2 | 5 1 0| 6 5 |