on 11-14-2012 12:11 PM
Hi Experts,
we have a landscape where BW on HANA and Native hana using the same HANA DB, meaning tables are loaded to different schema's of HANA for Bw and Non BW.
I dont want to load any table of BW schema to memory, please advice how to do the same.
when we restart the hana db, most of the tables of BW schema are loaded to memory, i want to shutdown BW on HANA system but HANA Db should be up and running while no table of BW schema are in memory, please advice if there is way to achieve this.
thanks in advance
Hello Ganesh,
SAP HANA always loads all rowstore tables at startup, which includes some tables from BW (usually they are not that big). If you don't want them to consume memory, just unload them using HANA studio "UNLOAD <table>" statement.
Regards,
Marc
SAP Customer Solution Adoption (CSA)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any advice on this please
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.