IFX_LOB_XFERSIZE environment variable

Use the IFX_LOB_XFERSIZE environment variable to specify the number of bytes in a CLOB or BLOB data type 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 data is sent. If IFX_LOB_XFERSIZE is not set, the error check occurs after the entire BLOB or CLOB data is transferred.

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

Read syntax diagramSkip visual syntax diagram
>>-setenv--IFX_LOB_XFERSIZE--value-----------------------------><

value
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

You should adjust the value of IFX_LOB_XFERSIZE to suit your environment. Set IFX_LOB_XFERSIZE 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 used.


Copyright© 2018 HCL Technologies Limited