What SAP T-Codes are used to troubleshoot SAP Performance Issues?

What SAP T-Codes are used to troubleshoot SAP Performance Issues?

ST04 – Database Buffer, check especially for Expensive SQLs (Detail Analysis of SQL Request)

ST02 – SAP buffers

ST06 – OS stats

ST05 – SQL trace

SE30 – Abap runtime analysis


ST03, ST02, ST04 are the tcode for workload, tuning and DB Performance Monitoring codes.

ST06 FOR Operation System Monitoring.

SM51 OR SM50 is process overview which tells you the workprocess sequence

0 comments

How to Run X Windows on Linux Server in SAP ?

Type in the following to launch XWINDOWS

Prereqs : Run XWINDOWS client

On the Unix machine where you want XWINDOWS execute the beloe
maxsq45:dwaadm 11> setenv DISPLAY <171.29.27.05:0.0>        your desktop IP
maxsq45:dwaadm 12> xclock

Now cal the script of the tool you want to launch to see it on your desktop.

Tags: SAP XWINDOWS Commands, How to Run X Windows on Linux Server in SAP, Run configtool using XWINDOWS,

0 comments

What is SAPDB User in SAP ?

SAP<SID>DB

This SAP<SID>DB SQL login is used by SAP Java Application Server for database connections. If you change this password on the database server you will also have to change it in the secure store using configtool.

Password: set during the installation;
Server roles: securityadmin; this server role is required only during
the upgrade of Java Application Server to releases >= 7.10. The role
can be removed during the productive usage of the system. The upgrade
will set it as required.
Database roles: db_owner in the SAP database;
Default database: SAP database

Note Please, do not not change any settings for this login.




Tags: about SAP<SID>DB User in SAP , What is SAP<SID>DB User in SAP, SAP OS USERS,

0 comments

What is sidadm User in SAP ?

This user is the os administrator used to perform administrative tasks on the SAP system. Especially such tasks as upgrade and transport imports are carried out under this user. Misconfiguration can lead to errors in these tasks.

Password: set by the user during the installation.
Server roles: sysadmin
Database roles: n/a


Tags: What is sidadm User in SAP, SAP sidadm, <sid>adm, sidadm permissions,

0 comments

How to do JSPM Patching without Restarting AS Server SAP Java

JSPM has an option to change the default deploy workflow strategy.
Use normal deploy workflow strategy to avoid server restarts if posible.

To do this start JSPM with this command line:
go -config=/jspm/safetyDeployThreshold=-1


tags: Patching components without restarting Java AS, How to do JSPM Patching without Restarting AS Server SAP Java,

0 comments

What is SAPServiceSID User in SAP ?

This user is the os administrator used to run the sap system. The sap systems connects to the database using integrated security under this user. Misconfiguration can lead to severe errors.

Password: set by the user during the installation
Server roles: sysadmin
Database roles: n/a


Tags: What is SAPServiceSID User in SAP, SAPServiceSID errors, Windows SAPServiceSID ,

0 comments

What are the prereqs before apply SAP Java Patches

Take a SAP Java database backup
Take a SAP File system backup
Clear log files, as patches generate lot of logs




Tags: What are the prereqs before applying SAP Java Patches, Steps to do before applying SAP Java patches, SAP java Support packs prerequisites,

0 comments

How to enhance SAP BDLS runtime performance

Prerequisites before running BDLS on SAP System

1. Switch off the Archive log mode of database. During BDLS lots of archive logs get generated, to switching to noarchive mode always make it faster.

2. Create index on some large table where I think it could take much time.




tags: sap running bdls faster, How to enhance SAP BDLS runtime performance,

0 comments

When to run BDLS in SAP System Copy ?

When you perform a system copy from Production (PRD) to a Non production System(QAS)
we run a BDLS to convert the SID from PRD to QAS for example.

BDLS usually takes long time
Ex., 1.2 TB database, it lasts about 12 hours


Check related posts on BDLS Performance tuning steps


Note: When not to run BDLS in SAP System Copy ?
If you don't change the SID and you use the same client, you should not need to run BDLS.




tags:BDLS runtime performance, When to run BDLS in SAP System Copy , what is SAP BDLS, SAP logical system conversion, t-code BDLS,

0 comments

What are SAP BW Admin Regular admin tasks ?

Monitor the performance of SAP BW processes
Monitor the status of SAP BW processes and requests
Monitor the performance of BEx applications
Display the BW usage statistics
Monitor the database load
Availability monitoring for UD Connect
Monitor periodic process chains
Check the BW Delta Queue
Monitor BW log files


Tags: What are SAP BW Admin Regular admin tasks, BW admin tasks, Daily Basis BW admin tasks list, 

0 comments

Difference between SAP Synchronous and asynchronous transports?

Synchronous transport: Dialog or batch process is blocked until import has ended in synchronous transport.
Asynchronous transport: Dialog or batch process is released after import is started in asynchronous transport.


Tags: SAP transport types, synchronous asynchronous transports, differences,Difference between SAP Synchronous and asynchronous transports, STMS, SE10, SE09, 

0 comments

SAP Long running Job How to analyze ?

Answer: T-Code SE30



Tags: How to fix long running jobs in SAP,  long running jobs analysis steps, sap long running jobs, sm37, se30, 

0 comments

How to check version of SAP Java Engine J2EE

Execute the /usr/sap/<SID>/<instance name>/j2ee/cluster/bootstrap/scripts/version script file without specifying any parameters.

This will display information such as the version of the J2EE Engine, SP number, patch level, build details, and so on.

Ex., 7.10 SP2  looks like this in system info component(1000.7.10.2.3.20070618035500)

For Example:
To get version of the J2EE engine you have to execute version.bat file :
/usr/sap/<SID>/<instance name>/j2ee/cluster/bootstrap/scripts/version.bat

RELATED POST:
SAP JVM SWITCH SOFTWARE DOWNLOAD LOCATION


Tags: How to check version of SAP Java Engine J2EE, java version script, kernel version, netweaver, 

0 comments

How to check Logon Groups configuration through SAP NetWeaver Aministrator NWA

Step 1 : Open NetWeaver Administrator via the following URL:
http://<host>:<http port>/nwa
Step 2 : Select the tab Configuration Management

Step 3 : Select Infrastructure Management

Step 4 : Select Java Http Provider Configuration and after that Logon Groups

Step 5: Check if the alias or context-root of the application is added into a certain Logon Group.
If yes, the requests to this application should be served only by instances which are also in this Logon Group.



Tags: logon groups NWA, How to check Logon Groups configuration through SAP NetWeaver Aministrator NWA 

0 comments

How to create a heap dump of the SAP AS Java?

Method 1
Step1.  Get ready with server0 PID

Step 2. Start jvmmon executable located in /usr/sap<SID>/SYS/exe/run/sapjvm_5/bin

Step 3. Type "dump heap" command

Method 2
You can also start jvmmon GUI  using executable jvmmon -gui.exe

Method 3

Create a heap dump using the JStart monitoring program (jsmon)
Start jsmon executable located in /usr/sap/<SID>/SYS/exe/uc/<OS> and specify the profile example: jsmon pf=/usr/sap/<SID>/SYS/profile/<PROFILE_FILE_NAME>
Execute the command process view and notice the idx of the server process you want to create a heap dump of
Execute the command hsdump idx to create a heap dump of the process having index = idx
The heap will be dumped into big file with extension .hprof located in \usr\sap\SID\JCXX\j2ee\cluster\server0 folder



Tags: How to create a heap dump of the SAP AS Java, jsmon, heap dump using the JStart monitoring program (jsmon),  jvmmon GUI ,-XX:+HeapDumpOnOutOfMemoryError, 

0 comments

SAP LVM System administration and maintenance tasks

SAP LVM stores its configuration data in the Configuration Manager repository, which is the central storage for technical configurations of all applications deployed on SAP NetWeaver Application Server Java (AS Java) .

LVM = Landscape Virtualization Management

SAP LVM System Admin Tasks

SAP LVM Starting and Stopping
SAP LVM User Management
SAP LVM Backup and Restore
SAP LVM Software Change Management (uses NWDI)
SAP LVM Support Desk Management
SAP LVM High Availability

