Creating Jobs

You can create two types of jobs:

• Conversion jobs

  Use a conversion job to process data that requires conversion before loading and that is not in internal format. Conversion jobs have associated maps and format objects.

• No-conversion jobs (fast jobs)

  Use a no-conversion job to process data that does not require conversion before loading and that uses the Informix internal format. No maps or formats are associated with a no-conversion job. Consequently, a no-conversion job is faster than a conversion job. No-conversion jobs are always completed in express mode.

Creating Conversion Jobs

When you create a conversion load or unload job using command-line parameters, all maps, formats, and query objects automatically have the same name as the job name. When you create a conversion job with detailed specification files, the HPL objects can have different names from the job name.

Creating Conversion Jobs Using a Quick Command

When you create a conversion job using a quick command, the onpladm utility creates all HPL objects associated with the job. The HPL objects that it creates have the same name as the job.

The following diagram illustrates the syntax to create a conversion job from the command line.

Creating a Conversion Job
 
>>-onpladm create job--job--+--------------+-- -d--device------->
                            '- -p--project-'
 
>-- -D--database-- -t--table------------------------------------>
 
>--+---------------------------------------+-------------------->
   '-| Setting the 

 Run Mode |-'
 
>--+-------------------------------------+--+-------------+----->
   +- -n---------------------------------+  '- -T--target-'
   '-| Setting the 

 Format |-'
 
>--+-------------+--+-----------------+--+----------------+----><
   '- -S--server-'  '- -M--devicesize-'  '- -B--blocksize-'
 

The following diagram illustrates the syntax to set the run mode with the -f option.

Setting the Run Mode:
 
               .-l--+---+-.
               |    '-c-' |
|-- -f--+---+--+----------+--+---+--+---+-----------------------|
        +-d-+  '-u--------'  '-n-'  '-N-'
        +-p-+
        '-a-'
 

The following diagram illustrates the syntax to set the format type with the -z option.

Setting the Format:
 
|-- -z--+----+--------------------------------------------------|
        +-D--+
        +-FI-+
        +-FA-+
        +-FB-+
        +-C--+
        '-CB-'
 

Creating Conversion Jobs Using Detailed Specification Files

You can also specify job details in specification files that you reference from the command line.

When you create a job by using a specification file, you must create all associated HPL objects; the onpladm utility does not create these objects for you.

Creating a Conversion-Load Job

Use the syntax shown in Specification-File Conventions to create a conversion-load job from a specification file.

Use the following syntax to create a specification file for a conversion-load job:

BEGIN OBJECT LOADJOB jobname 
# Compulsory Attributes 
PROJECT projectname 
DEVICE device_array_name 
MAP mapname 

FILTER filtername 
SERVER targetservername 
DATABASE targetdatabasename 
FLTFILE filtered_records_filename 
REJECTFILE rejected_records_filename 
LOGFILE job_progress_logfilename 
RUNMODE runmode_type 
GENERATEVIORECS violation_records_option 
TAPES sourcetape_num 
NUMRECORDS records_num 
STARTRECORD start_record 
MAXERRORS max_error_num 

END OBJECT  

The following table lists the attributes and their attribute values.

Creating a Conversion Unload Job

Use the syntax shown in Specification-File Conventions to create a conversion unload job from a specification file.

Use the following syntax to create a conversion unload job:

BEGIN OBJECT UNLOADJOB jobname 
# Compulsory Attributes 
PROJECT projectname 
DEVICE device_array_name 
MAP mapname 

FILTER filtername 
SERVER targetservername 
DATABASE targetdatabasename 
REJECTFILE rejected_records_filename 
LOGFILE job_progress_logfilename 
ISOLATIONLEVEL isolation_level 
MAXERRORS max_error_num 

END OBJECT  

The following table lists the arguments and their attribute values.

Creating No-Conversion Jobs

A no-conversion job is faster than a conversion job because onpload uses the internal format of the target database and does not create new maps or formats. No-conversion jobs are always run in express mode.

Creating No-Conversion Jobs Using a Quick Command

When you create a job using a quick command, the onpladm utility creates all HPL objects associated with that job.

The following diagram illustrates the syntax to create a no-conversion job.

Creating a No-Conversion Job
 
>>-onpladm create job--job--+--------------+-- -n--------------->
                            '- -p--project-'
 
>-- -d--device-- -D--database-- -t--table----------------------->
 
   .-----------------------------------------------------------------------------.
   V                                                                             |
>----+-------------------------------------------------------------------------+-+-><
     '-+-------------+--+-------------+--| Setting the 

 Run Mode |-'
       '- -S--server-'  '- -T--target-'
 

The following diagram illustrates the syntax to set the run mode with the -f option.

Setting the Run Mode:
 
               .-l-.
|-- -f--+---+--+---+--------------------------------------------|
        +-d-+  '-u-'
        +-p-+
        '-a-'
 

Creating No-Conversion Jobs Using Detailed Specification Files

You can also specify job details in specification files that you reference from the command line.

When you create a job by using a specification file, you must create all associated HPL objects; the onpladm utility does not create these objects for you.

Creating a No-Conversion Load Job

Use the syntax shown in Specification-File Conventions to create a no-conversion load job with specification files.

Use the following syntax to create a specification file for a no-conversion load job:

BEGIN OBJECT FASTLOADJOB jobname 
# Compulsory Attributes 
PROJECT projectname 
DEVICE device_array_name 
DATABASE targetdatabasename 
TABLE tablename 

SERVER targetservername 

END OBJECT  

The following table lists the attributes and their values.

Creating a No-Conversion Unload Job

Use the syntax shown in Specification-File Conventions to create a no-conversion unload job with specification files.

Use the following syntax to create a specification file for a no-conversion unload job:

BEGIN OBJECT FASTUNLOADJOB jobname 
# Compulsory Attributes 
PROJECT projectname 
DEVICE device_array_name 
DATABASE targetdatabasename 
QUERY queryname 

SERVER targetservername 

END OBJECT  

The following table lists the attributes and their values.