What does Accelerator Loader do?

Accelerator Loader enables efficient loading of data to IBM® Db2® Analytics Accelerator for z/OS and IBM Db2 for z/OS.

IBM Db2 Analytics Accelerator Loader for z/OS enables you to load data to one or more IBM Db2 Analytics Accelerator for z/OS accelerators. Because Accelerator Loader reduces several manual loading steps to a single batch job, you reduce time, effort, and cost. Accelerator Loader enables you to load to IBM Db2 Analytics Accelerator for z/OS from mainframe or non-mainframe, relational or non-relational, and remote sources. After loading, you can query these data sources in IBM Db2 Analytics Accelerator for z/OS using standard Structured Query Language (SQL).

Accelerator Loader enables you to:
  • Extract and convert data to Db2 internal format from non-Db2 and remote sources including IMS, VSAM, SMF Data, and others.
  • Load directly to the accelerator without first loading the data into Db2, reducing CPU and storage resources.
  • Load data into Db2 and multiple accelerators in parallel from the same external load file, reducing two steps to one.
  • Load the accelerator with current Db2 data or with data from a historical point in time without stopping update activity to the production Db2 tables.
  • Load the accelerator with data from an image copy that you specify.
  • Load the same Db2 for z/OS or non-Db2 for z/OS data into multiple accelerators at the same time.
  • Load data into a table that exists only on the accelerator, called an accelerator-only table. In this case, Db2 has a placeholder description for the accelerator-only table in the catalog, but no VSAM data sets exist for the object.
  • Add data to existing accelerator-only tables using LOAD RESUME YES.
  • Back up and restore data in accelerator-only tables.