PH59232: THE FIELDS ACCESSCOUNT AND LASTACCESSTIMESTAMP FOR AN ACCELERATOR-SHADOW TABLE ARE UPDATED EVEN W/O RUNNING A QUERY

APAR status

• Closed as documentation error.

Error description

• A customer running the stored procedure ACCEL_GET_TABLES_INFO
  notices that the return values AccessCount and
  LastAccessTimeStamp for an accelerator-shadow table have been
  updated although no query was run that has accessed that table.
  It seems to be the case that, for example, the replication
  process updating the accelerator-shaow table triggers an update
  of those fields.
  This is in contradiction with the description in
  https://www.ibm.com/docs/en/daafz/7.5?topic=procedures-sysprocac
  cel-get-tables-info
  and with the intention of those information fields.
  
  It is intended to deliver a corresponding fix with Accelerator
  maintenance level 7.5.12.2.
  
  Additional keywords:
  TS014990273 TS015650997
  SYSPROC.ACCEL_GET_TABLES_INFO AccessCount LastAccessTimeStamp
  GH/.../Customer-Cases/issues/633 DT258770
  

Local fix

Problem summary

• Problem Summary:
  The fields AccessCount and LastAccessTimeStamp for an
  accelerator-shadow table are not only updated by customer
  queries but also by other processes such as replication. The
  fields are changing even without running any query.
  
  Users Affected:
  Customers monitoring accelerator-shadow tables by using stored
  procedure ACCEL_GET_TABLES_INFO to retrieve the fields
  AccessCount and LastAccessTimeStamp.
  
  Problem Scenario:
  See APAR Error description.
  
  Problem Symptoms:
  See APAR Error description.
  

Problem conclusion

• The issue has been fixed with Accelerator maintenance level
  7.5.12.2.
  The fields LastAccessTimeStamp and AccessCount of an
  accelerator-shadow table table are now only updated if the table
  is accessed by a customer query.
  Upgrade your accelerator environment(s) accordingly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels