running onpload from command line 
Author Message
 running onpload from command line

We have created a few load jobs for HPL but can't get onpload to
run from the command line.  The job works fine out of the X interface (ipload)
but it sure would make life easier if we could run them all
at one time, unsupervised.

I've tried the syntax shown in the "Command" portion of the X interface:

   onpload -p proj1 -j job1 -fl

.. and it will just sit there and do nothing.  If I monitor it from
the X interface it says "Connecting" but nothing ever happens.  Any ideas?

On another note, does anyone have a good script to populate the tables
in the onpload database? Sure would be nice to not have to click
through the job creation 200 times...

TIA,
Ron

________________________________________________________________________

Lead author, Informix Handbook      President, One Point Solutions
   "Your Complete Reference"         "Informix & Web/Database solutions"
    http://www.***.com/     http://www.***.com/
________________________________________________________________________



Mon, 07 Jun 2004 23:10:34 GMT
 running onpload from command line



Quote:
> I've tried the syntax shown in the "Command" portion of the X interface:

>    onpload -p proj1 -j job1 -fl

> .. and it will just sit there and do nothing.  If I monitor it from
> the X interface it says "Connecting" but nothing ever happens.  Any ideas?

Okay, asking the obvious questions first here:

1. 32-bit or 64-bit engine?
2. Environment variables okay?  Is the server name you set up via ipload the
same as your INFORMIXSERVER setting?
3. Is there any output to the log/error files?
4. Is onpload doing anything on the database side (making a connection)?
5. Is the instance on the same box as onpload?

Quote:
> On another note, does anyone have a good script to populate the tables
> in the onpload database? Sure would be nice to not have to click
> through the job creation 200 times...

There's a command-line (onpladm, I think) that can easily be integrated into
scripts for automatic job creation.  This is a godsend to Baan/PeopleSoft
folks.

--Chuck



Tue, 08 Jun 2004 00:34:23 GMT
 running onpload from command line

Quote:

>We have created a few load jobs for HPL but can't get onpload to
>run from the command line.  The job works fine out of the X interface (ipload)
>but it sure would make life easier if we could run them all
>at one time, unsupervised.

>I've tried the syntax shown in the "Command" portion of the X interface:

>   onpload -p proj1 -j job1 -fl

>.. and it will just sit there and do nothing.  If I monitor it from
>the X interface it says "Connecting" but nothing ever happens.  Any ideas?

I'm presuming that the project name (etc) actually exist?

Quote:
>On another note, does anyone have a good script to populate the tables
>in the onpload database? Sure would be nice to not have to click
>through the job creation 200 times...

This one I can handle . . . .

There's a TAR file on the IIUG website (pload.tar ??) that contains create_pload.sh.  I've modified this to  use this in my reorg
scripts; so far, no probs.

(.. .  until I find a way to automagically create scripts using onpladm in our 9.2 release . . . . .8-)

Quote:
>TIA,
>Ron

>________________________________________________________________________

>Lead author, Informix Handbook      President, One Point Solutions
>   "Your Complete Reference"         "Informix & Web/Database solutions"
>   http://www.informixhandbook.com    http://www.one-point.com
>________________________________________________________________________

--------------------------------
John Carlson
Informix DBA
EDS/WHSmith USA

#include std_disclaimer.h     /* These are my opinions, not my company's opinion  */



Tue, 08 Jun 2004 04:44:20 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Erros from ONPLOAD command

2. Running DTS from the command line?

3. command line to run sql scripts (newbie)

4. Run SP from the command line

5. How can i run a job fron sqlserver on a command line or a query instruction

6. Automate running of SqlServer Script from command line

7. How to get command line argument when running a script through ISQL

8. running s.p. from command line

9. run DTS job from command line how ?

10. How to run SQL scripts via command-line?

11. Running a DTS Package from a command line with DTSRUN

12. How to run a job from the command line


 
Powered by phpBB® Forum Software