How to restore SAP Sybase DB in to the same host.

If you wan to restore SAP sybase DB into the Same host using the backup dump, please follow below steps:

1. First make sure the dump is available to the file system level.
2. Stop SAP system
    stopsap
3. Then start only Sybase database
    startdb
4. Now Switch use to syb<sid> then connect tot he DB
    su - syb<sid>
    isql64 -Usapsa -P<password> -S<SID> -X
5. Now trigger restore command:
    use master
    go
    load database <SDI> from '<path of the file/<filename>'
    go

6. After processing the load, it will ask run bring online command.
    online database <SID>
    go

7. Exit from sybase level and stop and start the SAP.

How to backup SAP Sybase Database

If you want to do a backup of Sybase Database for SAP, we can do in different ways.
1. From DBACOCKPIT you can schedule in the database calendar.
2. Run the backup command from OS Level.
3. Using the third party tools.


To take the backups in sybase we need to create dump configuration. this is required to perform the backup options 1 & 2.
Below are the steps to perform using Commands at OS Level (linux).
1. Login to OS level and switch to database user.
    su - syb<sid>
2. Connect to Sybase DB level
    isql64 -Usapsa -P<password> -S<SID> -X
3. connect to master database
    use master
    go
4. Now configure dump
    sp_config_dump @config_name='<sidDB>',
    @stripe_dir = '<backup path>' ,
    @compression = '101' ,
    @verify = 'header'
    go
5. Now trigger the backup providing the file name
    dump database <SID> using config = 'dump config file name(which      we created in the above step)'

    

How to donwload, Install and add HANA DB to Studio

Download HANA Studio software:

1.   Open portal: https://support.sap.com or directly open https://launchpad.support.sap.com/#/softwarecenter

2.       If you open first link, Select Download Software

3.  It will open a new window and you need SAP S user to login, select SUPPORT PACKAGES & PATCHES, then extract By Alphabetical Index (A-Z)

4. Choose letter H

5. Select HANA PLATFORM EDITION

6. Choose SAP HANA PLATFORM EDITION 2.0.
7. Select HANA Studio 2

8. Under downloads Select which operating system you want, here we are selected Windows, and download latest file.

 9.  Download SAPCAR file for Windows version from above place, search with name SAPCAR and download related to windows.

Installation of HANA Studio:

1. Then extract the HANA Studio.SAR using SAPCAR file.

 It will extract all files to install and creates a folder.

 2.       Double Click on hdbsetup

 Click on Finish.

 Adding HANA system in Studio:

Open HANA Studio by click below icon

 For the first time it will ask to select the workspace, if you want you can change it later.

 Click on launch

Below are the available consoles:

Click on Administration Console

And click Add system icon to add HANA system

 Enter details of HANA DB

 Click on Finish

It will add system like below:

 Click on the First line “ SYSTEMDB@XXXXXX”

You can get complete details at right side.

Business Functions in SAP

Important Tcodes for Business Functions:
SFW5 - activate/deactivate Business Functions 
SFW BROWSER - investigate, which enhancements are related to the Business Function in question 
SFW1 - create switches (only customer enhancements) 
SFW2 - create Business Functions (only customer enhancements) 
SFW3 - create Business Function Sets for industry solutions (only customer enhancements) 

We need to activate Business Functions in Development system and then need to transport over the Landscape:

Activating Business functions:
1. Start Tcode: SFW5
2. Select Business Functions which needs to activate
3. Chose Activate Changes. One batch job will trigger for the actiation. Job name is: SFW_ACTIVATION_SF0X
4. Then Capture in a Transport through out the landscape.
5. for logs, Goto -> Switch Framework Logs in SFW5.
For any reason the activation has cancelled, you can restart the activation selecting: System Settings --> Activate Restart. Business Functions can activate in any client, it will be activated Globally. Please make sure if any prerequisites needs to perform for any Business Function before activation.
Important SAP Notes:
SAP Note 1324838 Mapping of Business Functions to Technical Usages 
SAP Note 1524246 Relationship of licenses and business functions 
SAP Note 337623  Customizing after installation or upgrade 
SAP Note 868771  Copy Special Customizing 

SAP Note 908007  Special functions in Switch Framework / SFW5 

DBACOCKPIT Activation

If you get Error " The Web Dynpro User Interface of the DBA Cockpit is not configured"

Or any Services are not active errors while Accessing DBACOCKPIT, please follow below steps to activate the services:

Goto SICF_INST

Enter 'WEB DYNPRO ABAP' as technical name.

Execute:

