Unloading data from HDR
SMITH JOHN needed a text-format copy of a 300 GB database whose dbexport took 12 to 16 hours, and wanted to run it on the HDR secondary without disturbing replication. Art Kagel recommended his myexport utility in external-table and parallel modes, which is much faster. He then explained the .shar file unpacks by running it with bash or ksh in an empty directory.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi to All
Our Production Database is about 300 Go, and beside the ontapes backup we need
the data on text format. There are some huge table (about 200 000 000 rows for
the hugest one), so the dbexport takes time, about 12 hours to 16 hours, of
course we used to did it in Week ends.
Now the users work also in weekends, so i'm thinking to use our HDR server to
do this dbexport, but i know that dbexport locks the database and i guess its
will causes problems with the replication process.
So, is there a way to unload data, as quickly as possible, on a HDR server ?
or any other way ?
Thanks in advance for your usual support.
Use my dbexport replacement utility myexport using the external table and
parallel processing modes, it will be significantly faster than dbexport.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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.
On Sat, Feb 8, 2014 at 3:39 AM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to All
>
> Our Production Database is about 300 Go, and beside the ontapes backup we
> need
> the data on text format. There are some huge table (about 200 000 000 rows
> for
> the hugest one), so the dbexport takes time, about 12 hours to 16 hours, of
> course we used to did it in Week ends.
>
> Now the users work also in weekends, so i'm thinking to use our HDR server
> to
> do this dbexport, but i know that dbexport locks the database and i guess
> its
> will causes problems with the replication process.
>
> So, is there a way to unload data, as quickly as possible, on a HDR server
> ?
> or any other way ?
>
> Thanks in advance for your usual support.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c3fba2f2303c04f1ee0da6
Ok, i'll try it Thank you
Hello Mr Art How to extract .shar of your myexport tool thanks
.shar files are shell archives. You can just run it like a shell script using either any ksh compatible shell including ksh, pdksh, or bash in an empty directory and it will unpack itself. It probably has "#! /usr/bin/ksh" embedded in the first line, but you can either edit it to change the shell or path or just run it as: bash ./myexport.shar Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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. On Mon, Feb 10, 2014 at 2:30 PM, SMITH JOHN <daylight@webmails.com> wrote: > Hello Mr Art > How to extract .shar of your myexport tool > thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3490a67a5e004f21277b0