Properties reference: DB2 connector

The mode to be used when writing to a database table

Type: selection
Default: Insert
Values:
- Insert
- Insert new rows only
- Update
- Delete
- Insert then update
- Update then insert
- Delete then insert
- Bulk load
- User-defined SQL

Specifies whether to generate SQL statements at run time.

Type: boolean
Default: false

The table name to be used in generated SQL

Type: string

Specifies whether or not to enclose database object names in quotes when generating DDL and DML

Type: boolean
Default: false

Specifies the prefix for columns that contain the result of expressions.

Type: string
Default: EXPR
Minimum length: 1
Maximum length: 256

SQL statement properties

Type: category

Direct insert

If set to Yes, the connector insert directly into the target table. In this mode, when running with multiple processing nodes it is possible to have partially committed data if one or more of the processing nodes encounters an error. If set No, the connector inserts into the temporary work table (TWT) first and then from TWT into the target. In this mode the data will either be completely committed or completely rolled back guarantying consistency.

Type: boolean
Default: true

Key columns

A comma-separated list of key column names.

Type: string

Use unique key column

Use Unique key column in UPDATE statement

Type: boolean
Default: false

Unique key column

Unique key column name used in UPDATE statement

Type: string

Update columns

Comma separated list of columns to be updated with UPDATE statement. If no column specified, all columns are updated.

Type: string

Select statement

Statement to be executed when reading rows from the database or the fully qualified name of the file that contains the statement.

Type: string

Read select statement from file

Select YES to read the SELECT statement from the file that is specified in the SELECT statement property.

Type: boolean
Default: false

Where clause

The where clause predicate of the SQL statement

Type: string

Other clause

The other clause predicate of the SQL statement

Type: string

Insert statement

Statement to be executed when inserting rows into the database

Type: string

Update statement

Statement to be executed when updating rows in the database

Type: string

Delete statement

Statement to be executed when deleting rows from the database

Type: string

User-defined SQL

Source of the user-defined SQL statements

Type: selection
Default: Statements
Values:
- Statements
- File

Statements

SQL statements to be executed for each input row

Type: string

File

File on the conductor node that contains SQL statements to be executed for each input row

Type: string
Minimum length: 1
Maximum length: 256

Character set

IANA character set name

Type: string
Minimum length: 1
Maximum length: 256

Fail on error

Abort the statement sequence when an error occurs

Type: boolean
Default: true

Treat warnings as info

Do not abort the job when a DB2 Warning is encountered, report as an information messsage.

Type: boolean
Default: false

Enable partitioned reads

Enable or disable partitioned reads by using the selected partitioning method.

Type: boolean
Default: false

Partitioned reads method

The method to use for partitioned reads.

Type: selection
Default: Minimum and maximum range
Values:
- Modulus
- Minimum and maximum range
- DB2 connector

For more information, see the Reading partitioned data topic.

Table name

Specifies the table that is used by the selected partitioned reads method.

Type: string

Column name

Specifies the key column that is used by the selected partitioned reads method. This column must be a numeric data type.

Type: string
Minimum length: 1
Maximum length: 256

Generate partitioning SQL

Specifies whether the connector should modify the SELECT statement at run-time and generate the required partitioning clause

Type: boolean
Default: true

Select the action to perform on the database table

Type: selection
Default: Append
Values:
- Append
- Create
- Replace
- Truncate

Generate create statement at runtime

Specifies whether to generate a create table statement at runtime

Type: boolean
Default: true

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

Read create statement from file

Select YES to read the CREATE statement from the file that is specified in the CREATE statement property.

Type: boolean
Default: false

Target table on Db2 for z/OS

Determines whether the target table is on Db2 LUW or Db2 for z/OS.

Type: boolean
Default: false

In

Identifies the database and/or table space in which the table is created: IN database-name.table-space-name. On Db2 LUW if required add CYCLE / NO CYCLE indication.

Type: string

Index in

