Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

CAPI_CONNECTION - LRAP Statement

CAPI_CONNECTION - LRAP Statement

The LRAP CAPI_CONNECTION statement specifies a named set of parameters that the Consumer API (CAPI) uses for the Log Read API (LRAPI) component of the PowerExchange Logger for z/OS.
The LRAPI connects to the PowerExchange Logger to read change data for the address space that is extracting that data, such as the PowerExchange Listener address space.
Adabas, CA Datacom/DB, CA IDMS/DB, Db2 for z/OS, IMS, and VSAM
CAPI_CONNECTION - UOWC
Yes for z/OS CDC
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.