BA. Captures the before image data, before the latest change, and the after image data, after the latest change. The before image data is shipped with an action character forcing the deletion of the record. The after image data, which includes the change data, is in the format of an insert operation.
AI. Captures the after image data only.
TU. Captures the before and after image data, as it occurs. The before image data enables the application to ensure that no changes occurred in the record since the request. The after image data appears as an update operation. The update is a full image, but the application that captures this change can change the target record rather than delete it and insert a new record, as occurs with a BA.

SL. Start the extraction from the point where the last extraction ended, either by restart tokens for z/OS, or by checkpoint timestamps for i5/OS.
RS. Restart the extraction from the start point of the last extraction. This option enables you to run the same extraction multiple times.

CPOOL. Initializes connection pooling.
DFN. If you specify DFN, the PowerExchange data source type is returned as follows:
PWX:
dbtype
If you do not specify DFN, the following string is returned:
PWX
Informatica recommends that you use the default value.
ILMBRIDGE. Specify this option if the Informatica Data Archive product accesses data by means of a JDBC-ODBC bridge connection to the PowerExchange ODBC driver. The ILMBRIDGE option enables the following options: BINASCHAR, CLOSEDSTMREUSE, NOFKEYS, NOUNDERSCORE, SQLLEN4BYTES, and V3COLNAMES.
OWB. Defines various SQL validations and statement reuse properties. Used by Oracle Warehouse Builder.
V30. Causes the ODBC SQLColumns() call to return V3 column names. Used by the IBM DB2 Information Integrator (II).
VERBOSE. Causes extra messages to be generated regarding Compatibility options.

BINASCHAR. Causes the ODBC SQLColAttributes() call to change BIN or VARBIN columns to CHAR or VARCHAR columns and double the lengths.
CLOSEDSTMREUSE. Causes a statement opened in read or select mode to be retained after an ODBC SQLFreeStmt() call of type SQL_CLOSE. Subset of StmtKeepAlive.
NOFKEYS. Causes the SQLForeignKeys() ODBC call to return an empty result set without a call to the PowerExchange Listener.
NOUNDERSCORE. Prevents underscore (_) characters from being replaced with the percent sign (%) in DTLDescribe processing. This option allows PowerExchange to process a single NRDB2 table.
SQLLEN4BYTES. Specifies that the JDBC-ODBC bridge calls SQLGetData with a 4-byte integer buffer to return the length of the target data.
V3COLNAMES. Causes ODBC V3 names to be returned for all metadata result sets, such as SQLTables(), SQLColumns(), and SQLPrimaryKeys(). Superset of the V30 flag.

Y. Enables confirm write. Ensures that data sent to the PowerExchange ODBC driver is immediately sent to, rather than buffered by, the PowerExchange Listener. Additionally, a success or no success response is sent, which improves error recovery. However, sending a response can slow data transfer rates.
T. Enables asynchronous write with fault tolerance. For more information about asynchronous write, see the
PowerExchange Bulk Data Movement Guide
.
N. For DB2, DB2 UDB, and Oracle data sources only. Disables confirm write. Before using this setting, contact Informatica Global Customer Support.

SET CURRENT DEGREE

N. No encryption is used when moving data.
Y. Data is encrypted by using a special Informatica developed algorithm if it is being accessed by way of a PowerExchange Listener.
AES. Data is encrypted by using Advanced Encryption Standard (DES) algorithm.

1
. Use a128-bit encryption key.
2
. Use a 192-bit encryption key.
3
. Use a 256-bit encryption key.

Y. Interpret the pacing size in rows.
N. Interpret the pacing size in kilobytes.

STQA/NEWJOURNAL

icucheck.exe > iculist.txt

B. Browse. Reads a copy of the data on the queue.
R. Read. Reads the data and removes it from the queue.

Y. Omit the database row test output from the PowerExchange CDC audit trail for the application.
N. Include the database row test output in the PowerExchange CDC audit trail for the application.

ORACLEID=(
coll_id,
oracle_sid,
connect_string,
cap_connect_string)

ORACLEID=(
coll_id,
oracle_sid,
connect_string,
cap_connect_string)

filename/
newlibrary/
newfilename/
newmembername

filename/
newlibrary/
newfilename/

ARRAYSIZE. The DB2 fetch array size, in number of rows, for DB2 bulk data movement operations that use the DB2 access method. The array size pertains to the DB2 multiple-row FETCH statements that PowerExchange uses to read data from DB2 source tables. Valid values are from 1 through 5000. Default is 25.
PowerExchange dynamically lowers the array size when all the following conditions are true:
The database type is DB2.
The table contains LOB columns.
The ARRAYSIZE value is greater than 1.
Row size * ARRAYSIZE is greater than 16000000 bytes.
LOWVALUES. If you previously set the LOWVALUES statement in the DBMOVER configuration file to Y for PowerExchange Client for PowerCenter (PWXPC) sessions, you can use this ODBC parameter to specify an override of LOWVALUES=N for sessions that use PowerExchange ODBC connections. You must use PWXPC instead of ODBC to preserve hexadecimal '0' values, called
low values
, in source character fields when passing these values to a PowerCenter session for delivery to a VSAM target on
z/OS
or a sequential file target on Linux, UNIX, Windows, or z/OS.
TCPIP_OP_TIMEOUT. Specifies a timeout, in seconds, for a network operation. When the client-side application thread detects that the network operation exceeds this timeout interval, PowerExchange ends the connection and issues a timeout error message.
TCPIP_CON_TIMEOUT. Specifies a timeout, in seconds, for a connection attempt. If PowerExchange cannot establish an ODBC connection within this time interval, PowerExchange issues an error message.
TCPIP_HB_INTERVAL. Specifies a heartbeat interval, in seconds, that overrides the default
TCP/IP
heartbeat interval of 507 seconds. If PowerExchange does not receive data before the TCP/IP heartbeat interval elapses, PowerExchange ends the ODBC connection and associated workflow with a heartbeat timeout error. Use this override to prevent dropped connections from TCP/IP heartbeat timeout errors.
USE_CATALOG_METADATA. Specify USE_CATALOG_METADATA=Y to read metadata from the catalog during a DB2 bulk load session, rather than issuing a SELECT statement. Then, when PowerExchange reads the metadata from the catalog, it is not necessary to grant PowerExchange SELECT privileges on the table.

PWXOVERRIDES=ARRAYSIZE=
array_size

PWXOVERRIDES=LOWVALUES=N

PWXOVERRIDES=TCPIP_OP_TIMEOUT=
network_operation_timeout

PWXOVERRIDES=TCPIP_CON_TIMEOUT=
connection_timeout

PWXOVERRIDES=TCPIP_HB_INTERVAL=
nnnnn

PWXOVERRIDES=USE_CATALOG_METADATA=Y

PWXOVERRIDES=TCPIP_OP_TIMEOUT=
nnn;TCPIP_CON_TIMEOUT=
nnn

PWXOVERRIDES=LOWVALUES=N

STQA/NEWJOURNAL

0. The EOF is returned when the end of the current log is reached. The end of the log is determined at the start of the extraction process, because the actual end point constantly changes.
2 to 86399. The number of seconds to wait for data before returning EOF.
86400. The EOF is never returned. The job waits forever.