topic Re: Informix + HP in Operating System - HP-UX

Informix + HP

John Booth_1 — Wed, 06 Feb 2002 14:30:48 GMT

Does anyone know if HP-UX allows you to make an Informix table stay resident in memory??

Thanks,
JP

Re: Informix + HP

harry d brown jr — Wed, 06 Feb 2002 14:36:04 GMT

John,

THe question should be does informix allow itself to stay memory resident. This is a question for informix.

live free or die
harry

Re: Informix + HP

S.K. Chan — Wed, 06 Feb 2002 14:38:48 GMT

Well, this should be asked on the Informix side.

Re: Informix + HP

Steve Lewis — Wed, 06 Feb 2002 15:04:10 GMT

Yes, you execute the SQL statement SET TABLE tabname MEMORY_RESIDENT;
To undo it, execute the SQL statement SET TABLE tabname NON_RESIDENT;
You can also set indexes memory_resident and finally you can specify that particular fragments/partitions of tables and indexes are to be made memory_resident.
Some people prefer to leave it up to the engine, by allocating sufficient space in the resident segment, by making the onconfig BUFFERS parameter sufficiently large.
You can check which tables are resident by using the commands onstat -g dic and onstat -g cac.

Re: Informix + HP

Steve Lewis — Wed, 06 Feb 2002 15:13:11 GMT

Sorry, forgot to say that memory residence applies to IDS versions 7.30(7.31?) upwards.
You can force memory residency for the database shared memory BUFFERS by setting the onconfig parameter RESIDENT to 1.

Re: Informix + HP

Deepak Extross — Thu, 07 Feb 2002 03:21:22 GMT

Also, note that the command
"SET TABLE MEMORY_RESIDENT"
can only be issued by the informix admin.
Not even the administrator of the database (grant dba to ...) has permission to this.