How Data Compression in the Column Store in HANA database works and its details ? #SAP HANA

​Data compression in the SAP HANA database's column store significantly improves storage efficiency and performance.​ The method employs various compression techniques that allow for substantial reductions in data size, thus optimizing memory usage and processing times.

Using SAP column store tables, data compression can achieve ratios of up to 11 times, presenting a viable cost-saving solution for data storage in the HANA database. Such high compression ratios are critical in enhancing the performance of data-intensive applications.

The column store enables efficient compression of data, which reduces the costs associated with keeping data in main memory. This efficiency is essential for managing large datasets typical of enterprise applications.

Columnar data storage facilitates highly efficient compression primarily because most columns contain only a few distinct values compared to rows. This structure allows for targeted data access, improving overall read efficiency and query performance, particularly with extensive data sets3.

Administrators can monitor compression performance and trigger optimizations as needed. By understanding the compression ratios and structures in place, they can ensure that the database operates at peak efficiency, maintaining optimal space usage and improving access speeds.

Data in column tables can have a two-fold compression:

• Dictionary compression

This default method of compression is applied to all columns. It involves the mapping of distinct column values to consecutive numbers, so that instead of the actual value being stored, the typically much smaller consecutive number is stored.

• Advanced compression

Each column can be further compressed using different compression methods, namely prefix encoding, run length encoding (RLE), cluster encoding, sparse encoding, and indirect encoding. The SAP HANA database uses compression algorithms to determine which type of compression is most appropriate for a column. Columns with the PAGE LOADABLE attribute are compressed with the NBit algorithm only.

Compression is automatically calculated and optimized as part of the delta merge operation. If you create an empty column table, no compression is applied initially as the database cannot know which method is most appropriate. As you start to insert data into the table and the delta merge operation starts being executed at regular intervals, data compression is automatically (re)evaluated and optimized.

Automatic compression optimization is ensured by the parameter active in the optimize_compression section of the indexserver.ini configuration file. This parameter must have the value yes.

 

Cost Functions for Optimize Compression

The cost functions for optimize compression are in the optimize_compression section of the service configuration (e.g. indexserver.ini)

• auto_decision_func - if triggered by MergeDog
• smart_decision_func - if triggered by SmartMerge

 

Note: 

1. Advanced compression is applied only to the main storage of column tables. As the delta storage is optimized for write operations, it has only dictionary compression applied.
2. If the standard method for initiating a delta merge of the table is disabled (AUTO_MERGE_ON column in the system view TABLES is set to FALSE), automatic compression optimization is implicitly disabled as well. This is the case even if the AUTO_OPTIMIZE_COMPRESSION_ON column is set to TRUE in the system view TABLES. It is necessary to disable auto merge if the delta merge operation of the table is being controlled by a smart merge triggered by the application. For more information, see the section on merge motivations.

 

FAQ: SAP HANA Native Storage Extension (NSE)

1: How can I activate NSE?

NSE can be activated via DDL commands on the desired tables. There are no additional configuration steps needed.

2. I have activated NSE for a database object but want to revert my changes. How can I achieve this?

Changes to database objects can be reverted by setting the load granularity to default.

ALTER TABLE "<table_name>" DEFAULT LOADABLE;

Adding the option CASCADE allows to overwrite all modifications on the below layers:

ALTER TABLE "<table_name>" DEFAULT LOADABLE CASCADE;

 

3. Where do I find information about buffer cache usage?

Information on the buffer cache usage such as hit ratio and size can be obtained in the following locations:

• M_BUFFER_CACHE_STATISTICS
• M_BUFFER_CACHE_POOL_STATISTICS
• SQL: "HANA_NSE_BufferCache" (SAP Note 1969700)
• M_SQL_PLAN_CACHE (starting SAP HANA 2.0 SPS07, columns *_BUFFER_CACHE_IO_READ_SIZE, *_BUFFER_CACHE_PAGE_MISS_COUNT and *_BUFFER_CACHE_PAGE_HIT_COUNT)
• SQL: "HANA_SQL_SQLCache_2.00.070+" (SAP Note 1969700)

4. How can I calculate the memory consumption of NSE enabled tables?

