본문 바로가기

SAP HANA

Setting SSL certificate as a customer's certificate in HANA COCKPIT Certificate file is X.509 certificate chain file in PEM format. Key file is RSA key file in PKCS8 PEM format. Command> XSA set-certificate -c [Certificate file] -k [Key file] 더보기
How to Connect MARIADB using SDA in SAP HANA Test Environment: – SAP HANA Version: 2.00.042.00.1564994110 (fa/hana2sp04) – MariaDB Version: 10.3.11 Set the settings in the following order: Install unixODBC Install MariaDB odbc driver Set adm user’s environment(.customer.sh, .odbc.ini, etc.) Create SDA Remote Source using adaptor with MYSQL. Create credential for MariaDB Sample of create credential for SDA Create SQL: CREATE CREDENTIAL FOR .. 더보기
Authorization for HANA Cockpit User — create user DBACOCKPIT password Sap12345 NO FORCE_FIRST_PASSWORD_CHANGE; — alter user DBACOCKPIT disable password lifetime; — FOR SYSTEMDB Only grant select on “SYS_DATABASES”.”M_SERVICES” to DBACOCKPIT; grant select on “SYS_DATABASES”.”M_SERVICE_MEMORY” to DBACOCKPIT; grant select on “SYS_DATABASES”.”M_SERVICE_STATISTICS” to DBACOCKPIT; grant select on “SYS_DATABASES”.”M_HEAP_MEMORY_RESET” to.. 더보기
ZBW_HANA_MIGRATION_COCKPIT (SAP Note 1909597) ************************************************************************ * ZBW_HANA_MIGRATION_COCKPIT (SAP Note 1909597) * Provided by Product Management SAP EDW (BW/HANA) * * This cockpit combines several tools to make the migration of an * existing SAP BW deployment to the SAP HANA platform a more * beautiful experience. * * (c) SAP AG 2011-16 MFB, SAP Canada Inc. * Last update: 2016-03-22 ***.. 더보기
[SAP HANA] Row Store Table Ratio SELECT HOST, PORT, CASE WHEN (((SUM(FREE_SIZE) / SUM(ALLOCATED_SIZE)) > 0.30) AND SUM(ALLOCATED_SIZE) > TO_DECIMAL(10)*1024*1024*1024) THEN 'TRUE' ELSE 'FALSE' END "Row store Reorganization Recommended", TO_DECIMAL( SUM(FREE_SIZE)*100 / SUM(ALLOCATED_SIZE), 10, 2) "Free Space Ratio in %", TO_DECIMAL( SUM(ALLOCATED_SIZE)/1048576, 10, 2) "Allocated Size in MB", TO_DECIMAL( SUM(FREE_SIZE)/1048576, .. 더보기
Using hdbalm New Install Packages. - hdbalm -h -p -u install xxx.zip Update Packages - hdbalm -h -p -u install --option=ALLOW_DU_VERSION_UPDATE xxx.zip 더보기
Uninstall SAP HANA Plugins Uninstall SAP HANA Plugins Procedure 1. Stop HANA Server 2. Change directory to the location of the SAP HANA uninstallation utility: /usr/sap//SYS/global/hdb/install/bin 3. Run the following command to uninstall SAL AFL: ./hdbuninst –b --path= Where is the path to the SAL AFL plugin. By default, the plugin is installed here: ///exe/linuxx86_64/plugins/sal_1.00.84.0 더보기
SAP HANA Delete Backup Catalog Script backup catalog delete all before backup_id ; 더보기