Myexport / Myimport

Hi all! Is there any way to import a database into a especific dbspace using myexport / myimport? I can't see any option similiar to the "-d <dbspace>" that uses dbimport... Thanks in advance!!! -- Javier Perez Arenal - jperez@uniovi.es Jefe del Area Técnica de Informática y Comunicaciones Vicerrectorado de Informática y Comunicaciones Universidad de Oviedo Edificio Severo Ochoa C/ Fernando Bongera s/n, Campus del Cristo 33006 - Oviedo, Asturias --Boundary_(ID_663I+gmmtYLnWcSc5DEG/Q)

Myimport uses -d for dbspace as well... [root@james ~]# myimport Usage: myimport <database> [-X] [-c] [-q] [-e] [-V] [-p] [-m] [-u] [-d <dbspace>] [-l [{ buffered | unbuffered | nolog }] [-ansi]] [-T <dbspace-file>] [-H {D|H}] [{ -i <dir> | -t <tapedev> [ -b <blksz> -s <tapesz> [-f <script-file>]] }] NOTE: <log-file> must be a complete path arguments to /u/apps/informixutils/myimport are order independent Myimport extensions: -T <dbspace_file> reads a file containing pairs of dbspacenames myimport will replace all instances of the first dbspace in each pair with the second, effectively creating tables and indexes in a different but equivalent set of dbspaces. -e Assume database already exists and this is a reload. -p Load all tables in parallel. (Best used with -m!). -H Use HP Loader (via myonpload) in (D)elux or (E)xpress mode. -m Run index/constraint creation script after import. Requires scripts from myexport ... -m ... or equivalent. -u Run data distribution creation script after import. Requires script from myexport ... -u ... or equivalent. -l Specify logging mode for the new database. (Default: unbuffered if no -l, nolog if -l with no argument.) -V Print version strings. James -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Javier Pérez Arenal Sent: Thursday, May 20, 2010 6:37 AM To: ids@iiug.org Subject: Myexport / Myimport [20194] Hi all! Is there any way to import a database into a especific dbspace using myexport / myimport? I can't see any option similiar to the "-d <dbspace>" that uses dbimport... Thanks in advance!!! -- Javier Perez Arenal - jperez@uniovi.es Jefe del Area Técnica de Informática y Comunicaciones Vicerrectorado de Informática y Comunicaciones Universidad de Oviedo Edificio Severo Ochoa C/ Fernando Bongera s/n, Campus del Cristo 33006 - Oviedo, Asturias --Boundary_(ID_663I+gmmtYLnWcSc5DEG/Q) ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Myimport supports the -d dbspace option just like dbimport. It also has the "-T dbspace_map_file" option that lets you map explicit dbspace positions embedded in the schema file to different dbspaces (for example if the export was taken using dbexport -ss or using myexport). The map file contains lines like: old_dbspace1 new_dbspace1 old_dbspace2 new_dbspace2 ... To map the old_ dbspaces to the new_ ones. Any object that was originally explicitely in an old_ dbspace is mapped to the corresponding new_ dbspace. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. 2010/5/19 Javier Pérez Arenal <jperez@uniovi.es> > Hi all! > > Is there any way to import a database into a especific > dbspace > > using myexport / myimport? > > I can't see any option similiar to the "-d <dbspace>" that > uses dbimport... > > Thanks in advance!!! > > -- > > Javier Perez Arenal - jperez@uniovi.es > > Jefe del Area Técnica de Informática y Comunicaciones > > Vicerrectorado de Informática y Comunicaciones > > Universidad de Oviedo > > Edificio Severo Ochoa > > C/ Fernando Bongera s/n, Campus del Cristo > > 33006 - Oviedo, Asturias > > --Boundary_(ID_663I+gmmtYLnWcSc5DEG/Q) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00504502b23ae2f3fe04871c6eec