Kbase 21414: Fathom - Record and Index Activity report displays data only for 50 tables/indexes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Fathom Management 1.0A
Fathom Management 2.x
Fathom Management 3.x
SYMPTOM(s):
Getting "??" on index and table details reports using Fathom
Record and Index Activity report displays data only for 50 tables/indexes
CAUSE:
The information in the Index Details and Record/Table Details can display some values with "??" normally because the information is not available for that Index or Table via the _IndexStat or _TableStat VST tables. The number of indexes and tables that have statistics gathered are influenced by the -basetable, -baseindex, -indexrangesize and -tablerangesize start parameters.
The default for these values is 50. If your Database has more than 50 indexes or more than 50 tables there will be indexes and/or tables that are recognizable as falling outside the range of 50 by the "??" indicating the data is missing. Note that you may not necessarily see all 50 indexes or tables in the Database view as system indexes and tables are not displayed.
FIX:
Change the value of these parameters using Progress Explorer tools. A example, you can change it to:
-basetable 1 -baseindex 1 -indexrangesize 1000 -tablerangesize 1000