use_binary_aa

Default: False
Range: True or False

Note: For DB2, do not set this parameter to True. This forces the client to not use the bulk loader for tables that use AA values or RSNs and results in significantly longer data extraction times.

This parameter maps AA values, Parent_AA values, RSNs and DMSII Links to binary(6) or raw(6) instead of char(12) to reduce the storage requirement for AA values (and RSNs) by half.

AA values (and RSNs), which are 48-bit values, are stored in 6 bytes when using binary data, as opposed to 12 bytes when using character data.

The data types used for these columns depend on the value of the sql_type column in the DATAITEMS client control table. The purpose of this parameter is to define how these items are to be mapped by default to avoid changing the sql_type of all such columns.