Re: What's in my buffers script

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.08.22.14.29.29.722621.10594@bloomberg.net>... > On Fri, 22 Aug 2003 11:18:08 -0400, Kristofer Andersson wrote: > > Yup, my 9.4 wasn't up when I tested the script. New version with an > option to filter out the TBLSpace entries. Also now works for all > versions of IDS through 94. and with either dbaccess or sqlcmd. Thanks. What is TBLSpace and what are those entries with numeric names for tabname (678_1234 etc)? Kristofer

On Sun, 24 Aug 2003 17:06:42 -0400, Kristofer Andersson wrote: The entries with 'tablename' "TBLSpace" are the Tablespace entries or partition headers for the tables, detached indexes, and fragments contained in each dbspace. In the latest version of the script that I posted the '-t' option filters out these entries, only listing real partitions (see the '-h' option for usage). As to the numeric 'tablenames' I'd guess these are the partitions for detached indexes created by constraints and actually have a leading space character that is hard to see in the report. Art S. Kagel > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:<pan.2003.08.22.14.29.29.722621.10594@bloomberg.net>... >> On Fri, 22 Aug 2003 11:18:08 -0400, Kristofer Andersson wrote: >> >> Yup, my 9.4 wasn't up when I tested the script. New version with an >> option to filter out the TBLSpace entries. Also now works for all >> versions of IDS through 94. and with either dbaccess or sqlcmd. > > Thanks. > > What is TBLSpace and what are those entries with numeric names for > tabname (678_1234 etc)? > > Kristofer