Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / March 2005

Tip: Looking for answers? Try searching our database.

9.4 upgrade SHMVIRTSIZE problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Andrew - 29 Mar 2005 23:39 GMT
Upgrade from 9.21 to 9.40
Windows NT Advanced server SP3
4 Gig ram

Had had SHMVIRTSIZE set to 655360

Did the upgrade and Informix failed on setting up the Shared memory.
Worked OK if it was reduced - to 327680, and stepped up OK to 557056, but
after that it just falls over when you try to bring the bugger online.
Anyone got any ideas?  Non Move to *ix realted, thanks.  Just don't
understand how with nothing but the db version changed that suddenly starts
falling over.

Even just ideas about what to look at would be most welcome

ta
Andrew
Art S. Kagel - 30 Mar 2005 14:58 GMT
> Upgrade from 9.21 to 9.40
> Windows NT Advanced server SP3
[quoted text clipped - 8 lines]
> understand how with nothing but the db version changed that suddenly starts
> falling over.

It may be that the total of resident, virtual, and message segments exceeds
the OS max shared memory you can attach a process to.  Why different than in
9.21?  Because some other data structures in the RESIDENT segment may now be
larger than they were expanding that segment so that others need to be
smaller.  Alternative to reducing SHMVIRTSIZE you may be able to reduce the
number of ipcshm connections in your NETTYPE parameters which will eliminate
some message (type M) shared memory and leave more room for virtual segments.

Art S. Kagel

> Even just ideas about what to look at would be most welcome
>
> ta
> Andrew
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.