IBM Informix Data Migration and Reorganization
| Gain experience using Informix data movement utilities, including SQL LOAD and UNLOAD, dbload, dbexport, dbimport, onpload, and the High Performance Loader (HPL). |
| This is a basic course for IBM Informix Dynamic Server and IBM Informix Dynamic Server.2000 database and system administrators, application developers, and technical support individuals |
| 2 Day(s) |
| Instructor-led Classroom Learning |
- Relational Database Design or have equivalent knowledge
- IBM Informix Structured Query Language or have equivalent knowledge
- Managing and Optimizing IBM Informix Dynamic Server Databases
|
Students will learn: - Identify the Informix tools available for data migration and reorganization
- Select the best tool for various data migration tasks
- Create HPL objects: devices, formats, maps, filters, and queries
- Define HPL objects to provide maximum reusability
- Assemble HPL objects to create load and unload jobs
- Use the ipload Graphical User Interface (GUI) interface to create objects and jobs
- Use the autogenerate features of the HPL to generate maps, formats, load jobs and unload jobs
- Monitor and tune onpload for optimal performance
- Use Deluxe and Express mode loads
- Troubleshoot common problems with the HPL
|
Course overview: - IBM Informix data migration tools
- Introduction to the HPL
- Defining HPL device arrays
- Defining formats
- Defining HPL maps
- Defining HPL filters
- Defining and executing a load job
- Defining queries
- Defining an unload job
- Creating projects
- Using, monitoring, and tuning onpload
|
| Call (888)-99-ITTOD For Pricing On This Training Course |
