Avoid errors transferring large objects

The IFX_LOB_XFERSIZE environment variable is used to specify the number of bytes in a CLOB or BLOB to transfer from a client application to the database server before checking whether an error has occurred. The error check occurs each time the specified number of bytes is transferred. If an error occurs, the remaining data is not sent and an error is reported. If no error occurs, the file transfer will continue until it finishes.

For example, if the value of IFX_LOB_XFERSIZE is set to 10485760 (10 MB), then error checking will occur after every 10485760 bytes of the CLOB or BLOB is sent. If the IFX_LOB_XFERSIZE environment variable is not set, the error check occurs after the entire BLOB or CLOB is transferred.

The valid range for the IFX_LOB_XFERSIZE environment variable is from 1 to 9223372036854775808 bytes. The IFX_LOB_XFERSIZE environment variable is set on the client.

You should adjust the value of IFX_LOB_XFERSIZE to suit your environment. Set the IFX_LOB_XFERSIZE environment variable low enough so that transmission errors of large BLOB or CLOB data types are detected early, but not so low that excessive network resources are consumed.