IDS Forum

Re: RE: Import Information quickly

Posted By: Art Kagel
Date: Thursday, 3 November 2011, at 10:40 a.m.

In Response To: Re: RE: Import Information quickly (GUSTAVO ECHENIQUE)

As mentioned, get my myexport package which also contains the myimport
script. It is a drop in replacement for dbimport that runs much faster
optionally using external tables for importing the data which is the
fastest way to bring in the data. Myimport can also import multiple tables
in parallel which will make better use of the server's available resources
to pull in data as fast as possible. Myexport/myimport will also require
my package utils2_ak and optionally Jonathan Leffler's sqlcmd package (this
contains the default load utility that myimport uses, sqlreload, which
operates at about the same speed as dbimport) and Ravi Krishna's myonpload
package (needed if you want to have myimport use the hploader to import the
data).

Doing a parallel load from an export created with dbexport rather then
myexport will take a bit of work. Using the -E (external table) option
will also require a manual step (running myschema with the
--myexport-scripts or --myexport-express options to generate the import
scripts that would normally have been generated if you had used myexport
-E). This will only work, of course, if you still have access to the
original database so that myschema can read the database catalog tables.
If not, then you can either use the -HD or -HE options to myimport to have
it use the hploader (with myonpload) to get a faster load. If you have to
use the default load method (using sqlreload) then the speed of the load
will be about the same as using dbimport.

If you want to try using external table or even a parallel load and have
trouble email me directly (see my sig) and I'll try to help. Using these
options from a dbexport data set is not documented particularly well
<sorry>.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

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.

On Thu, Nov 3, 2011 at 9:59 AM, GUSTAVO ECHENIQUE <
gustavo.echenique@cemdo.com.ar> wrote:

> Hi Andrew, is not a silly question yours.
>
> Because I do not use dbimport takes about 20 hours to import the entire
> base,
> and do not have the time.
>
> I have to work with a database exported on 31/07/2011 and I was wondering
> if
> there was a much more rapid than the dbimport to import.
>
> A hug.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--14dae9340577d23c3d04b0d59027

Messages In This Thread

• Import Information quickly
  GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 9:32 a.m.
  • RE: Import Information quickly
    Andrew Grantham -- Thursday, 3 November 2011, at 9:40 a.m.
    • Re: RE: Import Information quickly
      GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 9:45 a.m.
      • RE: Import Information quickly
        Andrew Grantham -- Thursday, 3 November 2011, at 9:49 a.m.
        • Re: RE: Import Information quickly
          GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 9:59 a.m.
          • RE: Import Information quickly
            Andrew Grantham -- Thursday, 3 November 2011, at 10:06 a.m.
            • Re: Import Information quickly
              Jack Parker -- Thursday, 3 November 2011, at 10:20 a.m.
            • Re: RE: Import Information quickly
              GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 10:30 a.m.
              • RE: Import Information quickly
                Andrew Grantham -- Thursday, 3 November 2011, at 10:35 a.m.
              • Re: RE: Import Information quickly
                Art Kagel -- Thursday, 3 November 2011, at 10:53 a.m.
          • Re: RE: Import Information quickly
            Art Kagel -- Thursday, 3 November 2011, at 10:40 a.m.
      • RE: RE: Import Information quickly
        Everett Mills -- Thursday, 3 November 2011, at 9:53 a.m.
        • Re: RE: RE: Import Information quickly
          GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 10:03 a.m.
          • RE: Import Information quickly
            Everett Mills -- Thursday, 3 November 2011, at 10:32 a.m.
            • RE: Import Information quickly
              Everett Mills -- Thursday, 3 November 2011, at 10:36 a.m.
              • Re: Import Information quickly
                Art Kagel -- Thursday, 3 November 2011, at 11:07 a.m.
            • Re: Import Information quickly
              Art Kagel -- Thursday, 3 November 2011, at 11:06 a.m.
      • Re: RE: Import Information quickly
        Art Kagel -- Thursday, 3 November 2011, at 10:25 a.m.
  • Re: Import Information quickly
    Art Kagel -- Thursday, 3 November 2011, at 9:58 a.m.
    • Re: Import Information quickly
      GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 10:15 a.m.
      • RE: Import Information quickly
        Andrew Grantham -- Thursday, 3 November 2011, at 10:17 a.m.
  • Re: Import Information quickly
    GUSTAVO ECHENIQUE -- Thursday, 3 November 2011, at 12:21 p.m.
    • Re: Import Information quickly
      David Zinder -- Thursday, 3 November 2011, at 3:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.