Number of Processes for DTP Parallel Processing

To speed up runtime of DTP it is possible to parallelize it. There is a possibility to set a maximum number of DTP instances that run in parallel. In t-codes like RSA1->DTP or RSDTP in its menu Goto->Settings for Batch Manager->Number of Processes.

This settings is stored in table RSBATCHPARALLEL (Control Parallel Batch Processes) in field PARALLEL_PROCS (Maximum Number of All Parallel Processes for This type). Corresponding domain is RSBATCHPAR. Table can be read in a way that in field PROCESS_TYPE = DTP_LOAD and into PC_VARIANT = DTP technical name.

Similarly, in t-code RSBATCH there is a possibility to set this via button Parameter Settings under which also number of processes for DTP parallel processing. See more info about the t-code RSBATCH here. This can be setup either set:

1. For all DTPs – means default value for all DTP that do not have it setup, default value is 3

2. Or via button Mass Maintenance of ALL Settings for Parallel Processing for particular DTP

More information:

Degree of Parallelization in SAP BW

Table RSBKADMIN – DTP System Specific Attributes

Degree of Parallelization in SAP BW

Normally by SAP BW systems a large portions of data is processed. Such a data volume normally cannot be processed by single process. Depending on the available hardware resources the process that crunches the data should be parallelized. SAP BW systems similarly as any other moderns DWH systems is supporting this feature. The number of processes that are processing the data is called degree of parallelization.

In the SAP BW it is possible to define the degree of Parallelization in t-code RSBATCH for multiple different tasks/objects within the SAP BW. There are (in version 7.5 SP15) about 106 different processes. As per table RSPROCESSTYPES these includes:

ABAP            Execute ABAP Program

ADSOACT      Activate Requests in DataStore Objects (advanced)

ADSODEL      Deletion of Requests from DataStore Objects (advanced)

ADSOOLR      Delete Overlapping Requests from DataStore Object (advanced)

ADSOREM      Clean Up Old Requests in DataStore Objects (advanced)

AGGRFILL      Initial Fill of New Aggregates

AND              AND (Last)

ANPR            Execute Analysis Process

ARCHIVE       Archive Data from an InfoProvider

ATTRIBCHAN Attribute Change Run

AUTOCLASS   Automatic Classification

BIAINDEX      Initial Activation and Filling of SAP HANA/BWA Indexes

BIA_TPS        Update Explorer Properties of BW Objects

BOBJDSJOB   Start Job in SAP BusinessObjects Data Services

BOBJEVENT   Trigger Event in SAP BOBJ BI Platform for BW Data Changes

BPCADMCDM BPC: Create Dimension

BPCADMOTC  BPC: Optimize Application

BPCADMVLG  BPC: Validate Logic

BPCADTARC   BPC: Archive Audit

BPCAPPS       BPC: Application Source

BPCBADIRT   BPC: BAdI Retractor

BPCCLCUBE   BPC: Delete Application

BPCCLEAR     BPC: Delete BPC Tables

BPCCMCOVT  BPC: Convert for CM

BPCCOMS      BPC: Delete Comments

BPCCONVERT BPC: Convert

BPCECHAIN   BPC: Execution of Chain

BPCEMAIL     BPC: E-Mail

BPCEPURPT   BPC: Generate Equity Pick-up Audit Report

BPCFILE        BPC: Data Connection

BPCFINOPT    BPC: Complete Optimization

BPCFTP         BPC: FTP

BPCIFS          BPC: InfoProvider Source

BPCIOBJS      BPC: InfoObject Source

BPCJORNAL   BPC: Journal

BPCLOAD      BPC: Load

BPCMADLOAD BPC: Master Data Description

BPCMALOAD  BPC: Master Data

BPCMDDEAL  BPC: Master Data Processing

BPCMODIFY   BPC: Modify Dynamically

BPCONLINE   BPC: Online Status

BPCOWCALC  BPC: Ownership Calculation

BPCPSAS       BPC: PSA Source

BPCRUNLGC  BPC: Run Logic

BPCTDHVER   BPC: Manage TDH Version

CHAIN           Local Process Chain

CHGLOGDEL  Deletion of Requests from Change Log of DSO (classic)

CLEARTODS   Delete Entire Content of Linked Transactional ODS

CL_ARCHIVE  Cleanup Archive

COMMAND     OS Command

COMPRESS    Compression of the InfoCube

CPS_EVENT   Event in SAP CPS

CPS_JOB       Job in SAP CPS

DATACHANGE Trigger Event Data Change (for Broadcaster)

DBSTAT        Construct Database Statistics

DECISION     Decision Between Multiple Alternatives

DROPCUBE    Complete Deletion of Data Target Contents

DROPINDEX   Delete Index

DSOREPLIC   DataStore Object-Replication

DTP_LOAD     Data Transfer Process

EXOR            EXOR (First)

HAAP            Execute SAP HANA Analysis Process