0 comments

NW 7.3 Apply SAP Java License steps

Logon to SAP Netweaver Administrator(nwa)


Click on "Licenses" under "Licenses & Certificates" and Select "Check Licenses".

 click on "Install from File" and one popup comes to browse your license file.

Select you license file and click on "Add" button.

0 comments

Where is Visual Admin (SAP) in new SAP NW 7.3 versions

 Visual Administrator functionalities have been integrated into NWA

You can access NWA via  URL  /nwa


Tags: SAP Visual Admin, NW 7.1 No visual admin,  NW 7.3 No visual administartor, VA removed in NW j2EE,

0 comments

SAP J2EE HTTP ALIAS - How to Remove

In NW 7.0 Go to Visual Admin navigate to the Configuration Adapter service under one of the server nodes.Expand the Configurations tree - HTTPHosts - default - Aliases.
There you will find a branch of each of your server nodes and a default branch.
Click on the little pencil button to go to change mode and then delete the occurrences of your marketing aliases under the default branch and the server ID branches.
When you go back to the HTTP Provider service the aliases should be gone.



Tags: SAP J2EE HTTP ALIAS - How to Remove,  How to Remove SAP J2EE HTTP ALIAS , Visual admin HTTP provider service,

0 comments

User cannot connect to SAP - How would you troubleshoot ?

Post your answers in the comment box below






Tags: User cannot connect to SAP - How would you troubleshoot,

0 comments

Who can perform production SAP OS/DB migrations?

The technical migration procedure must be performed by a consultant with special SAP certification with OS/DB migrations. There's only one SAP OS/DB certification valid for all  supported platforms.








Tags: SAP OS/DB migrations FAQ, OS/DB docs, OS/DB project plan,

0 comments

BASIS-SAP Manager Roles & Responsibilitis

• Work with the process leads, functional leads, and application architects to gather and understand technical requirements.
• Able to facilitate meetings.
• Maintain and update technical requirements on an on-going basis.
• Work independently on other activities in scope for the project.
• Initiate and plan IT projects. 
• Develop and maintain the overall project plan and schedule. 
• Assess the degree to which changes to scope, issues and risks will affect the project and work with project team, cross-divisional teams, senior/executive management and sponsor to gain agreement for resolution.
• Manage interactions across IT and Business organizations to support the implementation and ongoing support.
• Measure performance to assure the project is progressing as compared to original plan and budget.
• Collaborate with IT staff to adapt processes and procedures.
• Manage the scope, financial budgets and oversee project deliverables and inter-dependencies.
• Communicate project progress by producing reports to provide timely and accurate project status and decision support information.
• Make recommendations based on current project status to resolve issues.

tags: SAP Basis Manager Roles Responsibilities, Basis manager jobs, 

0 comments

What is ToC Transport of Copies in SAP ?

Transport of copies option is available in each SAP system. This is a type of transport similar to customizing and workbench with its different behavior. Beauty with this type of transports is, it dies in the next target system. What does this mean??? Let's say I have three system landscape for my ECC system: DA1 -> QA1 -> PA1.
If you create a workbench request in DA1 system and release it, it goes to import buffer of QA1. Once imported in QA1, transport is now available in the import buffer of PA1 for import in PA1. But, if you create a Transport of Copy for the same transport in DA1 and release it, it will be in import queue of QA1. However, when you import this transport to QA1 it does not go to the import buffer of PA1.

Example:
If you try to use the transport of copies explicitly in any SAP system, say you have created a transport request DA1K900001 in DA1 system and you want to copy this request in a ToC type transport so that you can move it to just the QA1 system. System will not allow you to put these objects in the ToC type transport unless you release transport DA1K900001 as the objects are locked under this transport request. So, you cannot create a ToC in ECC system for an unreleased transport.

STEPS TO DO SAP TRANSPORT OF COPIES 



Tags: ToC, SAP ToC, Transport of Copies, CHARM ToC, Solman ToC, 

0 comments

How to reset status of queue in qRFC?

Answer:

T-Code : SMQ1  ---> qRFC monitor ---> reactivate queue


