Home

	Expand Search

Access Service User's Guide DirectConnect for AS/400

Chapter 2 Configuring the DirectConnect Access Service Library

Access service Transfer properties

Access service Transfer properties

These properties control how an access service performs transfer processing. The subsection heading for these properties must appear in the service library configuration file as:

{Transfer}

BulkCommitCount

Specifies the number of rows sent in a bulk transfer before a commit is issued.

Syntax

BulkCommitCount=integer

Range

0-32767

Default

0

Values

integer is the number of rows sent in a bulk transfer.

If the value is 0, the access service issues a commit at the end of the transfer. If the value is non-zero, the access service issues a commit after every n rows. For example, if BulkCommitCount is set to 50, a commit is issued after every 50 rows.

Comments

• The BulkCommitCount property is useful when you make large transfers to Adaptive Server and, as a result, run out of page locks on Adaptive Server. Issuing a commit after every n rows clears the page locks.

• After rows are committed, they cannot be rolled back. Therefore, if you set BulkCommitCount to a non-zero value and a transfer fails, the access service rolls back only the batch containing data since the last commit was issued.

• For more information on bulk transfer, see Chapter 10, "Using Bulk Copy Transfer"

TransferBatch

Specifies how many destination-template transfer statements should be batched in one request.

Syntax

TransferBatch=integer

Range

0-32767

Default

1

Values

integer is a number of destination-template clauses.

If the value is 0, the access service sends all statements that fit in the request buffer.

Comments

• The access service accumulates the designated number of destination templates in its request buffer before executing each request.

• For more information about destination-template transfer, see Chapter 11, "Using Destination-Template Transfer"

TransferErrorCount

Specifies how many error rows are allowed during bulk transfer or destination-template transfer before processing stops.

Syntax

TransferErrorCount=integer

where integer is a number of error rows.

Range

0-32767

Default

0

Values

integer is a number of rows with errors.

A value of 0 means transfers do not stop processing regardless of the number of errors encountered.

Comments

For detailed information about how the TransferErrorCount property affects transfers, see "Controlling processing with TransferErrorCount property" .