Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi Gurus out there!
Using IDS 10 on Sun Solaris 10.
I have a question about Informix performance when using a dedicated temporary
dbspace (properly setup and declared in DBSPACETEMP in onconfig) versus using
the default location of temporary tables ('/tmp', which on Solaris is a memory
based file system).
This IBM page
http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlr.doc/sqlrmst193.htm
says the following:
1) The dbspaces that you list in DBSPACETEMP must be composed of chunks that are
allocated as raw UNIX devices.
2) order of precedence for where to create temporary tables:
# The dbspace or dbspaces that the environment variable DBSPACETEMP
specifies, if this is set
# The dbspace or dbspaces that the ONCONFIG parameter DBSPACETEMP specifies.
# The dbspace or dbspaces that the ONCONFIG parameter TABLESPACE specifies.
# The operating-system file space in /tmp (UNIX) or %temp% (Windows)
Am I right in interpreting that using DBSPACETEMP is to be preferred over /tmp?
If so, why, beside the fact that using '/tmp' on Solaris means eating memory?
Is there anyone that has done a performance benchmark using DBSPACETEMP
versus '/tmp' on Sun Solaris?
Thank you in advance
Rupan3rd (from Italy - and no, it's not sunny)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.