DESCRIPTION OF ACCEL_OFFLOAD_ELIGIBLE COLUMN

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

This is a description of ACCEL_OFFLOAD_ELIGIBLE column  in DSN_STATEMENT_CACHE_TABLE 

 

Environment

Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

The ACCEL_OFFLOAD_ELIGIBLE column in the DSN_STATEMENT_CACHE_TABLE table shows
whether a statement is eligible for acceleration.
If the value ‘Y’ is displayed,
the statement can be accelerated.
If ‘N’ is displayed, the statement is either
not eligible or the query is already routed to an existing accelerator

(Accelerator Modeling is not performed for queries that are routed to an Accelerator).