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.
DirkM — — source: Informix-list mailing list archive (1991-1998)
We load some of our tables memory resident using the "set table <tabname>
memory_resident" command.
What I would like to know is, how can I test to see if my command (in a
program) really worked and the table is now in memory.
I tried "onstat -P" and also "onstat -B". The first one show me more tables
resident than the ones I've loaded, which I don't completely understand,
and the second one also shows me resident buffers right at the bottom, but
I can't see if the specific table I loaded is now in memory or not.
Does anyone know how I can check for this ? I would appreciate some help on
this.
Regards
Dirk
↪ replying to DirkM
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
DirkM wrote:
>
> We load some of our tables memory resident using the "set table <tabname>
> memory_resident" command.
> What I would like to know is, how can I test to see if my command (in a
> program) really worked and the table is now in memory.
>
> I tried "onstat -P" and also "onstat -B". The first one show me more tables
> resident than the ones I've loaded, which I don't completely understand,
> and the second one also shows me resident buffers right at the bottom, but
> I can't see if the specific table I loaded is now in memory or not.
>
> Does anyone know how I can check for this ? I would appreciate some help on
> this.
Run onstat -R buffers that are class HIGH are resident table pages.
Art S. Kagel
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.