MX 3.x)

Starting, Configuring, and Managing MXCS

HP NonStop SQL/MX Connectivity Service Manual—640327-001

3-6

Reconfiguring Server Data Sources

You must use a user ID that has OPERATOR permission to perform management

tasks.

1. Using NSM/web, click Data Source Configurations to expand the list of data

sources.

2. Click on the data source you want to reconfigure.

3. Click the tab associated with the change you want to make.

If you have questions about a screen, click Help.

Using Case-Sensitive table names

To handle the system metadata table names that are case-sensitive, use NSM/web to

set the SQL_ATTR_METADATA_ID environment variable for the data source.

1. Using NSM/web, expand Data Source Configurations.

2. Click a data source name.

3. Click the Sets tab.

4. Click + to add a new Set.

5. Enter SQL_ATTR_METADATA_ID for Name and SQL_TRUE for Value.

6. Click Ok when finished.

The default setting is SQL_FALSE and is overridden by the setting from the ODBC

application when calling SQLSetConnectAttr for the same attribute.

To Change This Click This Tab

Control Query Default Control Query Defaults

Controlled Tables Controlled Tables

DEFINE statement Defines

SET statement Sets

Resource management

policy

Resource Management Policy

Resource statistics Resource Statistics

Number of servers,

Performance, and Start

options

General Configuration

CPU utilization and process

priority

Process Management