Unloading data from HDR

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