To take the DB2 9 DBA 731 exam, you must have already passed the DB2 9 Fundamentals exam 730. We recommend that you take the DB2 Fundamentals tutorial series before starting this series.
This tutorial is one of the tools to help you prepare for Exam 731. You should also review the resources at the end of this tutorial for more information about DB2 utilities (see Resources).
Although not all materials discussed in the Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should at least have a basic knowledge of:
It is important to make sure that the data you want to transfer is compatible with both the source and target platforms. File formats supported by the utilities are:
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.
Worksheet Format (WSF): Data stored in this format can be interpreted in worksheets. It can be used for export and import only.
Cursor: A cursor is declared with a query. It can only be used as the input of a load operation.
No Responses Comments and Pings closed