Oninit cdi / Archive
Talk to an expert →

move database from 1 dbspace to another

Posted in 2000

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