Getting started

In an IBM Db2 environment, there often is a need to load large amounts of data into Db2 tables—to populate a table initially, or to replace the data in the table periodically. The data can originate from sources such as:

  • Other Db2 tables (possibly from a different Db2 system)
  • Other DBMSs, including IBM IMS or distributed-systems DBMSs
  • Applications that generate sequential files

Related topic

Product-features

In many cases, users load millions of rows. Because data in the table space is often unavailable to applications during the load process, the load process must be completed as quickly as possible. The LOADPLUS for DB2 product is a flexible, high-performance tool that combines all of the basic load tasks with additional functionality. LOADPLUS offers significant benefits:

  • Increases availability of Db2 data because LOADPLUS reduces the time needed to load the data

    In addition, the online load options allow your tables to remain accessible in either read-only (RO) or read/write (RW) status while LOADPLUS loads your data. LOADPLUS also provides a unique, high-performance option that works with UNLOAD PLUS to reduce the total processing time for unloading and reloading data.

  • Reduces costs of loading Db2 data because LOADPLUS uses fewer CPU cycles and EXCPs
  • Provides flexibility by allowing you to load data from a variety of input formats

  • Expands functionality to eliminate the need to perform additional tasks before and after data is loaded

    For example, LOADPLUS provides the following functions:

    • Comprehensive set of data type conversions to reduce the need for special application code
    • Ability to make the image or inline copies during the load
    • Ability to dynamically allocate work files and copy data sets, reducing the need to include DD statements in your JCL
  • Integrates with the BMC solutions for Db2

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*