Re: TBLSPACE_STATS parameter
"Carlson@WHSmith" wrote: > mgimbert8769@my-deja.com wrote: > > > > Hello everybody! > > > > Somebody known TBLSPACE_STATS paremeter? > > what is this used for? > > > > Thanks. > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > this parameter allow OnLine to maintain table / object storage > information In v7 onwards at least, "Storage" information (extents, etc) is always maintained. TBLSPACE_STATS, when set to 1, tells Informix to keep "performance" statistics (reads, writes, updates, seq scans, etc) at the Tablespace (table, index) level - for example, sysmaster:sysptprof information. > within the sysmaster database. It is disabled by default, It is actually enabled by default (set to 1 in onconfig.std; enabled if non-existent in one's onconfig file). Rudy
Rudy Fernandes wrote: > > "Carlson@WHSmith" wrote: > > > mgimbert8769@my-deja.com wrote: > > > > > > Hello everybody! > > > > > > Somebody known TBLSPACE_STATS paremeter? > > > what is this used for? > > > > > > Thanks. > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > > > this parameter allow OnLine to maintain table / object storage > > information > > In v7 onwards at least, "Storage" information (extents, etc) is always > maintained. TBLSPACE_STATS, when set to 1, tells Informix to keep > "performance" statistics (reads, writes, updates, seq scans, etc) at the > Tablespace (table, index) level - for example, sysmaster:sysptprof > information. True . . . . a big OOPS on my part. I had forgotten that's the reason why I enabled it -- hot table characteristics for disk placement. > > > within the sysmaster database. It is disabled by default, > > It is actually enabled by default (set to 1 in onconfig.std; enabled if > non-existent in one's onconfig file). > Oops again . . . . must be suffering from a bad brain day today . . . -- John Carlson (I think . . . . 8-) Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */