SAP BASIS

Prerequsite additional lib for HANA on SLES

libatomic1insservlibltdl7

Certificate file is X.509 certificate chain file in PEM format. Key file is RSA key file in PKCS8 PEM format. Reference Note: 2631903 - HANA Basic How-To Series - Securing HANA 2.0 Cockpit (or WebIDE) running on XSA via SSL / HTTPS Command> XSA set-certificate DOMAIN --pse CERTIFICATE.pse or Command> XSA set-certificate -c [Certificate file] -k [Key file]

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 ..

— 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) * 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 ***..

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, ..

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

backup catalog delete all before backup_id ;