Come back and Enter 'WEB DYNPRO DBA COCKPIT' as a technical name.

Generation of the Web Dynpro Runtime:

• ·         Call transaction SGEN
• ·         Select 'Generation of Web Dynpros'
• ·         Choose 'Continue'
• ·         Select software component 'SAP_BASIS'
• ·         Choose 'Continue'
• ·         Choose 'Continue'
• ·         Choose 'Start Job Directly'

Now try to execute the DBACOCKPIT.

Useful Transactions for FIORI

/n/UI2/FLP                       To Launch SAP Fiori Launchpad

/n/UI2/FLPD_CONF         To Launch Fiori Launchpad Designer (cross-client)

/n/UI2/FLPD_CUST         To Launch Fiori Launchpad Designer (client-specific)

/n/UI2/CACHE_DEL         Delete cache entries

/n/IWFND/MAINT_SERVICE To Activate ODATA Services

/n/IWNFD/ERROR_LOG         To check Fiori Error logs

/n/UI2/GW_ACTIVATE           Gateway – Activation

/n/UI2/GW_APPS_LOG         Gateway – Application Log

/n/UI2/GW_ERR_LOG           Gateway – Error Log

/n/UI2/GW_MAINT_SRV        Gateway – Service Maintenance

/n/UI2/GW_SYS_ALIAS         Gateway – Manage SAP System Alias

Important Note's Related to SAP HANA

Supported Operating System for SAP HANA:
Before the SAP HANA installation can be started, you must configure the Linux system according to the recommended OS settings for SUSE Linux Enterprise Server (SLES) and Red Hat Enterprise Linux (RHEL). 
Note's: 
See SAP Note 2235581 - "SAP HANA: Supported Operating Systems" for an overview of all of the supported Linux versions. 

SUSE Linux Enterprise Server (SLES) for SAP 11 SP2. See SAP Note 1310037 and 1824819 - SAP HANA DB: Recommended OS settings for SLES 11 SP2 
SUSE Linux Enterprise Server (SLES) for SAP 11 SP3. See SAP Note 1310037 and 1954788 - SAP HANA DB: Recommended OS settings for SLES 11 SP3 
SUSE Linux Enterprise Server (SLES) for SAP 11 SP4. See SAP Note 1310037 and 2240716 - SAP HANA DB: Recommended OS settings for SLES 11 SP4 
SUSE Linux Enterprise Server (SLES) for SAP 12. See SAP Note 2205917 - SAP HANA DB: Recommended OS settings for SLES for SAP Applications 12 
Red Hat Enterprise Linux (RHEL) 6.6 for SAP HANA. See SAP Note 2013638 - SAP HANA DB: Recommended OS settings for RHEL 6.5 
Red Hat Enterprise Linux (RHEL) 6.5 for SAP HANA. See SAP Note 2136965 - SAP HANA DB: Recommended OS settings for RHEL 6.6 
Red Hat Enterprise Linux (RHEL) 6.7 for SAP HANA. See SAP Note 2247020 - SAP HANA DB: Recommended OS settings for RHEL 6.7 

See SAP Note 2188482 - SAP HANA on IBM Power Systems: Allowed Hardware 

Note Related to Multiple SAP HANA SID's on one SAP HANA System: 
As of SAP HANA SPS09, SAP supports running multiple SAP HANA systems on a single host In production. This is restricted to single host and scale-up scenarios only. Keep in mind that multi-SID requires significant attention to various detailed tasks related to system administration and performance management. For more information:
 read SAP Note 1681092 - Multiple SAP HANA DBMS's (SID's) on one SAP HANA System.

The SAP HANA hardware directory can be found at: 
https://www.sap.com/dmc/exp/2014-09-02-hana-hardware/enEN/index_html. 

SAP HANA Course and Certification codes

HANA Books & Course Details:

HA100 - SAP HANA Introduction
HA200 - SAP HANA Installation & Administration
HA215 - SAP HANA Monitoring and Performance tuning
HA240 - Authorisation, Security and Scenarios
HA250 - Migration to SAP HANA using DMO
HA350 - SAP HANA Data Provisioning
HA355 - SAP HANA Smart Data Integration
HA500 - SAP HANA Vora
BW305H, BW310H and BW362 - SAP BW on SAP HANA

Latest HANA Administration Certification is:
C_HANATEC_13 - SAP Certified Technology Associate - SAP HANA 2.0

S/4 HANA Conversion Certification:
E_S4HCON_75 - SAP Certified Technology Specialist - SAP S/4HANA Conversion and SAP System Upgrade