ODBC Server Installation and Management Manual

Contents

HP NonStop ODBC Server Installation and Management Manual—429395-002

4. Managing the NonStop ODBC

Server (continued)

4. Managing the NonStop ODBC Server (continued)

Displaying Cache Statistics 4-6

Performance Tuning 4-7

Configuring ODBC Datasources 4-8

Using Batches for DBLIB Clients 4-10

Using Stored Procedures 4-11

Managing Connect/Disconnect Processing 4-11

Configuring Communication Stacks 4-11

Setting Up SCS 4-11

Configuring SQL/MP 4-12

Using the NonStop ODBC Server Connectivity Tool 4-12

Authorization and Security 4-13

Controlling Access to a NonStop ODBC Server System 4-15

Database Access Controls 4-17

PROGID Security 4-20

Troubleshooting Security Problems 4-24

Using Error and Event Messages for System Diagnosis 4-25

EMS Event Messages From the SCS Process 4-25

Multilan Errors 4-26

TCP/IP Errors 4-27

NonStop ODBC Server Shutdown Messages 4-29

Using the Subsystem Control Facility 4-29

INFO PROCESS Command 4-30

STATUS PROCESS Command 4-31

TRACE PROCESS Command 4-33

Tracing 4-34

The Trace Log 4-34

Setting Up Tracing 4-35

Stopping a Trace 4-37

Log Tables 4-37

Logging to a Terminal 4-38

Displaying Trace Options 4-38

Developing Custom Applications 4-38

5. Managing NonStop ODBC Server Resources

Resource Accounting 5-1

Resource Governing 5-1

The Resource Accounting Facility 5-2

Resource Accounting Profile 5-3