This course covers methods of moving data in and out of a DB2 database and propagating data from a source database to a target database through replication. After taking this course, learners will be better prepared to decide which utility to use when manipulating data.
Objectives:
Use the export, import, and load utilities
Use the Set Integrity Wizard
Create a replication source and target table
Create a subscription set
Administer the capture and apply programs
Topics:
Exporting data
Importing and loading data
Import options for various file formats
The Load Wizard
Replication concepts
Creating a replication environment
Monitoring the capture and apply programs
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.