308 DB2 UDB ESE V8 Performance Guide for High Performance OLTP and BI
The following subsections are organized as follows:
򐂰 Brief description
򐂰 Performance considerations
򐂰 Best practices
4.3.1 Brief description
The export command is used to write data from a DB2 database to one or more
files stored outside of the database. The exported data can then be imported or
loaded into the same or different DB2 database (using the DB2 import or the
DB2 load utility, respectively), or it can be imported into another application (for
example, a spreadsheet).
The data to be exported can be specified by a SELECT statement, or by
providing hierarchical information for typed tables.
Following is an example of the export command:
db2 export to staff.ixf of ixf select * from userid.staff
The export utility is an embedded SQL application and does SQL fetches
internally.
See IBM DB2 UDB Data Movement Utilities Guide and Reference, SC09-4830
for further details.
4.3.2 Performance considerations
The following performance considerations apply:
򐂰 Since the export utility does SQL fetches internally, all optimizations available
to SQL operations apply to export as well, such as large buffer pools,
indexing, and sort heaps.
򐂰 Minimize device contention on the output files.
4.3.3 Best practices
We recommend the following best practices to achieve superior export
performance.
Note: When LOBs are involved, multiple paths may be provided to store LOB
data to avoid out-of-space conditions in the file system.

Get DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.