SAP Knowledge Base Article - Preview

3583835 - HANA_Tables_TopGrowingTables_Size_History/HANA_Tables_TopGrowingTables_Records_History only shows the old data.

Symptom

  • HANA_Tables_TopGrowingTables_Size_History and HANA_Tables_TopGrowingTables_Records_History only show the old data.
  • Modify the BEGIN_TIME/END_TIME with date and time

       '2025/03/01 07:58:00' BEGIN_TIME,                  /* YYYY/MM/DD HH24:MI:SS timestamp, C, C-S<seconds>, C-M<minutes>, C-H<hours>, C-D<days>, C-W<weeks>, E-S<seconds>, E-M<minutes>, E-H<hours>, E-D<days>, E-W<weeks>, MIN */
       '2025/03/17 08:05:00' END_TIME,                    /* YYYY/MM/DD HH24:MI:SS timestamp, C, C-S<seconds>, C-M<minutes>, C-H<hours>, C-D<days>, C-W<weeks>, B+S<seconds>, B+M<minutes>, B+H<hours>, B+D<days>, B+W<weeks>, MAX */ 
  • But the result shows an old date and time
    -> 
    ;BEGIN_TIME;END_TIME        ;SPACE_LAYER;HOST;PORT ;SCHEMA_NAME;TABLE_NAME;SIZE_BEGIN_MB;SIZE_END_MB;SIZE_CHG_MB;CHG_PCT
    1;?         ;2024/03/06 16:07;DISK       ;any ;  any;any        ;/xxx/xxx;         0.00;   64972.69;   64972.69;9999.00

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 


Read more...

Environment

  • SAP HANA Platform Edition 1.0
  • SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

HANA, statistics server, statistics, old data, HANA_Tables_TopGrowingTables_Size_History , HANA_Tables_TopGrowingTables_Records_History  , KBA , HAN-DB , SAP HANA Database , HAN-DB-MON , SAP HANA Monitoring , Problem

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.