7517: Data count does not match the LOB count

Problem:

Table: "PRDLMDMERCHANDISINGT"."R_MODEL" checking at 10:59:05 19/02/05.

Table id 01EAH 311BH, Database id 0000H 0C3AH, Non-fallback.

7517: Data count does not match the LOB count.

AMP 00023, Primary subtable 1024 (400H)

LOB id 1, Subtable 1792 (700H)

3 too many LOB rows

Table Result: Error(s) reported

Solution:

# Method One

> Drop the problematic tables and restore them from a good backup.

# Method Two

Perform the following steps for each affected table.

1. Create a temp table with same DDL as the problem table.

2. INS-SEL into the new table.

3. Run the checktable on temp table. If no errors, proceed to next steps.

4. Drop the problem table.

5. Rename temp table to the problem table.

6. Run checktable on the above renamed table to confirm no further errors.

Example:

CREATE TABLE PRDLMDMerchandisingT.R_Model_TMP AS PRDLMDMerchandisingT.R_Model WITH DATA;

> CHECK "PRDLMDMERCHANDISINGT"."R_MODEL_TMP" AT LEVEL ONE;

CHECK "PRDLMDMERCHANDISINGT"."R_MODEL_TMP" AT LEVEL ONE;

Checktable defaults to concurrent mode

on non-quiescent system with logons enabled.

Check beginning at 11:28:25 19/02/05.

CHECKTABLE will run from Host: 0 Session: 2252,54154

Table: "PRDLMDMERCHANDISINGT"."R_MODEL_TMP" starting at 11:28:26 19/02/05.

Table id 029DH 56EFH, Database id 0000H 0C3AH, Non-fallback.

Table Result: No errors

Summary:

1 table(s) checked.

0 fallback table(s) checked.

1 non-fallback table(s) checked.

0 table(s) failed the check.

Check completed at 11:28:26 19/02/05.

DROP TABLE PRDLMDMerchandisingT.R_Model;

Rename table R_Model_TMP To R_Model;

> CHECK "PRDLMDMERCHANDISINGT"."R_MODEL" AT LEVEL ONE;

CHECK "PRDLMDMERCHANDISINGT"."R_MODEL" AT LEVEL ONE;

Checktable defaults to concurrent mode

on non-quiescent system with logons enabled.

Check beginning at 11:32:43 19/02/05.

CHECKTABLE will run from Host: 0 Session: 2252,54157

Table: "PRDLMDMERCHANDISINGT"."R_MODEL" starting at 11:32:43 19/02/05.