How to lock and unlock the client in SAP

Follow the Steps to LOCK/UNLOCK the Client in SAP.

1. To Lock and Unlock a client in R/3 system,run the following function modules  in transaction SE37.

2. SCCR_CLIENT_LOCK (to lock the client).

3. SCCR_CLIENT_UNLOCK (to unlock the client).

4.run the function module with Client number input which is to be LOCK/UNLOCK.This function set flag  "client is locked temporarily for client copy" in client maintenance menu 

5. The client will be available for user DDIC and SAP* .If any other user tries to login ,system gives message that " client locked temporarily "

  

How to reset the Buffers in SAP

Hi Guys,

Some time its needed to reset some buffers in SAP.For performance issue clean-up different buffer use below mention Tcode to reset the buffer.But keep in mind resetting of the buffer could change the performance of the entire system.

/$DYNP - Reset the screen buffer  of the application server.
/$SYNC - Reset the buffer of the application server.
/$CUA   - Reset the CUA buffer  of the application server.
/$TAB    - Reset the TABLE buffer of the application server.
/$NAM  - Reset name tab buffer of the application  

How to get the List of users in sybase

There is multiple ways of getting users list in sybase database.You may use follow below command.

Method 1:

select * from sysusers

select name as user_name from sysusers


Method 2:

sp_helpuser

How to take database backup in Sybase ASE

Database Backup command:

Login to Sybase Database

> isql64  -Usapsa -PXXX -SSID   -X
>go
>use master
>go
>dump database <SID> to "<directory> "
>go


Database backup with compress:

Login to Sybase Database

>isql64 -Usapsa -PXXX -SSID -X
>go
>use master
>go
>dump database <SID> to "<directory>" with compression = 101
>go

How to ADD new system in SAP HANA studio

Follow the steps.

Open the SAP HANA Studio

Click ==>ADD

Then Add hostname or Application server IP address.

Enter the HANA DATABASE User ID and Password for connection establish.

Connection established wait an min.

Now HANA DATABASE SYSTEM Has been ADDED,

This is the way to add HANA DATABASE SYSTEM in SAP HANA STUDIO.

Enable Telnet in suse linux

By default ,telnet is disabled in SUSE.

Go to YAST and double click SOFTWARE MANAGEMENT ,in the search box, enter "telnet" and 
click SEARCH ,tick on telnet-server and click ACCEPT .

Open the TERMINAL.
Edit the telnet file with vi editor and change disable from "yes" to "no" ,Then save the file.

# vi /etc/xinetd.d/telnet

Finally ,restart the xinetd and test the connection.

# /etc/init.d/xinetd restart
# telnet <your ip-address> <port>

Check SUSE linux Version

You can execute the below command to check the current release of your SUSE Operating System.

# cat /etc/SuSE-release
SUSE Linux Enterprise  Server 12 (x86_64)
VERSION = 12
PATCHLEVEL = 1

or

# cat /etc/issue

Welcome to SUSE LINUX  Enterprise  Server 12 (i586)  -kernel  \r  (\l)

Delete imported request in SAP

Execute Transaction code STMS_IMPORT .

Go To  Extras => Deleted Imported request.

import SAP transport request from os level

One of the way to import Transport request in SAP System.

Make sure Transport request is released from the source system.
Logon to target System as <SID>adm user.

To add the transport request to the buffer (single command line ).

tp addtobuffer <transport-request> <SID> client=<CLIENT-NUMBER> 

pf =/usr/sap/trans/bin/TP_DOMAIN_<DOMAIN-SID>.PFL 

Example:

tp addtobuffer DEVK90032  DEV client = 300 pf=/usr/sap/trans/bin/TP_DOMAIN_DEV.PFL

To import the transport request (single command line).

tp pf=/usr/sap/trans/bin/TP_DOMAIN_<DOMAIN-SID>.PFL  import  <transport-request> <SID> U128 client = <CLIENT-NUMBER> 

Example:

tp pf=/usr/sap/trans/bin/TP_DOMAIN_DEV.PFL import DEVK90032 DEV U128 clinet=300 

How to enable log overwrite mode in SAP HANA Using SQL statement

If you don't want to be spend time on LOG maintenance :

Follow below steps:

#  su - hdbadm

$ hanadb1 : /usr/sap/HDB/HDB00> hdbsql

hdbsql ==> connect -n <server name> -i  <instance number> -u <user> -p <password>

