Re: FW: Limited Transaction Logging

In article <5a1lph$t8j@cssun.mathcs.emory.edu>, Kahler, Russell P. <Russ@oncontact.com> wrote: >I don't know what database engine you are running but if it is DSA 7.12 >or higher you may want to look into using temp dbspaces. If you setup >a table space as a temporary table space any tables created in it are >not logged (meaning all inserts,updates,deletes). As long as you can >control where your tables are being created this should solve the >problem of logging some tables and not others. Uhhmmm... well, if you don't mind not having these tables archived and losing them every time OnLine is shutdown. Temp dbspaces are not backed up. Also, temp dbspaces are cleared out when you reinitialize shared memory (take OnLine down and bring it back up). As the manual says, "Temporary dbspaces are designed exclusively for the storage of temporary tables.". Regards, Cathy ------------------------------------------------------------------------ Cathy Kipp E-mail: ckipp@verinet.com Principal Consultant Fort Collins, Colorado, USA Database Strategies, Inc. Phone: 1-970-226-0240 Informix User Group of Colorado - President International Informix User Group - Board of Directors ------------------------------------------------------------------------