Specifies the table space in which indexes or long column values are to be stored (Db2 LUW only).

Type: string

Buffer pool

Specifies the buffer pool be use for the implicitly created table space and determines the page size of the table space. Do not specify BUFFERPOOL if the table space name is specified by using the IN table-space-name clause or the IN ACCELERATOR clause is specified. If you do not specify the BUFFERPOOL clause, Db2 selects the buffer pool as described in Implicitly defined table spaces (Db2 for z/OS only).

Type: string

Organize by

Specifies how the data is organized in the data pages of the table: row-organized table / column-organized table (Db2 LUW only).

Type: selection
Default: Database default
Values:
- Database default
- Row
- Column

Distribute by

Specifies the database partitioning or the way the data is distributed across multiple database partitions (Db2 LUW only).

Type: selection
Default: None
Values:
- None
- Hash
- Random

Key columns

A comma-separated list of key column names.

Type: string

Compress

Specifies whether data compression applies to the rows. On DB2 for z/OS: if the IN table-space-name clause or the IN ACCELERATOR clause is specified, COMPRESS YES or COMPRESS NO must not be specified.

Type: selection
Default: Database default
Values:
- Database default
- No
- Yes

Type

Specifies whether adaptive compression or classic row compression is used (Db2 LUW only).

Type: selection
Default: Adaptive
Values:
- Adaptive
- Static

Value compression

This determines the row format that is to be used. Each data type has a different byte count depending on the row format that is used (Db2 LUW only).

Type: boolean
Default: false

Other options

Other options/clauses to the CREATE TABLE statement eg. Partitioning-clause.

Type: string
Minimum length: 0
Maximum length: 512

Create statement

A statement to be executed when creating the target database table

Type: string

Generate drop statement at runtime

Specifies whether to generate a drop table statement at runtime

Type: boolean
Default: true

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

Read drop statement from file

Select YES to read the DROP statement from the file that is specified in the DROP statement property.

Type: boolean
Default: false

Drop statement

A statement to be executed when dropping the database table

Type: string

Generate truncate statement at runtime

Specifies whether to generate a truncate table statement at runtime

Type: boolean
Default: true

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

Read truncate statement from file

Select YES to read the TRUNCATE statement from the file that is specified in the TRUNCATE statement property.

Type: boolean
Default: false

Truncate statement

A statement to be executed when truncating the database table

Type: string

Perform table action first

Select Yes to perform table action first. Select No to run Before SQL statements first.

Type: boolean
Default: true

Transaction properties

Type: category

Record count

Number of records per transaction. The value 0 means all available records

Type: integer
Default: 2000
Minimum: 0
Maximum: 999999999

Time Commit Interval

Specify the amount of time to pass before a commit is issued. If you set a small value you force frequent commits and therefore if your program terminates unexpectedly, your table can still contain partial results. However, you may pay a performance penalty because of the high frequency of commits. If you set a large value, DB2 must log a correspondingly large amount of rollback information which may also slow your job.

Type: integer
Default: 0
Minimum: 0

End of wave

Specify settings for the end of wave handling. None means EOW markers are never inserted, Before means EOW markers are inserted before committing the transaction, After means EOW markers are inserted after committing the transaction

Type: selection
Default: None
Values:
- None
- Before
- After

End of data

Specifies whether to insert an EOW marker for the last set of records when the number is less than the specified transaction record count value

Type: boolean
Default: false

Transaction grouping allows operations on multiple links to be executed within a single transaction.

Type: boolean
Default: false

Transaction grouping settings

Type: category

Action on skip

The action to be taken when a link is skipped

Type: selection
Default: Continue
Values:
- Continue
- Rollback

Action on failure

The action to be taken when a failure occurs on a link

Type: selection
Default: Rollback
Values:
- Continue
- Rollback

Session properties

Type: category

Isolation level

Specifies the isolation level that is used for all database transactions.

Type: selection
Default: Cursor stability
Values:
- Read uncommitted
- Cursor stability
- Read stability
- Repeatable read