As explained in question #1, pages of NSE tables, when loaded into memory, are loaded into the buffer cache. Some helper structures for the columns are still loaded into the main store area of HANA and reside there until the column is unloaded.
After reading an NSE table, its non-pageable area will be loaded to the main store memory, while the pageable area will be loaded into the buffer cache. If, just after this read, you check the memory consumption for the table, the value will be the sum of main store memory and the memory occupied in the buffer cache. Keeping in mind the nature of the Buffer Cache, you will understand that the allocation in the buffer cache is transient. As soon as another NSE table is read, those pages loaded into the buffer cache may be displaced in a least-recently used fashion. Or they may stay there for longer, if there is enough space in the buffer cache to accommodate both tables. Given the transient characteristic of the pages loaded into the buffer cache, for the purpose of determining memory savings brought by NSE, this memory area should not be considered for the definition of the total memory allocated by the NSE table.

SQL: "HANA_Tables_ColumnStore_TableSize_2.00.030+" (SAP Note 1969700) reports the NSE-related memory consumption in column PAGED_GB.

5. Where is the buffer cache located?

The buffer cache is stored in the heap allocator Pool/CS/BufferPage. The allocator always resides in DRAM. This also applies to systems using PMEM or Fast Restart Option.

6. How does the buffer cache behave during memory pressure?

The NSE Buffer cache is not unloaded as part of shrink operations. As a result, the memory used by the NSE cache cannot be released and be reused by other components in case the database runs out of memory.

To avoid memory issues, the buffer cache should be configured with a reasonable size depending on the size of tables located in NSE.

7. How to handle NSE advisor recommendations to move columns like $trexexternalkey$ or $AWKEY_REFDOC$GJAHR$?

$trexexternalkey$ or $AWKEY_REFDOC$GJAHR$ are internal columns (SAP Note 1986747) that refer to the primary key respectively a multi-column index/concat attribute. Indexes can be moved to NSE as well.

a) identify index name:

SELECT SCHEMA_NAME, TABLE_NAME, INDEX_NAME, INDEX_TYPE, CONSTRAINT FROM INDEXES WHERE TABLE_NAME = '<table_name>';

b) change the index load granularity

ALTER INDEX "<schema>"."<index_name>" PAGE LOADABLE;example: ALTER INDEX "PLAYGROUND"."_SYS_TREE_CS_#170484_#0_#P0" PAGE LOADABLE;

 

8. How can I get information on the impact of NSE on query performance?

Starting SAP HANA 2.0 SPS07 monitoring view M_SQL_PLAN_CACHE contains several additional columns  that provide deeper insight on NSE usage during query execution (*_BUFFER_CACHE_IO_READ_SIZE, *_BUFFER_CACHE_PAGE_MISS_COUNT and *_BUFFER_CACHE_PAGE_HIT_COUNT).

The following sql commands in SAP Note 1969700 exist to support the investigation:

• SQL: "HANA_SQL_SQLCache_2.00.070+" 
• SQL: "HANA_SQL_SQLCache_TopLists_2.00.070+" 

9. Does DDIC support NSE?

Since S/4 HANA 2021, DDIC supports load unit settings "Page Preferred" and "Page Enforced". Depending on the S/4 HANA release, these settings can change.
The current configuration can either be checked via SE11 -> "Technical Settings" -> "DB-Specific Properties".
Alternatively, you can query the details directly in DBACOCKPIT via the following SQL:

select
    t.TABLE_NAME, t.LOAD_UNIT HDB_LOAD_UNIT,
    CASE WHEN d.LOAD_UNIT = 'P' THEN 'Page Preferred'
      WHEN d.LOAD_UNIT = 'Q' THEN 'Page Enforced' END DDIC_LOAD_UNIT
FROM
    TABLES t full outer join DD09L d ON t.table_name = d.tabname
WHERE
    (t.LOAD_UNIT = 'PAGE' OR d.LOAD_UNIT IN ('P', 'Q')) AND t.SCHEMA_NAME LIKE 'SAP%';

For further details on DDIC integration, please see SAP Note 2973243.

10. When are DDIC load unit settings applied and what happens if an upgrade changes the DDIC load unit?

Whether load unit settings are applied automatically depends on the scenario:

1. When converting from anyDB to SAP S/4 HANA, the DDIC load unit is applied in the course of the migration, tables with "page preferred" and "page enforced" are created using NSE.
2. A fresh installation of S/4 HANA 2021+ is performed. The DDIC load unit is applied directly during installation.
3. A conversion from Suite on HANA to S/4 HANA or a S/4 HANA upgrade does not enforce DDIC load unit settings. In this scenario only exchange tables are created with the new settings. The load unit setting of existing tables will be preserved. Only a change to "Page Enforced" will result in a load unit change on the database. Other SAP_BASIS objects with load unit "Page Preferred" such as BALDAT, CDPOS, and EDID4 stay as is and will not be automatically changed.

