Usage
Creates or modifies a server, that is, an instance of a database on a specific host.
You can define as many servers as you need in your Enterprise Data Movement Model (EDMM). Each server must have a unique name. Each server can participate in a number of data movement requests.
Default processes created with each server
When a sending server is created, one or more of the following processes are typically created by default. Not all processes are added to each DBMS:
|
Process |
Default Name |
|---|---|
|
DB2/400 Change Selector |
library/journal |
CREATE SERVER server-name AT [HOST] host-name
DBMS {“Microsoft SQL Server”|Sybase|Oracle|“DB2/400”| “DB2/UDB”| Informix|FileSystem }
Or ALTER SERVER server-name AT [HOST] host-name TO
[DBMS_INSTANCE instance-name]
[VERSION ‘version’]
[ODBC|JDBC]
[PORT number]
[JDBC_DRIVER type]
[METABASE_OWNER owner-name ]
[PROJECT name]
[INSTALL_LIBRARY name]
[MAX_TRANS_ROWS n]
[SHADOWS [NODE]{v5nodename|NONE}]
[[NOT] ORADELETELOGS]
[[NOT] ORAIGNORELOGCORRUPTION]
[DESCRIPTION ‘descriptive text’]
[IASP ‘iaspname’]
[ENABLE_PREPARED_STMT ‘enabled_prepared_statement’]
[SPECIFIED_LIMIT ‘specifiedlimit’]
[COP ‘copvalue’]
[LOCATION pathname]
[ROLLOVER {AT hh:mm:ss | EVERY hhh:mm:ss | SIZE nsize |
ROWS nrows | REQSTOPS}]
[CHARSET {"default" | "utf-8"}]
[DELIMITER 'delchar']
[QUOTE_CHAR 'quotechar']
[NULL_STRING 'nullval']
[USEDEFAULTLOCATION][WRITE_BEFORE_VALUES];Parameters
|
Parameter |
Description |
Default |
|---|---|---|
|
DBMS |
DBMS from which or to which you are distributing data. |
|
|
DBMS_INSTANCE |
This parameter value is DBMS specific:
|
server name on a CREATE |
|
VERSION |
Version of the DBMS you are using to manage the database. |
empty string |
|
ODBC | JDBC |
Driver used to access the DBMS; JDBC is recommended. |
JDBC |
|
PORT |
JDBC driver port number, required for all but iSeries. |
0 on a CREATE |
|
JDBC_DRIVER |
See Release Notes for the current list. |
|
|
METABASE_OWNER |
For DB2/400 and DB2/UDB servers only. Owner ID or library of metabase tables and objects on this server. |
rpuser |
|
META_DATABASE |
For Informix only: The database that contains the metabase tables. |
omnirep |
|
INSTALL_LIBRARY |
DB2/400. Library where Connect CDC product was installed. Contains program modules. In DB2/400, may contain a metabase, if METABASE_OWNER specifies the same library. |
|
|
MAX_TRANS_ROWS |
Maximum number of transaction rows. Used for Sybase and MS SQL Server only. |
400000 on a CREATE |
|
SHADOW |
The sending node. This target-only sever “shadows” for purposes of modeling servers to a node. |
NONE |
|
DESCRIPTION |
Descriptive text. |
|
|
IASP |
The name of the iASP. This field is only available on a server where you have defined DB2/400 servers. |
|
|
ENABLE_PREPARED_STMT |
Prepared statements are enabled for the entire database server. A prepared SQL statement is a statement in which the steps to parse, analyze, validate, and determine the access path are only done once, when the statement is first prepared. On subsequent executions of the statement, the database has this information stored in memory and can skip the initial preparation steps. After a statement is prepared, only the column values change from one execution of the statement to the next. |
|
|
SPECIFIED_LIMIT |
The maximum size allowed for open statements in the cache. When the statement cache is full, the least recently used statement is removed from the cache, closed, and destroyed. |
|
|
COP |
Specify this parameter to connect to multiple gateways. |
|
|
LOCATION |
Specifies the path to location of the target file. |
LOCATION |
|
ROLLOVER |
Specifies the criteria for the target file to roll over to a new operating system file. Event options are:
|
ROLLOVER |
|
CHARSET |
Specifies the character set for the target flat file:
|
CHARSET |
|
DELIMITER |
Specifies the column delimiter character. The default is comma. This character must be an ASCII character from 1 to 253. The character itself may be entered. To enter a single quote, use four single quotes ’’’’. |
DELIMITER |
|
QUOTE_CHAR |
Specifies the quote character. The default is a double quote (“). This character must be an ASCII character from 1 to 253. The character itself may be entered. |
QUOTE_CHAR |
|
NULL_STRING |
The default is “~”. Connect CDC differentiates between null and empty strings. Connect CDC identifies an empty string as no character. |
NULL_STRING |
|
USEDEFAULT LOCATION |
Sets the default location in the kernel directory to <install_location>/targetfiles/<modelname>/<File Server label name>. |
|
|
WRITE_BEFORE_VALUES |
Before and After values for all columns will be written to the File Server when an update statement is captured. |
|
CREATE SERVER rvg_syb12_biwa AT HOST biwaX
DBMS Sybase VERSION ‘11.5’
JDBC
JDBC_DRIVER Sybase
PORT 8050
DBMS_INSTANCE “rvg_syb12_biwa”
METABASE_OWNER dbo
MAX_TRANS_ROWS 400000