SAPTechArena

...

Unicode : Multi language support Non Unicode : single language support  Unicode supports all multiple languages like english, chainaa, german,..etc. Nonunicode :only supports  two languages i.e english and german. After NetWeaver and ECC 5.0 and etc. supports unicode kernel. Unicode provides a unique number for every character, no matter what the platform, no matter...

Download the latest Kernel files. Login to the Server through OS level with SIDadm. Make the copies of the existing folders  in the backup folder :-  Drive:\usr\sap\SID\SYS\exe Stop the SAP Instance & Services SAPSID_00 SAPSID_01 SAPHostControl SAPHostExec Extract the SAR Files   Go to command prompt Go to as above path & Extract...

What is saproot.sh? saproot.sh is used to configure the ownership and permissions of some kernel files (BRTOOLS), including the SAPOSCOL. We have to execute the saproot.sh script after we have performed the kernel upgrade. The script need to be execute under root user and can be find under below location. /usr/sapmnt/SID/exe How to use To execute the saproot.sh, just put the...

The kernel upgrade activity on UNIX, Linux environment. Preparation: First check current Kernel patch release. Step 1:  Download the necessary kernel patch from sap. Step 2:  First create  a new directory  and transfer the  kernel files SAPEXE.SAR,SAPEXEDB.SAR with SAPCAR,use winscp software. Step 3:  Take backup old kernel file...

RC = 0, successfully imported. RC = 4, imported ended with warning.Common issue:• Generation of programs and screens• Columns missing and Rows missing. RC = 8, not imported ended with errorCommon issue:• Syntax error.• Program generation error.• Dictionary activation error.• Method execution error. RC = 12, import is cancelled.Common issue:• Import is canceled due to object missing.•...

You might want to install SAP ECC 5 or SAP ECC 6 and been asking SolmanKey. What if you don't have Solman Server ? Then how would you generate solman key ? There are 2 ways (if you don't have Solman Server to generate solman key) : 1. Ask your friend which have Solman Server to generate it. OR 2. Use this simple script (VB Script) to generate it. '   Solution Manager Key...

You need to change an instance profile parameter on the R/3 system.  Goto :TCODE RZ10, login/system_client The default value is 000. Which Client you want change client value like 300,800,000,. ...

Goto transaction code RZ11, enter the parameter name – rdisp/max_wprun_time and press enter. Once you get the below screen, click on Change Value and enter the desired time. Please not to set the value to 0 as it will make the running time unlimited. No restart required as the parameter is dynamically switchable. For permanent change, please do it on transaction code RZ10. You can...

You want to change the transport number range on the SAP System. SAP stored the last transport request in the table E070L. You can find the information using transaction code SE16 or SE16N. Due to non-modifiable function on transaction code SE16/SE16N, you may need to update the table from database level. Below example is on Oracle database. If let say, the latest transport number...

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...

DB2 Table and Index Commands Look at columns and data types of a table db2 describe table schema.tabelename Look at one column's data type. db2 "describe select <colname> from schema.tablename" Look at indexes on a table db2 describe indexes for table schema.tablename Export data to a file in ixf format db2 export to tablename.ixf of ixf messages tablename.txt select...

DB2 Security Commands Build a script to grant user execute privilege on all packages. db2 "select 'db2 grant execute on package '||pkgschema||'.'||pkgname||' to user <user>;' from syscat.packages where pkgschema = 'NULLID'" > output.file Security Notes dbadm auth must be revoked before any other database privlege create_not_fenced_routine must be revoked before...

DB2 Backup and Restore Commands Take an OFFLINE backup db2 connect to <dbname> db2 quiesce database immediate force connections db2 connect reset db2 backup database <dbname> to <path> compress without prompting after backup completes: db2 connect to <dbname> db2 unquiesce database db2 connect reset Take an ONLINE Backup db2 backup db <dbname>...