CAPI_CONNECTION=(NAME=
capi_connection_name
                [,DLLTRACE=
trace_id]
                 ,TYPE=(MYSQL
                       ,SERVER={
database_server|localhost}
                      [,MYSQLBINLOG=
path_to_mysqlbinlog]
                      [,ONDATATRUNC={WARN|
FAIL}]
                      [,ONTABLETRUNC={WARN|
FAIL}]
                      [,RECONNTRIES={
number|
12}]
                      [,RECONNWAIT={
seconds|
5}]
                      [,ROWMEMMAX=
bytes]
                      [,RSTRADV=
seconds]
                      [,UOWREADAHEAD=
minimum_transactions,
maximum_transactions]
                       )
)

NAME=

capi_connection_name

Required. A unique user-defined name for this CAPI_CONNECTION statement.

Maximum length is eight alphanumeric characters.

DLLTRACE=

trace_ID

Optional. The user-defined name of the TRACE statement that activates internal DLL tracing for this CAPI. Specify this parameter only at the direction of Informatica Global Customer Support.

TYPE=(MYSQL, ... )

Required. The type of CAPI_CONNECTION statement. For MySQL sources, this value must be MYSQL.

SERVER={

server_name

|localhost}[,

port_number

]

Required. The host name or IP address of the MySQL server where the MySQL source database runs. You can enter "localhost" if the MySQL server and PowerExchange Listener run locally on the same machine. Optionally, if you want the database server to listen on a port number other than the default port number of 3306, append the non-default port number to the server name.

MYSQLBINLOG=

path_to_mysqlbinlog

Optional. If the MySQL server is not installed on the local host, specify the path to the mysqlbinlog utility in this parameter or in the PATH environment variable. PowerExchange uses the mysqlbinlog utility to read change events from the MySQL binary log.

ONDATATRUNC={WARN|

FAIL

}

Optional. Indicates whether PowerExchange issues a warning message and continues processing or ends abnormally when it needs to truncate data from MySQL columns that have a mediumblob, longblob, mediumtext, longtext, enum, json, set, varbinary, or varchar datatype and are longer than 98,304 bytes.

Default is FAIL.

ONTABLETRUNC={WARN|

FAIL

}

Optional. Indicates whether PowerExchange issues a warning message and continues processing or ends abnormally when it encounters a TRUNCATE TABLE record in the change stream.

Default is FAIL.

RECONNTRIES={

number

|

12

}

Optional. The maximum number of times that PowerExchange tries to reconnect to the MySQL Server database server after detecting that the database server has shut down or a network connection to the server has been dropped. When PowerExchange and the database server run on the same machine, PowerExchange processes change records to the end-of-log and then checks whether the server is still running. If PowerExchange connects to a remote database server and the server shuts down or the network connection to the server is severed, the binary log reader connection might be dropped. In this case, you can use this parameter in conjunction with the RECONNWAIT parameter to improve connection resiliency.

Valid values are 0 or any positive number. A value of 0 results in no connection retries. Default is 12.

RECONNWAIT={

seconds

|

5

}

Optional. The number of seconds that PowerExchange waits before any attempt to reconnect to a MySQL Server database server after detecting that the server has shut down or the network connection to the server has been dropped. Use this parameter in conjunction with the RECONNTRIES parameter to improve connection resiliency.

Valid values are 0 through 3600. A value of 0 results in no waiting between connection retries. Default is 5.

ROWMEMMAX=

maximum_bytes

Optional. The maximum amount of memory, in bytes, that PowerExchange can use to store a row change from a MySQL source table. No default value is available. If no maximum value is provided, PowerExchange does not limit the memory for a captured row change.

RSTRADV=

seconds

Optional. The time interval, in seconds, that PowerExchange waits before advancing restart and sequence tokens for a registered data source during periods when UOWs do not include any changes of interest for the data source. When the wait interval expires, PowerExchange returns the next committed "empty UOW," which includes only updated restart information.

PowerExchange resets the wait interval to 0 when one of the following events occur:

PowerExchange completes processing a UOW that includes changes of interest.
PowerExchange returns an empty UOW because the wait interval expired without PowerExchange receiving any changes of interest.

Valid values 0 through 86400. No default is provided. A value of 0 disables restart advance processing.

If you do not specify RSTRADV, PowerExchange does not advance restart and sequence tokens for a registered source during periods when PowerExchange receives no changes of interest. In this case, when PowerExchange warm starts, it reads all changes, including those not of interest for CDC, from the restart point.

UOWREADAHEAD=

minimum_transactions_in_queue

,

maximum_transactions_in_queue

Optional. The minimum number of transactions and maximum number of transactions that control I/O on the UOW read-ahead queue that PowerExchange uses to prefetch change data. The UOW read-ahead queue is a dynamic queue of buffered transactions that are waiting to be read by the PowerExchange capture process. When the queue reaches the maximum number of transactions, the queue reader thread stops and sleeps until enough transactions have been read from the queue to return it to the maximum value.