HIERSAVE     Save Hierarchy (3.X)

INDEX           Generate Index

INTERRUPT    Interrupt Process

LOADING       Execute InfoPackage

LPI                Logically Partitioned InfoPackages

MAIL             Send Message

MDREORG     Reorganize Attributes and Texts for Master Data

MDUPDATEGK Master Data Update with Global Keys

MULTIHIER    Load All Hierarchies

NDB_MERGE  Trigger Delta Merge

ODSACTIVAT Activate Requests in DataStore Objects (classic)

ODSPROCESS Update DataStore Object Data (Further Update)

OHD_NOTIFY Open Hub Notification

OPENHUB      Data Export into External Systems (Obsolete)

OR                OR (Each)

PC_ACTIVE    Is the previous run in the chain still active?

PLSEQ           Execute Planning Sequence

PLSWITCHL   Switch Realtime InfoCube to Load Mode

PLSWITCHP   Switch Realtime InfoCube to Plan Mode

PSADELETE   Deletion of Requests from PSA

PSAPROCESS Read PSA and Update Data Target

QMSTATUS    Quality Status/Set Data Release

RDA_CLOSE   Close Request for an InfoPackage (RDA/Push)

RDA_RESET   Stop Real-Time Data Acquisition (RDA) Load Process

RDA_START   Start Load Process for Real-Time Data Acquisition (RDA)

REMOTE        Remote Process Chain

REPA_BB       Precalculation of Value Sets

REPA_BC       Precalculation of Web Templates

REPA_BP       Print in the Background

REPA_ER       Exception Reporting

REQUDEL      Delete Overlapping Requests from InfoCube

ROLLUP         Roll Up of Filled Aggregates/BWA Indexes

RS2HANA      Replicate BW Analysis Authorizations to SAP HANA

RSCNV           Remodeling Toolbox Operation

RSDASYB_PM Sybase IQ Partition Monitor

RSSDA_STAT Creation of Database Statistics for Virtual Tables

R_SALES2XI  Send POS Sales Data to XI System

SDI_INIT       Start SAP HANA EIM Remote Subscription

TB_LCCUPD   Last Customer Contact Update (Retraction)

TIMCHNGRUN Adjustment of Time-Dependent Aggregates

TRIGGER       Start Process

WODSODEL   Deletion of Requests from Write-Optimized DSO (classic)

WORKFLOW

Notice that for not all the above mentioned processes the parallelization make sense so not for all of them are the degree of parallelization is possible to set. Actually, the setting itself is done in section called “Settings for Parallel Processing” for those processes that it can be set.

The settings set in this t-code are stored in table RSBATCHPARALLEL - Control Parallel Batch Processes. Maintaining the table itself is coded in FM RSBATCH_MAINTAIN_PAR_SETTINGS.

More information:

2197654 - BW Data Extraction - Important house keeping activity in BW system

How to check what is your SAP system type?

SAP system type is an function of the system in the SAP system group from the point of view of the Transport Organizer.

What is the SAP system type or sometimes referred as SAP system class can be revealed from parameters of SAP system. These parameters itself are normally set via system profile parameters function (t-codes RZ10 / RZ11).

1. transport/systemtype defines if the system belongs from a transport point-of-view to the world of SAP development systems (param value = SAP) or if it is a customer system (value = "CUSTOMER" and it is default value). The parameter is set during installation of the system. The parameter affects the transport behavior of the system (e.g. range of transport request numbers) on the correction system (working in the SAP namespace SSCR, etc.), and on upgrade behavior (keyword modifications).

2. auth/sap_test_system parameter indicates that the SAP system is special test system.  If so value of the param is set to ON.

3. auth/fa_test_system parameter indicates that the SAP system is type of test system marked as final assembly system. If so value is set to ON.

If any of these parameters are present in the SAP system it means that the system is based on ABAP Stack.

As alternative to t-codes RZ10 / RZ11 function module TR_SYS_PARAMS can be used to check of what is value of transport/systemtype among other technical information like System Change Option, SID, Change Option for Client-Dependent Customizing Objects, Change Option for Repository Objects in Logon Client, Client Role, Recording Client for Switch BC Sets.

Report RSPPARAM – display profile parameters

Today - just very quick one related one useful tool. There are transactions available in the system to see what are values of system profile’s parameters. Just to name few:

RZ10                 Maintain Profile Parameters – complex one, you can choose different profiles and 

its version, and you can maintain the parameters here via Extended maintenance radio button

RZ11                 Profile Parameter Maintenance – you can display just one parameter at the same time and change its value

But what to do if I need to see values of several parameters? I do not want to go one by one within TA RZ11… There is nice and handy ABAP report called RSPPARAM. It allows displaying of current settings of the several profile parameters at the same time in one screen. Moreover I can select pattern for name of params using wildcards.

PS: I mentioned this report for first time in this blog at this post: Strange question marks appeared in SAP user interface?