Auto commit mode

Specifies whether the connector commits transactions manually, or allows the database to commit transactions automatically at its discretion.

Type: selection
Default: Off
Values:
- Off
- On

Array size

The array size to be used for all read and write database operations

Type: integer
Default: 2000
Minimum: 1

Schema reconciliation

Properties that affect schema reconciliation

Type: category

Fail on size mismatch

Fail if the sizes of numeric and string fields are not compatible when validating the design schema against the database

Type: boolean
Default: true

Fail on type mismatch

Fail if the types of fields are not compatible when validating the design schema against the database

Type: boolean
Default: true

Drop unmatched fields

Drop fields that don't exist in the input schema

Type: boolean
Default: true

Fail on row error

Fail the job if a write operation to the target is unsuccessful

Type: boolean
Default: true

Fail on row error

Fail the job if a write operation to the target is unsuccessful

Type: boolean
Default: false

Enable LOB references

Enables/disables the ability to specify LOB columns to be passed using locator (reference) information. LOB columns not specified will be passed inline

Type: boolean
Default: false

Columns

Use to choose columns containing LOBs to be passed by locator (reference)

Type: string

Log multiple matches

Specifies the type of message logged when the lookup query returns more than one match for a set of keys

Type: selection
Default: None
Values:
- None
- Informational
- Warning
- Fatal

Insert buffering

Specifies whether to enable the insert buffering optimization in partitioned database environments.

Type: selection
Default: Default
Values:
- Default
- Off
- On
- Ignore duplicates

Atomic arrays

Specifies whether arrays should be inserted atomically. Insert buffering with non-atomic arrays does not report errors accurately.

Type: selection
Default: Auto
Values:
- Auto
- No
- Yes
- Simulated

Temporary work table mode

If set to Automatic, the connector will automatically create the temporary work table using an internally generated name.

Type: selection
Default: Automatic
Values:
- Automatic
- Existing

Table name

The name of the existing temporary work table.

Type: string

Truncate table

If set to Yes, the temporary work table is truncated before any data is written to it.

Type: boolean
Default: false

Drop table

If set to Yes, the connector will drop the temporary work table.

Type: boolean
Default: true

Use external tables

Indicates whether external tables are used.

Type: boolean
Default: false

Maximum reject count

The number of rejected records at which the system stops processing and immediately rolls back the load. The default is 1 (that is, a single rejected record results in a rollback)

Type: integer
Default: 1
Minimum: 1
Maximum: 2147483647

Directory for named pipe (Unix only)

Specifies the location where the named pipe used by the load operation should be created. This property applies to Unix systems only.

Type: string
Default: /tmp
Minimum length: 1
Maximum length: 512

Directory for log files

Specifies the directory for the log and bad files. If it is left blank, the connector will use the value of the environment variable TMPDIR. If TMPDIR is not defined, it will default to /tmp on Unix and to system temporary directory on Windows.

Type: string
Minimum length: 1
Maximum length: 512

Other options

Additional options to be passed to the external table statement

Type: string
Minimum length: 0
Maximum length: 512

Statistics

Instructs load to collect statistics during the load according to the profile defined for this table (STATISTICS).

Type: boolean
Default: false

Statistics on columns

Generates statistics on the columns. If no column specified, statistics are collected on all columns by default.

Type: string

Properties that affect logging

Type: category

Log column values on first row error

Specifies whether to log column values for the first row that fails to be written

Type: boolean
Default: false

Log key values only

Specifies whether to log key columns or all columns for failing statements

Type: boolean
Default: false

Column delimiter

Specifies the delimiter to use between columns

Type: selection
Default: Space
Values:
- Space
- Newline
- Tab
- Comma

Before/After SQL properties

Type: boolean
Default: false

Before SQL

Enter the SQL statement or the fully-qualified name of the file that contains the SQL statement to run once before any data is processed.

Type: string

Read Before SQL statement from file

