50 DB2 Nuggets #36 : Tech Tip - Blu Conversion May Fail on Some Tables

Body

When trying to convert your database to BLU. You may see that some tables fail. This can be seen like this. 

In the progress of the convert utility. The below will be seen.

Table RowsNum RowsComm Status Progress (%)
--------------------------------------- --------------- --------------- --------------- ---------------
"TANJINXU"."ACT" 18 0 COPY Failed

This is caused by the utility heap size. The convert utility utilizes the admin move table function. If the utility heap size is not sufficient then the conversion will fail.

If the convert utility fails then the utility heap size is the reason for the failure.

The real error can be seen by invoking the admin move table function.

---ADMIN_MOVE_TABLE failed for table "TANJINXU"."ACT" with error message below---
CALL SYSPROC.ADMIN_MOVE_TABLE('TANJINXU','ACT','','','','ORGANIZE BY COLUMN','','-','','COPY_USE_LOAD,NOT_ENFORCED','COPY')
SQL3011C There is not enough storage to process the command. SQLSTATE=HY00

To resolve this you can inncrease the utility heap size.

db2 update db cfg using UTIL_HEAP_SZ <value>

Or set it to automatic. 

Then reissue the command. The conversion should complete without error.