The onpladm utility features

You can create and maintain the onpload database with the onpladm utility and the ipload utility. The onpload database stores information about the High-Performance Loader (HPL) objects of load and unload jobs.

The first time that you issue a create command, the onpladm utility creates the onpload database, if it does not yet exist.

The onpladm utility can perform the functions that the following table describes.
Object Operation
Project Create, delete, describe, list, run
Job Create, delete, describe, list, modify, run
Map Create, delete, describe, list, modify
Format Create, delete, describe, list, modify
Query Create, delete, describe, list, modify
Device array Create, delete, describe, list, modify
Computer Create, delete, describe, list, modify
Target server Configure and list default settings
Filter Create, delete, describe, list, modify
The onpladm utility also allows you to:
  • Create jobs and other objects with a single, minimum-input command.
  • Specify object characteristics in specification files.
  • Create, load, or unload jobs for all tables in a database.
  • Create jobs for an entire database and group the jobs into a project with a single command.
  • Run individual jobs or projects independently.
Important: The most effective way to use onpladm is to create and modify HPL objects is to:
  1. Create the default objects by using default job creation options.
  2. Use describe object syntax to describe the objects.
  3. Manually modify these objects with correct values for different configuration parameters.
  4. Use modify object syntax to correctly create these objects.

Copyright© 2018 HCL Technologies Limited