Re: Error 229

Posted in 1995

Bob Baskett — 22 May 1995 18:23:03 -0400 — source: Informix-list mailing list archive (1991-1998)

> > > > When creating a temporary table we get this error and there > > seems to be no reason. If we leave > > DBTEMP unset (default = /tmp) or set it to a different value, > > we still get this error: 229. We seem to have plenty of room on the > > DBTEMP is a SE parameter. On Online, temp tables are created in rootdbs ^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ not true. not true either DBTEMP is also an only parameter. in online, temp tables are created in the same dbspace which the database was created in. however, in later versions (6.x and higher i think), you can set it to a given dbspace using the DBSPACETEMP variable. > or whatever you have defined in DBSPACETEMP. /tmp is still used in > Online but only for sorts. unless you are utilizing the PSORT option, in which case the PSORT_DBTEMP variable is used. > David W Chan > Objective Research Ltd > dwc@cix.compulink.co.uk > -- regards, +----------------------------------------------------------------------------+ | . . | Bob Baskett | | ... ... | Software Engineer | | ..... ..... | Business Systems Integration Group | | .. ... .. | Semiconductor Products Sector | | . . . | Mesa, AZ | | | President, Informix Users Group Of Arizona | | Motorola, Inc. | | +----------------------------------------------------------------------------+ | Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 | +----------------------------------------------------------------------------+