11. Do I need additional disk space when using NSE?

During conversion to page loadable, the persistence structures are rewritten for optimal usage with NSE. In most cases, this does not change the total amount of disk space needed. However, in rare cases tables, partitions, and columns that are converted to NSE may see an increased disk usage up to 80 %. Some column data types (like TIMESTAMP, DATE, CHAR, VARCHAR and NVARCHAR) do not support all possible dictionary compressions if columns are stored as page loadable.

12. Is the buffer cache preloading data after a system restart just like the normal column store does?

No, the buffer cache will be empty after restart and only be populated on demand.

Note: 

Please refer to the SAP note to get full details. 

2799997 - FAQ: SAP HANA Native Storage Extension (NSE)

what is SAP HANA Native Storage Extention? #Data Archiving

SAP HANA 2 SPS 04 provides a new feature called SAP HANA Native Storage Extension (NSE). NSE is a disk-based extension to the in-memory COLUMN STORE in SAP HANA. Instead of loading a whole column, only the needed pages are loaded into the buffer cache when accessing the data.

SAP HANA Native Storage Extension (NSE) is a general-purpose, built-in warm data store in SAP HANA that lets you manage less-frequently accessed data without fully loading it into memory. It integrates disk-based or flash-drive-based database technology with the SAP HANA in-memory database for an improved price-performance ratio. 

SAP HANA offers various software solutions to manage multi-temperature data (hot, warm, and cold), such as DRAMs for hot data and SAP HANA Extension Nodes, SAP HANA dynamic tiering for warm data, and SAP HANA Cold Data Tiering for cold data. 

Hot data is used to store mission-critical data for real-time processing and analytics. It is retained continuously in SAP HANA memory for fast performance and is located in the highest performance (and highest TCO) storage. 

Warm data is primarily used to store mostly read-only data that need not be accessed frequently. The data need not reside continuously in SAP HANA memory, but is still managed as a unified part of the SAP HANA database ― transactionally consistent with hot data, and participating in SAP HANA backup and system replication operations, and is stored in lower cost stores within SAP HANA. 

Cold data is used to store read-only data, with very infrequent access requirements. You manage cold data separately from the SAP HANA database, but you can still access it from SAP HANA using SAP HANA’s data federation capabilities. This image shows the difference between standard HANA in-memory storage and the storage offered with NSE:

The capacity of a standard SAP HANA database is equal to the amount of hot data in memory. However, the capacity of a SAP HANA database with NSE is the amount of hot data in memory plus the amount of warm data on disk.

Since growth in data volume results in increased hardware costs, the ability to decouple data location from a fixed storage location (layer) is one of the key themes of a multi-temperature data storage strategy.

NSE is integrated with other SAP HANA functional layers, such as query optimizer, query execution engine, column store, and persistence layers. Key highlights of NSE are:

• A substantial increase in SAP HANA data capacity, with good performance for high-data volumes.
• The ability to co-exist with the SAP HANA in-memory column store, preserving SAP HANA memory performance.
• An enhancement of existing in-market paging capabilities by supporting compression, dictionary support, and partitioning.
• An intelligent buffer cache that manages memory pages in SAP HANA native storage extension column store tables.
• The ability to monitor and manage buffer cache statistics via system views.
• The ability to support any SAP HANA application.
• A simple system landscape with high scalability that covers a large spectrum of data sizes.
• An advisor that collects object access statistics and provides column store object load unit recommendations.

Note: 

1. The NSE feature in SAP HANA does not require you to modify your applications.
2. Although SAP HANA 2.0 calculates 10% of memory for the buffer cache by default, this memory is only reserved and not allocated. SAP HANA accesses 100% of its memory (including the 10% reserved for the buffer cache) if you are not using NSE.
3. If there are page loadable tables in your current version of SAP HANA and you move to another, later, version, only those tables that were designated as page-loadable in the earlier version use the buffer cache in the later version (up to the limit that was calculated in the original version of SAP HANA you were running).

 

 

What is SAP Information Lifecycle Management (SAP ILM) ?

