Oninit cdi / Archive
Talk to an expert →

RE: Memory resident tables

Posted in 2004

Topics: Platform-Specific Issues, Versions, Editions & End-of-Life

Gustavo Tobares — — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C4E77E.F198B930 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some tables memory resident and monitored with onstat -b and I believe with have enough buffers to put some others tables, my question is: Can I put memory resident tables like systables? Sysdistrib? Or they are in "buffer" by the continuos usage? They are some trouble to put many tables memory resident?? I hope with someone can help me, thanks a lot!!! Gustavo Tobares ------_=_NextPart_001_01C4E77E.F198B930 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.45"> <TITLE>RE: Memory resident tables</TITLE> </HEAD> <BODY> <BR> <BR> <P><FONT SIZE=3D2>Hi all,</FONT> </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>S.O: = Solaris 8</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>ENGINE: = IDS 7.31.UD8</FONT> </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>In the = last days I put some tables memory resident and monitored with onstat = -b and I believe with have enough buffers to put some others tables, my = question is:</FONT></P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Can I put = memory resident tables like systables? Sysdistrib? Or they are in = &quot;buffer&quot; by the continuos usage?</FONT> </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>They are = some trouble to put many tables memory resident??</FONT> </P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>I hope = with someone can help me, thanks a lot!!!</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Gustavo Tobares</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01C4E77E.F198B930-- sending to informix-list

↪ replying to Gustavo Tobares
Art S. Kagel — — source: Usenet: comp.databases.informix

Gustavo Tobares wrote: > This message is in MIME format. Since your mail reader does not understand PLEASE do not post MIME. It more than triples the bandwidth required to download and store your posting. > > Hi all, > > S.O: Solaris 8 > ENGINE: IDS 7.31.UD8 > > In the last days I put some tables memory resident and monitored > with onstat -b and I believe with have enough buffers to put some others > tables, my question is: > > Can I put memory resident tables like systables? Sysdistrib? Or they > are in "buffer" by the continuos usage? Don't need to. All the information that the server needs from system catalog tables is already cached in in-memory tables (see: onstat -g dic - the data dictionary cache onstat -g dsc - the data distributions cache onstat -g prc - the stored procedure cache These caches are stored in the Virtual Shared Memory segment and are independent of the Buffer Cache. > They are some trouble to put many tables memory resident?? Only starving other tables out of the cache. > I hope with someone can help me, thanks a lot!!! Art S. Kagel > > > Gustavo Tobares >

Related threads

Glossary