问题现象:
DB2 reorg列式存储表报错 SQL1667N
db2 reorg table t1
SQL1667N The operation failed because the operation is not supported with the type of the specified talbe. Specified table: "T1". Table type: "ORGANIZE BY COLUMN". Operation: "REORG TABLE". SQLSTATE=42858
问题解决:
reorg table的时候加上 reclaim extents:
db2 reorg table t1 reclaim extents
参考: