RE: Slow dbcopy?
I think you could even use DBD::Informix in perl script to control the
processing(unload/load) of each table individually, which gives you better
flexibilities.In DBD::Informix v0.6 , you can do this to get all the table
names.
@tables = $dbh->func('system', '_tables');
etc.
Have a look at Web site :http://www.perl.com/CPAN/modules/by-module/DBIx/
Peter Ai
On Thursday, August 12, 1999 1:03 PM, Thomas Parsli
[SMTP:thomas.parsli@ose.no] wrote:
> Jing Liu <jingliu@ics.uci.edu> writes:
>
> > Thomas Parsli wrote:
>
> [SNIP]
>
> > > We're trying the unload->rcopy->load path, this seems faster on the
> > > relativly small tests I've done. I suppose gzip could help with our
10Mb WAN...
> >
> > Is there any way to do unload and load automatically to copy multipile
tables? I think it
> > is not suported in routines.
>
> I use perl-scripts with
>
> $tables = 'echo "select tabname from systables where tabid >= 100 and
> tabtype = 'T' order by 1" | dbaccess <dbname>';
>
> to list all tables.
>
> dbexport/import is fine, but it only works on the whole database.
>
> Thomas