No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

Huawei SAP HANA Appliance Single Node Installation Guide (KunLun 9008 and 9016) 09

Rate and give feedback :
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Adjusting HANA 1.0 Database Parameters

Adjusting HANA 1.0 Database Parameters

After installing the database, adjust the HANA database parameters based on the following:

Parameters for the data volume:

async_write_submit_active:on

async_read_submit:on

async_write_submit_blocks:all

max_parallel_io_requests=256

max_submit_batch_size=128

min_submit_batch_size=32

Parameters for the log volume:

async_write_submit_active:on

async_read_submit:on

async_write_submit_blocks:all

max_parallel_io_requests=256

max_submit_batch_size=128

min_submit_batch_size=32

NOTE:
  • If the log volume uses PCIe SSDs, the following parameters in Parameters for the log volume do not need to be set:

    max_parallel_io_requests=256

    max_submit_batch_size=128

    min_submit_batch_size=32

  • Do not add or miss spaces when copying commands. Otherwise, the command execution may fail.

Use PuTTY to log in as <sid>adm and run the following commands to adjust the HANA database parameters.

hanats:/ # su - s00adm
s00adm@hw00001:/usr/sap/S00/HDB00> HDB start
s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[DATA].async_write_submit_active=on

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[DATA].async_write_submit_blocks=all

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[DATA].async_read_submit=on

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset 
fileio[DATA]. max_parallel_io_requests=256

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset 
fileio[DATA]. max_submit_batch_size =128

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset 
fileio[DATA].min_submit_batch_size=32


s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[LOG].async_write_submit_active=on

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[LOG].async_write_submit_blocks=all

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset fileio[LOG].async_read_submit=on

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam –paramset
fileio[LOG]. max_parallel_io_requests=256

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset 
fileio[LOG]. max_submit_batch_size =128

s00adm@hw00001:/usr/sap/S00/HDB00> hdbparam
--paramset 
fileio[LOG].min_submit_batch_size=32
Translation
Download
Updated: 2019-06-17

Document ID: EDOC1100004728

Views: 36250

Downloads: 122

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Share
Previous Next