cancel
Showing results for 
Search instead for 
Did you mean: 

Unload tables from BW Schema

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member93896
Active Contributor
0 Kudos

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)

Former Member
0 Kudos

any advice on this please