How to Start Stop SAP HANA Database

Command to Start/Stop SAP HANA Database

Using sapcontrol  Program to Start/Stop SAP HANA.


Login to " root " User.

/usr/sap/hostctrl/exe/sapcontrol  -nr 00 -function start

/usr/sap/hostctrl/exe/sapcontrol -nr 00 -function stop


Start/Stop SAP HANA system using HDB program

Login to " root "  User.

/usr/sap/<SAPSID>/<instance_name>/HDB start

/usr/sap/<SAPSID>/<instance_name>/HDB stop


Check SAP HANA system Status (Process list)

/usr/sap/hostctrl/exe/sapcontrol  -nr 00 -function GetProcessList 

SAP HANA Studio Displays System services status as Yellow

Symptom

SAP HANA studio displays a yellow system status even through all SAP HANA services running or not started (SAPSTARTSRV)

Reason  and prerequisites.

The SAP HANA Studio cannot reach SAPstartsrv  even through is running.

Solution:

In the SAP HANA Studio  goto "Window --> Preference --> General ---> Network connections 
--> Active provider "  and   change the value  from "NATIVE " to "DIRECT".

Note :SAP Snote  for Yellow Status : 1639568

How to activate SAP* user in SAP

In SAP,There is a parameter login/no_automatic_user_sapstar whose default value is 1.
If the value is set to 1.automatic login of SAP*  into the SAP system using password PASS won't be allowed.

Set the value of  parameter login/no_automatic_user_sapstar to 0 in both default and instance profile and restart the instance .So automatic login of SAP* with default password PASS enabled.  

How to delete SAP lock entry in SM12

What is SAP lock entry.
 SAP Lock is set by the executing work process when user/jobs want to change the data in SAP.
Whenever a lock to be set the respective work process checks in the lock table. Whether a respective lock conflicts the existing entries in the lock table.

Types of Lock
Write Lock (E) : This is also known as exclusive lock mode as the lock data can be edited by only one user at a time.Any other request from work process to set another Write lock or Read lock are rejected.A cumulate lock can be applied on the lock data by the same owner again.

Read lock (S) :  This is also known as shared lock mode as several user can have read access to the locked data at the same time. Additional read lock requests  are entertained even if  they are from different user.However a write lock is  rejected.  

Enhanced lock (X) : This is also known as exclusive non-cumulative lock mode.An enhanced write lock can be requested  only once even if it is by the same transaction.

Optimistic lock(O) :  These lock are set up when the users displays the data in change mode. Several optimistic locks can be set up on the same data.Optimistic locks are Read locks at first and converted to Write locks  when user want to save the data.if an optimistic lock  on a data changed to Write locks ,all other optimistic locks on that data will be deleted.

Locks that are set by an application program are released by the program itself  or they released by update program once the database has been changed

Transaction Code SM12 can be used to Monitor the SAP Locks.

Have you selecting the options below.

• Table name
• Lock Argument
• Client
• User name

If you encounter some old locks and after through analysis ,we would like to delete these.

Follow this ways.

1. Select the lock and delete form SM12 .
2. Identify the user who has set the respective lock and end the user session using SM04 Tcode.  

Types of Work Process in SAP

What is work process in SAP?

The work process is used to execute a particular type of jobs in an SAP System.

Types of Work Process in SAP?

There are SIX type of work process in SAP.

• Dialog 
• Backgrounds
• Enqueue 
• Spool 
• Update 
• Update2 

DIA(Dialog Work process)

Used for execution of dialog steps triggered by active user .For every dispatcher at least 2 dialog workprocess to be configured.

 SPO(Spool Work process)

Used to passing sequential data to printer. Atleast one spool work process to be configured for an  SAP system. 

UPD(Update Work process)
Used for execution of update task. Atleast one update work process to be configured for an SAP system.More then one Update work process cab  be configured for dispatcher.

BTC(Background  Work process)
Used for executing background jobs. Atleast 2 Background work process to be configured for SAP system.

