Course Description

StorHouse/RM MVS Data Loader

Duration: 1/2 day

This course teaches students how to load data into user tables and indexes in a StorHouse/RM database with a "bulk" load operation from an MVS host. The bulk load operation is performed by the MVS Data Loader utility which uses standard Job Control Language (JCL) to transfer control files and data from an MVS host to a StorHouse/SM in order to load tables and build indexes in a StorHouse/RM database. This course assumes an understanding of standard JCL functionality.

Prerequisites: StorHouse/RM System and Database Administration

Course Objectives:

Upon completion of this course the students will:

• Understand the architecture, use and features of the FileTek MVS Data Loader



• Understand the steps used to load data from an MVS host into StorHouse/RM user tables and to build indexes



• Understand the MVS Data Loader control file and the syntax of the LOAD INTO TABLE statement



• Know how to create JCL to pass the control file and data file to the StorHouse/SM



• Be able to use the restart or abort capabilities to control your database load



• Understand the segment management features of the MVS Data Loader