R
Rob Fitzpatrick
Guest
> The database is proserv'ed with -tablerangesize 900 -indexrangesize 2850 > If I run the following, I get 1215. Let me know what other info you may need. > SELECT COUNT(*) FROM _file I think your -tablerangesize is not high enough. You haven't specified your -basetable/-baseindex so I assume they are set to 1. An empty 11.6.3 database contains 175 _File records. So assuming you don't have extra system records for optional features (e.g. auditing or TDE) then I'd guess you have 1,040 application tables. So with TRS of 900 (assuming -basetable 1) you would be missing stats for at least your uppermost 140 tables ("at least" because there could be gaps in the object numbers). You can set reasonable stats parameter values like this: find last dictdb._file no-lock where _file._tbl-type = "T" use-index _file-number. find last dictdb._index no-lock where not _index._index-name begins "_" use-index _index-number. display "Highest table number: " _file._file-number skip "Highest index number: " _index._idx-num skip with no-labels. Sample output: Highest table number: 468 Highest index number: 904 If you set -basetable to a value other than 1 then set -tablerangesize to (highest table # - basetable + 1). If you set -baseindex to a value other than 1 then set -indexrangesize to (highest index # - baseindex + 1). This approach provides minimum values. I like to pad these numbers by about 20 for tables and 40 for indexes, depending on how often the schema may change online.
Continue reading...
Continue reading...