ENQ(Enqueue  Work process)
This is Required to administrator lock table in the shared memory. Lock table contains database locks for ABAP STACK of an SAP system. Only one enqueue work process to be configured for SAp system.

 UPD2(Update2  Work process)
This is similar to Update Work Process.There is small difference in functionality based on critically of the Update.

How to increase and decrease the work process in SAP

The work process  is used to execute the particular type of the job in an sap system.for load balancing increase or decrease the Work process. Imporove the performance for SAP System.

to increase/decrease the number of work process,value to be changed accordingly for the following Profile Parameter.as per work process in RZ10.

• rdisp/wp_no_dig (for dialog work process)
• rdisp/wp_no_btc(for background work process)
• rdisp/wp_no_spo(for spool work process)
• rdisp/wp_no_enq(for enqueue work process)
• rdisp/wp_no_vb(for update workprocess)
• rdisp/wp_no_vb2(for update2 workprocess)

In RZ10 transaction,select the instance profile,for which work process number to be changed to edit the profile parameter through extend maintenance and save the changes and active the profile.

Note : Please note that as the parameter is not  dynamic one,restart of the sap application server is required for the changes to become effective.

How to delete the client in SAP

 Client Deleting  Procedure:

Step 1 : Login as any super user in existing client(which you want to delete).

Step 2 : Hit the Transaction SCC5.

Step 3 : In result Screen select Option "Delete from T000"

Step 4 : Click parallel process icon and set the parallel process.

Step 5: Choose Number of parallel process and Logon/ServerGroup.

Step 6 : Click Immediately  in order to client delete in foreground. Alternately Run client deletion on background Process

   

How to define default client in SAP

You can set the SAP to default client login via Parameter.

"login/system client" value = specific Client(XXX)ex 100  

Every time when user going to login in SAP you will find 800 as client show in below.

It can be done using transaction RZ10. AS an example you can set the parameter value 800 in transaction code RZ10. A restart is needed  to make changes.  

How to check the size of the client in SAP

Step 1: Execute the report RSSPACECHECK in T-code SE38.

Step 2: Put the client Number.and Execute (F8).

Step 3: It take time to calculate based on Client data.

Result will be.

What is client in sap

 A client is organizational and legal entity in the SAP system.All the business management data is protected here because other client can not access them .The main objective of the client is to keep the data unique.The data in a client only visible with in the client,it cannot be change or display from another client.

SAP system there can be multiple clients.SAP R/3 comes with 3(three) Default client.

SAP Clients

Client    000 - Master client

Client    001 - Copy of master client

Client    066 - Early watch client

Client 000 Master Client. Special client in SAP System.It contains all standard configurations,parameters,standard transactions,.etc.SAP R/3 comes with Organizational structure.

Client 001 Copy of master Client. Client can be customized  to prepare in to move it into the Production environment .once 001 client Customized ,it does not behave like Client 000.

Client 066 Early watch Client. Service for customer systems,

Note: One impotent thing to remember is that during  SAP R/3 System implementation ,Once SAP installed ,the first thing to be done is copy standard client include in SAP R/3 package. SAP Users can start using the SAP for creating ,testing,training,or  even start using it for customization with one SAP instance ,a number of  Clients can be created.no need to install separate software for each and every customer .It provide unique.one client cannot see the data of another client.As depicted above 300 and 500 client exist under one roof.We can create number of Client in SAP application 

(From 000 to 999).

DB2 Backup Command

DB2 Backup Command and Procedure.

Step 1: db2stop

Step 2: db2start

Step 3: db2 connect to <DB2SID>

Online backup command

db2 backup <DB2SID> online to "backup stored directory"

Offline backup command

db2 backup db <DB2SID>  to "backup stored directory"

Online backup command with compress

db2 backup <DB2SID> online to "backup stored directory" compress

Offline backup command

db2 backup db <DB2SID>  to "backup stored directory" compress

Get backup details (%) on while backup running.

db2 list utilities show detail