Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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.