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
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. 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:32:43 19/02/05.
Enter a command, "QUIT;", "HELP;" or F7 for interactive help: |