CA RC/Query Table Accelerated Information row count does not match actual table row count.

book

Article ID: 14345

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction



When viewing the CA RC/Query for DB2 for z/OS (RCQ) Table Accelerated Information it was noted that there is a difference in the actual row count for an accelerator table compared to the RC/Q Table Accelerated Information returned from the IF CMD.  What would be the cause of the difference? 

Environment

Release:
Component: RCQ

Resolution

The RC/Q Table Accelerated Information is obtain using the stored procedure call SYSPROC.ACCEL_GET_TABLES_INFO.  The information returned from the SYSPROC.ACCEL_GET_TABLES_INFO call may be reporting rows that may be inactive, but still physically exist on the box resulting in the row count difference.