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) 08

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 2.0 Database Parameters

Adjusting HANA 2.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
hanats:/usr/sap/S00/HDB00> hdbsql -u SYSTEM -p Huawei@123

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help
with commands
       \q to quit


hdbsql S00=> ALTER SYSTEM ALTER CONFIGURATION
('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests [DATA]') = '256' WITH RECONFIGURE;

hdbsql S00=> ALTER SYSTEM ALTER
CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio',' max_submit_batch_size [DATA]') = '128' WITH RECONFIGURE;

hdbsql S00=> ALTER SYSTEM ALTER
CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio',' min_submit_batch_size [DATA]') = '32' WITH RECONFIGURE;

hdbsql S00=> ALTER SYSTEM ALTER
CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio',' max_parallel_io_requests [LOG]') = '256' WITH RECONFIGURE;

hdbsql S00=> ALTER SYSTEM ALTER
CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio',' max_submit_batch_size [LOG]') = '128' WITH RECONFIGURE;

hdbsql S00=> ALTER SYSTEM ALTER
CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio',' min_submit_batch_size [LOG]') = '32' WITH RECONFIGURE;
Translation
Download
Updated: 2019-05-14

Document ID: EDOC1100004728

Views: 32001

Downloads: 116

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