RE: DBSPACETEMP

Howie What do you mean by random ?? It is possible to specify more than one dbspace in DBSPACETEMP and they can be a mixture of unlogged (marked as temp) and logged dbspaces. They will be used in a round-robin basis by the engine to allocate space for temp tables (each existing in a single dbspace). For index builds all appropriate spaces will be used for the sort/merge process. Keith -> -----Original Message----- -> From: howie_lfc@hotmail.com [mailto:howie_lfc@hotmail.com] -> Sent: Friday, August 18, 2006 3:30 PM -> To: informix-list@iiug.org -> Subject: DBSPACETEMP -> -> -> Hello All, -> -> Just a quick question for you to ponder. -> -> Is it possible to include random dbscpaces in the -> DBSPACETEMP parameter -> with the onconfig file to prevent space problems in the temp dbspace -> when creating indexes etc. on very large tables? -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> *********************************************************************************************** This email, including any attachment, is confidential and may be legally privileged. If you are not the intended recipient or if you have received this email in error, please inform the sender immediately by reply and delete all copies from your system. Do not retain, copy, disclose, distribute or otherwise use any of its contents. Whilst we have taken reasonable precautions to ensure that this email has been swept for computer viruses, we cannot guarantee that this email does not contain such material and we therefore advise you to carry out your own virus checks. We do not accept liability for any damage or losses sustained as a result of such material. Please note that incoming and outgoing email communications passing through our IT systems may be monitored and/or intercepted by us solely to determine whether the content is business related and compliant with company standards. ***********************************************************************************************