SQL command to move DB to another DB Space?

Good morning, Is there an SQL command available to have Informix move (relocate) a database from one DB Space to another? Or is that something I just have to use onunload/onload or dbexport(myexport)/dbimport to accomplish? TIA Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu -- "We can't solve problems by using the same kind of thinking we used when we created them." - Albert Einstein, physicist (1879 - 1955) ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.

You can move individual tables with ALTER FRAGMENT....INIT IN... but you can't use that for the catalog tables, so to move an entire database you have to unload, drop, reload (or unload, load to new, drop old, rename new) or create the new database and copy the data from one to the other directly using my dbcopy utility or by using the hploader writing to a pipe read by another hploader writing to the new table. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, May 20, 2009 at 12:43 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Good morning, > > Is there an SQL command available to have Informix move (relocate) a > database from one DB Space to another? Or is that something I just have > to use onunload/onload or dbexport(myexport)/dbimport to accomplish? > > TIA > > Jonathan B. Smaby > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > -- > "We can't solve problems by using the same kind of thinking we used when > we created them." > - Albert Einstein, physicist (1879 - 1955) > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c923d72e3aa9046a5acf93