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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |
| |||
| 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. |
| |||
| 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. |
| |||
| 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. > |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|