Oninit cdi / Archive
Talk to an expert →

Novice Question about DBSPACETEMP

Posted in 2000

Topics: Storage & Space Management, Server Administration

↪ replying to Jay Singh
Joanne Dority — — source: Informix-list mailing list archive (1991-1998)

The environment variable, if set, will override the DBSPACETEMP onconfig parameter for that session. Otherwise, the onconfig parameter will be honored. What's tricky is -- if the database has logging, you need to use the "with no log" clause with your sql statements for it to work properly. Jay Singh wrote in message <8ucjhm$dgj$1@nnrp1.deja.com>... >In the IDS 2000 server manual, it says that the environment variable >DBSPACETEMP should be set other wise the temp deafults to root dbspace. > >I have the DBSPACETEMP parameter set in the onconfig file for the >instance however the environment variable is not set. (I did echo >$DBSPACETEMP) > >Does this make any difference ?? > >Thanks >Jay > > >Sent via Deja.com http://www.deja.com/ >Before you buy.

Jay Singh — — source: Informix-list mailing list archive (1991-1998)

In the IDS 2000 server manual, it says that the environment variable DBSPACETEMP should be set other wise the temp deafults to root dbspace. I have the DBSPACETEMP parameter set in the onconfig file for the instance however the environment variable is not set. (I did echo $DBSPACETEMP) Does this make any difference ?? Thanks Jay Sent via Deja.com http://www.deja.com/ Before you buy.

Glossary