LOAD PLUS for DB2

The architecture of LOAD PLUS for DB2 is designed for high-speed data loading into DB2 tables on z/OS. The main components include the LOADPLUS address space, which orchestrates the entire process. Within this address space, the data input reader handles reading data from the input files, supporting various formats such as fixed-length, variable-length, and delimited.

The data formatter then prepares the data for loading, and the DB2 interface interacts with DB2 to insert the data into the target tables. The error handler manages errors, providing options to skip invalid records, log errors, and define error limits. Communication between components is primarily internal, optimized for performance.

LOAD PLUS utilizes parallel processing, dividing the input data into multiple partitions and loading them concurrently. This is configured through JCL and control statements. For example: //LOADPLUS EXEC PGM=BMCUTIL, PARM='LOAD', ...

EMP; /*. The product leverages DB2 catalog information for table structure and data type definitions. Security is integrated through DB2's and z/OS's security features, including RACF.

Monitoring and logging are provided through DB2 utilities and system monitoring tools. LOAD PLUS offers superior performance compared to the standard DB2 LOAD utility, making it ideal for large-scale data loading operations.