DESCRIPTION OF ACCEL_OFFLOAD_ELIGIBLE COLUMN
search cancel

DESCRIPTION OF ACCEL_OFFLOAD_ELIGIBLE COLUMN

book

Article ID: 139023

calendar_today

Updated On:

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).