IDS Forum

RE: HPL data migration

Posted By: Marcus Haarmann
Date: Saturday, 7 January 2006, at 4:04 p.m.

In Response To: RE: HPL data migration (Zablatzky, Wayne)

Hi,

Maybe you can use the "alter fragment on table" statement to change the
fragmentation in place.
Just a thought.

Marcus

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Zablatzky, ....
Sent: Saturday, January 07, 2006 9:56 PM
To: ids@iiug.org
Subject: RE: HPL data migration [6182]

Thanks for the fast reply, but that still involves a 'disk' file. Scratch
space is hard to come by. I have been testing with: insert into X select *
from X_old. This takes ~6 hours to complete. I've unloaded this table a few
years ago with HPL and it took ~2 1/2 hours. Another 2 1/2 to load.
Much more data now. I was kind of hoping that I could use the HPL as a
direct copy utility.

Wayne

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Jack
Parker
Sent: Saturday, January 07, 2006 12:25 PM
To: ids@iiug.org
Subject: RE: HPL data migration [6181]

Set up an unload job to pipe (2x#cpus)
set up a load job from pipe (the same ones) and run.

Unload to pipes:
use mknod -p to create these. Your device elements look like: 'cat >
/tmp/pipe.1'

Load from pipes:
Your device elements look like 'cat /tmp/pipe.1'

I do not recommend this approach for a repeatable production process. You
can 'lose' a pipe and not get all of your data.

I prefer to unload to pipe with a gzip stuck on the end:

(gzip - > file.gz)

and then load from those gzip files.

gunzip -c file.gz > /tmp/pipe.1

That way you have an intermediate file on disk. Unloading to gzip is about
7x faster than unload to disk.

j.

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
Zablatzky, ....
Sent: Saturday, January 07, 2006 12:12 PM
To: ids@iiug.org
Subject: HPL data migration [6180]

Is it possible to use HPL to do a table-to-table migration? I need to
fragment an 86GB table. I want to rename the current table X to X_old,
create a new table X (fragmented) and then use HPL to migrate the data from
X_old to X. Is this possible or do I need to Unload/Load the data? If it is
possible, how do I set it up in the ipload utility? I've used HPL in the
past, but not extensively.

Thanks in advance,
Wayne

Please do not transmit orders or instructions regarding a UBS account by
e-mail. The information provided in this e-mail or any attachments is not an

official transaction confirmation or account statement. For your protection,

do not include account numbers, Social Security numbers, credit card
numbers, passwords or other non-public information in your e-mail. Because
the information contained in this message may be privileged, confidential,
proprietary or otherwise protected from disclosure, please notify us
immediately by replying to this message and deleting it from your computer
if you have received this communication in error. Thank you.

UBS Financial Services Inc.
UBS International Inc.

****************************************************************************

***
Forum Note: Use "Reply" to post a response in the discussion forum.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Please do not transmit orders or instructions regarding a UBS account by
e-mail. The information provided in this e-mail or any attachments is not an
official transaction confirmation or account statement. For your protection,
do not include account numbers, Social Security numbers, credit card
numbers, passwords or other non-public information in your e-mail. Because
the information contained in this message may be privileged, confidential,
proprietary or otherwise protected from disclosure, please notify us
immediately by replying to this message and deleting it from your computer
if you have received this communication in error. Thank you.

UBS Financial Services Inc.
UBS International Inc.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• HPL data migration
  Zablatzky, Wayne -- Saturday, 7 January 2006, at 12:12 p.m.
  • RE: HPL data migration
    Jack Parker -- Saturday, 7 January 2006, at 12:25 p.m.
    • RE: HPL data migration
      Zablatzky, Wayne -- Saturday, 7 January 2006, at 3:55 p.m.
      • RE: HPL data migration
        Marcus Haarmann -- Saturday, 7 January 2006, at 4:04 p.m.
      • RE: HPL data migration
        Victor Miramontes -- Saturday, 7 January 2006, at 4:19 p.m.
        • RE: HPL data migration
          Zablatzky, Wayne -- Sunday, 8 January 2006, at 7:18 p.m.
      • RE: HPL data migration
        Jack Parker -- Saturday, 7 January 2006, at 5:16 p.m.
  • Re: HPL data migration
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 9 January 2006, at 9:51 a.m.
    • RE: HPL data migration
      Walter Milan -- Monday, 9 January 2006, at 12:11 p.m.
      • RE: HPL data migration
        Zablatzky, Wayne -- Monday, 9 January 2006, at 6:19 p.m.
    • RE: HPL data migration
      Zablatzky, Wayne -- Friday, 13 January 2006, at 6:04 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.