Administrator
- Administrator
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Property | Description |
|---|---|
Connection Name | A name for the Db2 for LUW CDC connection. This name must be
unique within the organization. Connection names can contain
alphanumeric characters, spaces, and the following special
characters: _ . + - Spaces at the beginning or end of the name are trimmed and are
not saved as part of the name. Maximum length is 100 characters. Connection names are not case
sensitive. |
Description | Description of the Db2 for LUW CDC connection.
Maximum length is 4000 characters. |
Runtime Environment | Name of the runtime environment that contains the
Secure Agent that you want to use to run mapping tasks. |
Listener Location | Host name or IP address of the system where the PowerExchange
Listener that processes PWX CDC Reader requests for Db2 change
data and the PowerExchange Logger for LUW run. Also include the
Listener port number. Enter the value in the following format,
where host_name can be a host name or IP
address:
For example:
|
User Name | A user name that can be used to access the
PowerExchange Listener when PowerExchange Listener security is
enabled. If you enabled PowerExchange LDAP user authentication, the
user name is an enterprise user name. For more information, see the
SECURITY statement in the PowerExchange Reference
Manual . |
Password | Password that is associated with the user name
that is specified in the User Name property.
|
Collection Name | Db2 instance name that is specified in the
Database field of the registration group
that contains capture registrations for the Db2 source tables. This
value is used to filter the extraction-map metadata that the PWX CDC
Metadata Adapter imports when using this connection. |
CAPI Connection Name | Name of a CAPX CAPI_CONNECTION statement that is
defined in the PowerExchange dbmover configuration file. This
statement includes parameters that the PWX CDC Reader uses to
extract change data from PowerExchange Logger for Linux, UNIX, and
Windows log files. The PWX CDC Reader requires this property value
and ignores any default CAPI_CONNECTION statement that is defined in
the dbmover configuration file.
|
Connection Retry Period | Number of seconds that the PWX CDC Reader tries to
reconnect to the PowerExchange Listener after the initial connection
attempt fails. If a connection cannot be established within the
retry period, the mapping task fails. The default is 0, which
disables connection retries. |
Compression | Controls whether the PowerExchange Listener
compresses change data before sending the data over the network to
the PWX CDC Reader. Select this property to compress the data. By
default, this property is not selected. |
Encryption | Controls whether the PowerExchange Listener encrypts change data
before sending it over the network to the PWX CDC Reader. Also
specifies the type of encryption to use. Select one of the
following options:
The default is None . |
Pacing Size | Amount of data, in rows or kilobytes, that the source system
passes to the PowerExchange Listener before pausing to wait for
another PWX CDC Reader request for more data. Decrease this
value to improve session performance. Use 0 for maximum
performance. The default and minimum value is 0. |
Pacing Units | Type of units to use with the Pacing Size
property. Select either Rows or
Kilobytes . |
Map Location | Enter the host name or IP address of the system that contains the
extraction maps. Also include the port number. This value is required when the PowerExchange Listener runs on a
PowerExchange Logger for Linux, UNIX, and Windows machine that
is remote from the extraction maps. The Listener requires access
to the extraction maps to process change data extraction
requests. Enter the value in the following format, where
host_name can be a host name or IP
address:
For example:
The Map Location value takes precedence
over the Listener Location value for
testing connections and importing extraction-map metadata. |
Map Location User | A user name that can access the PowerExchange
Listener at the location that is specified in the Map
Location property. |
Map Location Password | Password associated with the user name that is
specified in Map Location User property.
|
Event Table | If you created an event table to stop change data
extraction based on user-defined events, enter the name of the
PowerExchange extraction map for the event table. The event table
must be a Db2 table on the CDC source system. |
Replace Low
Values with Spaces
| Controls whether to replace embedded nulls in
character data with spaces. Select this property to replace embedded
nulls. By default, this property is selected. |
Custom Properties | Custom properties or connection property overrides. Custom
properties are properties that you can specify to override
PowerExchange default settings. You can enter multiple
properties by using a semicolon (;) as the separator or you can
specify a parameter to specify connection property overrides
through a parameter file. For example:
In most cases, you set custom properties only at the direction
of Informatica Global Customer Support. These
properties are equivalent to the PWX
Override options for the PowerExchange Client
for PowerCenter (PWXPC) CDC connections in PowerCenter. To specify connection property overrides through a parameter
file, you set a parameter in the form of
$<ParameterName> , where you prefix a
user-defined parameter name with a dollar sign character ($).
Then configure a mapping task for the mapping to use a parameter
file that contains the user-defined parameter definition by
specifying the parameter file name in the Parameter
File Name field on the Runtime
Options tab.
For more information, see the “Connection overrides reference”
chapter. |
