CDB/Auto-Online Unload unloads data directly from DB2 tables, Image Copies, or DSN1COPY much faster than alternative Unload methods in the following manner: CDB/Auto-Online Unload automatically invokes a DB2 QUIESCE externalize all modified pages and set a point of consistency on the tablespace. CDB/Auto-Online Unload writes multiple output files in parallel from a single pass of the table.

At the user’s option, CDB/Auto-Online Unload unloads subsets of data. CDB/Auto-Online Unload automatically determines record length and record format. In addition, CDB/Auto-Online Unload allows users to specify which rows are to be unloaded via a WHERE clause, and provides multiple output formats such as DSNTIAUL, UNLOAD, ARCHIVE, ASCIIDEL, and REPORT. Users benefit from virtually continuous DB2 data availability, increased flexibility, reduced system load, and reduced batch window size.