Error: "491: Error allocating memory for col_data in de_select_alloc_for_column_data (1161)" duri (4234692)

Error: "491: Error allocating memory for col_data in de_select_alloc_for_column_data (1161)" duri

Error received during Compared:

"491: Error allocating memory for col_data in de_select_alloc_for_column_data (1161)
data = 6800000 bytes
length = 100000 bytes
indicator = 100000 bytes
491: Error 1 calling de_select_alloc_for_column_data in de_batch_setup"

Compare cannot get the amount of memory required to load into memory the number of rows of the table defined be SP_DEQ_BATCHSIZE.

Reduce the batchsize for compare on the source:

1) Make sure compare is not running.

2) sp_ctrl> set param SP_DEQ_BATCHSIZE 1000.

3) Run compare again.

Here is description of SP_DEQ_BATCHSIZE:

This parameter controls the batch size that SharePlex uses for the compare/repair function when the compare config or compare table command is issued. The batch size controls the number of rows that SharePlex selects at once for comparison. Larger batch sizes increase processing speed but require more memory. Memory usage also depends on the number and size of the columns in the table(s) being compared, and the number of compare processes running at the same time.

If the SP_DEQ_BATCHSIZE parameter is larger than the number of rows in the source table being compared, SharePlex reduces the batch size to the number of rows in the table. That prevents SharePlex from allocating more space than it needs for the compare processes. As you gain experience with the compare commands, you might find a more optimal setting for this parameter.

Default: 10,000 rows
Range of valid values: 20 to 32,767 rows (up to the maximum number of rows in the table)
Takes effect: Immediately available for the next comparison

The parameter SP_DEQ_BATCHSIZE has been deprecated in later versions of SharePlex and is replaced by the parameter SP_DEQ_MALLOC. Here is the description of the parameter SP_DEQ_MALLOC: SP_DEQ_MALLOC This parameter controls the fetch batch size. The batch size controls the number of rows that SharePlex selects at once for comparison. Larger batch sizes increase processing speed but require more memory. The value is divided equally by the number of compare threads to be used, and then the batch size is recalculated based on all column sizes added together. Default: 500 (MB) Range of valid values: 50 to 32,767 (MB) Takes effect: Immediately available for the next comparison. Please refer to knowledge base article # 124140 for differences in these two approaches for controlling the batch size of compare/repair.