How to run a CA Fast Unload Job with IBM DB2 Analytics Accelerator tables?.

Document ID : KB000010561
Last Modified Date : 14/02/2018
Show Technical Document Details

CA Fast Unload Jobs can work with IBM DB2 Analytics Accelerator tables with SQL-ACCESS ONLY parameter and the appropriate set up in the IBM DB2 Analytics Accelerator.


When performing a CA Fast Unload Job, it is possible to redirect an SQL-ACCESS ONLY Job to run on an IBM DB2 Analytics Accelerator. In order to do this, you must have a SELECT statement that will run on the IBM DB2 Analytics Accelerator with all normal IBM DB2 Analytics Accelerator limitations, you must be performing a SELECT on an acceleration-eligible table, and you must have your subsystem defined with QUERY_ACCELERATION set to an option that will provide acceleration by default. QUERY_ACCELERATION options that do this include ENABLE, ENABLE WITH FAILBACK, ELIGIBLE, and ALL. These options can be viewed in IBM documentation describing the system parameter.

There is not an explicit CA Fast Unload keyword that will overwrite the system default for the QUERY_ACCELERATION system option.