This chapter will introduce you to the data movement utilities, such as Import, Export, Load, and Ingest, that are available in Db2. You will be able to use online table movement procedures to copy a specific table and specific schema without impacting on applications. You will also be introduced to database maintenance utilities such as REORG, REORGCHK, REBIND, and RUNSTATS. In addition to this, you will learn how to use the db2look and db2move tool commands:
- Demonstrate the ability to use the Export utility to extract data from a database and store it in an external file
- Demonstrate the ability to use the Import and Load (bulk-load) utilities to load the data from an external file to a database table
- Demonstrate the ability to use the Continuous Data Ingest (CDI) utility to perform high-speed data transformation, and loading into a database table
- Demonstrate the...