The following SAP HANA parameters control column loads during SAP HANA startup and on the secondary system of a system replication scenario based on columns loaded
into memory before the shutdown.
Parameter Name - preload_column_tables
Default Value - true
About Parameter -
Per default SAP HANA loads the columns into the memory of the secondary system of a system replication scenario during normal uptime. This has the advantage that a reload is not required at failover time. If you want to disable this feature (e.g. because only limited memory is available on the secondary side), you can set the preload_column_tables parameter to ‘false’.
The effect of this parameter depends on the system where it is set.
Primary system: Information about loaded tables is collected and persisted in the system replication related snapshot.
Secondary system: The load information from primary is evaluated and the tables are loaded accordingly.
How to Set Parameter - global.ini -> [system_replication] -> preload_column_tables
Additional Command - we can check for tables currently part of this reload information using the following hdbcons command.
tablepreload c -f
Parameter Name - preload_column_tables
Default Value - true
About Parameter -
Per default SAP HANA loads the columns into the memory of the secondary system of a system replication scenario during normal uptime. This has the advantage that a reload is not required at failover time. If you want to disable this feature (e.g. because only limited memory is available on the secondary side), you can set the preload_column_tables parameter to ‘false’.
The effect of this parameter depends on the system where it is set.
Primary system: Information about loaded tables is collected and persisted in the system replication related snapshot.
Secondary system: The load information from primary is evaluated and the tables are loaded accordingly.
How to Set Parameter - global.ini -> [system_replication] -> preload_column_tables
Additional Command - we can check for tables currently part of this reload information using the following hdbcons command.
tablepreload c -f
No comments:
Post a Comment