As you prepare
to test existing applications with the new DirecConnect products, you will want
to configure the new products as closely as possible to your existing gateway
configurations. This chapter contains information to help convert your existing
configuration files and parameters to those used in the new architecture.
Converting
Old Net Gateway Configurations
Startup
parameters
In the new
architecture, the Transaction Router replaces the Net Gateway. Because TRS
is not a stand-alone component like its predecessor, its startup parameters
have been migrated to DirectConnect Server and TRS Library configuration properties.
The
following table indicates how to map your existing startup parameters into
DirectConnect configuration properties:
|
Startup
Parameters
|
New
Location
|
New
Configuration Property
|
| |
Direct
Connect Server
|
Transaction
Router
Service
|
|
|
-M flag |
x
|
|
MaxServer Connections = Connections |
|
-N flag |
x
|
|
RemoteSites = numsitehandlers |
|
-R flag |
|
x
|
RPCInfoFile = newpath |
|
-P flag |
|
x
|
PEMDest = destsys |
|
-G Flag |
|
x
|
LogInfoFile = newpath |
|
-T and -t flags |
|
x
|
TraceTAS = long/short/no |
|
-O flag |
|
x
|
Security = yes/no |
|
-D flag |
|
x
|
DirectPrevent = yes/no |
|
-K flag |
|
x
|
Accounting=yes/no |
| |
|
x
|
AccountFile=newpath |
|
-E flag |
|
x
|
UseDBRPC=ýes/no |
|
-V flag |
|
x
|
TruncateLV=yes/no |
|
-C flag |
|
x
|
UpperCase=yes/no |
|
-L flag |
|
x
|
ConnInfoFile=newpath |
|
-Q flag |
|
x
|
ConQTimeout=timeout |
|
-d flag |
|
x
|
DeactCon=yes/no |
| |
|
x
|
SNATraceFile=newpath |
|
-I flag |
|
|
Interfaces file now defaults to ini sub-directory of $SYBASE |
|
-J flag |
|
|
Character set configured in locales.dat file |
|
-z flag |
|
|
National language configured in locales.dat file |
|
-S flag |
|
|
No longer needed |
Configuration
files
DirectConnect
TRS stores the files used to maintain lists of RPCs, userids, transaction
groups, etc in new locations. The file names are listed on the left of the
chart and the old and the new locations are listed on the right.
|
File
Names
|
File
Locations
|
|
PC
Platforms
|
UNIX
Platforms
|
Net-GW
(Old)
|
DirectConnect
(New)
|
|
server.tds |
ngtds.server |
$SYBASE |
$SYBASE/eConnect/log |
|
server.log |
nglog.server |
$SYBASE |
$SYBASE/eConnect/log |
|
server.rpc |
ngrpc.server |
$SYBASE |
$SYBASE/eConnect/cfg |
|
server.reg |
ngreg.server |
$SYBASE |
$SYBASE/eConnect/cfg |
|
server.cid |
ngcid.server |
$SYBASE |
$SYBASE/eConnect/cfg |
|
server.grp |
nggrp.server |
$SYBASE |
$SYBASE/eConnect/cfg |
|
server.act |
ngact.server |
$SYBASE |
$SYBASE/eConnect/cfg |
Converting
Old MDI Database Gateway Configurations
In the new
architecture, many existing configuration properties have been deleted, re-named
or re-implemented. The table below lists the original configuration property,
an associated release version, its new name (if any), the location where that
property is now configured, and an explanation of the change.
Access Server
Many of the
Access Server configuration properties are now configured at the DirectConnect
or Open Server Connect. Many configuration properties have also been re-named
or eliminated.
To assist
your migration, the table below lists the original configuration property,
its new name (if any), and comments, including the location ([ ])where that
property is now configured. In the tables below we will use the following
abbreviations:
- N/A…Not
applicable
- DirectConnect
for MVS DB2 Access Service…DB2 Acs Svc
- DirectConnect
server…DC Srv
- MainframeConnect
for DB2…MFC DB2
| Legacy
Config Property Name |
New
Config Property Name |
Explanation |
| Tuning
Parameters |
|
|
|
Maximum Record Size |
N/A |
|
|
Maximum Block Size |
N/A |
|
|
Maximum Request Size |
N/A |
|
|
Maximum Result Size |
MaxResultSize |
[DB2 Acs Svc]. |
|
No. of Blocs in a Chunk |
N/A |
Chunking is no longer supported |
| Legacy
Config Property Name |
New
Config
Property Name |
Explanation |
| Processing
Parameters |
|
|
|
Temporary Storage Type |
Temp storage queue type |
[MFC DB2]. |
|
Force First 25 Rows? |
N/A |
[DB2 Acs Svc]. No longer supported |
|
Allow Binary Data? |
DisableBinary-Results |
|
|
Date Format |
DateResults
|
[DB2 Acs Svc]. Replaced by several new config props |
|
Time Format |
TimeResults
|
[DB2 Acs Svc]. Replaced by several new config props |
|
Catalog Refresh Location |
N/A |
No longer supported (PC/SQL-link only) |
|
Character Null |
N/A |
No longer supported (PC/SQL-link only) |
|
Numeric Null |
N/A |
No longer supported (PC/SQL-link only) |
|
Treat Empty RSP Input Pipe as Error? |
N/A |
This property is always assumed to be TRUE |
|
Host decimal separator translation |
TargetDecimal-Separator |
[DB2 Acs Svc]. |
| Legacy
Config Property Name |
New
Config
Property Name |
Explanation |
| Transaction
Management Parameters |
|
|
|
Commit/Rollback Method |
TransactionMode |
[DB2 Acs Svc]. |
|
Treat RSPs as a Unit of Work? |
N/A |
This property is always assumed to be FALSE |
|
Request Validation Exit |
Request exit name |
[MFC DB2]. |
|
Result Validation Exit |
Result exit name |
[MFC DB2]. |
| Legacy
Config Property Name |
New
Config
Property Name |
Explanation |
| Catalog
Access Parameters |
|
|
|
Catalog Qualifier |
CSPCatalogQualifier |
[DB2 Acs Svc]. |
|
Include System Tables |
CSPIncludeSystem |
[DB2 Acs Svc]. |
|
Exclude Non-Authorized |
CSPExclusions |
[DB2 Acs Svc]. |
|
Include Public Tables |
CSPExclusions |
[DB2 Acs Svc]. |
|
Group-ID Support |
Group ID exit name: |
[MFC DB2]. Exit names designate the security package |
|
DB2 Parameters |
|
|
|
Default Database Name |
N/A |
No longer supported (PC/SQL-link only) |
|
System Database Name |
Host Request Library |
[MFC DB2]. |
|
System Table Qualifier |
CSPCatalogQualifier |
[DB2 Acs Svc]. |
|
Return Column Labels? |
N/A |
Always NO. |
| Legacy
Config Property Name |
New
Config
Property Name |
Explanation |
| Miscellaneous |
|
|
|
Administration Password |
N/A |
No longer supported |
|
Activate Notification |
N/A |
No longer applicable |
|
Cleanup Transaction ID |
N/A |
Fixed by Open Server |
Database
Gateway
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
| Client
Connection Properties |
|
|
|
Service Name |
See note |
[DB2 Acs Svc] A {ServiceA} heading in the DB2 Access Service Library configuration
file denotes
the service name |
|
Shareable |
N/A |
No longer supported |
|
Socket Number |
See note |
[SQL.INI] Network addresses for Connectivity to the DirectConnect Server
are now configured in the SQL.INI file. |
|
SPX Name/Socket |
See note |
SQL.INI |
|
TCP/IP Port |
See note |
SQL.INI |
|
Banyan Street Talk Name |
See note |
SQL.INI |
|
Decnet Name |
See note |
SQL.INI |
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
|
Communication Properties |
|
|
|
Local LU Alias |
ConnectionSpec1 |
DB2
Access Service
{Target
Interaction}
|
|
Partner LU Alias |
ConnectionSpec2 |
DB2
Access Service
{Target
Interaction}
|
|
Session Mode |
ConnectionSpec3 |
DB2
Access Service
{Target
Interaction}
|
|
TP Name |
TPName |
DB2
Access Service
{Target
Interaction}
|
|
Database Name |
N/A |
InfoHub property |
|
APPC Security |
APPCSecurity |
DB2
Access Service
{Target
Interaction}
|
|
Password Required |
PasswordRequired |
DB2
Access Service
{Target
Interaction}
|
|
Compression |
N/A |
No longer supported |
|
Allocate |
Allocate |
DB2
Access Service
{Target
Interaction}
|
|
ASCII-EBCDIC Convert Table |
|
No longer supported. |
Database
Gateway Configuration
Property |
New
Configuration Property |
Note/Explanation |
|
Gateway Parameters |
|
|
|
Autostart Database Gateway |
EnableAtStartup |
Specifies
whether an access service is enabled at the time the DC Server starts.
DB2 Access Service
{Client
Interaction}
|
|
Maximum Number of Clients |
MaxConnections |
Specifies the maximum number of clients that can log on to the DC Server
at one time. DC Server |
|
|
MaxSvcConnections |
Specifies
the maximum number of clients that can log on to a particular DC access
service at one time. DB2 Access Service
{Client
Interaction}
|
|
Client Idle Timeout |
ClientIdleTimeout |
DB2
Access Service
{Client
Interaction}
|
|
Application Validation Filename |
ApplicationValidationFile |
DB2
Access Service
{Client
Interaction}
|
|
Quoted String Delimiter |
QuotedStringDelimiter |
DB2
Access Service
{Target
Interaction}
|
|
CSP Qualify by DBNAME |
CSPQualDBName |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
CSP Include System Tables |
CSPIncludeSystem |
DB2
Access Service
{Catalog
Stored Procedures}
|
|
TableTypes: System |
CSPIncludeSystem |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
Table Types: View |
CSPIncludeView |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
Table Types: Synonym |
CSPIncludeSynonym |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
Table Types: Table |
CSPIncludeTable |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
Table Types: Alias |
CSPIncludeAlias |
Introduced
in v 2.05. DB2 Access Service
{Catalog
Stored Procedures}
|
|
CSP Catalog Qualifier |
CSPCatalogQualifier |
DB2
Access Service
{Catalog
Stored Procedures}
|
|
CSP Include Public Tables |
CSPIncludePublic |
DB2
Access Service
{Catalog
Stored Procedures}
|
|
CSP Exclude Non-Authorized |
CSPExclusions |
DB2
Access Service
{Catalog
Stored Procedures}
|
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
| Client
Parameters |
|
|
|
Maximum Number of Rows |
MaxRowsReturned |
DB2
Access Service
{Client
Interaction}
|
|
Maximum Result Size |
MaxResultSize |
DB2
Access Service
{Client
Interaction}
|
|
Request Transform Level |
SQLTransformation |
DB2
Access Service
{Target
Interaction}
|
|
Transaction Mode |
TransactionMode |
DB2
Access Service
{Client
Interaction}
|
|
Verbose Messages |
SendWarningMessages |
DB2
Access Service
{Client
Interaction}
|
|
Stop Condition |
StopCondition |
DB2
Access Service
{Target
Interaction}
|
|
Decimal Separator is Comma |
ClientDecimalSeparator |
Introduced
in v 2.05. DB2 Access Service
{Client
Interaction}
|
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
|
Data Type Conversions |
|
|
|
ByteInt |
N/A |
|
|
SmallInt |
Int2Results |
DB2
Access Service
{Datatype
Conversion}
|
|
Integer |
Int4Results |
DB2
Access Service
{Datatype
Conversion}
|
|
Char |
N/A |
|
|
L Varchar |
N/A |
|
|
Float |
FloatResults |
DB2
Access Service
{Datatype
Conversion}
|
|
Decimal |
DecimalResults |
DB2
Access Service
{Datatype
Conversion}
|
|
Date |
DateResults |
DB2
Access Service
{Datatype
Conversion}
|
|
Time |
TimeResults |
DB2
Access Service
{Datatype
Conversion}
|
|
Timestamp |
DateTimeResults |
DB2
Access Service
{Datatype
Conversion}
|
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
| Data
Conversion Errors |
|
|
|
Character Conversion Errors |
CharConvertError |
DB2
Access Service
{Data
Conversion Errors}
|
|
Numeric Conversion Errors |
NumConvertError |
DB2
Access Service
{Data
Conversion Errors}
|
|
Date/Time Conversion Errors |
DateTimeConvertError |
DB2
Access Service
{Data
Conversion Errors}
|
|
Default Date |
DefaultDate |
|
|
Default Time |
DefaultTime |
|
|
Summary Message Level |
SendWarningMessages |
DB2
Access Service
{Client
Interaction}
|
| Database
Gateway Configuration Property |
New
Configuration Property |
Note/Explanation |
|
Troubleshooting Parameters |
|
There are many additional Logging & Tracing options available in the
DirectConnects. Refer to the manuals for details. |
|
Detailed Trace Options |
N/A |
|
|
Log File Name |
LogFileName |
DC Server |
|
Max File Size |
LogFileSize |
DC Server |
|
Viewlog Pipe Name |
N/A |
|
|
Activate Trace of Host Server Files |
TraceTarget |
DB2
Access Service
{Tracing}
|
|
Display Trace on Screen |
TraceToScreen |
DC Server |
|
Trace Timing & Major Steps |
N/A |
|
|
Trace SQL Request as Received |
LogReceivedSQL |
DB2
Access Service
{Logging}
|
|
Trace SQL Request as Transformed |
LogTransformedSQL |
DB2
Access Service
{Logging}
|
|
Trace Host Communications |
TraceHostCom |
DB2
Access Service
{Tracing}
|
