cancel
Showing results for 
Search instead for 
Did you mean: 

Informix + HP

SOLVED
Go to solution
John Booth_1
Advisor

Informix + HP

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

Thanks,
JP
5 REPLIES
harry d brown jr
Honored Contributor

Re: Informix + HP

John,

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

live free or die
harry
Live Free or Die
S.K. Chan
Honored Contributor

Re: Informix + HP

Well, this should be asked on the Informix side.
Steve Lewis
Honored Contributor
Solution

Re: Informix + HP

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
Honored Contributor

Re: Informix + HP

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
Honored Contributor

Re: Informix + HP

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.