Select Yes to read the SQL statement from the file that is specified in the Before SQL statement property.

Type: boolean
Default: false

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

After SQL

Enter the SQL statement or the fully-qualified name of the file that contains the SQL statement to run once after all data is processed.

Type: string

Read After SQL statement from file

Select Yes to read the SQL statement from the file that is specified in the After SQL statement property.

Type: boolean
Default: false

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

Before SQL (node)

Enter the SQL statement or the fully-qualified name of the file that contains the SQL statement to run once on each node before any data is processed on that node.

Type: string

Read Before SQL (node) statement from file

Select Yes to read the SQL statement from the file that is specified in the Before SQL (node) statement property.

Type: boolean
Default: false

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

After SQL (node)

Enter the SQL statement or the fully-qualified name of the file that contains the SQL statement to run once one each node after all data is processed on that node.

Type: string

Read After SQL (node) statement from file

Select Yes to read the SQL statement from the file that is specified in the After SQL (node) statement property.

Type: boolean
Default: false

Fail on error

Abort the job if there is an error executing a command

Type: boolean
Default: true

Determines how records should be ordered across multiple links.

Type: selection
Default: All records
Values:
- All records
- First record
- Ordered

Key column

A column to be used for sorting.

Type: category
Default: false

Column name

The name of a column to be used for sorting.

Type: string

Sort order

Specifies whether sorting should be in ascending or descending order.

Type: selection
Default: Ascending
Values:
- Ascending
- Descending

Null order

Specifies whether null values should appear before or after non-null values.

Type: selection
Default: Before
Values:
- Before
- After

Case sensitive

Specifies whether strings should be compared using a case sensitive or insensitive comparison.

Type: boolean
Default: false

Specifies the type of reoptimization that is done by DB2.

Type: selection
Default: None
Values:
- None
- Once
- Always

Specifies the lock wait strategy that is used when a lock cannot be obtained immediately.

Type: selection
Default: Use the lock timeout database configuration parameter
Values:
- Return an SQLCODE and SQLSTATE
- Use the lock timeout database configuration parameter
- Wait indefinitely
- User specified

Lock wait time

Time to wait for a lock

Type: integer
Minimum: 1
Maximum: 32767

Specifies the pad character that is used in the WHERE clause for string columns that are smaller than the column size.

Type: string
Minimum length: 1
Maximum length: 256

By default the connector runs one player process per database partition. If you want to force the connector to run fewer player processes, set this property to Yes

Type: boolean
Default: false

Total number of player processes

The total number of player processes across all processing nodes.

Type: integer
Minimum: 1

Determines whether the target table is on DB2 for z/OS.

Type: boolean
Default: false

Load method

Load method to be used for loading input data into DB2 for z/OS.

Type: selection
Default: MVS dataset(s)
Values:
- MVS dataset(s)
- Batch pipe(s)
- USS pipe(s)

Transfer

Transfer properties

Type: category

Transfer type

Determines the method of transferring data to the z/OS machine.

Type: selection
Default: ftp
Values:
- ftp
- sftp
- lftp

Transfer to

Name of the target machine to which the data is sent.

Type: string
Minimum length: 1
Maximum length: 256

User

Determines the user name for transferring.

Type: string
Minimum length: 1
Maximum length: 256

Password

Determines the password for transferring.

Type: protected string
Minimum length: 1
Maximum length: 256

Directory for data files

Specifies the location where the data files will be created before transfer to z/OS.

Type: string
Minimum length: 1
Maximum length: 4096

HFS file directory

The presence of this option indicates that HFS files is to be used and gives the directory name where the files will be created. The value should be a fully qualified HFS directory name.

Type: string
Minimum length: 1
Maximum length: 512

Transfer command

User-entered command sent just before data transfer begins. FTP example: quote site vcount=7 datakeepalive=60

Type: string
Minimum length: 1
Maximum length: 2000

Retry on connection failure

