Re: Create Table, Default DB Space

On Tue, 21 Apr 1998 11:11:42 -0400, "Jerry A. Van Zant" <jvz@opendata.com> wrote: >Is there a way in version 7.* to change the default dbspace where tables are >created when "in dbspace" is not specified? > >We bought an application that likes to create "work" tables that multiple >threads can get to, so they don't create them as temp tables. > >I have two problems with this: > >1) The tables are logged! And they can get quite large. > >2) The location of these tables end up being the root dbspace. This >package is "database independent" so they can't use Informix extensions. > >I don't think I can do much about 1 above. How about 2? The tables will by default be created where the database was originally created. That means you have to create the database in the dbspace where you want these "work" tables to end up. You shouldn't create any database in the root dbspace anyway, so this should be ok. Also remember all other tables may still be created in any dbspace you may want to so it's easy to keep enough free space in the dbspace where you create the database. Appart from these "work" tables that you can't control the location for, all that have to be in the dbspace where you create the database is the system tables for that database. They are not very large though. If you want to move a database from one dbspace to another on easy way is to use dbexport and then dbimport. When using dbimport you simply type: dbimport databasename -d dbspacename This will create the database without loging which you probably want to turn on after the import is ok. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)