Space announcement


This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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

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

Was this page helpful? Yes No Submitting... Thank you