본문 바로가기

Database

 (103)
[HANA] Scale-out Take-over 시 OSTR 상태 Take-over 수행 시 OSTR 상태 Test Environment Environment 구분 Primary Site Secondary Site Master Node Slave Node Master Node Slave Node Node명 hana3-master hana3-slave hana1-master hana1-slave M_TABLES BMSQL_CONFIG BMSQL_CONFIG STEP-1. Table replicate 수행 Execute Table Replicating on Primary Site Check on Secondary Site -> Secondary에서는 m_table_replicas에서 조회 불가 => 즉, Table replicate는 수행중이지 않음 But, Primary..
[HANA] HANA 2.0 SPS04 - New feature (Auto register) Secondary Site의 자동 재등록 Takeover 후 Auto Register 설정 Parameter register_secondaries_on_takeover File name (s) global.ini Description All secondary sites that where registered to the previous primary are re-registered to the current site on takeover Data type BOOLEAN Default FALSE Restart required False Layer Restrictions SYSTEM Parameter retries_before_register_to_alternative_source File name (s) ..
[HANA] Trace file 통합 확인 보호되어 있는 글입니다.
[HANA] Scale-out Table replication Table Replication OSTR설정 -- Replicate 수행 alter table bench.a7 add synchronous replica at 'hana1-slave:30003'; -- 현황 조회 select * from m_table_locations where schema_name = 'BENCH'; select * from m_table_replicas; 시나리오> Table Replicate 수행 OSTR 삭제 -- Replica 삭제 alter table bench.a7 drop replica at all locations; -- 상태 확인 select * from m_table_locations where schema_name = 'BENCH'; select * from m_t..
[HANA] Scale-out table relocation TABLE GROUP 지정 USER의 GROUP NAME별 위치 지정 BENCH / GRP_M - Master / GRP_S - Slave Command -- User별 Default Location 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'BENCH') SET(LOCATION=>'master'); -- User - GROUP별 Default Location 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'BENCH', GROUP_NAME => 'GRP_M') SET(LOCATION=>'master'); ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'B..
[HANA] Load 측정 KPI - Current Load Current Load select left(now()||'',19) Time , m_t_running , m_t_nw_poll , m_t_jobexec_wait , m_t_mutex_wait , m_t_exlock_enter , m_t_semaphore_wait , m_t_shlock_enter , m_t_joining , m_t_intentlockenter , m_t_all - (m_t_running+m_t_nw_poll+m_t_jobexec_wait+m_t_mutex_wait+m_t_exlock_enter+m_t_semaphore_wait+m_t_shlock_enter+m_t_joining+m_t_intentlockenter) m_t_other , s_t_running , s_t_nw_poll , ..
[HANA] Load 측정 KPI - Load History Load History with raw as ( select a.timemi , a.host -- 1. Host , a.host_cpu_util , a.host_mem_resd_mb , a.host_mem_tot_resd_mb , a.host_mem_usd_mb , a.host_mem_alloc_lim_mb , a.host_mem_sz_mb , a.host_swap_in_mb_sum , a.host_swap_out_mb_sum , a.host_disk_sz_mb , a.host_disk_usd_mb , a.host_nw_in_mb_sum , a.host_nw_out_mb_sum -- 2. Service , b.cpu_util , b.system_cpu_util , b.used_mem_mb , b.mall..
[HANA] 2491748 - How-To: Analyzing Runtime Dumps with SAP HANADumpViewer 출처 : https://launchpad.support.sap.com/#/notes/2491748 https://launchpad.support.sap.com/#/notes/2491748 launchpad.support.sap.com 2491748 - How-To: Analyzing Runtime Dumps with SAP HANADumpViewer Symptom You are interested in analyzing SAP HANA runtime dumps Environment SAP HANA Cause Attention: The SAP HANADumpViewer functionality is now fully integrated in the more comprehensive SAP HANA Dump..

티스토리툴바