Informix + HP

[John Booth_1]

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

Thanks,
JP

[harry d brown jr]

John,

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

live free or die
harry

[S.K. Chan]

Well, this should be asked on the Informix side.

[Steve Lewis · Accepted solution]

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.

[Steve Lewis]

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.

[Deepak Extross]

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.