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

Module File Caching (MFC).....................................................................................................48
Design of MFC..................................................................................................................49
Configuring MFC from the MXCS mode................................................................................49
Configuring MFC using NSM/Web.....................................................................................50
Managing MFC.................................................................................................................50
Benefits of MFC.................................................................................................................51
Limitations of MFC.............................................................................................................51
Troubleshooting MFC.........................................................................................................51
.err Files.......................................................................................................................52
.lock Files.....................................................................................................................52
.mdf Files.....................................................................................................................52
.lst Files........................................................................................................................52
.sql Files......................................................................................................................52
Disk Activity.................................................................................................................53
Enable Fileset and OSS Caching.....................................................................................53
Known Issues................................................................................................................54
A Migrating Applications from NonStop ODBC Server.....................................56
Server-Side Migration Steps.....................................................................................................56
Server: Duplicating NonStop ODBC Server Logical Database Object Names.................................56
Database Object Names....................................................................................................56
ANSI Names.....................................................................................................................57
Name Mapping................................................................................................................57
CREATE SQLMP ALIAS Command........................................................................................58
Using SQL Scripts to Automate Name Mapping.....................................................................58
Accessing Migrated Names................................................................................................59
Server: Migrating NonStop ODBC Server Configuration Settings..................................................59
Comparison of Configuration Terms......................................................................................59
Resource Governing...........................................................................................................60
Setting Control Statements...................................................................................................60
Configuring MXCS Data Sources.........................................................................................60
Setting Network Attributes...................................................................................................61
Setting MXCS Service Attributes...........................................................................................62
Server: Preserving User Alias Settings........................................................................................62
Client-Side Migration Steps......................................................................................................62
Client: Modifying Applications.................................................................................................62
ODBC API calls.................................................................................................................63
Modifying SQL Statements..................................................................................................65
Migrating SQL Server Objects.............................................................................................65
Modifying Pass-Through Commands.....................................................................................65
Features Not Supported...........................................................................................................66
NonStop ODBC Server Migration Example................................................................................66
Server Characteristics.........................................................................................................66
System Catalog Names......................................................................................................66
User Catalog Names..........................................................................................................68
Configuration Example for the NonStop ODBC Server............................................................70
Adding Aliases for System Catalog Object Names.................................................................72
Adding Aliases for User Catalog Names...............................................................................73
Adding User Alias Names To Safeguard...............................................................................75
Running and Configuring MXCS..........................................................................................75
Client Data Source Configuration.........................................................................................76
B Using Microsoft Access with ODBC/MX......................................................77
SQL_ATTR_ACCESS_VERSION for Microsoft Access....................................................................77
SQL_ATTR_MAP_DATATYPE for Microsoft Access........................................................................77
Contents 5