Skip to Content

Hi NW admins,

May be you know about the functions of the ST14 which is delivered by ST-A/PI which also includes:

 

  • Transaction ST14 (Application monitor)
  • Report RTCCTOOL (Servicetools Update) 
  • Report RSECNOTE (SAP Security Notes Check)
  • Transaction ST12 (ABAP trace for EarlyWatch/GoingLive)
  • Transaction ST13 (Launchpad for further analysis tools)
  • new SDCC datacollectors for BW APO CRM and databases
  • collectors for E2E change management

 

The ST14 is good to get an overview which area is wasting space and where is potential for optimization:


The collection of this data in ST14 is depending on the result of the database collectors. They are present in DB02 => Space => Additional Functions => Collector Logs


Here you can see the last analysis and if all modules are in an active state. This is prerequisite to use the ST14.


Error analysis

For error analysis you can use table DB02_COLL_LOG
Details in 1482296 – DVM Service: analysed data volume incorrect (Oracle)
Report RSORACUP (connection DEFAULT delete/create) to activate all collectors (oracle).
Details in 1002840 – No data or obsolete data in DB Space Statistic monitor

You also have to check if all entries in table TCOLL ae correct. Normally this is checked by report RTCCTOOL but you can double check it with note 12103.

If you have one of the latest versions of ST-A/PI (01R / 01Q SP2) you have to implement some corrections:
2049530 – Data Collectors corrections ST-A/PI 01R*
1936913 – Data Collectors corrections ST-A/PI 01Q SP02
1843959 – ST14 does not show data for BW analyses

Don’t forget after you implemented a new support package for ST/PI or ST-A/PI to uncomment/recomment analysis coding! Therefor use RTCCTOOL=>Addon&Upgrade assistent=> Procedure after addon implemtation..
You can also execute the report /SSF/SAO_UTILS via transaction SA38 and flag the first option ‘Uncomment/Recomment analyis coding for additional components’.


Customizing

If your ST14 is working and you could collect some results than you my be prefer a other format or you don’t want so much information than you can customize it.

Check the Questions&Answers section in note 69455 – Servicetools for Applications ST-A/PI (ST14, RTCCTOOL, ST12)
Q8: deactivate single ST14 analysis subroutine ?
A8: An ST14 analysis job calls a sequence of analysis subroutines. If one subroutine fails, proceed ad follows: from the short dump get the subroutine name (e.g. AFI_FI_SCAN_T685). Run report /SSA/AXM from SE38. On the selection screen, enter the first 3 letters (e.g. ABW/ABO; check this in your report, the headline in a tree entrie includes the letters) of the subroutine name into parameter P_APPL and execute. In the left section ‘ST14 customizing’ choose ‘Mapping: Assign analy. subroutines to GRPIDs’ and press the button ‘Change’. In the following tablecontrol deselect the ‘Active’ checkbox for analysis subroutine that should be skipped and press ‘Save’.
Then schedule a new analysis from ST14.

 

Quick overview

If you want to have quick overview without scheduling ST14, you can use the DB02 / dbacockpit => space => additional functions => BW Analysis:

With a double click on a row you go into detail view.

The ST14 is pretty good for analyzing BW or SCM systems. To get a quick overview were your space is wasted and what could be optimized.

For me it is the starting point of a deeper analysis, because it is platform and DB independent.


If you have any further questions, don’t hestate to comment the blog or contact me or one of my colleagues at Q-Partners ( info_at_qpcm_dot_de )

 

Best Regards,

Jens Gleichmann

Technology Consultant at Q-Partners (www.qpcm.eu)

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Jitendra Gupta

    Hi Jens,

    This is a really helpful blog. Need your help over a requirement of mine. I need to get the size of objects in BW system to decide priority in archival plan. Can you share exact steps I need to perform to get that and also how can I get it only for DSO and cubes.

    Regards

    Jitendra

    (0) 
    1. Jens Gleichmann Post author

      Hi Jitendra,

      I guess you are a SAP administrator. You can recommend an archival plan, but it depends on the business which object will be archived. So there is no exact recommendation for your request.

      You can see the ST14 report as starting point to get an overview. The priority of the objects depends on needs of your business except the basis tables.

      Therefor you can check out this note. Here you find a collection of BW tables (starting with RS*):

      “16. BW tables: RSBMLOGPAR, RSBMLOGPAR_DTP, RSBMNODES, RSBMONMESS, RSBMONMESS_DTP, RSBMREQ_DTP, RSCRTDONE, RSDELDONE, RSHIEDONE, RSLDTDONE, RSMONFACT, RSMONICTAB, RSMONIPTAB, RSMONMESS, RSMONRQTAB, RSREQDONE, RSRULEDONE, RSSELDONE, RSTCPDONE, RSUICDONE”

      Take care of them and clear them from time to time. For selective archiving you should use DVM.

      Regards,

      Jens

      (0) 
  2. Yannik Böhm

    Hi Jens,

     

    i´m looking in the transaction ST14 right now. Can you say me what is meant with OTHER?

     

    You can fnd this at BW Evaluation / Customizing -> Total Size BW Objects

     

    Regards,

    Yannik

     

    (0) 
    1. Jens Gleichmann Post author

       

      Hi Yannik,

      ‘OTHER’ are basis tables like RSMONMESS or RSDDSTAT*. This tables in sum should not be more than 10-20% of your whole system. This is a good starting point to reduce the size with housekeeping.

       

      Regards,

      Jens

       

      (1) 
      1. Yannik Böhm

        Hi again Jens,

         

        Thanks for your fast reply.

        The point OTHER makes ca. 40% of the Size in our Database.

        Can you give me a Method where i can check this topic a bit closer?

        Like which Tables are so big?

         

        Regards,

        Yannik

        (0) 
        1. Jens Gleichmann Post author

          Hi Yannik,

          yes, just use the ST14 as described for the top DB objects and schedule an analysis run. There you will find what is behind the point ‘OTHER’ (see first screenshot: Top30 Other Tables) and can use housekeeping with TX STC01 or note 2388483 (How-To: Data Management for Technical Tables).

          Regards,

          Jens

           

           

          (1) 

Leave a Reply