BMC LOADPLUS for DB2

Load DB2 for z/OS data quickly

Managing the data that supports business applications places a heavy burden on your IT department. You may need to move DB2 data or load full tables, subsets of data, or even random data into a DB2 table for use in a test environment. Your processing requirements may require conversion of data to a different format as part of the load process. How can you load data easily while maintaining continuous availability?

BMC solution

BMC LOADPLUS for DB2 enables you to load data with flexibility and control. Powerful restart capabilities reduce manual intervention when restarting a failed load job. BMC LOADPLUS for DB2 sorts input data, dynamically allocates work files and image copy data sets, rebuilds and reorganizes indexes, and collects DB2 object statistics during the load process.

Features and benefits

• Significantly reduces costs of loading DB2 data  - uses fewer CPU cycles and EXCPs than the native DB2 utility
• Analyzes and allocates memory and CPU resources for maximum performance and availability
• Eliminates the need to execute RUNSTATS utility separately
• Eliminates the need to sort input data separately
• Eliminates the need to reorganize indexes after data is loaded
• Automatically calculates optimal work file sizes and dynamically allocates work file and copy data set space

Key differentiators

• Runs outside of DB2 address space to reduce affect of load process on other applications
• Eliminates the need to execute a separate copy utility separately - produces copies as part of the load process
• Verifies that data is correct before replacing or adding it to existing data - prevents loading of incorrect data due to JCL errors

Related Products

• BMC Database Administration for DB2