How to create a java thread dump?

How to create a java thread dump?

-Start the SAP Management Console.
-Navigate to AS Java process table under respective server node
-Select the process for which you want to create a stack dump in the java process table ( Process can be SDM / dispatcher / server0)
-Right click on the process and from the context menu, choose “Dump stack trace”

What is SAPOSCOL and its functions ?

What is SAPOSCOL and its functions ?

SAPOSCOL is an operating system collector. It is a standalone program that runs in operating system background. SAPOSCOL collects data about operating system resources like:

CPU Utilization
Usage of Physical Memory
Usage of Virtual Memory
Usage of filesytems
Usage of Physical disks
Usage of running processes

SAPOSCOL runs exactly once per host and runs independently of the sap system.

By default, SAPOSCOL collects data every 10seconds and records it. It also records the hourly average statistics for the last 24hours in shared memory. This data will be fetched by background job “SAP_COLLECTOR_FOR_PERFORMANCE” and writes it to the MONI performance database table.

Steps of adding datafiles(oracle) in SAP

Steps of adding datafiles(oracle) in SAP

What is BRTOOLS?

BRTOOLS is the database administration tool supported by SAP for oracle database.

How to access BRTOOLS ?

BRTOOLS can be accessed by logging into database host as ora<sid> user and calling brtools at the command prompt.

How to add or extend datafiles in sap system based on oracle database?

Once brtools is called at command prompt, following menu will be displayed

BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
======================================
Select option 2 - Space management from the above query and press c to continue.

It displays another screen as below :

Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
=============================================
Select Option 1- Extend tablespace and press continue.

In the next screen, you will be prompted to enter tablespace name, size/location of new datafile to be added, initial filesize, maximum filesize, autoextend (yes/no). Please provide all the relevant details and you can see an SQL query is being built based on the inputs given by you.

Once all the inputs are provided, press continue to execute the command and the datafile will be added.

Checking database, tablespace sizes in SAP

Checking database, tablespace sizes in SAP

How to check the database size ?

Goto transaction DB02  and navigate to Space -> Space overview to view

Database name
Database system
Size
Free size
Used percentage
Number of database users
Number of tablespaces
Number of tables and size
Number of indexes and size
In DB02, navigate to Space -> Space overview to find all the above mentioned details

How to check  the users that are present in database at SAP level ?

In DB02, navigate to Space -> Users -> Overview as below

How to check various tablespaces in SAP and their sizes ?

In DB02, navigate to Space -> Table spaces -> Overview to view tablespaces details as below.

Basis Architecture

Basis Architecture 

Sap system comprises of 3 different tiers:

1. SAP application tier.
2. SAP database tier.
3. SAP presentation tier.

1. SAP application tier addressed as central instance or dialog instance, where central and dialog instances have all the ability to process all the users requests, executed by the users from their GUI. The CI & dialog instance comprises of work processes and services which are responsible for processing users request.

2. SAP database tier of SAP system comprises of 4 major components.

-ABAP component
-BASIS component
-HR component
-LOGISTICS & ACCOUNT components (sd,mm,pp,fi etc)

These major components makes the SAP database and also gives helps to process the GUI.

3. SAP presentation tier has to be loaded on every desktops/laptops of an end-users, through which users can access SAP application and database.

Note:

- Any sap system is built upon a 3 tier architecture, where presentation layer is considered as a GUI.
- Central instance or dialog instances are considered as SAP application.

What is central instance architecture ?

Architecture of central instance is designed to process all the users request. They consist of work processes, services and a dispatcher.

- A dispatcher has the ability to accept the work from a user GUI, and trigger it to the right and free work process depending on the task executed by the user.

- Services of SAP system are responsible for communication via dedicated port numbers, where message service is responsible for communicating b/w SAP applications and central database.

- SAP applications context are: central and dialog instances.

- Message server port number is 3600

- Gateway service is responsible for communication b/w SAP to SAP and SAP to NON SAP systems via dedicated port numbers.

- Gateway server port number is 3300.

What is work process?

In any central instance of an R/3 system one can find 5 work processes, they are:

1. Dialog work process
2. Background work process
3. Update or V1/V2 work process
4. Spool work process
5. Enqueue work process

1. Dialog work process is responsible for on-line transactions, they are represented as "DIA".

2. Background work process is responsible for processing long-running or off-line tasks without a direct user interaction, they are represented as "BTC" or "BGD".

3. Update work process is responsible for saving the data in the database tables. There are 2 types of updates represented as "UPD" and "UP2". They can also be represented as synchronous and asynchronous V1/V2 again or critical and less critical respectively.

