본문 바로가기

Archive/HANADB

Archive/HANADB 2021. 5. 6. SAP HANA DB 접속 도구 설치 (SAP Development Tools) SAP Development Tools 사이트 https://tools.hana.ondemand.com/#hanatools SAP Development Tools tools.hana.ondemand.com 사전 요구 사항 설치 과정 Install Eclipse 2020-12 http://www.eclipse.org/downloads/packages/ Eclipse Packages | The Eclipse Foundation - home to a global community, the Eclipse IDE, Jakarta EE and over 350 open source pro 519 MB 537,930 DOWNLOADS Tools for developers working with Java and Web ..
Archive/HANADB 2021. 4. 26. HANA History Memory Usage Data blogs.sap.com/2014/02/12/hana-history-memory-usage-data/ HANA History Memory Usage Data | SAP Blogs 2 Likes 10,326 Views 4 Comments blogs.sap.com select index, used_physical_memory, free_physical_memory, server_timestamp from _SYS_STATISTICS.HOST_RESOURCE_UTILIZATION_STATISTICS order by server_timestamp desc
Archive/HANADB 2021. 4. 23. SAP HANADB Partition 1. Where do I find detailed information about partitioning? General information related to partitioning is contained in the SAP HANA Administration Guide. 2. Which indications exist for issues related to SAP HANA partitioning? The following SAP HANA alerts indicate problems in the memory area: Alert Name Description 17 Record count of non-partitioned column-store tables Determines the number of ..
Archive/HANADB 2020. 11. 10. HANA Backup Issue Symptom The performance duration of a SAP HANA DB backup with backint takes extremely long time until reach successful the end. In the trace files, there are no issues or error to found. Environment SAP HANA DB 1.0 SAP HANA DB 2.0 Reproducing the Issue Long backup duration time occurs and following default configuration values was in use: data_backup_buffer_size from 512 parallel_data_backup_bac..
Linux Memory 확인 방법
Archive/HANADB 2020. 11. 5. Linux Memory 확인 방법 free 메모리 사용량을 확인할 때 사용하는 가장 단순하고 쉬운 명령어. 커널에서 사용하는 공유메모리/버퍼 양 표시 -/+ buffers/cache: 현재 cache 메모리에서 버퍼링된 사용량 -m : MB단위로 데이터 표시 -b : byte단위로 데이터 표시 -k : kilo byte 단위로 데이터 표시 -t : 맨 마지막에 total 량 표시 -o : buffer/cache 표시 안함 -s : 지정한 초단위(Regular interval)로 refresh -l : low & High 메모리 크기 통계 -V : free명령의 버전 표시 ps > ps -ef --sort -rss rss(Resident Set Size) : 물리 메모리를 실제 점유하고 있는 크기 가장 위에 있는 프로세스가 물리 메모리를 ..
새로운 서버에 Tenant DB 복원
Archive/HANADB 2020. 10. 30. 새로운 서버에 Tenant DB 복원 Data Full Backup 복사 scp 백업파일명 로그인계정@대상서버:(경로)/backup/ scp 2020_10_26_03_35_00_databackup_3_1 xxxxxx@xxx.xxx.xxx.xxx:/backup/ HANA Studio에서 복원 진행 - SYSTEM 계정으로 SYSTEMDB에 접속해서 진행 Tenant DB를 선택 RECOVER DATA FOR ERE USING FILE ('/backup/COMPLETE_DATA_BACKUP') CLEAR LOG
Archive/HANADB 2020. 10. 23. HANA GetProcessList sapcontrol -nr 01 -function GetProcessList
Archive/HANADB 2020. 10. 5. Important Hints related to SAP HANA Important Hints related to SAP HANA What are important hints related to SAP HANA? The most important hints of SAP HANA are: Hint CALC_VIEW_UNFOLDING NO_CALC_VIEW_UNFOLDING Type HANA Details Activate / deactivate unfolding of calculation views in SQL statements Scenarios These hints influence the processing of calculation views within SQL statements (see SAP 2177965 and SAP internal 2170436): CAL..
Archive/HANADB 2020. 9. 24. [스크랩] Setting a Memory Limit for SQL Statements help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/1.0.12/en-US/3f9dfb00-5a9a-4164-8d68-57330ee57b47.html Setting a Memory Limit for SQL Statements The statement memory limit allows you to set a limit both per statement and per SAP HANA host. help.sap.com Setting a Memory Limit for SQL Statements The statement memory limit allows you to set a limit both per statement and per SAP HANA host. Pre..

티스토리툴바