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

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

book

Article ID: 10561

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

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.



Environment

Release:
Component: PFU

Resolution

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.