HPL Pros and Cons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tam O'Shanter - 31 Oct 2006 17:22 GMT

Hello All,
Looking at moving large amounts of data from place to place, repeatedly, and
I wondered if you could weigh in on the pros/cons of using HPL. One of my
peers is of the opinion that it's not all that worth while as it requires an
X Windows install etc... and there are better tools that don't require such
a setup.

I'm of the opinion HPL is the bomb-digity and should have a confirmed seat
in our operation.

Thoughts?

Experiences?

Mucho Gracias.....

Tam.

Reply to this Message

Kernoal - 31 Oct 2006 17:35 GMT

Use HPL with the command line options and you never have to use X
Windows!
onpladm does it all command line.
There is a fine manual for this one and there are several presentations
done at the user conference over the past three years. Go to
www.iiug.org and you can down load the session slides.

Here are the command line options:
usage : onpladm <command>
create job <jobname> {options}
create map <mapname> {options}
create project <projectname> {options}
create object {options}
delete job <jobname> {options}
delete map <mapname> {options}
delete format <formatname> {options}
delete query <queryname> {options}
delete filter <filtername> {options}
delete device <devicename> {options}
delete machine <machinename> {options}
delete project <projectname> {options}
modify object {options}
describe job <jobname> {options}
describe map <mapname> {options}
describe format <formatname> {options}
describe query <queryname> {options}
describe filter <filtername> {options}
describe device <devicename> {options}
describe machine <machinename> {options}
describe project <projectname> {options}
list job {options}
list map {options}
list format {options}
list query {options}
list filter {options}
list device {options}
list machine {options}
list project {options}
list defaults {options}
run job {options}
run project {options}
configure defaults {options}

FYI

Kernoal

> Hello All,
> Looking at moving large amounts of data from place to place, repeatedly, and
[quoted text clipped - 13 lines]
>
> Tam.

Reply to this Message

Tam O'Shanter - 31 Oct 2006 19:32 GMT

Thanks. I've pulled some of the materials avialible on the IIUG site with
regards to HPL and am eagerly consuming the info!

Tam.

> Use HPL with the command line options and you never have to use X
> Windows!
[quoted text clipped - 64 lines]
>>
>> Tam.

Reply to this Message

Art S. Kagel - 31 Oct 2006 21:44 GMT

> Thanks. I've pulled some of the materials avialible on the IIUG site with
> regards to HPL and am eagerly consuming the info!
>
> Tam.

Make sure to take a look at Ravi Krishna's myonpload script in the IIUG
Repository if you haven't gotten that one yet.

Art S. Kagel

Reply to this Message

Obnoxio The Clown - 31 Oct 2006 18:08 GMT

Tam O'Shanter said:

> Hello All,
> Looking at moving large amounts of data from place to place, repeatedly,
[quoted text clipped - 12 lines]
>
> Experiences?

I'm of the opinion that your peer is talking out of his or her arse. HPL
no longer requires an X-windows install, as it now has a command-line
interface. The only downside of HPL (and this might have been fixed by
now) is that it takes quite a while to start up, so if you're loading a
small table, DBLOAD is quicker.

Signature

Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

Reply to this Message