Optional. The following overrides apply to PowerExchange ODBC connections for bulk data movement or CDC sessions:
If you specify multiple overrides, use a comma (,) as a separator, for example:
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
, in source character fields when passing these values to a PowerCenter session for delivery to a VSAM target on
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
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.
Corresponding ODBC Parameter: PWXOVERRIDES