Unix Technical Forum

HPL Pros and Cons

This is a discussion on HPL Pros and Cons within the Informix forums, part of the Database Server Software category; --> Hello All, Looking at moving large amounts of data from place to place, repeatedly, and I wondered if you ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 12:26 PM
Tam O'Shanter
 
Posts: n/a
Default HPL Pros and Cons

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.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-20-2008, 12:26 PM
Kernoal
 
Posts: n/a
Default Re: HPL Pros and Cons

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


Tam O'Shanter wrote:
> 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.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-20-2008, 12:26 PM
Obnoxio The Clown
 
Posts: n/a
Default Re: HPL Pros and Cons


Tam O'Shanter said:
> 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?


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.

--
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-20-2008, 12:26 PM
Tam O'Shanter
 
Posts: n/a
Default Re: HPL Pros and Cons

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

Tam.


"Kernoal" <kernoals@gmail.com> wrote in message
news:1162312506.003697.168380@i42g2000cwa.googlegr oups.com...
> 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
>
>
> Tam O'Shanter wrote:
>> 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.

>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-20-2008, 12:26 PM
Art S. Kagel
 
Posts: n/a
Default Re: HPL Pros and Cons

Tam O'Shanter wrote:
> 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com