* UPD ---> synchronous ---> V1 ---> critical
* UP2 ---> asynchronous ---> V2 ---> less critical

4. Spool work process are represented as "SPO" and are responsible for printing in SAP system.

5. Enqueue work process is represented as "ENQ" and it is responsible for locking mechanism, ENQ prevents deadlocks over database tables, by processing user request in "Q"(fifo) fashion.

The central instance is represented as "DVEBMGS"

-DIALOG
-V2
-ENQUEUE
-BACKGROUND
-MESSAGE
-GATEWAY
-SPOOL

What is SAP business suite? ERP, CRM, SRM, SCM, PLM & HCM

What is SAP business suite? ERP, CRM, SRM, SCM, PLM & HCM

In order to integrate end to end business process in an organization, SAP offers a number of applications which can be seamlessly integrated with each other to maximize the benefit of using SAP. SAP offers below applications which are collectively referred as sap business suite.

SAP Enterprise Resource Planning (ERP)
SAP Customer Relationship Management (CRM)
SAP Supplier Relationship Management (SRM)
SAP Supply Chain Management (SCM)
SAP Product Lifecycle Management (PLM)
SAP Human Capital Management (HCM)

SAP business suite 7 is the latest version which enables running applications on cloud.
 

-SAP Customer Relationship Management (CRM):

Consider the sales process in an organization. Marketing department collects data about prospects from various sources, sales representatives meet prospects and collect more information about prospects which help them generate sales lead, finally sales is executed and after sales service is provided.  It’s important for organization that customer data should be available as and when required hence customer data has to be stored at central database. Sales process also involves several level of approval even cross department approval as well hence software system should enable approval process as well. SAP CRM addresses these issues by storing customer information at central database and standardizing sales process (for example approval process) by enabling workflow. This helps in faster business by reducing sales cycle time.

SAP CRM also helps in measuring, monitoring and improving effectiveness of marketing activities. The SAP CRM focuses on entire sales process mainly presale and post-sale whereas SAP SD merely focuses on sales order processing.
 

-SAP Supplier Relationship Management (SRM):

In order to serve the customer faster while keeping inventory low, organizations need to work in close coordination with suppliers.

A big organization may have thousands of suppliers and hence managing becomes a challenge. Organization need to categorize suppliers into low importance, medium importance and strategically important and accordingly relationship should be valued.

There are different people on organization and supplier side and these people may be spread across different part of the organization, different departments, different function and different geography. For faster interaction between these people and remove duplication of effort, a system is needed which can enable close coordination to overcome this challenge.


-SAP Supply Chain Management (SCM):

Supply chain management involves demand forecast & planning, inventory management and execution of various interdependent tasks to be performed by different people spread across department/ geography.

Challenge in demand forecast is to put together all relevant data and analyse them considering various variables which might have an impact on demand. This process of extracting meaningful information from huge volume of data (big data) is called data analytics.

SAP SCM overcomes the challenge of demand forecast & planning by providing data analytic capability. SAP SCM also provides workflow functionality which streamlines activities (to be performed by various people) by establishing a well-defined structure of who will perform what task along with dependency between tasks. A person/ team are responsible for completion of respective assigned task. Work flow functionality enables faster completion of activities.


-SAP Product Lifecycle Management (PLM):

Product planning team comes up with an idea (idea of a product is born).  Product design team spread across geography/ discipline work in coordination. During product manufacturing organization has to work in close coordination with suppliers, contractors, transporters etc. For distribution of product, organization has to work with logistics partner.

During the entire process huge amount of data is generated and moreover this data is distributed. Manager needs a holistic view to make decisions. Challenge is to put together all data so that a holistic view can be generated. Manager needs to know the impact of any change in existing design/ production process on product cost.

SAP PLM overcomes these challenges by collecting all data centrally for a holistic view, enabling information sharing for proper coordination between various parties like product design team, engineering team, manufacturing team, suppliers, finance and others.


-SAP Human Capital Management (HCM):

HR department is involved in various processes like recruitment, on boarding, training & development, time recording, promotion, role change, payroll, separation, full & final settlement. With each event information like employee’s personal details, role, reporting manager, salary details etc. needs to be recorded and updated.

When number of employees in the organization is large and spread across geography then managing huge amount of data centrally becomes a challenge. HR department has to work in close coordination with finance department.

SAP HR overcomes these challenges by managing all data centrally and integrating HR processes. SAP HR is highly integrated with SAP FI.

Example: When an employee gets promoted, information like role, band, salary, reporting manager etc. need to be updated. Hence an event can have multiple impacts. SAP HR can be utilized for maintenance and updating of various data originating from an event.