Db2 RDS Misc and Excp View

Db2 RDS Misc and Excp View shows the RDS EXCP data for the Db2 Analytics Accelerator.

PROFILE_NAME	The name of the profile.
JOB_MEASUREMENT_TS	The timestamp when the Strobe measurement was started.
OWNER	The user ID or job name that initiated the request.
PROFILE_PATH	The path where the profile is located.
RUN_DATE	The date when the reporter processed the sample data set output from the measurement session to create the performance profile.
RUN_TIME	The time when the reporter processed the sample data set output from the measurement session to create the performance profile.
RUN_TS	The timestamp when the reporter processed the sample data set output from the measurement session to create the performance profile.
ENTRY_ID	The ID of the Db2 entry.
END_USER_ID	The end user's ID.
END_USER_TRANS	The end user's transaction name.
END_USER_WORKSTATION	The end user's workstation name.
CORRELATION_ID	The correlation ID of the requester executing the SQL.
TRAN_CODE	The transaction code.
AUTH_ID	The authorization ID.
WLM_NAME	The name of the WLM class under which the workload ran if it was assigned.
ROWS_FETCHED	Shows the number of database rows fetched.
ROWS_INSERTED	Shows the number of database rows inserted.
ROWS_UPDATED	Shows the number of database rows updated.
ROWS_DELETED	Shows the number of database rows deleted.
RID_LIST_PROC_USED	Shows the number of times RID list (also called RID pool) processing is used.
RID_LIST_PROC_NOT_USED_STORAGE	Shows the number of times Db2 detected that no storage was available to hold a list of RIDs during a given RID list process involving one index (single index access with list prefetch) or multiple indexes (multiple index access).
RID_LIST_PROC_NOT_USED_LIMITS	Shows the number of times Db2 detected that a RID list exceeded one or more internal limits during a given RID list (or RID pool) process involving one index (single index access with list prefetch) or multiple indexes (multiple index access).
TIMES_RE_OPT_OCCURRED	Shows the total number of times reoptimization occurred because the value of the host variable or parameter marker changed.
PREPS_SATISFIED_CACHE	Shows the number of times a PREPARE command was satisfied by copying a statement from the prepared statement cache.
PREPS_NOT_SATISFIED_CACHE	Shows the number of times that Db2 searched the prepared statement cache but could not find a suitable prepared statement.
IMPLCIT_PREPS	Shows the count of implicit prepares which occur when the user copy of the prepared SQL statement no longer exists in the local dynamic SQL cache.
NO_PREPS	Shows the number of times where no SQL PREPARE or EXECUTE IMMEDIATE was issued by the application and a copy of a prepared SQL statement was found in local dynamic SQL cache.
PREPS_STMT_DISCARD	Shows the number of times statements are invalidated in the local dynamic SQL cache because the MAXKEEPD limit has been reached.
PREPS_STMT_DROP	Shows the number of times statements are invalidated in the local dynamic SQL cache because of SQL DDL or updated RUNSTATS information and prepared SQL statements in the local dynamic SQL cache have to be reclaimed.
MAX_DEGREE_PG_EXEC	Shows the maximum degree of parallel query processing executed among all parallel groups to indicate the extent to which queries were processed in parallel.
PG_EXECS	Shows the total number of parallel groups executed.
PG_FELL_SEQ_WITH_CURSOR	Shows the total number of parallel groups that fell back to sequential mode due to a cursor that can be used by UPDATE or DELETE.
PG_DEGREE_REDUCED	Shows the total number of parallel groups that did not reach the planned parallel degree because of a lack of storage space or contention on the buffer pool.
PG_DEGREE_EXECS_PLANNED	Shows the total number of parallel groups that executed in the planned parallel degree.
PG_ON_SINGLE_COORD_SUBS_NO	Shows the total number of parallel groups executed on a single Db2 subsystem due to the COORDINATOR subsystem value being set to NO.
PG_ON_SINGLE_ISOLATION_LEVEL	Shows the total number of parallel groups executed on a single Db2 subsystem due to repeatable-read or read-stability isolation.
PG_INTENDED_ACROSS_GP	Shows the total number of parallel groups that Db2 intended to run across the data sharing group.
PG_MEMBER_BYPASSED	Shows the number of times the parallelism coordinator had to bypass a Db2 when distributing tasks because one or more Db2 members did not have enough buffer pool storage.
PG_REFORMULATED_CONFIG_CHANGE	Shows the total number of parallel groups where Db2 reformulated the parallel portion of the access path because of a change in the number of active members, or because of a change of processor models on which they run, from bind time to run time.
PG_REFORMULATED_BP_SHORTAGE	Shows the total number of parallel groups in which Db2 reformulated the parallel portion of the access path because there were insufficient buffer-pool resources.
PG_FELL_SEQ_BUF_SHORTAGE	Shows the total number of parallel groups that fell back to sequential mode due to a storage shortage or contention on the buffer pool.
PG_FELL_SEQ_EAS	Shows the total number of parallel groups that fell back to sequential mode due to a lack of ESA sort support.
DRA_ATTEMPTS_TS_SCAN_REVERT	Shows the number of times that an attempt to use direct row access reverted to using a table-space scan because Db2 was unable to use a matching index scan.
DRA_ATTMEPTS_OK	Shows the number of times that direct row access was successful.
DRA_ATTEMPTS_INDEX_REVERT	Shows the number of times an index was used to find a record.