Information has a lifecycle. It is created, it lives within databases and systems, it changes, and it is archived and eventually deleted. With SAP Information Lifecycle Management (SAP ILM), companies can meet their data retention, data destruction, and system decommissioning requirements and obtain compliance with legal and regulatory mandates. As a result, SAP Information Lifecycle Management (SAP ILM) helps companies streamline their technical infrastructure, reduce IT costs, and improve IT risk and compliance management.

SAP Information Lifecycle Management (SAP ILM) is based on the following pillars:

 • Data archiving (active data and system):

• Analyze data volumes
• Securely move data from the database to the archive
• Access archived data conveniently

• Retention management (end-of-life data):

• Define and manage all retention policies across the enterprise
• Manage the destruction of data responsibly based on policies
• Enforce retention policies
• Use secure information lifecycle management–aware storage (partner offerings)
• Perform e-discovery and set legal holds

• System decommissioning (end-of-life system):

• Decommission SAP and non-SAP legacy systems to a central retention warehouse 
• Enforce retention policies on data from the shut-down system
• Run reporting on data from the shut-down system (SAP Business Warehouse (SAP BW) and local reporting)
• Use predefined business warehouse queries for reporting
• Interpret and understand data in archives without the help of the original system

 

To learn more about SAP Information Lifecycle Management (SAP ILM), 

please contact your SAP representative, write to us at ilm@sap.com, or visit us on the Web at http://scn.sap.com/community/information-lifecycle-management.

How to check SAP Application log Statistics with help of Program "SBAL_STATISTICS" ? # SAP Basis Administrator

To check SAP Application log statistics you can use the program "SBAL_STATISTICS," you can utilize the reporting capabilities it provides for analyzing and obtaining detailed statistical information about application logs generated by various applications within SAP. This program serves as a useful tool for effectively monitoring and managing log entries.

Based on the findings from the SBAL_STATISTICS report, administrators may decide to clean up old logs, adjust logging levels, or take corrective actions on applications based on the insights derived from the statistics of application logs.

Accessing the Program

You can access the program through Tcode "SA38", as shown below

Click on execute and select the statistic collection option as per requirement. 

STATISTIC COLLECTIONS

TIME CREATION: 

get the number of logs for every month in a year, how many logs are in each month

CLIENTS :

get the number of logs for every client, how many logs are in each client

OBJECTS, Subobject, messages :

detailed overview based on OBJECT and SUBOBJECT of logs

columns:

• OBJECT, SUBOJECT (defined in TCODE SLG0)
• MIN DATE - the oldest creation date ( highlighted field is older than 180 days)
• MAX DATE - the latest creation date ( highlighted field is older than 180 days)
• Logs Cnt - number of logs
• MsgCnt All - number of messages
• MsgCnt E, W, I, S, A - number of message with type Error, Warning, Information, Success, Cancel
• reached exp date - number of logs they reached expiry date and can be deleted via option SLG2 - only logs that have reached their expiration date
• and can be deleted - number of logs can be deleted via option SLG2 - And logs that can be deleted before the expiration date
• cannot be deleted - number of logs cannot be deleted via option SLG2 - Non-deletable logs (display only). Such logs can be deleted only be the application that created the logs.
• never expire - number of logs that expity date is set to 31/12/9999
• % - number of % logs in current client.

USERS: 

get the number of logs for every user

PROGRAMS: 

get the number of logs for the program

TCODE: 

get the number of logs for TCODE

EXPIRATION DATE: 

get the number of logs for each option of Expiration Date (SLG2)

- Only logs that have reached their expiration date

- And logs that can be deleted before the expiration date

- Non-deletable logs (display only)

RELID data, BALDAT: 

get number records with different RELID in BALDAT

Statistic logs

to view data select Option and click on Execute. 

You can view log details under Details as shown below.

Documents referred : 2524124 - Application log Statistics

Data Management Guide forSAP Business Suite

What's LOB and the importance in HANA database ?

 In the SAP HANA database, Large Objects (LOBs) are unstructured data types such as images, videos, or documents. ​The importance of LOBs in HANA, particularly regarding their disk size, is significant for performance, storage management, and application development.​

1. Definition of LOBs

LOBs, or Large Objects, refer to unstructured data types that include items such as pictures, PDFs, and XML content1. They are characterized by their capability to be quite large, which necessitates special considerations in terms of storage and performance within databases like SAP HANA4.

2. Disk Size Limitation

In SAP HANA, the current maximum size for a LOB is 2 GB2. This limitation is critical as it influences how data is managed within the database and affects the strategies for data storage and retrieval employed by application developers.

