Data movement utilities
A key objective of the exam is to demonstrate the ability to use traditional DB2 data movement utilities. In this section, we will discuss the various available DB2 data movement tools, utilities, stored procedures, and commands.
DB2 has four data movement utilities:
In addition to the above utilities, the following commands and stored procedures are available:
Four OS file formats supported by the DB2 export, import, ingest, and load utilities are described:
- Non-delimited or fixed-length ASCII (ASC) — As the name implies, this file type contains ASCII data in fixed length to align with column data. Each ASC file is a stream of ASCII characters consisting of data values ordered by row and column. Rows in the data stream are separated by row delimiters, which are assumed to be newline characters.
- Delimited ASCII (DEL) — This is the most common file format used by a variety of database managers for data exchange. It contains ASCII data and uses special character delimiters to separate column values. Rows in the data stream are separated by a newline character as the row delimiter.
- PC version of the Integrated Exchange Format (PC/IXF) — This is a structured description of a database table. This file format can be used not only to import data but also to create a table that does not already exist in the target database.
- Cursor — A cursor is declared with a query. It can only be used as the input of a load operation.
Table 1. Supported file formats summary
|ASC (including binary||supported||supported||supported|
|Cursor||not supported||supported||not supported|