skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The DB2 Wire Protocol Driver : Connection Option Descriptions : Bulk Binary Threshold
  
Bulk Binary Threshold
Attribute
BulkBinaryThreshold (BBT)
Purpose
The maximum size, in KB, of binary data that is exported to the bulk data file.
Valid Values
-1 | 0 | x
where:
x
is an integer that specifies the number of KB.
Behavior
If set to -1, all binary data, regardless of size, is written to the bulk data file, not to an external file.
If set to 0, all binary data, regardless of size, is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
If set to x, any binary data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
Default
32
GUI Tab
Bulk tab