3. Storage of LOBs in HANA

SAP HANA can store large binary objects (LOBs) such as images or videos on disk, rather than inside column or row structures in main memory3. This distinction is vital for performance optimization, as storing large objects on disk allows for more efficient use of memory resources in main operations.

4. Impact on Performance

The way LOBs are managed in SAP HANA—their storage on disk instead of main memory—has implications for startup times and takeover processes5. As LOBs can occupy considerable storage space, their management directly affects the overall efficiency of data access patterns in applications utilizing HANA.

5. Application Development Considerations

Understanding the size and nature of LOBs is essential for application developers working with SAP HANA6. They must consider these aspects when designing data models and structures to ensure optimal performance and adherence to size constraints for LOB storage.

How does SAP table "BALDAT" enhance the performance of the SAP system, and why is it important?

 #SAP Basis Administrator

The BALDAT table in SAP serves as a standard repository for logging application events.​ It is crucial for tracking, analyzing, and troubleshooting various activities within the SAP system. Understanding its technical details and significance will aid users in managing logs efficiently, enhancing system performance, and maintaining operational integrity.

1. Overview of the BALDAT Table

The BALDAT table, also referred to as "Application Log: Log Data," is a standard table used within SAP R/3 ERP systems to store detailed log information related to application processes. It provides a structured format for capturing critical data necessary for monitoring system activities and auditing changes made during transactions.

2. Technical Structure

The BALDAT table comprises several fields that define the data structure, including, but not limited to:

• MANDANT (Client): Identifies the client within which the log entry is stored, fundamental for data organization and segregation across different business environments2.

• RELID (Region in IMPORT/EXPORT Data Table): This field helps to indicate the region related to log entries, facilitating more refined data categorization2.

• LOG_HANDLE (Application Log: Log Handle): A unique identifier for each log entry, ensuring traceability and reference2.

• BLOCK (Internal Message Serial Number): Numbers log entries serially to assist in organizing log data2.

• Error Tracking and Troubleshooting: It captures detailed error messages, warnings, and informational logs generated during transactions, allowing administrators to investigate issues effectively7. This capability is vital for diagnosing application performance and operational integrity.

• Auditing and Security: Logs maintained in BALDAT can be leveraged for auditing purposes. They provide insights into user activities, changes made to data, and potential security violations, ensuring compliance with regulatory standards7.

• Job Monitoring: The table records logs related to job scheduling and execution, allowing administrators to track the status and outcomes of automated tasks and background processes, enhancing overall system management7.

Additional fields track the length of user data, data types, and various parameters related to the logs.

3. Importance of BALDAT in SAP Systems

The BALDAT table holds significant importance in an SAP system for various reasons:

4. Log Management and Maintenance

Given that the application logs can grow exponentially, regular maintenance of the BALDAT table is critical. Tools like the SBAL_DELETE report can be utilized to automate the cleanup of outdated log entries, minimizing performance degradation due to excessive log data. Furthermore, administrators can analyze logs using transactions such as SLG2 to identify non-deletable logs and manage retention effectively.

Please refer to SAP Note: 

195157 - Application log: Deletion of logs

2524124 - Application log Statistics

5. Conclusion and Best Practices

In summary, the BALDAT table's structured logging capability and detailed recording of application activities make it an essential component of the SAP ecosystem. Regular monitoring and maintenance of this table, coupled with a proactive cleanup strategy, can significantly enhance system performance and operational compliance. Best practices include the periodic execution of log cleanup reports, adherence to logging policies, and the implementation of comprehensive log analysis procedures.

This comprehensive overview provides a clearer understanding of the technical specifications and significance of the BALDAT table within SAP systems.

 

How to Switch HANA alerts off/on with SQL Statement ?

 we can switch off the underlying alert checker, so it no longer runs automatically or you can switch it back on again using the following methods:

• HANA 1.0 SPS12

• HANA 2.0 SPS00 and higher

If you need to disable or enable these alerts in batch (more than one at once), the easy way is to manipulate STATISTICS_SCHEDULE (_SYS_STATISTICS).
STATISTICS_SCHEDULE Table (Embedded Statistics Service)
Statistics schedule per host. This view contains information only for the last 7 days.
 

Caution
If you switch off alerts, you may not be warned about potentially critical situations in your system.
Be careful when modifying data on SYSTEM_STATISTICS through SQL Script.

