SAPTechArena

Step by Step Procedure for Kernel Up-gradation: Basis Administrator shall login to www.service.sap.com with OSS & password and download the latest Kernel files. Downloads---->SAP Support Packages---->Support packages & Patches-Entry By application group---->SAP application Components---->SAP ERP---->SAP ERP 6.0---->  Entry By Component---->SAP...

To Generate Solution Manager Key Execute T-code SMSY in Solution Manager system, you need to do the following steps: 1) Create a system by right clicking on System entry and select Create new system. 2) Enter the System Name i.e., SID (3 chars) 3) Product = SAP ECC (select from the list) 4) Product Version= ECC 5.0 (select from the list) 5) Save the entries. 6) Select...

The Security Audit Log is a tool designed for auditors who need to take a detailed look at what occurs in the SAP system. By activating the audit log, you keep record of those activities you consider relevant for auditing. This information is recorded on a daily basis in an audit file on each application server. You can then access this information for evaluation in the form of...

What is a SAR file ? SAR files are  delivered by SAP for releasing supportpackages of Kernel and other OS level binaries.   How to extract a SAR file in SAP  Navigate to the path where the SAR file is located and use following command to extract a SAR file. SAPCAR -xvf <filename.SAR>...

Stopping Run-Away or “Bad” Work Processes 1. Log on to any client in the appropriate SAP system. 2. Go to transaction SM50. 3. On the Process Overview screen, find the process which must be stopped. Place a √ in the □ to the left of the process number to be stopped by pressing Space.  On the top-most menu bar,click the Process → Cancel without core. 4. Click...

DB2 Utility Commands List the running utilities and their progress db2 list utilities show detail Throttle a running utility. First find the Utility ID. db2 list utilities show detail Throttle the utility to a value of 1 to 10. 10 being the most throttled. db2 set UTIL_IMPACT_PRIORITY for <util_id> TO ...

DB2 Tuning Commands Quickly look at some basic tuning measurements db2 "select db_name, rows_read, rows_selected, lock_waits, lock_wait_time, deadlocks, lock_escals, total_sorts, total_sort_time from table (snapshot_database (' ', -1) ) as snapshot_database" ...

DB2 Tablespace and Bufferpool Commands View the names, pagesize, and number of pages of the bufferpools in your database db2 "select bpname,pagesize,npages from syscat.bufferpools" Make a bufferpool resize automatically. You must have STMM turned on at the database configuration level db2 alter bufferpool bp1 size AUTOMATIC Alter a bufferpool size that is a fixed size db2 ALTER...