SQL/MX Connectivity Service Manual for SQL/MX Release 3.2 (H06.25+, J06.14+)

I
installing
overview of, 19
installing MXCS on the server
requirements, 19
step 1, use DSM/SCM to install, 20
step 2, add table names, 31
step 3, start collector for statistics and server trace, 20
step 4, start MXCS, 20
IP address, client
, 14
L
logging on, 26
M
Managing, 26
managing
MXCS service, 26, 31
server data sources, 27, 31
mapping names for migration, 57
messages, 17
Microsoft Access, 77
Microsoft ODBC
Data Source Administrator, 13
migrating functions, 63
Migrating NonStop ODBC Server applications, 76
configuration settings, 59, 62
database object names, 56, 57
example, 66, 76
features not supported, 66
network configuration, 61
preserving user alias settings, 62
resource governing, 60
server-side migration, 56
service configuration, 62
steps for client side, 62, 65
steps for server, 56
Module File Caching (MFC)
benefits of, 51
configuration of, 49
design of, 49
limitations of, 51
managing, 50
troubleshooting, 51, 53
MXCS
features of, 18
limitation of, 18
MXCS permissions, 16, 26
overview, 16
MXOAS command to start MXCS, 21
MXOAS file, 23
MXOCFG file, 23
MXODSN file
installed file list, 23
MXOSRVR file, 23
N
name mapping for migration, 57
name types
See object name types, 57
NonStop MXCS
managing the service, 26, 27
starting, 20
NonStop ODBC Server
features not supported, 66
migrating client side, 62, 65
migrating server side, 56, 62
migration example, 66, 76
NonStop ODBC/MX
SQL functions not supported, 18
NonStop server requirement, 19
NonStop SQL/MX, adding logical names, 31
NSM/web, 26
Numeric data type
BinNum, 18
O
object names, migrating, 56
ODBC API mapping between versions, 63, 65
operations, controlling access to, 16
OPERATOR permission, 17
stopping, 27
S
server, MXCS
components of, 12
data sources for, 13
description of, 12
mapping to client data source names, 15
uninstalling server components, 25
service
See disabling MXCS service, 27
service, MXCS
disabling, 27
displaying status, 26
enabling, 27
managing, 26, 27
SET statements, adding or deleting, 29
shutting down MXCS, 27
SMXOTMPL file, 23
SQL server objects, migrating to ODBC/MX, 65
SQL statements, migrating to ODBC/MX, 65
SQL statements, statistics for, 17
SQL_ATTR_ACCESS_MODE, 78
SQL_ATTR_ACCESS_VERSION, 77
SQL_ATTR_MAP_DATATYPE, 77
SQLStatistics, 77
starting
MXCS, 20
resource statistics, 40
server data sources, 30
server trace, 46
statements, data source
adding or deleting, 29
statistics, resource
See resource statistics, 32
status
81