hdbsql==> ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM')SET ('persistence'.'log_mode') = 'normal' WITH RECONFIGURE

OR

hdbsql==> ALTER SYSTEM ALTER CONFIGURATION('global.ini'.'SYSTEM')SET ('persistence'.'log_mode') = 'overwrite' WITH RECONFIGURE

How to enable log overwrite mode in SAP HANA Using SAP HANA STUDIO

If you don't want to be spend time on log maintenance :

Follow below steps:

HANA STUDIO ==>Confguration==>  global.ini==>  persistence  and set the parameter  log_mod = normal to overwrite.

Note : when you change the log_mode,you must restart  and database  system to activate the changes  .it  is also recommended that you perform a full data backup.You can also set the log_mode to overwrite.

How to check kernel version in SAP

Check Kernel version using SAPGUI:

GO TO : SM51

Click on Release Notes as below screenshot.

Below screen will come ,Please refer below screenshot and Kernel level  and Kernel Patch Level .

There is another way to get the kernel version and kernel patch level .

Logon to SAP GUI.

Choose SYSTEM ==> STATUS.

Navigate to below mention screenshot (Yellow marked).

  

Then get Kernel version and Kernel Patch level

.......

How to check SAP version and SAP Netweaver version

Logon into the SAP system Via SAPGUI

From main menu Navigate to SYSTEM ==>STATUS (Get the below Screen)

In the component version  you seeing SAP ECC 6.0 ,It means this SAP system running on SAP   ECC 6.0.

Check the more details, Click on search button

It will open component details where we can get more information about SAP system components.

Components in Yellow mark  are tell all about SAP and SAp Netweaver Version detail.

Here you can see

SAP_BASIS is at 700 it represent It is SAP Netweaver 7.0
SAP_APPL is at 600 it represent It is ECC 6.0

SAP_APPL have EHP version upto EHP8 like 618.

How to lock/Unlock SAP Tcode

GO TO : SM01

Enter the Tcode which we want to lock/unlock at the bottom of the screen and press enter or click lock/unlock screen.

Just Check the Check box and save what you want to lock and unlock  the check box want you want to unlock the Tcode.

How to Enable/Disable Archive log mode in Oracle

How to Disable Archive Log Mode:

sqlplus  / as sysdba

SQL > archive log list

Database log mode         Archive mode
Automatic archival         Enabled
Archive Destination        USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence   19
Next log sequence                 20
Current log sequence            20

here you will see Automatic archival log mode ON or Enable.

Exceute below command from SQLPLUS : (Disable the Archive log)

SQL> shutdown immediate;
SQL> startup mount
SQL> alter database NOARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;

How to Enable Archive Log Mode :


sqlplus / as sysdba

SQL> archive log list

Database log mode           NO Archive Mode
Automatic archival           Disabled
Archive  destination          USE_DB_RECOVERY_FILE_DEST
Oldest online Log Sequence        19
Next log sequence to archive       20
current log sequence                    20

here you will see automatic archival -Disable.That means Archive is OFF or Disabled.

Execute the below command from SQLPLUS: (To enable the Archive Log Mode)

SQL> shutdown immediate;
SQL> startup mount
SQL> alter database ARCHIVELOG;
SQL> shutdown immediate
SQL> startup;
SQL> exit;  

How to revert the Snote in SAP

Go to Transaction : SNOTE

Step1 : select the note and click the Reset  SAP note implement.

Step2 : Here it is asking  changes process : Choose  yes

All the changes will be capture in TR.

Note: Snote has been successfully Reverted . 

How to uncar the support packs .SAR files in SAP

Support pack files downloaded from SAP marketplace  are in the .SAR format.To be able to install a support package, we have to uncar these files,using SAPCAR files.The procedure for uncaring of  .SAR file is as given below:

UNCARING the .SAR SUPPORT PACK File:

On Windows Level:

Login <SID>ADM

cd /usr/sap/trans.

/<SAR FILE Directory>/SAPCAR XXX.EXE  -xvf <Filenane>.SAR

This will extract the support packages into the /usr/sap/trans/EPS/in  move the packages to this directory.

On Unix/Linux level:

Login <SID>ADM

cd /usr/sap/trans

/<SAR FILE Directory>/ ./SAPCARXXX.EXE -xvf <Filename>.SAR

This will extract the support package into the /usr/sap/trans/EPS/in  move the packages to this directory