Oninit cdi / Archive
Talk to an expert →

move database from 1 dbspace to another

Posted in 2000

Summary

Mr.B asked how to move a database to another dbspace on IDS 7.3 under HP/UX. rusty66 advised dbexport, dropping the database, then dbimport with -d dbspacename. Daniel Ho gave the same option and suggested moving tables, which leaves system tables in the old dbspace. Mr.B used dbexport, drop and dbimport -d and reported it did what he needed. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management, Versions, Editions & End-of-Life

Mr.B — — source: Informix-list mailing list archive (1991-1998)

Hi, I need to move a database from one dbspace to another. As a systems operator I am not very familiar with the databse-tools: what is the best thing to do? I have IDS 7.3 running on a HP/UX 11.x. Thanks. Ben DE PAUW (sysadmin)

↪ replying to Mr.B
rusty66 — — source: Informix-list mailing list archive (1991-1998)

Export the database. dbexport dbname Drop the database. Import the database into the dbspace you want. dbimport dbname -d dbspacename -l buffered ( Use buffered only if you want buffered logging ) "Mr.B" wrote: > Hi, > > I need to move a database from one dbspace to another. > As a systems operator I am not very familiar with the databse-tools: > what is the best thing to do? > I have IDS 7.3 running on a HP/UX 11.x. > > Thanks. > > Ben DE PAUW > (sysadmin)

↪ replying to Mr.B
danielho@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Ben, Maybe I provide some solutions to you. (1) dbexport the whole database, rename the old one and using dbimport to load the database in another dbspace. (2) move all tables in the database to another dbspace but the db system information still remain on the old dbspace. Daniel In article <38DB5FC5.42D65A87@freebel.net>, ben.depauw@freebel.net wrote: > Hi, > > I need to move a database from one dbspace to another. > As a systems operator I am not very familiar with the databse-tools: > what is the best thing to do? > I have IDS 7.3 running on a HP/UX 11.x. > > Thanks. > > Ben DE PAUW > (sysadmin) > > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Mr.B
Mr.B — — source: Informix-list mailing list archive (1991-1998)

Hi, Thanks to all of you. I used dbexport into a directory, dropped the db and performed a dbimport ... -d <dbspace> dbname this did just what I needed. Bye "Mr.B" wrote: > Hi, > > I need to move a database from one dbspace to another. > As a systems operator I am not very familiar with the databse-tools: > what is the best thing to do? > I have IDS 7.3 running on a HP/UX 11.x. > > Thanks. > > Ben DE PAUW > (sysadmin)

Glossary