For example: You want to disable all the schedules for the alerts shown in both HANA Cockpit > Configure Alerts / HANA studio > Alerts. Run the following statement:

UPDATE _SYS_STATISTICS.STATISTICS_SCHEDULE SET "STATUS" = 'Inactive' where "ID" between 1 and 710

In case you want to activate them back to the original schedule, you can run the following statement:

UPDATE _SYS_STATISTICS.STATISTICS_SCHEDULE SET "STATUS" = 'Idle' where "ID" between 1 and 710

You can build your own scripts and procedures for this purpose. For example, to save the current status of the alerts to restore later or to just disable a few alerts for a given maintenance window.

 

How to check Web dispatcher version in web ? #Sap Basis Administrator

To check the version of SAP Web Dispatcher using various methods, users can log into the SAP operating system and execute specific commands or access the web interface.​ These methods ensure accurate identification of the version currently in use.

1. Command Line Method

One effective way to check the Web Dispatcher version is by executing the command sapwebdisp -v in the command prompt after logging in as the administrative user13. This command will display the version information directly, ensuring that you are aware of what is currently operational.

2. Accessing the Work Directory

Another method involves navigating to the "work" directory of the Central Instance (CI), typically located at /usr/sap/SID/DV*/work, where you can open the file named dev_desp. The first line of this file will indicate the release version of the Web Dispatcher being used.

3. Using the Web Admin Interface

For those preferring a graphical user interface, one can check the version through the SAP Web Dispatcher admin URL. By clicking on “Release information” within the Web Dispatcher administrative interface, it should display the current version.

 4. Monitoring Through Administration Tools

Additionally, administrators can monitor the SAP Web Dispatcher version and its status using command line programs like icmon. This method provides a continuous report on the current state of the Web Dispatcher46.

5. Verifying via Process Information

Lastly, confirming the Web Dispatcher version can also be achieved by checking system-level processes. Using the command ps -ef | <searchRefSen indexList="30,60" order="4" >grep webdisp can reveal which Web Dispatcher instance is running, including its kernel version in use</searchRefSen>.

  

#SAP Basis Administrator - Trace Functions / Analysis in SM50

 Selected menu entries and functions of the process overview, and available system-wide process overview functions are described below:

Note

To use these functions, you first need to select at least one work process.

• Write stack:

Administration  Work Process  Write Stack

To find out the current status of a process, you can write the ABAP and C stacks. The ABAP stack is written only if the process is currently running an ABAP program and can identify the ABAP stack.

• Display trace file:

Administration  Trace  Display File  Current/Previous 

All components that were selected under Active Components are displayed in the trace file.

• Download trace file:

Administration  Trace  Save as Local File

With this function, you can download one or more trace files to your local PC.

See saving trace files locally

• Reset trace file:

Administration  Trace  Reset  All Files/Work Process Files

You can reset all trace files or just trace files for individual work processes. All Files means all dev*files on this server. As well as work process traces, traces from the gateway, dispatcher, ICM, RFC, and so on, are also reset. Caution: After the trace files have been reset, the information contained in them is lost and cannot be retrieved.

• Create snapshot:

Administration  Snapshot  Create.

Here you can create a snapshot to use for error analysis, which is then managed in the $(DIR_GLOBAL)/sapcontrol/snapshots directory of the system.

• Manage snapshot and saving locally:

Administration  Snapshot  Administration.

Here you can jump to transaction SNAPSHOTS. Here you can manage snapshots and save them to your local PC.

• Manage dispatcher trace file:

Administration  Trace  Dispatcher  Change Trace Level / Display File / Save as Local File / Reset File

Here you can change the trace level of the dispatcher trace file, display the trace file, save the file locally, and reset the trace file.

 

Menu Functions - Administration of Work Processes in SM50 #SAP Basis Administrator

System Administration in SM50

The most important administration tasks are listed for reference below:

Managing Work Processes

• Terminate ABAP Program
• Debug ABAP Program
• Display Active Processes
• Display Details of a User
• Display Details of a Process
• Delete Session
• Terminate Process (With or Without Core)
• Start Process After Error/Termination Automatically
• Cancel Request Processing
• Display System-Wide Process List
• Reset Terminations
• Reset the Info Area

Trace Functions / Analysis

• Create Snapshot
• Snapshot Administration
• Write C Stack
• Manage Dispatcher Trace File
• Display Trace File
• Download Trace File
• Change Trace Components
• Configure Trace File Display
• Reset Trace File

  

