How DB2 unloads data
DB2® unloads data by table space scan with sort, table space scan, or clustering index.
DB2 unloads data by one of three methods:
- Table space scan with sort: If at least one table space has an index, DB2 uses a table space scan with a sort.
- Table space scan: DB2 uses a table space scan for simple table spaces that contain more than one table, or that contain one table but do not have an index.
- Clustering index: DB2 uses this option for simple table spaces that contain one table and have an index, and for tables in a segmented table space that have an index.