Group: IBM Db2 Analytics Accelerator for z/OS exceptions

Edit online

These exceptions enable you to determine whether a table that is enabled for IBM Db2 Analytics Accelerator for z/OS is fully operational or if it needs to be reloaded.

You can create a Db2 Automation Expert utility profile to generate the JCL to load tables that are enabled for IBM Db2 Analytics Accelerator for z/OS with the Load Accelerator Tables utility. For more information, refer to the topic Load accelerator table options.

IBM Db2 Analytics Accelerator for z/OS exception conditions only apply to tables that are loaded onto an appliance. Objects that are not enabled for IBM Db2 Analytics Accelerator for z/OS are not evaluated by these exception conditions.

All accelerators that are attached to a Db2 subsystem will be queried. This means that, for example, if there are two accelerators attached to a Db2 SSID, any selected exception conditions will be applied to all tables in the object profile that are enabled for IBM Db2 Analytics Accelerator for z/OS, on both of the accelerators.

The following table explains the exception values (under the IDAA heading) for IBM Db2 Analytics Accelerator for z/OS that appear on the Update Exceptions Profile Display.

Table 1. Statistics type: IBM Db2 Analytics Accelerator for z/OS
Statistic	Description
NOT_OPERATIONAL	Triggers an exception if the status of a table that is enabled for IBM Db2 Analytics Accelerator for z/OS is not operational. Message DAJ218W is issued to alert you of this condition.
RELOAD_RECOMMENDED	Triggers an exception if the status of a table that is enabled for IBM Db2 Analytics Accelerator for z/OSis RELOAD_RECOMMENDED or RELOAD REQUIRED.
DAYS_SINCE_LOADED	Triggers an exception if the specified number of days since the last time a table that is enabled for IBM Db2 Analytics Accelerator for z/OS was loaded is met.