Re: sysmaster slow

Floyd Wellershaus wrote: > --0-1611837224-1106318424=:47941 > Content-Type: text/plain; charset=us-ascii > > HI Art, > >>>Anyway, you can move the temp table IO's off root by adding one or more > > of the non-temp dbspaces to DBSPACETEMP. << > > I am not sure I know what you mean here. move NON-temp dbspaces to DBSPACETEMP ? > btw, I have 3 dbspaces listed in dbspacetemp. DBSPACETEMP can contain both dbspaces marked as temp (ie created with the -t option to onspaces) and those that are 'normal' dbspaces. The engine knows which is which and will use the listed temp dbspaces to locate non-logged temp tables (ie those created explicitly with the WITH NO LOG clause). The engine will also locate logged temp tables in 'normal' dbspaces if any are listed in DBSPACETEMP, if all of the listed dbspaces are 'temp' spaces then the engine must locate logged temp tables in ROOTDBS. > Onstat -g ppf gets output for me, so I assume the tablestats are on. That is neat. Does it tell you io per table ? Where can I read more about that ? for instance, how do I know what tablename is by the partnum ? See Tsutomu's response for this query. Art S. Kagel > Thanks. > > "Art S. Kagel" <KAGEL@bloomberg.net> wrote: > Floyd Wellershaus wrote: > > As Martin pointed out, logged temp tables (including those created by an > INTO TEMP clause) are created in ROOTDB if there are not 'regular' dbspaces > listed in DBSPACETEMP, however, given the low number of writes on the two > chunks prod_root_c[12], I'd say that's not the problem, nor is logical log > IO. Anyway, you can move the temp table IO's off root by adding one or more > of the non-temp dbspaces to DBSPACETEMP. I agree with Martin that you > should turn on table level stats if not on already and monitor onstat -g ppf. > <SNIP> Art S. Kagel sending to informix-list