Unowned LVC cells message clarification [CR 439550]

Three “LVC cells” messages were added to the output of sp_iqcheckdb in Sybase IQ 12.6 ESD #2, but descriptions were not included in the manuals. An example message:

sp_iqcheckdb 'check index EFG2JKL.ASIQ_IDX_T208_C504_FP'
------------------------------------
Index Statistics:
** Inconsistent Index: abcd.EFG2JKL.ASIQ_IDX_T208_C504_FP ****** FP
Indexes Checked: 1
** Unowned LVC Cells: 212 ******

The sp_iqcheckdb messages include:

• Unowned LVC cells

• Duplicate LVC cell rows

• Unallocated LVC cell rows

These messages indicate inconsistencies with a VARCHAR or CLOB column. Unowned LVC cells represent a small amount of unusable disk space and can safely be ignored. Duplicate and Unallocated LVC cells are serious errors that can only be resolved by dropping the damaged columns.

To drop a damaged column, create a new column from a copy of the old column, then drop the original column and alter rename the new column to the old column.