Select Yes to try to establish a connection again when the initial attempt to connect is unsuccessful.

Type: boolean
Default: true

Number of retries

Enter the number of times to try to establish a connection after a failure on the initial attempt.

Type: integer
Default: 3
Minimum: 1
Maximum: 999999999

Interval between retries

Enter the time in seconds to wait between retries to establish a connection.

Type: integer
Default: 10
Minimum: 1
Maximum: 999999999

DSN prefix

This option identifies a prefix to be used when creating MVS dataset names. If omitted, the transfer user name is used.

Type: string
Minimum length: 1
Maximum length: 256

Batch pipe system ID

If the data is to be transferred to a Batch pipes system on z/OS, this option identifies its name.

Type: string
Minimum length: 1
Maximum length: 256

USS pipe directory

The presence of this option indicates that USS piping is to be used and gives the directory name where the pipes will be created. The value should be a fully qualified USS directory name.

Type: string
Minimum length: 1
Maximum length: 512

File(s) only

LOAD will not actually be executed, only MVS datasets are created.

Type: boolean
Default: false

Device type

This option specifies the device type to be used for various datasets that the LOAD utility may need. If omitted, the default is SYSDA.

Type: string
Default: SYSDA
Minimum length: 1
Maximum length: 8

Partition number

If this option is present, then only the indicated partition will be loaded. If this option is omitted, all partitions of the DB2 for z/OS database table will be loaded.

Type: integer
Minimum: 1

Row count estimate

This option specifies an estimated count of the total number of rows to be loaded into all partitions combined. This estimate is used to calculate the amount of disk space which will be needed on z/OS for various datasets. If not present, a row estimate of 1000 is used.

Type: integer
Default: 1000
Minimum: 0

Statistics

This option requests that statistics be displayed at the end of the load.

Type: selection
Default: None
Values:
- None
- All
- Index
- Table

Utility ID

This is a unique identifier within DB2 for the execution of the LOAD utility. The default value is DB2ZLOAD.

Type: string
Default: DB2ZLOAD
Minimum length: 1
Maximum length: 16

Concurrent access level

Level of application's concurrent access to the table space or partition. Parameter's value corresponds to SHRLEVEL option of LOAD command.

Type: selection
Default: NONE
Values:
- NONE
- REFERENCE
- CHANGE

Keep existing records in table space

Select Yes to add records to the end of the table if the table space is not empty or No to load data into an empty table space. The value corresponds to the RESUME option value in the LOAD command.

Type: boolean
Default: true

Load with logging

Indicates whether logging is to occur during the load process.

Type: boolean
Default: false

Set copy-pending

Specifies whether or not the table space is set to the copy-pending status. (Applicable only when Load with logging = No)

Type: boolean
Default: false

Encoding

Specifies the input dataset encoding

Type: selection
Default: EBCDIC
Values:
- EBCDIC
- ASCII
- UNICODE
- CCSID

Character set

The IANA character set name for the encoding. If not specified, ibm-1047-s390 will be used for EBCDIC, ASCII for ASCII, and UTF-16BE for UNICODE.

Type: string
Minimum length: 1
Maximum length: 256

Graphic character set

The IANA character set name for the graphic encoding. If not specified, UTF-16BE is the default.

Type: string
Minimum length: 1
Maximum length: 256

CCSID

Specifies the coded character set identifier (CCSID) for SBCS data, Mixed data, and DBCS data in the input file.

Type: string
Minimum length: 1
Maximum length: 256

Image-copy function

Specifies whether to run an Image-copy function after Load

Type: selection
Default: No
Values:
- No
- Full
- Concurrent
- Incremental

Scope

Scope of the image-copy

Type: selection
Default: Full
Values:
- Full
- Single partition

Image-copy file

Image-copy file attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Image-copy backup file

Specifies whether or not to create a backup of the image-copy file

Type: boolean
Default: false

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Recovery file

Specifies whether or not to create the image-copy recovery file

Type: boolean
Default: false

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Recovery backup file

