/
(BWFT-1811) Set Up and Install

(BWFT-1811) Set Up and Install

Nov 29, 2018

This guide walks you through the complete process of setting up, running and displaying the results of Datavard's BW FitnessTest. 

As from the version 1808, Datavard's BW FitnessTest has been transformed to an add-on to Datavard Insights.

Contents

Installation

Steps to install the transport requests:

  1. Copy the installation files into a transport directory. Normally, the 'cofiles' should be copied into /usr/sap/trans/cofiles and the 'data' should be copied into /usr/sap/trans/data.

  2. Add the transports to the Import Queue using the menu in STMS (Extras > Other Request > Add).

  3. Import the transports in the order, which is described in the transports.txt file. You received this file in the zipped folder from your Datavard consultant.

  4. User executing BW Fitness test should have this role assigned - /DVD/BWFT. It is part of the given transport.

Supported BW versions: 7.00 – 7.51 with up-to-date SPs
Supported database systems:

  • MaxDB

  • MSSQL

  • DB2

  • DB4

  • DB6

  • HANA

  • Oracle

  • Sybase ASE

  • Informix

Prerequisites to run BWFT successfully

DB statistics should be up to date

  • Details: In order to get accurate results for most of the BWFT collectors, database table statistics of all tables that are analysed must be up to date. DataVard BWFT analyses sizes and row counts of the database tables used for SAP system from its database statistics. Current and most accurate row count and size of a table cannot be retrieved during the BWFT execution due to performance reasons.

  • Impact: If DB table statistics are not up to date, results don't have to be accurate. Outdated statistics on RS* tables can also cause performance issues during the BWFT execution.

  • Action: Please check with your basis team if DB statistics can be updated short before the BWFT execution. Database statistics can be checked in DB20 transaction.

Query statistics should be turned ON prior to the BWFT execution

  • Details: DataVard BWFT analyses a query and load performance in a BW system. In order to see runtime of queries executed in the past it is necessary that Query statistics (RSDDSTAT) are turned ON before the BWFT is executed. Our recommended period for the analysis of queries is 6 months, however capturing a month is sufficient. It is required that for analysed objects Query statistics must be turned ON with the setting - OLAP Statistics Detail Level = 2 - All (a system records all data from an area for the front end and calculation layer as well as data from an area for an aggregation layer and aggregation information).

  • Impact: If Query statistics are turned OFF or turned ON only for selected queries this can cause some KPIs cannot be calculated properly. This applies also if query statistics are not turned on with Detail level "2 - All". This impacts only a single KPI of the BWFT - Query Performance. Query Performance KPI is not a showstopper for executing the rest of the BWFT.

  • Action: Please check with your basis administrator or check the setting in a transaction RSDDSTAT.

InfoProvider statistics should be turned ON prior to the BWFT execution

  • Details: DataVard BWFT analyses load performance in a BW system. In order to see details of executed InfoPackages in the past it is necessary that InfoProvider statistics (RSDDSTAT) are turned ON for all InfoProviders before the BWFT is executed (OLAP Detail level is not important here). Our recommended period for the analysis of InfoPackages is 6 months, however capturing a month is sufficient.

  • Impact: If InfoProvider statistics are turned OFF or turned ON only for selected InfoProviders this can cause some KPIs cannot be calculated properly. This impacts only a single KPI of the BWFT - InfoPackage Performance analysis. This KPI is not a showstopper for executing the rest of the BWFT.

  • Action: Please check with your basis administrator or check the setting in a transaction RSDDSTAT.

Steplist

The execution of Datavard's BW FitnesTest consists of the following steps:

Initial settings

Add a system to a Monitoring area

In the first step add the current system to the BW FitnessTests monitoring area. Without completing this step, it's not possible to start the Collector job in Datavard Insights.

  1. In the Datavard Insights program (transaction code DVD/MON) navigate to the menu bar Settings > System settings.

  2. In System settings, highlight the system where BW FitnessTest will be running and click on the Monitoring areas in the left panel.

  3. Click on New entries on the application toolbar and enter the area name "FT".

  4. Press the enter key or the Save icon. In the list of Monitoring areas you should now see the "FT" monitoring profile.

The system  which is going to be analyzed by Datavard's BW FitnessTest is now added to the required monitoring area.

Set up the collection of data in input tables (optional)

This step is optional, as by default BW FitnessTest uses standard values for collecting data (two background jobs and reset period of six months).

However, you have the possibility to customize the collection of data by setting up the input tables, which are in the default case empty. To customize the collection of data through a Collector job in input tables follow these instructions:

  1. Navigate to the top panels Settings > Collector settings.

  2. In Collector settings, choose (highlight) from the list the FitnessTest collector - /DVD/MON_FT_CL_COLL_MAIN, then go to Inputs & rules on the left side of the screen.

  3. Displayed are all input tables for the FitnessTest collector. To modify the collector settings click

    by the following tables.

/DVD/MON_FT_INEW

  • System ID - enter the current system ID (F4)

  • FT Run ID - enter "BWFC_INS"

  • JOB_NUMBER - number of background jobs used for collecting data, maximum value is 1/4 of total background jobs

  • Recommended period value - number of time units specified in the Type field. After the collecting process finishes, Fitnesstest waits after the Recommended period value passes and starts all over again. This period is calculated starting from the Collector job execution.

  • Type - time unit (F4)

  •  Do not change the field Server.

 

/DVD/MON_FT_IN2

In this table you can specify the time difference between the execution of  two scheduler FitnessTest collectors "InfoProviders in three runs (IPR3R)" and "Number range buffer (NR buffer)".

  • KPI name - name of the Fitnesstest collector.

  • Field Name - Each KPI name has two records with the time period parameters - PRDTYPE or PRDVALUE

    • PRDTYPE: period type (in the version 1811 only days (DA) - are supported)

    • PRDVALUE: period value, enter a number of time units

Creating a Collector job

  1. In the Insights transaction /DVD/MON click Create collector job.

  2. Fill the displayed dialog according to the following figure:

    • Definition

      • System ID - ID of the current system (SID). This field is filled automatically. If you want to enter a SID of a remote satellite system, you should make sure that BW FitnessTest was transported to this system.

      • Monitoring profile - enter "BWFT"

    • Execution

      • Change only if the collecting process shouldn't start immediately

    • Period - how often the Collector job runs. Recommended value is set after clicking Predefined values

      • Type - time units

      • Value - number of time units

    • Retention time - time period after which collected data is deleted. Recommended value is set after clicking Predefined values

      .

  3. Select (Re)Start collector job.