SAP BASIS

Login on Solution Manager Productive client Start transaction slg2 Select: "and logs which can be deleted before the expire date" (under Expiry date) Specify as value for the "Object" field (under Selection conditions): * N.B.: Do remind to use value exclusions in case for example CDMC is in place (See end of SAP note 1316694) Select: "Delete immediately" (under Options) Create a variant to dele..

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

The first thing we need to do, is to send a customer message to SAP Support (component XX-SER-NET-OSS-NEW) and tell them to register the hostname and IP of our new Saprouter. (In our case it is system name (hostname) = " **"and Public Ip =*******) We have to register it with the official IP address (no internal IPs allowed), but it's allowed to use NAT in the firewall/router. Ports to be allowed..

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 ;

Symtom SMLT ( language is locked: you cannot perform this action) Solution Run TX: SMLT and Enter "abortimp" in the command field and press the ENTER button.

Implement this notes after SAP BW 7.x intalled 1949273 - Important SAP Notes for SAP BW 7.40, powered by SAP HANA - 1846493 - Important SAP Notes for SAP BW 7.3x, powered by HANA

Add Parameter DIR_EPS_ROOT = ex: DIR_EPS_ROOT = \\\sapmnt\trans2\EPS

Symptom The SAP application server is no able to startup with no more work processes. Dispatcher trace file (dev_disp): *** DP_FATAL_ERROR => DpWPCheck: no more work processes *** DISPATCHER EMERGENCY SHUTDOWN *** The work process trace file (dev_w*): M *** ERROR => ThPlgConnectToIcm: IcmReadAck failed (-8, ni_rc=-6) M in_ThErrHandle: 1 M *** ERROR => ThStart: connect to icman (step 1, th_errno ..