InfoLoad for DB2 on z/OS Modernization Guide

InfoLoad is a high-speed data loading utility for DB2 on z/OS. It is designed to efficiently load data from InfoUnload dumps into DB2 tables, minimizing downtime and resource consumption.

InfoLoad uses optimized data transfer techniques and parallel processing to achieve high loading speeds. It bypasses some of the overhead associated with standard DB2 load utilities, resulting in faster load times.

InfoLoad is part of the INFO-UTIL product suite from Infotel. It is specifically designed to work with data unloaded using InfoUnload, another utility in the suite.

The primary command is typically invoked through JCL (Job Control Language) on z/OS. The JCL specifies the input InfoUnload dataset, the target DB2 table, and various control options.

InfoLoad uses control cards within the JCL to specify load parameters. These parameters include the input dataset name, the target table name, and options for error handling and data conversion.

InfoLoad integrates with DB2's standard utilities and interfaces. It does not expose a separate API. Instead, it leverages DB2's existing interfaces for data access and manipulation.

InfoLoad reduces the time required to load data into DB2, minimizing downtime for applications that rely on that data. This can translate to improved service levels and reduced operational costs.

By speeding up the data loading process, InfoLoad allows organizations to refresh their DB2 data more frequently. This can improve the accuracy and timeliness of business intelligence and reporting.

InfoLoad leverages DB2's built-in security features for authentication and authorization. It does not introduce its own security mechanisms.

Access to InfoLoad is controlled through standard z/OS security mechanisms, such as RACF (Resource Access Control Facility). Users must have the necessary privileges to access the input datasets and the target DB2 tables.

InfoLoad relies on DB2's audit logging capabilities to track data loading activities. These logs can be used to monitor and audit data loading processes.

InfoLoad is administered through JCL and control cards. There is no separate administrative interface.

Monitoring InfoLoad involves tracking the execution of the JCL jobs and reviewing the DB2 logs. Standard z/OS monitoring tools can be used for this purpose.

Configuration parameters for InfoLoad are specified in the control cards within the JCL. These parameters include the input dataset name, the target table name, and various load options.