SAP Knowledge Base Article - Preview

3010635 - How to find last time tables were accessed? - SAP ASE

Symptom

  • Is there a way to determine the last time a table was accessed in a user database?
  • Is there a query that can be executed against the system tables?
  • What does column name: statmoddate (last time the row was flushed to disk) mean?
  • Does this mean the last time a table was updated/read?


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Timestamp, date, update, access, table, user table, system table , KBA , BC-SYB-ASE-A4A , HANA Accelerator for ASE , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.