Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
High-Performance Loader User's GuideThe describes how to use the HCL Informix® to load and unload large quantities of data efficiently to or from Informix® databases.
The onpladm utilityThis section describes how to use the onpladm utility.
Define onpladm utility jobsYou can create, modify, describe, list, run, and delete jobs with the onpladm utility.
Create onpladm jobs
Create no-conversion jobsA no-conversion job is faster than a conversion job because onpload uses the internal format of the target database and does not create maps or formats. No-conversion jobs are always run in express mode.
Create no-conversion jobs by using detailed specification filesYou 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 objects; the onpladm utility does not create these objects for you.
Create a no-conversion unload job

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


Attribute	Attribute value
device_array_name	Device-array name You must create the device array; onpladm does not create it for you.
jobname	Job name
projectname	Name of an existing project
queryname	The SQL SELECT statement, in quotation marks, that contains unload criteria
targetdatabasename	Name of the database that the records will be loaded or unloaded to; if set, this value overrides the database value in the load map
targetservername	Name of the target database server

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.