SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | DB2 Universal Database for UNIX / NT(BC-DB-DB6) SAP BC

comments icon Comments

RSDB6CSTRACE SAP ABAP Report - Evaluation of DB2 UDB Trace (Cumulative DBSL Trace)







RSDB6CSTRACE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter RSDB6CSTRACE into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

DB6CST_LST - DB6: Analyze Cumulative SQL Trace


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT RSDB6CSTRACE. "Basic submit
SUBMIT RSDB6CSTRACE AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB6CSTRACE VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Evaluation of DB2 UDB Trace (Cumulative DBSL Trace)
Text Symbol: 029 = Statement was executed with DB query degree
Text Symbol: 028 =
Text Symbol: 027 = last statement usage
Text Symbol: 026 = first statement usage
Text Symbol: 025 = Reset Trace Table
Text Symbol: 024 = entries from trace table DB6CSTRACE?
Text Symbol: 023 = Do you want to delete all
Text Symbol: 022 = No rows found in trace table DB6CSTRACE !
Text Symbol: 021 = Reading &1 rows from table DB6CSTRACE...
Text Symbol: 020 = last trace entry
Text Symbol: 019 = first trace entry
Text Symbol: 018 = sorted by
Text Symbol: 017 = Results for
Text Symbol: 016 = SQL statement text
Text Symbol: 015 = table
Text Symbol: 014 = time/stmt
Text Symbol: 013 = count
Text Symbol: 012 = total time
Text Symbol: 011 = Statement was executed with DB optimization level
Text Symbol: 010 = operations
Text Symbol: 009 = Time histogram for
Text Symbol: 008 = Statement was prepared in ABAP source(s):
Text Symbol: 007 = ABAP program
Text Symbol: 006 = Source
Text Symbol: 005 = Line
Text Symbol: 004 = Statement was executed on application server(s):
Text Symbol: 003 = Retrieving application server names from DB6CSTRACE
Text Symbol: 002 = Retrieving ABAP position from DB6CSTRACE
Text Symbol: 001 = Retrieving full statement text from DB6CSTRACE


INCLUDES used within this REPORT RSDB6CSTRACE

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:





No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

DB6_EXPLAIN
   CALL FUNCTION 'DB6_EXPLAIN'
     EXPORTING
     input_statement        = SQL_STMT_STR2
*    NO_DISPLAY       = ' '
*    tables
*    plan             =
          .

POPUP_TO_DECIDE_INFO
      CALL FUNCTION 'POPUP_TO_DECIDE_INFO'
         EXPORTING
           DEFAULTOPTION = 'N'
           TEXTLINE1     = 'Do you want to delete all'(023)
           TEXTLINE2     = 'entries from trace table DB6CSTRACE?'(024)
           TITEL         = 'Reset Trace Table'(025)
*          START_COLUMN  = 25
*          START_ROW     = 6
        IMPORTING
           ANSWER        =  POPUP_ANSWER.

SAPGUI_PROGRESS_INDICATOR
  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
       EXPORTING
            PERCENTAGE = 0
            TEXT       = MSGTEXT.

SAPGUI_PROGRESS_INDICATOR
  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
     EXPORTING
      PERCENTAGE = 0
      TEXT = 'Retrieving application server names from DB6CSTRACE'(003).

SAPGUI_PROGRESS_INDICATOR
  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
     EXPORTING
      PERCENTAGE = 0
      TEXT  = 'Retrieving ABAP position from DB6CSTRACE'(002).

SAPGUI_PROGRESS_INDICATOR
    CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
         EXPORTING
              PERCENTAGE = 0
        TEXT   = 'Retrieving full statement text from DB6CSTRACE'(001).


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.







The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name RSDB6CSTRACE or its description.


   
 

RSDB6CSTRACE - Evaluation of DB2 UDB Trace (Cumulative DBSL Trace)
RSDB6CSTRACE - Evaluation of DB2 UDB Trace (Cumulative DBSL Trace)
RSDB6CALC - DB2 Universal Database: Common formulas for processing CCMS data
RSDB6CALC - DB2 Universal Database: Common formulas for processing CCMS data
RSDB6ALCOMMON - DB6: Common Coding for Alert Data Collectors
RSDB6ALCFG - DB6: Initial Configuration Data for Alert Monitoring Infrastructure