SAP Knowledge Base Article - Preview

2899966 - Options to Speed up Table Reloading time after SAP HANA Database restart

Symptom

  • You want to improve the Column store table reloading on HANA
  • You see from the Index server trace that the time for the HANA Restart is lost in the trace component 'TableReload':

    [38831]{-1}[-1/-1] 2025-06-24 09:20:18.668705 i Basis            TraceStream.cpp(00526) : ==== Starting hdbindexserver, version 2.00.079.00.1720729199....
    ......
    [42538]{-1}[10/-1] 2025-06-24 09:23:52.898295 i TableReload      TRexApiSystem.cpp(00699) : Now reloading <number of tables> tables (loading up to 8 tables in parallel)
    ......
    [42538]{-1}[-1/-1] 2025-06-24 11:06:06.237139 i TableReload      TRexApiSystem.cpp(00725) : Finished table reloading
    [42538]{-1}[-1/-1] 2025-06-24 11:06:06.257473 i Service_Startup  TREXIndexServer.cpp(02071) : Pre-/Re-Loading of column store tables finished.

    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 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

reload, loading, columnstore, load, restart, starting, startup, Hana, TableReload, Finished table reloading , KBA , HAN-DB , SAP HANA Database , 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.