Skip to end of metadata
Go to start of metadata

In order to understand the infrastructure of the Data Volume Management Extractors the following table provides an overview about the meaning and purpose of the extractors.

In general, All the extractors use the READ RFC. The exceptions being the DVM Analyses Scheduler (Saving Potential), this uses the TMW RFC as it has to schedule the extractors in the target system(s) and the Extractor for Top Objects which requires no RFC as it only reads the data from the 0SM_SIZES cube and places it in the 0SM_TOPTI cube.

Extractor Name

Purpose

Frequency

Extraction Volume

Data Growth*

Data Target

DVM DB OBJECT SIZES

(replaced by DVM Size Statistics Extractor (DBCON) from SP09)

Extraction of DB statistics (sizes, entries) for tables and indexes

Used by all Dashboard Groups (besides Archiving Information)

weekly (as of SP5 it is fixed on Monday morning)

One record for each table and index available in SAP dictionary. Either this extractor or DVM Size Statistics Extractor (DBCON) should be active at any one time. But not both.

medium

0SM_SIZES (InfoCube)

 DVM Size Statistics Extractor (DBCON).

Extraction of DB statistics (sizes, entries) for tables and indexes (Available as of SP9) using the so called native DB connection (same as DBACockpit). If this is not available then the old extractor is used.

Used by all Dashboard Groups (besides Archiving Information)

weekly

One record for each table and index available in SAP dictionary. Either this extractor or DVM DB OBJECT SIZES should be active at any one time. But not both.

medium

0SM_SIZES (InfoCube)

DVM SAVING POTENTIAL

Extraction of Saving Potential Analysis results and histogram data from target system

Dashboard Group: Saving Potential

hourly

One record for each result set of a saving potential analysis and histogram set

low - medium (depends on configuration of the relevant scenarios and scheduled analyses)

0SM_DVPOT (InfoCube)

DVM ARCHIVING RUNS

Extraction of Archiving Job information

Dashboard Group: Archiving Information

hourly

One record for each executed archiving run within the last 60 min.

low (depends on archiving frequency)

0SM_ARCHJ (InfoCube)

DVM ARCHIVING STATISTICS

Extraction of Archive File statistics (details on archived, deleted objects and related file sizes)

Dashboard Group: Archiving Information

hourly

One record for each archive file created within the last 60 min.

low (depends on archiving frequency)

0SM_ARCHH (InfoCube)

DVM ARCHIVING OBJECT (DESCRIPTION)

Master Data Loader for descriptions of Archiving Objects (SAP + custom)

weekly

One record for each archiving object in the managed system

no data growth besides the initial load for each system (data is overwritten)

 0SM_AOBJ
DVM Analyses Scheduler (Saving Potential)Extractor to check and trigger the table analysis job (e.g. based on TAANA) in the managed system15 minNone in Solution Manager. Only TAANA result in the managed system, if you set the mode to KEEP_ONE, then it will only keep the latest TAANA result  
DVM Classification Data Extractor

Extraction of Table classification information, such as application area, document type etc

Used by all Dashboard Groups

dailyOne record for each table and index available in SAP dictionarymediumAGSDVM_CLASSREPO (DB Table)
DVM TABLE MASTER DATA (DESCRIPTION)

Extraction of table name and description as attribute

Used by all Dashboard Groups

dailyOne record for each table and index available in SAP dictionarylow 0SM_TABNM
DVM Table Call Statistics

Extraction of table call statistics of all the tables in SAP dictionary, based on ST10

Dashboard Group: Table Call Statistics

dailyOne record for each table and index available in SAP dictionarymedium0SM_STAT (InfoCube)
DVM ARCHIVE STORAGE (DESCRIPTION)

Extract description text of Status of archive in storage as attribute

Dashboard Group: Archiving Information

weeklyless than 10low 0SM_STOPT
DVM ARCHIVE FILE STATUS (DESCRIPTION)

Extract description text of Status of an individual archive file of an archive session

Dashboard Group: Archiving Information

weeklyless than 10low 0SM_STFIL

Extractor for Top Objects (AGS_DVM_TOPOBJ_EXTRACT_NEW)

Only found in the Solution Manager system. Therefore no SOURCERFCDEST is required in table E2E_ACTIVE_WLI

Extract top 30 tables and top 30 document types (including related tables) from each request of DVM Object Sizes infocube (0SM_SIZES) and place aggregated results in cube 0SM_TOPTI. Used by Data Allocation Statistics - Tables (Top) dashboard which contains a long term history of only the biggest objects in your system landscape.

Dashboard Group: Table Statistics (View: Tables (TOP))

 hourly

depending on the document types (roughly about 100 - 2000 records on average)

 low

0SM_TOPTI (InfoCube)

 

iCI DVM Extractor( E2E_ICIDB_EXT_DVM )

For each defined KPI, calculate the KPI value. The KPI value will be written to the iCI cube, and will be visible on the DVM iCI dashboard.  

NB: only runs locally on the Solution Manager system. Therefore there is no load on the managed system and very little (if any load) on SolMan.

 once per day

one record for each created KPI

 can be ignored

 0SM_ESRSG

 Object Footprint Extractor

AGS_DVM_BOF_EXTRACT

 

Read the BOF results from data base tables on remote managed system

Dashboard Group:  Statistics & Trend – Business Object Footprint

 Hourly

 

 

 0SM_BOF

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

* Data growth is related to the growth rate in the SAP Solution Manager related infrastructure for DVM (without considering activated housekeeping)

Some extractors have become obsolete and have either been replaced by new extractors or the functionality they supported is no longer required or has been integrated with existing functionality. These extractors are usually deleted by executing the related activity (Adjust Extractor Settings) in the SOLMAN_SETUP steps for the DVM topic. For a non-exhaustive list you can check the troubleshooting section here.

  • No labels