Re: Monitoring table/index residency in IDS 7.3
kleahy <kleahy@worldvision.org> wrote:
>
> In IDS 7.3 the 'set residency' stmt permits making selected tables or
indexes
> memeory resident. On pg 2-577 of the SQL Guide it mentions being able to
> monitor which tables/indexes are resident and refers to the Admin guide
for
> details. Anybody know where it's mentioned in the Admin guide? I couldn't
> find anything in the Index that seemed relevant nor did a quick look at
> onstat or oncheck reveal anything.
It is in Chapter 11: Shared Memory
page 11-22: Shared-Memory Buffer Pool
Actually it is last column in onstat -t (flag 2000)
You can get that information also from sysmasters
select tabname
from sysptntab p, systabnames n
where p.partnum = n.partnum
and trunc(flags/8192) = 1;
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
--
Vardan Aroustamian
vaar@geocities.com