How to Suspend Sap Background jobs – BTCTRNS1 and BTCTRNS2

Suspend and Release Background Jobs with BTCTRNS1 & BTCTRNS2 : Whenever we are doing any SAP upgrade or Sap System Refresh Post activities ,In these scenario ,we need to Suspend SAP Jobs which are in released status with the execution of SAP Report BTCTRNS1 and BTCTRNS2. Why we need to Suspend SAP Background Jobs: If we’ll not suspend released jobs then in the middle of our upgrade activity ,Jobs will execute and impact our upgrade. How to Suspend Sap Background jobs before Upgrade execution(BTCTRNS1 ): Goto SE38 –> Enter Report Name BTCTRNS1 –> Execute –> DONE Result: It Moves all ……

WHAT IS SAPCPE AND HOW TO EXECUTE

WHAT IS SAPCPE: SPACPE is kernel program It copies selected files and directories from a source directory to a target directory based upon paramter that we give with sapcpe command.You can find it under /sapmnt/SID/exe/ SAPCPE is used to sync kernel files across the server.It is highly usefull for application server kernel upgrade.   Run SAPCPE Central Instance: It is recommended to execute sapcpe command from work directory as we can check log files of sapcpe command in work directory: cd /usr/sap/<SID>/DVEBMGS00/work sapcpe pf=/usr/sap/<SID>/SYS/profile/<InstanceProfile> It copies Global Exe kernel files from /sapmnt/SID/exe to /usr/sap/SID/DVEBMGS00/exe In work Directory check the logs ……

SAPROOT.SH and ORAROOT.sh

SAPROOT.SH & ORAROOT.SH saproot.sh and oraroot.sh are necessary to setup the ICMBND/BRTOOLS ownership and permission at OS level and script needs to be executed as root user. Aftter kernel upgrade we need to execute these scripts before starting SAP. Where to get These scripts: These files comes when we extract below files downlaoded from Sap Service Marketplace: SAPEXE.SAR >>It contains Database Independent executables files >> Contains saproot.sh script SAPEXEDB.SAR >>It contains Database Dependent executables files >> Contains oraroot.sh script Please follow as below: 1. Login as sidadm user 2. cd to /sapmnt/SID/exe 3. su (change as root user) 4. ./saproot.sh SID 5. ./oraroot.sh SID ……

How to Check Sap Kernel Unicode and Non Unicode

How to Check Sap Kernel Unicode & Non-Unicode: Before doing kernel upgrade it is mendatory step to check existing kernel whether it is Unicode and Non Unicdoe: There is a kernel program in kernel executables files disp+work.You can find it under /sapmnt/SID/exe/ Execute below disp+work Command from OS level. It provides 3 useful information: 1> Kernel Type : Unicode or Non Unidoe 2> Kernel Version 3> Kernel Patch level Please refer below screenshot,In the Blue box you’ll find Kernel Type,In our case it is Unicode. Based upon Unicode and Unicode kernel,We download related kernel files from SAP Marketplace. Please read complete Kernel ……

ZDATE_ILLEGAL_LOCTIME

ST22: ZDATE_ILLEGAL_LOCTIME    Today i faced run-time error ZDATE_ILLEGAL_LOCTIME ,I was getting lot of time mismatch related dumps. In this article ,i’ll explain reason and possible solution for these dumps. If you are getting continuously  run time error “ZDATE_ILLEGAL_LOCTIME” . Reason : “The local time on the application server is not correct.” The system time of the server was reset to the past, while the SAP application server was running. In this case, it does not matter whether this was done manually (with operating system commands) or automatically (with a “time service”, for example). Solution: Please refer SAP Note “447839 – ZDATE_ILLEGAL_LOCTIME ……

Unicode Conversion Preparation with SPUMG

Unicode Conversion Preparation with SPUMG  SPUMG plays major role in performing unicode conversion preparation steps.In this article i’ll cover how we can perform major presteps with SPUMG. First Please read to Undersatnd What is SPUMG and How to start it. SPUMG in Unicode Conversion   Start SPUMG: Go to Tcode: SPUMG and click on addional steps button as per below screen. with this step report UMG_ADD_PREP_STEP will be initiated which consists of several reports which were created for deleting corrupt or obsolete table data prior to Unicode conversion. On the next screen the included reports are displayed. Choose  Background. All ……

SPUMG in Unicode Conversion

What is SPUMG SPUMG is very important tool used in Non unicode to Unicode conversion.It is standrad Tcode provided by SAP based upon our SAP release. SPUMG is used in Preconversion Phase: Preconversion phase means,before doing actual unicode conversion,We need to complete many presteps or we can say we need to prepare our system for Unicode Conversion so mostly preconversion presteps are covered bt SPUMG Tcode. How to Use SPUMG: SPUMG is used to prepare the database tables of a non-Unicode system for conversion phase (R3load). Its results are stored in the Export Control Table and the Language List. Goto ……

SAP SYSTEM MONITORING TCODES

SAP SYSTEM MONITORING TCODES In this article,I am going to cover SAP SYSTEM MONITORING Tcodes , For any Basis Admin, daily sap system monitoring check is essential task.We daily do health check of our production sap system. SAP daily system monitoring helps in two way- Preventive Health check– This health check helps to prevent issue that may happen in near future. e.g. suppose in our daily SAP System monitoring,we catch our database size is 99 % full that means anytime in future DB size will be full and it’ll lead production outage. Regular health check– This is regular health check which ……

SAP JAVA SCHEMA PASSWORD CHANGE

SAP JAVA SCHEMA PASSWORD CHANGE For audit purpose,From security team,always there is requrement to change SAP Schema password every year. In this tutorial ,i explain how we can change SAP JAVA Schema Password,Here i took example of Unix OS. For SAP JAVA Schema user: Please check first your JAVA schema user name ,In my case it is SAPSR3DB,you can check Java schema user name from Configtool–>Secstore. Step 1 : Change it from OS level: Execute below BRCONNECT command directly from OS level: brconnect -u / -f chpass -o SAPSR3DB -p <NEWPASSWORD> [execute command where SAPSR3DB is JAVA schema user ] Please refer ……

SAP SCHEMA PASSWORD CHANGE

SAP SCHEMA PASSWORD CHANGE For audit purpose,From security team,always there is requrement to change SAP Schema password every year. In this tutorial ,i explain how we can change SAP Schema Password,Here i took example of Unix OS. For ABAP schema user: Please check first your ABAP schema user name ,you can find via executing command ENV and see what schema user name is defind in your environment variable.In my case it is SAPSR3 Change it from OS level: Execute below BRCONNECT command directly from OS level: brconnect -u / -f chpass -o SAPSR3 –p <NEWPASSWORD> [execute command where SAPSR3 is schema ……