IDS Forum

RE: Loading blobs

Posted By: Andrew Grantham
Date: Thursday, 21 February 2013, at 8:48 a.m.

In Response To: Re: Loading blobs (Art Kagel)

Art,

Thanks for your email. I have a table which has reached 27Gb in one dbspace and I would like to introduce fragmentation to it. At the moment I am simplying unloading the data using the HPL and then reloading it into a shadow copy of the original table using HPL or external tables. Once the work is done the objects are created and the tables switched around. Nice and simple. I am trying to determine the fastest way of doing the work. Using the no-conversion utility in HPL is very quick to unload but I cannot use it to load back up as the table contains blobs unless you can tell me differently?

> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Loading blobs [29550]
> Date: Thu, 21 Feb 2013 08:38:00 -0500
>
> Question: What's the full mission you need to accomplish? For example, are
> you reloading blobs because these were exported then deleted and now you
> need them back? Or is it that you exported the records to move them from
> one database or server to another database or server and the reload is too
> slow? How were they exported (using what tools)?
>
> If what you REALLY need to do is to move the blobs from one server to
> another, consider copying the data directly using my dbcopy utility. It is
> very fast (almost as fast as the HPLoader or external files in general) and
> you save the time and overhead of writing the data to disk as flat files
> and reading it back. You can also divide the data in the table using
> filters into multiple subsets and run many copies of dbcopy copying all of
> those subsets in parallel which will make the copy MUCH faster than either
> HPLoader or external tables.
>
> Dbcopy is included in the package utils2_ak which you can download from the
> IIUG Software Repository (www.iiug.org/software).
>
> 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, Feb 21, 2013 at 5:06 AM, Andrew Grantham <agrantha@hotmail.com>wrote:
>
> > All,
> >
> > Informix 11.70.FC2 on Sun Solaris.
> >
> > I would like to reload a table that contains BLOBs using something like the
> > High Performance Loader or EXTERNAL tables but nothing I have managed to
> > configure so far works with any amount of speed. I believe I cannot use
> > no-conversion format because loading BLOBs has restrictions. Anyway I am
> > seeking your experiences on loading BLOBs and how to make it as quick as
> > possible. All thoughts and advice welcome.
> >
> >
> >
> >
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --e89a8f22beb990a30b04d63c2e1f
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

Messages In This Thread

• Loading blobs
  Andrew Grantham -- Thursday, 21 February 2013, at 5:06 a.m.
  • Re: Loading blobs
    Art Kagel -- Thursday, 21 February 2013, at 8:38 a.m.
    • RE: Loading blobs
      Andrew Grantham -- Thursday, 21 February 2013, at 8:48 a.m.
      • Re: Loading blobs
        Art Kagel -- Thursday, 21 February 2013, at 9:05 a.m.
        • RE: Loading blobs
          Andrew Grantham -- Thursday, 21 February 2013, at 9:36 a.m.
          • Re: Loading blobs
            Art Kagel -- Thursday, 21 February 2013, at 9:46 a.m.
            • RE: Loading blobs
              Andrew Grantham -- Thursday, 21 February 2013, at 9:53 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.