본문 바로가기

SAP HANA

(8)
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, ..