change log_mode to overwrite in HANADB from HANA STUDIO

Log in to HANA STUDIO with Administrator

Double click on the system

Then go to  --> Configuration --> global.ini --> Persistence --> 

double click on parameter log_mode and change the value from normal to overwrite

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