Note: To use these functions, you first need to select at least one work process.

•  Cancel a process:

Administration  Process  Cancel  With Core/Without Core

The work process is terminated at operating system level. The Dispatcher starts a new work process with a new PID (provided you have configured the system appropriately) “Start Process After Error/Termination Automatically”). You can create a core file when the process is terminated for analyzing later. You can display the core file in transaction .RZ11

• Start Process After Error/Termination Automatically:

Administration  Process  Restart After Error   Yes/No.

If a process is terminated due to an error, it can be restarted automatically. The default is Yes.

• Debug a running ABAP program.

Administration  Program  Debugging

This function can only be executed if you have selected a work process in which an ABAP program is currently running. You can find the report name in the Active Program column. Note that you need “debug and replace authorization”, which is controlled by authorization object S_DEVELOP together with OBJTYPE 0 DEBUG and ACTVT = 02

• Terminate a running ABAP program:

Administration  Program  Cancel

This function can only be executed if you have selected a work process in which an ABAP program is currently running. You can find the report name in the Active Program column. If a program is terminated, a short dump is generated.

• Deleting an ABAP session:

Administration  Delete Session

You can delete the running ABAP session without having to close the work process.

• Display system-wide process list:

Goto  System-Wide List (or icon: . )

You can switch to the system-wide process list from the process overview of an individual instance.

With the icon you can also go to the system-wide process list.

• Display details of a process:—

Goto  Process Information (or icon: .)

Here you can display detailed information on memory statistics, database statistics, SQL statements, runtime, application, and specific attributes of the process.

• Display details of a user:

Goto  User Info

You can display information on the user here. To manage users go to the User Overview (transaction SM04).

In the process overview, you cannot be sure that a user session you want to terminate or delete is still active in the work process that you have chosen. You could therefore unintentionally affect another user's session.

• Reset Terminations:

List  Reset  Failures.

This counter is displayed in the column overview in column Failures (Work Process Failures). It specifies how often the work process has been restarted because of an error or a manual restart.

• Reset information area:

List  Reset  Info Area.

Resetting the info area is useful if, for example, dynamic work processes have been added or removed in the meantime.

 

What is the use of SAP Web Dispatcher in SAP Landscape?

 #use of SAP Web Dispatcher in SAP Landscape

#SAP Web Dispatcher functionality in SAP systems

The SAP Web Dispatcher serves as a pivotal component within the SAP landscape, primarily acting as a reverse proxy that optimizes the flow of HTTP(S) requests. Its key functions include load balancing across application servers, enhancing security features, and acting as an intermediary between clients and the SAP system.

1. Acting as an Intermediary

The SAP Web Dispatcher functions as a bridge between the internet and the SAP system, efficiently forwarding incoming HTTP(S) requests to the appropriate application servers while returning backend responses to clients127. This role is crucial for ensuring that requests are managed effectively within the SAP architecture.

2. Load Balancing

One of the primary uses of the SAP Web Dispatcher is to balance the load across multiple application servers in the SAP landscape. It ensures an even distribution of incoming requests, thereby optimizing resource utilization and preventing any single server from becoming overwhelmed48. The dispatcher employs various algorithms, including dynamic load balancing, to assess capacity and allocate requests accordingly8.

3. Enhancing Security

The SAP Web Dispatcher significantly enhances security by enforcing the use of HTTPS for secure connections and allowing URL filtering to restrict access to sensitive areas of the system8. It also manages SSL configurations, facilitating secure communications and protecting critical data from potential threats48.

4. Flexibility and Configuration

The dispatcher offers configurability, allowing it to be tailored to specific SAP landscapes, including ABAP and Java systems8. It can be deployed in front of multiple SAP systems, which is beneficial for organizations that require centralized traffic management48.

5. Caching and Performance Improvement

Additionally, the SAP Web Dispatcher can act as a web cache, which helps improve response times by storing frequently accessed content and reducing the load on application servers4. This feature enhances overall system performance and contributes to quicker response times for end-users.

​In summary, the SAP Web Dispatcher plays a vital role in managing HTTP(S) traffic, load balancing, and enhancing security within the SAP landscape, making it essential for optimizing system performance and reliability.

 

 

SAP Web Dispatcher: Release, Installation, Patches, Documentation

# Know which version is supported for your scenario and where to find the software.

# Find the online documentation of SAP Web Dispatcher.

 About SAP Web Dispatcher

