Skip to Content
0

Can the information of currently loaded tables be saved and restored manually?

Mar 01 at 01:00 PM

34

avatar image

Hello,

this is the situation:

- HANA 1.0 SPS12

- There is no PRELOAD flag set for any table

- 3TB of column tables are loaded during normal workload

- The RELOAD feature is active.

During a HANA revision update (after the executables were updated) the delivery units are going to be imported. If the parameter "reload_tables = true" was set before the update process gets started, the system will reload all tables (3TB) which were loaded during normal operation and recognised by the reload-mechanism.

Due to the high I/O load, the delivery unit import will be extremly slow and will just complete after the table reload has finished.

My idea was to set the reload_tables parameter to "false" before the update begins, then do the update and set the parameter back to "true" afterwards in combination with a HANA restart.

Does the HANA system lose the information which tables were loaded, when I set the parameter to "false" or are they saved somewhere and will be noticed when I re-activate the parameter?

My fear is, that the information is lost and when I reactivate the parameter the system will rescan all loaded tables at this moment (which are just a few) and so all the other tables needed by the SAP system for normal work don't get loaded at startup time.

If the information gets lost: Is there a way to manually save the information which tables are loaded at the moment and to restore this information to the system after the parameter gets activated again?

Regards
Mike

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers