Create or modify a server - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

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

Syntax
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:

  • DB2/400–n/a

  • MS SQL Server–Server name

  • Oracle–Instance name

  • Sybase–Server name

  • Informix–Instance name

  • DB2/UDB–Database name

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:

  • AT–At a specific point in time: You can set the time in hours:minutes:seconds. This is set in 24-hour time (0 to 23). You cannot specify the day; you can only specify the time during one day.

  • EVERY–After a specific interval in time, expressed in HH:MM:SS, where HH may be any positive integer, and MM and SS are minutes and seconds. The hours may be greater than 24.

  • SIZE–After the file reaches a specific size in characters

  • ROWS–After a file contains some number of rows

  • REQSTOPS–Only when the request stops (default)

ROLLOVER

CHARSET

Specifies the character set for the target flat file:

  • Default–operating system character set.

  • UTF-8–Use if the source table contains Unicode columns.

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.

 

Example
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