IDS Forum

RE: HPL data migration

Posted By: Victor Miramontes
Date: Saturday, 7 January 2006, at 4:19 p.m.

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

Yes, you can use HPL as a direct copy utility.

First your output and input should be defined as
pipes. There, you are obligated to put a command.
If you are in a unix environment you can put just
"cat".
Then, to retrive the data and load it in a single
instruction just execute:

onpload -p proj_name -j job_unload_name -fu | onpload -p proj_name -j job_load_name -fl

and that's it.

I hope this helps.

Regards,

Víctor Fabián Miramontes
DBA Proyecto SAP
Cencosud S.A.
TE: 54-11-4733-1000 int. 4158
>>> Wayne.Zablatzky@ubs.com 07/01/06 17:55 >>>

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.