SAP Web Dispatcher is a load balancer and reverse proxy that can be used with different web application server backends:

• SAP NetWeaver Application Server ABAP
• SAP NetWeaver Application Server Java
• SAP HANA XS, both in the "Classic" and "Advanced" flavor
• Any web server

Note: HANA XS Classic and HANA XS Advanced come with an internal Web Dispatcher of version 7.53. This note does not apply to this internal HANA Web Dispatcher. It cannot be used as a load balancer or reverse proxy for other systems. It is not possible to upgrade the Web Dispatcher version inside these products.

Selecting a SAP Web Dispatcher Version

SAP Web Dispatcher version 7.93 is recommended for most deployments.

SAP Web Dispatcher is downward compatible; the newest SAP Web Dispatcher can be used with all older backend systems.

If the recommended version is not supported on your operating system then pick the highest SAP Web Dispatcher version that is supported. See section Supported Operating Systems below.

We recommend the SAP Web Dispatcher version to be greater or equal to the kernel version of your backend system. The patch level is not relevant. If you have to use a SAP Web Dispatcher version that is lower than the kernel of your backend system some features of the AS ABAP may not be not available.

We recommend using the most current SAP Web Dispatcher patch level. There is no concept of "stack kernel" in SAP Web Dispatcher.

 

Additional notes:

• For details on SAP Web Dispatcher versions, corresponding product versions, release notes, incompatible changes, maintenance schedule and documentation,
• Incompatible changes: 
• There are no incompatible changes in SAP Web Dispatcher 7.89 and 7.85 with respect to 7.81.
• SAP Web Dispatcher 7.81 contains some slightly incompatible changes of configuration parameters with respect to version 7.77. See the section "Upgrade to the current version from earlier versions" below for details.
• SAP Web Dispatcher 7.73 and 7.77 contain some slightly incompatible changes of configuration parameters with respect to version 7.53. See the section "Upgrade to the current version from earlier versions" below for details.

• Supported operating systems: The latest SAP Web Dispatcher supports the operating systems Linux on x86 and PPC LE, Windows and AIX. If you have to deploy SAP Web Dispatcher on another operating system then use the highest version that supports that operating system. See the section "Supported Operating Systems for SAP Web Dispatcher Versions".

• Unicode: The Unicode SAP Web Dispatcher supports both Unicode and non-Unicode backend systems.

• The Product Availability Matrix (PAM) of some older SAP products lists outdated versions of SAP Web Dispatcher (e.g. for SAP NetWeaver). Please disregard such information of the PAM and follow the recommendation of this note instead.

Updating SAP Web Dispatcher

We generally recommend using the SAP Web Dispatcher with the most current patch level of the used version. The update is done simply by exchanging the executables. You may update SAP Web Dispatcher to the latest patch level of the currently installed version or to a different version. There is no automated upgrade procedure for SAP Web Dispatcher.

Online Documentation for the SAP Web Dispatcher

Navigate to http://help.sap.com

-> Enter "ABAP Platform and SAP NetWeaver" into the search field
-> Select the first link
-> Select the desired version
-> Application Server ABAP Infrastructure 
-> Components of Application Server ABAP
-> SAP Web Dispatcher

 

 SAP Web Dispatcher Versions, Corresponding Product Versions, Release Notes, Maintenance Schedule and Documentation

SAP Web Dispatcher is always delivered as part of another SAP product. The SAP Web Dispatcher release notes are part of that product. The following table helps you identify the corresponding product and release notes. SAP Web Dispatcher release notes are found under the topic "Application Server Infrastructure".

This table indicates which minimum version of SAP Web Dispatcher to use with a certain SAP product version. For details see section "Selecting a SAP Web Dispatcher Version" above.

The maintenance schedule of the SAP Web Dispatcher is identical with the SAP Kernel. The maintenance end dates can be read from the notes referenced in the table below. The other information in the notes regarding which kernel can be used with which S/4HANA or NetWeaver release cannot be applied to SAP Web Dispatcher. See section "Selecting a SAP Web Dispatcher Version" above.

The release notes for both BC-CST-WDP and BC-CST-IC are relevant for SAP Web Dispatcher unless the feature explicitly applies only to Internet Connection manager (ICM).

 

Profile Parameter Changes (*)

 

Reference document : 

908097 - SAP Web Dispatcher: Release, Installation, Patches, Documentation

Administration of Application Server ABAP