Specifies whether or not to create a backup of the image-copy recovery file

Type: boolean
Default: false

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Change limit percent 1

Specifies the percentage limit of changed pages in the table space at which an incremental image-copy is to be taken

Type: integer
Minimum: 1
Maximum: 100

Change limit percent 2

Specifies the percentage limit of changed pages in the table space at which an incremental image-copy is to be taken

Type: integer
Minimum: 1
Maximum: 100

Report only

Run utility to produce report only

Type: boolean
Default: false

System pages

Specifies whether the copy utility puts system pages at the beginning of the image-copy file

Type: boolean
Default: true

Allow changes

Indicates whether other programs can update the table space while COPY is running

Type: boolean
Default: false

Data file attributes

Data file attributes

Type: category

Input data file(s)

Input data file attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Discard dataset

Discard dataset attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Error dataset

Error dataset attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Map dataset

Map dataset attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Work1 dataset

Work1 dataset attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Work2 dataset

Work2 dataset attributes

Type: category

Dataset name

Dataset name used by the Load utility. If empty (default), then a dataset name is generated using the DSN prefix property.

Type: string
Minimum length: 1
Maximum length: 256

Number of buffers

Specifies the number of buffers to use (BUFNO). If empty (default), then the property is not used.

Type: integer
Minimum: 1
Maximum: 99

Unit

Specifies the device number, device type (generic), or group name for the data set (UNIT). If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

Data class

Specifies the SMS data class (DATACLAS). The name must be a valid SMS data class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Management class

Specifies the SMS management class (MGMTCLAS). The name must be a valid SMS management class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Storage class

Specifies the SMS storage class (STORCLAS). The name must be a valid SMS storage class and must not exceed 8 characters in length. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 8

Volume(s)

Specifies a list of volume serial numbers for this allocation (VOLUMES(?)). The value or list of values may be entered by the user with or without enclosing parentheses. In the TEMPLATE statement, however, the parentheses are required. So, if the user does not enter them, the syntax generator should add them. The value for this property is a comma-separated list of string values. If empty (default), then the property is not used.

Type: string
Minimum length: 1
Maximum length: 256

File disposition

File disposition properties

Type: category

Space type

Specifies the z/OS disk space allocation unit type (SPACE(?,?)). Valid values are Cylinders (CYL) and Tracks (TRK). The default value is Cylinders.

Type: selection
Default: Cylinders
Values:
- Cylinders
- Tracks

Primary allocation

Specifies the z/OS disk space primary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Secondary allocation

Specifies the z/OS disk space secondary allocation amount. The range of values is from 1 to 1677215. If empty (default), then its value equals computed (from the row estimate) space requirements in cylinders or tracks, respectively to Space type setting. For Map dataset, the resulting value is doubled.

Type: integer
Minimum: 1
Maximum: 1677215

Specifies the properties that control the bulk load operations.

Type: category

[deprecated] Use External Tables

Indicates whether external tables are used.

Type: boolean
Default: false

[deprecated] Compress file data

Indicates whether the External Table file data is compressed before the data is transferred, and is decompressed after it is received. This improves overall performance when a large amount of compressible data is being transferred.

Type: boolean
Default: false

Compression algorithm

Determines the compression algorithm of external table file data.

Type: selection
Default: GZIP
Values:
- GZIP
- LZ4

[deprecated] Maximum reject count

The number of rejected records at which the system stops processing and immediately rolls back the load. The default is 1 (that is, a single rejected record results in a rollback)

Type: integer
Default: 1
Minimum: 0

[deprecated] Skip rows

For a load operation, the number of rows to skip before beginning to load the data. The default is 0. Because skipped rows are processed before they are skipped, a skipped row is still capable of causing a processing error.

Type: integer
Default: 0
Minimum: 0

[deprecated] Other options

Additional options to be passed to the external table statement

Type: string
Minimum length: 0
Maximum length: 512

[deprecated] Directory for log files

