CAPI_CONNECTION=([DLLTRACE=
trace_id]
                 ,NAME=
capi_connection_name
                [,TRACE=
trace_name]
                 ,TYPE=(LRAP
                       ,AGENT=
agent_id
                       ,LOG=
logger_id
                      [,EOF={Y|
N}]
                      [,FUZZYRSTART={
Y|N}]
                      [,UIDFMT={
UID|CONN|CORR|CTYPE|PLAN|ALL}]
                      [,UIDFMTIMS={
UID|PSB|ALL}]
                  )
) 

DLLTRACE=

trace_id

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

NAME=

capi_connection_name

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

Maximum length is eight alphanumeric characters.

TRACE=

trace_name

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

TYPE=(LRAP, ... )

Required. Type of CAPI_CONNECTION statement. For the LRAPI, this value must be LRAP.

AGENT=

agent_id

Required. The PowerExchange Agent ID. This value must match the value in the AGENTID parameter of the EDMSDIR module. PowerExchange reads the EDMSDIR module from the EDMPARMS DD statement, or if this statement is not specified, from the STEPLIB or JOBLIB DD statement.

Maximum length is four alphanumeric characters.

LOG=

logger_id

Required. The PowerExchange Logger ID. This value must match the value specified in the LOGGER parameter of the EDMSDIR module.

Maximum length is four alphanumeric characters.

EOF={

N

|Y}

Optional. Controls whether PowerExchange stops change data extractions after reaching the end-of-log (EOL).

Options are:

N
. PowerExchange does not stop change data extractions when EOL is reached.
Y
. PowerExchange stops change data extractions when EOL is reached.

Default is N.

Because this parameter affects all users of the LRAP CAPI_CONNECTION statement, Informatica recommends that you use one of the following alternative methods to stop change data extractions at EOL:

For CDC sessions that use real-time extraction mode, enter 0 for the
Idle Time
attribute on the PWX DB2zOS CDC Real Time application connections.
For PowerExchange Condense, enter 1 in the COLL_END_LOG statement in the CAPTPARM configuration member.
For CDC sessions that use ODBC connections, enter 0 for the WAITTIME parameter in the ODBC data source.

FUZZYRSTART={

Y

|N}

Optional. Controls whether the restart2 token in the restart information that the PowerExchange Client for PowerCenter sends to the PowerExchange Logger for z/OS for a CDC session points to a begin-uow record or any RBA position that you specify in the restart2 token.

This parameter also pertains to the Restart Token 2 value that you specify for PowerExchange Navigator CAPX and CAPXRT database row tests.

Options are:

Y
. Allow the restart2 token to point to any position in the PowerExchange Logger logged data. This option enables you to skip a problematic record.
N
. Require the restart2 token to point to a begin-uow record in the PowerExchange Logger logged data.

Default is Y.

UIDFMT={

UID

|CONN|CORR|CTYPE|PLAN|ALL}

Optional. For Db2 for z/OS CDC sources, controls the type of value that PowerExchange returns in the generated DTL__CAPXUSER field in each change record. Options are:

UID

. Returns the user ID of the user who made the change.

CONN

. Returns the Db2 connection identifier at the time the change was made.

CORR

. Returns the Db2 correlation identifier at the time the change was made.

CTYPE

. Returns the Db2 connection type at the time the change was made.

PLAN

. Returns the Db2 plan name at the time the change was made.

ALL

. Returns all of the information supplied by the other options. PowerExchange provides this information in a colon-delimited list in the following format:

userid:
plan_name:
correlation_id:
connection_id:
connection_type

Default is UID.

You can specify only one option.

UIDFMTIMS={

UID

|PSB|ALL}

Optional. For IMS synchronous CDC data sources, controls the type of value that PowerExchange uses to populate the generated DTL__CAPXUSER column in each change record. Options are:

UID
. Returns the user ID of the user who made the IMS change.
PSB
. Returns the IMS program specification block (PSB) name.
ALL
. Returns both the user ID and PSB name in the format
userid
:
psbname
.

Default is UID.

You can specify only one option.