Uppercase and lowercase letters
The numbers 0 to 9
Spaces
The following special characters:
’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ? 
The first character is an apostrophe.

None
CS
. Cursor stability.
RR
. Repeatable Read.
CHG
. Change.
ALL

from_file/to_library/to_file/to_member 

from_file
is the file to be overridden.
to_library
is the new library to use.
to_file
is the file in the new library to use.
to_member
is optional and is the member in the new library and file to use. If no value is specified, *FIRST is used.

TRACK
CYLINDER

NO
. Do not delete the temporary files.
BEFORE
. Delete the temporary files before running the utility.
AFTER SUCCESS ONLY
. Delete the temporary files if the utility ends successfully with return code 0.
AFTER
. Delete the temporary files after the utility runs.

RESUME
. Generate a LOAD RESUME statement.
REPLACE
. Generate a LOAD REPLACE statement.

TASK
. Run the LOAD utility as a subtask under the PowerExchange Listener.
JOB
. Submit a separate job to run the DB2 LOAD utility.
NOSUBMIT
. Create the files and JCL to run the DB2 LOAD utility (unless
Mode Time
is set to
DATAONLY
) but do not submit the load job. You must submit the job manually.

WAIT
. Wait for the job to end before returning control to PowerCenter. This option can be specified only when the
Mode Type
is
JOB
or
TASK
.
NO WAIT
. Return to PowerCenter without waiting for the job to end. This option can be specified only when
Mode Type
is set to
JOB
or
NOSUBMIT
.
TIMED
. Wait the number of seconds that is specified in the
Time
attribute before returning control to PowerCenter. The TIMED option can be specified only when
Mode Type
is set to
JOB
.
DATAONLY
. Create the data file only. Do not create the files and JCL for running the DB2 LOAD utility. Usually, this option is used when
Mode Type
is set to
NOSUBMIT
.

No
. Do not use offload processing.
Yes
. Use offload processing.
Auto
. PowerExchange determines whether to use offload processing.

APPBUFSIZE=
app_buf_size.
Specifies the initial size of the application buffer for the connection. Overrides the APPBUFSIZE statement in the DBMOVER configuration file.
CNV_ERROR_OK= {
N
|Y}. If you use a DB2 relational connection to write data to a DB2 target, set this parameter to Y to allow the workflow continue after a PWX-00143 message reports a DBAPI illegal null conversion error. This error occurs when the workflow tries to write null data to a target NOT NULL column. Set this parameter to N to have the workflow end abnormally when this type of error occurs. Default is N.
CONNECTSTRINGCODEPAGE=
code_page
. Code page of the characters in the connection string. Enter this override if PowerExchange issues message PWX-07610.
CONNSHARE={N|
Y
}. By default, all DB2 lookups in a workflow use the same connection, and the PowerExchange Listener performs them in a single task.
To preserve the behavior in effect for DB2 lookups in PowerExchange releases earlier than 9.6.0, specify CONNSHARE=N.
If the DB2 connection is used as a target in a CDC workflow, do not change the default behavior. Otherwise, internal PowerCenter state tables that require connection sharing might not be updated correctly.
DB2 lookups that share a connection do not use offload processing, partitioning, or threading.
DB2TRUNCASDEL={
N
|Y}. Applies to DB2zOS target connections only. With the default of N, when the PowerCenter Integration Service requests a TRUNCATE statement, PowerExchange issues a TRUNCATE statement.
If you set this override to Y, when the PowerCenter Integration Service requests a TRUNCATE statement, PowerExchange issues a DELETE statement.
The DB2TRUNCASDEL override applies only to DB2zOS target connections. For DB2i5OS target connections, PowerExchange always issues a DELETE statement. For DB2LUW target connections, PowerExchange always issues a TRUNCATE statement.
LOWVALUES={Y|
N
}. Indicates whether PowerExchange preserves hexadecimal '0' values, called
low values
, in source character fields when passing these values to a PowerCenter session. Enter Y to preserve low values. When the session runs, PWXPC can write these values to a VSAM target on z/OS or to a sequential file target on Linux, UNIX, Windows, or z/OS. Overrides the LOWVALUES statement in the DBMOVER configuration file.
PWXNOQUOTES={
Y
|N}. By default, in the SQL SELECT statements that PWXPC uses to select data for session processing, PWXPC adds double-quotation marks (") around every table name and field name that includes spaces or special characters. These special characters are
/+-=~`!%^&*()[]{}';?,< >\\|
. If a table is identified by both a schema name and table name in the format
schema
.
table_name
, PWXPC places the quotation marks only around the "
table_name
" value.
If for any reason, you cannot use quoted table names or field names in your environment, set PWXNOQUOTES to Y to override the default behavior.
QAQQINILIB=
library_name
Specify the library name on the IBM i (i5/OS) system that contains the QAQQINI query options file. If the DBMOVER configuration file on the IBM i system includes the optional QAQQINILIB statement, this override takes precedence over the value specified in the DBMOVER file. This override only applies to IBM i systems.
RETLOGINFOMSG={
N
|Y}. By default, PWXPC writes PowerExchange error and warning messages but not informational messages to the session log. If you specify RETLOGINFOMSG=Y, PWXPC writes informational messages as well as error and warning messages to the session log.
RTNBUFFSIZE={
kilobytes
|
960
}. The size of the buffer, in kilobytes, that is used to collect journal entries for CDC as a result of PowerExchange calls to the IBM QjoRetrieveJournalEntries API. Adjust this parameter to tune performance based on your environment.
Valid values are 128 through 12288. Default is 960 KB.
If you also specified the RTNBUFFSIZE parameter in the PowerExchange AS4J CAPI_CONNECTION statement, this override takes precedence for the sessions that use the Db2 connection.
TCPIP_OP_TIMEOUT=
network_operation_timeout
. A network operation timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.
TCPIP_CON_TIMEOUT=
connection_timeout
. A connection timeout interval in seconds. For more information about this timeout override, see Asynchronous Network Communication.
USE_CATALOG_METADATA={
N
|Y}. Specify Y to read metadata from the DB2 catalog during a DB2 bulk load session rather than issuing a SELECT statement. PowerExchange then does not require SELECT privileges on the target table to get the metadata that is required for creating the DB2 load statement.