Specifies the directory for the log and bad files. If it is left blank, the connector will use the value of the environment variable TMPDIR. If TMPDIR is not defined, it will default to /tmp on Unix and to system temporary directory on Windows.

Type: string
Minimum length: 1
Maximum length: 512

Load mode

Specifies the mode where the load operates.

Type: selection
Default: Insert
Values:
- Insert
- Replace
- Restart
- Terminate

Restart phase

Specifies which DB2 load phase is to be restarted. The original input data needs to be reproduced for restarting the Load phase. Build and Delete phases ignore the input data.

Type: selection
Default: Load
Values:
- Load
- Build
- Delete

Bulk load with LOB or XML column(s)

Indicates whether there are any LOB or XML columns in the target DB2 table.

Type: boolean
Default: false

Load method

Determines the load method to use.

Type: selection
Default: Named Pipe(s)
Values:
- Sequential File(s)
- Named Pipe(s)

Exception table name

Name of tables where rows that violate constraints will be stored.

Type: string
Minimum length: 1
Maximum length: 512

Load timeout

Specifies the time in seconds to attempt opening a socket for the load operation before timing out.

Type: integer
Default: 300
Minimum: 0

File(s) only

Indicates whether input files should be created without executing the load operation.

Type: boolean
Default: false

Directory for data and command files

Specifies the location where the command file and data file (used by the load operation) should be created.

Type: string
Minimum length: 1
Maximum length: 512

Remove intermediate data file

Select Yes to remove the intermediate data file after completing the load operation.

Type: boolean
Default: true

File type

Specifies the format of the data in the data file.

Type: selection
Default: ASC
Values:
- ASC
- DEL

Lob Path List

A list of fully qualified paths or devices to identify the location of the individual LOB files to be loaded.

Type: string
Minimum length: 1
Maximum length: 512

Without prompting

Select Yes to add the WITHOUT PROMPTING parameter to the LOAD command in the generated command file.

Type: boolean
Default: false

Directory for named pipe (Unix only)

Specifies the location where the named pipe used by the load operation should be created. This property applies to Unix systems only.

Type: string
Default: /tmp
Minimum length: 1
Maximum length: 512

File type modifiers

Specifies the modifiers used with the \'MODIFIED BY\' keyword of the DB2 load utility

Type: category

Dump file

Specifies a fully qualified file path to use with the \'dumpfile\' file type modifier. If no path is specified, the \'dumpfile\' modifier is not used

Type: string
Minimum length: 1
Maximum length: 512

Clean-up on failure

Clean-up on failures during stage execution.

Type: boolean
Default: false

Save count

Specifies the number of records to load before establishing a consistency point.

Type: integer
Default: 0
Minimum: 0

Warning count

Specifies the number of warnings that are allowed before the load operation stops.

Type: integer
Default: 0
Minimum: 0

Row Count

The number of physical records to be loaded. Allows a user to load only the first rowcnt rows in a file.

Type: integer
Default: 0
Minimum: 0

Message file

Specifies the file where DB2 writes diagnostic messages.

Type: string
Default: loadMsgs.out
Minimum length: 1
Maximum length: 256

Temporary files directory

Specifies the path name that is used by the DB2 server to store temporary files.

Type: string
Minimum length: 1
Maximum length: 512

Statistics

Instructs load to collect statistics during the load according to the profile defined for this table (STATISTICS).

Type: boolean
Default: false

[deprecated] Statistics on columns

Generates statistics on the columns. If no column specified, statistics are collected on all columns by default.

Type: string

Non-recoverable load

The load transaction is marked as non-recoverable.

Type: boolean
Default: false

Copy loaded data

Specifies the method that is used for making a copy of the loaded data.

Type: selection
Default: No copy
Values:
- No copy
- Use device or directory
- Use shared library
- Use Tivoli to make a copy

Loaded data copy location

A comma-separated list of devices or directories where the copy is generated.

