Re: sysmaster extents

davin_harvey@dsti.co.uk wrote: > I have a couple of questions on this then > > I've got nothing set for DD_HASHSIZE or DD_HASHMAX. onstat -g dic > reports 357 dictionary entries, but surely the maximum size is 310? > Also, only 14 of these entries are system catalog tables, but surely > if these tables remained in cache, this number would be higher? > > Am I simply missing something obvious here? > Davin > 7.23UC6 on AIX 4.2 At the top of the onstat -g dic report is the line: Dictionary Cache: Number of lists: 31, Maximum list size: 10 ^^ DD_HASHSIZE ^^ DD_HASHMAX It may be that on AIX, which is one of the few platforms with a 4K page size, the default values are other than 31 & 10, check it out. On the rest, you misunderstand! All of those entries for the various tables? Those are each complex data structures containing information from systables, syscolumns, sysindexes, sysdistr, systabauth, syscolauth, sysviews, sysdepend, syssynonyms, syssyntable, sysconstraints, sysreferences, syschecks, sysdefaults, syscoldepend, sysblobs, sysopclstr, systriggers, sysfragments, sysfragauth, and sysviolations. The entries that you see for some of these system tables are the entries for them, because they were actively accessed, probably by a dbaccess>tables>info session, with all of the same information that is being kept for your user tables. To verify this, bring up an engine clean with no users but yourself. Run onstat -g dic it should show an empty data dictionary. Now using the command line option of dbaccess (dbaccess database -) select something from some user table. Exit (CTRL-D,CTRL-D) and run onstat -g dic again and you should see just the entry for that table. Go into dbaccess again and select * from systables. Exit and run onstat -g dic again. Voila! Systables is now in the data dictionary! Art S. Kagel