RE: Informix SHMEM file in /tmp
I think it could be because in onconfig you left blank DBSPACETEMP
# DBSPACETEMP:
# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces
# that the OnLine SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the OnLine system is brought online. If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.
DBSPACETEMP # Default temp dbspaces
> -----Mensaje original-----
> De: Webber Valerie H [SMTP:Valerie.H.Webber@m1.irs.gov]
> Enviado el: Monday, August 09, 1999 6:52 AM
> Para: 'Paul watson'; informix-list@iiug.org
> Asunto: Informix SHMEM file in /tmp
>
> Thanks for the help!
>
> Can anyone give me info about the SHMEM%%%% file that is created in /tmp
> when the instance is started? Is it created only during initialization of
> Informix and removed after Informix is up?
>
> How do you determine the amount of space needed in /tmp to handle this
> file?
>
> -----Original Message-----
> From: Paul watson [mailto:watsop@russellcorp.co.uk]
> Sent: Friday, August 06, 1999 11:26 AM
> To: informix-list@iiug.org
> Subject: Re: Tuning Shared Buffers
>
>
> Start with 25% of RAM and go from there. With NewEra frontend 4MB per
> user
> seem to be OK, but we did have a memory leak:-))
>
>
>
> Paul Watson
> WF Software Ltd
> Tel: +44 1436 674729
> Fax: +44 1436 678729
> www.wfsoftware.com
> # If you broke it, hide the evidence
>
> >>> Webber Valerie H <Valerie.H.Webber@m1.irs.gov> 08/06/99 12:51PM >>>
> Does any one have a rule of thumb for determining the size of BUFFERS in
> the
> ONCONFIG file? We have 512 megs of memory and about 75 concurrent users.
>
> An Informix consultant said we should set it to 20 megs but I feel that is
> too small.
>
> Does 150 megs sound appropriate? (2 megs per user)....
>
> And thanks for the help on the upgrading from 4.1.2 to 7.2.4.... We're
> running more test today.
>
> Valerie H. Webber
> Valerie.H.Webber@m1.irs.gov
> 704-569-1002 x107
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **********************************************************************