Type: string
Minimum length: 1
Maximum length: 512

Library used to copy

Specifies the name of the library that is used to generate the copy.

Type: string
Minimum length: 1
Maximum length: 256

Data buffer size

Specifies the number of pages (size 4KB) that are used as buffered space for transferring data within the load utility.

Type: integer
Default: 0
Minimum: 0

Sort buffer size

Specifies the number of pages (size 4KB) of memory that are used for sorting index keys during a load operation.

Type: integer
Default: 0
Minimum: 0

CPU parallelism

Specifies the number of processes or threads that the load utility spawns for processing records.

Type: integer
Default: 0
Minimum: 0

Disk parallelism

Specifies the number of processes or threads that the load utility spawns for writing data.

Type: integer
Default: 0
Minimum: 0

Indexing mode

Specifies whether indexes are rebuilt or extended incrementally.

Type: selection
Default: Automatic selection
Values:
- Automatic selection
- Rebuild table indexes
- Extend existing indexes
- Do not update table indexes

Allow access mode

Specifies the level of access on the table that is to be loaded.

Type: selection
Default: No access
Values:
- No access
- Read

Name of table space

Specifies the table space that is used for building a shadow copy of the index if the indexes are being rebuilt.

Type: string
Minimum length: 1
Maximum length: 256

Check pending cascade

Specifies whether the check pending state of the loaded table is immediately cascaded to all descendants.

Type: selection
Default: Deferred
Values:
- Immediate
- Deferred

Lock with force

If selected, the load operation forces off other applications that hold conflicting locks.

Type: boolean
Default: false

Partitioned database configuration

If selected, data is loaded into a partitioned table.

Type: boolean
Default: false

Output partition numbers

List of database partition numbers (OUTPUT_DBPARTNUMS). The database partition numbers represent the database partitions on which the load operation is to be performed. Items in the list must be separated by commas.

Type: string
Minimum length: 1
Maximum length: 256

Partitioning partition numbers

List of database partition numbers that are used in the distribution process (PARTITIONING_DBPARTNUMS). Items in the list must be separated by commas.

Type: string
Minimum length: 1
Maximum length: 256

Maximum partitioning agents

Specifies the maximum number of partitioning agents to be used in a load session (MAX_NUM_PART_AGENTS).

Type: integer
Default: 25
Minimum: 1

Isolate partition errors

Specifies the reaction of the load operation to errors that occur on individual partitions (ISOLATE_PART_ERRS).

Type: selection
Default: Load errors only
Values:
- Setup errors only
- Load errors only
- Setup and load errors
- No isolation

Status interval

Specifies the number of megabytes of data to load before generating a progress message (STATUS_INTERVAL).

Type: integer
Default: 100
Minimum: 1
Maximum: 4000

Port range

Specifies the range of TCP ports that are used to create sockets for internal communications (PORT_RANGE).

Type: boolean

Lower port number

Lower port number of the port range

Type: integer
Minimum: 0
Maximum: 65535

Higher port number

Higher port number of the port range

Type: integer
Minimum: 0
Maximum: 65535

Check truncation

If selected, data records are checked for truncation at input and output (CHECK_TRUNCATION).

Type: boolean
Default: false

Trace

Specifies the number of records to trace in a dump of the data conversion process and the output of the hashing values (TRACE).

Type: integer
Default: 0
Minimum: 0

Partitioned distribution file

If this option is specified, the load utility generates a database partition distribution file with the given name (DISTFILE).

Type: string
Minimum length: 1
Maximum length: 256

Partition collecting statistics

Specifies the database partition where statistics are collected (RUN_STAT_DBPARTNUM).

Type: integer
Default: -1
Minimum: -1
Maximum: 32767

Select Yes to limit the number of rows that are returned by the connector.

Type: boolean
Default: false

Limit

Enter the maximum number of rows that will be returned by the connector.

Type: integer
Default: 1000
Minimum: 1

Properties reference: DB2 connector

Connection

Usage