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

Starting the SAP System 1. Log on in your OS level as a user with SAP administrator authorization (<SID>adm). 2. Enter the command startsap [DB|R3|ALL]. The following applies to this command: • DB starts the database system: startsap DB • R3 starts the instances & associated processes of the...

ALV stands for ABAP List Viewer. ALV gives us a standard List format and user interface to all our ABAP reports. ALV is created by a set of standard function modules provided by SAP. ALV provides a lot of inbuilt functions to our reports and some of the functions  are listed...

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

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

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

Basic Commands Size of your database :  db2 'call get_dbsize_info(?,?,?,0)' Version of DB2 you are running: db2level Stop the db2 instance: db2stop Stop an instance that has current connections db2 force applications all db2 deactivate db <dbname> db2 terminate db2stop force ipclean Start the db2 instance: db2start Kill a hung instance (last resort): db2_kill -all List the...