Additional Info:
Check SM13 for "Waiting for Updates" for root cause analysis on queue status

Tags: SAP queue reset status

0 comments

SAP SPM What is Spend Performance Management Product?

SAP SPM is an integration point between data extraction and classification. It is integrated into the web user interface called the Data Management tool. SPM is designed to extract data from a number of disparate SAP ERP systems and aggregate data together.



Tags: SPM, What is SPM, SAP SPM What is Spend Performance Management Product, SPM on HANA , SPM on BWA, SPM on mobiles, SPM 3.0, SPM 2.1 upgrade to SPM 3.0 docs, SPM project plan docs, 

0 comments

How to test SAP system (ABAP) is working or not ?

At the OS level  Use the command to self test

> niping -t



Tags: How to test SAP system (ABAP) is working or not, 

0 comments

What is SAP Logical System means?

Logical system enables the system to recognize the target system as an RFC destination. Logical system is required for communication between systems within the landscape. You need a logical system when you create a new client in SAP

T-Code to create Logical System in SAP is BD54
Logical System is transportable.



Tags: SAP logical system, BD54, BDLS,What is SAP Logical System means,

0 comments

15 Steps to do a SAP System Copy

1. Create Java Export files from the source system:
2. Stop the target SAP system with the SAP Management Console
3. Make a copy of all the files in the \QAS\SYS\profile\ directory
4. Create a new backup of the source SAP system database
5. Restore the target SAP system database from the backup created in step 4.
6. Run the SAP-provided system copy tool
7. Stop the target SAP system using the SAP Management Console
8. Restore the files copied in step 3
9. Start the target SAP system
10. Cancel any production batch jobs:
11. Delete Source System profiles and Import the correct SAP profiles
12. Delete Source System Licenses and install the new Licenses
13. Reinitialize in the transport domain
14. Change the Logical System
15. Lock/Unlock users as necessary, using Transaction SU01
a) Stop and restart the SAP system
b). Run SGEN to recompile programs and reports
c). Run BDLS to change logical system







Tags: 15 Steps to do a SAP System Copy, BDLS, License, Profiles, STMS, Logon groups, RFC, SAP system copy steps

0 comments

Can I delete a project with SAP CHARM activated?

Answer : NO


Tags: SAP CHARM, Solman CHARM, Change and Release Management, Urgent correction steps, Java transports via CHARM, CHARM setup steps, 

0 comments

What is SAP BRM (Business Rules Management) ?

 SAP NetWeaver BRM (Business Rules Management) to help you manage your business rules, and to maintain more flexible and agile applications that reflect these changing rules.

You can use SAP NetWeaver BRM on its own in any composite or non-SAP applications to handle complex business logic and you can also leverage it in conjunction with SAP NetWeaver BPM (Business Process Management) to integrate, model, and modify rules within the context of a business process. The tight integration between SAP NetWeaver BPM and SAP NetWeaver BRM facilitates the separation of decision logic from process logic. SAP NetWeaver BRM enables organizations to manage business rules for decision automation.

RELATED: PI BRM ADMINISTRATOR TASKS

Tags: About SAP BRM,  (Business Rules Management) ,  SAP NetWeaver BRM, SAP NetWeaver BPM, SAP NetWeaver BPM docs, SAP NetWeaver BPM guides, SAP NetWeaver BPM project plan docs, WIKI, 

0 comments

How to retrieve unreleased Transport Request data after System Refresh

Be the first to Answer

0 comments

Steps to Create a Development Track in NWDI

Prerequisites

●  You have configured a domain. Applications SLD, DTR, and CBS have been started and can be called.

●  You are in Landscape Configurator in CMS on the Track Data screen.

Steps:

Choose New

Enter Track template, Track Name, DTR URL, CBS URL, DC path

In SC table Add SC

0 comments

SQL Query(Oracle) for Basis Admins

Rebuild index online
  alter index "SAPSR3"."RSSTATMANREQMAP~PT" rebuild online;

Check last optimizer statiscs run  select TABLE_NAME, STATUS, LAST_ANALYZED from DBA_TABLES where TABLE_NAME='VBFS';

0 comments