Running a Job

Home | Previous Page | Next Page The onpladm Utility > Defining Jobs >

Running a Job

The following diagram illustrates the syntax to run a job and display the job progress or send it to a log file.

Running a Job
 
>>-onpladm run job--jobname--+------------------+-- -f--+---+--->
                             '- -p--projectname-'       +-l-+
                                                        '-u-'
 
   .----------------------.
   V                      |
>----+------------------+-+------------------------------------><
     +- -l--logfilename-+
     +- -S--servername--+
     '- -Z--------------'

Element	Purpose	Key Considerations
-f	Flags to specify the type of job	Additional Information: The default is load job.
l	Specifies a load job	None
u	Specifies an unload job	None
jobname	Names a load or unload job from the onpload database	None
-l logname	Sets the path for a log file where job progress is recorded	None
-p projectname	Identifies the project where the format and map are stored	None
-S servername	Sets the onpload database server	Additional Information: The default is the value of the INFORMIXSERVER environment variable.
-Z	Enables writing to or reading from a tape until the end of the device. The onpladm utility prompts you for additional tapes until the load or unload is completed.	Restrictions: If you use this feature, you must use it for both load and unload jobs. Otherwise, the unloaded data might not match the loaded data. Additional Information: If the -Z option is not set, the onpladm uses the tape size specified with the -M option of the create job command. If the -Z option is set, it supersedes the tape size information provided.

For information on how to execute this command for a database server running on Windows, see Running onpladm on UNIX with Dynamic Server Running on Windows.

Using the onpladm Utility When Referential Constraints Are On Tables

The onpladm utility unloads and loads an entire database by creating individual table unload and load jobs. If the load mode is express, the default load mode, the onpladm utility disables referential constraints during load jobs. If database tables have constraints on them, problems can occur. For example, if one table has a referential constraint to another table and that table is not yet loaded, a violation that prevents a table from loading can occur.

If tables have constraints, you can manually disable the constraints after the load job is complete.