SYSIBM.SYSTABLES column CARD = -1 for Partioned Tablesgreenspun.com : LUSENET : DBAzine : One Thread |
Why does the column CARD on SYSIBM.SYSTABLES show up as a -1 for tables that are PARTITIONED even after Runstats was done.Is there any reason why DB2 can't use the value of CARD column on SYSIBM.SYSTABLEPART for each PARTITION and update the CARD column on SYSIBM.SYSTABLEPART with total.
An explanation would be appreciated. Thanks. Ed. Majerczak
-- Edward Majerczak (edward_majerczak@nyce.net), January 31, 2002