Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.