SAP Reports / Programs

comments icon Comments

RSDB4DBH SAP ABAP Report - iSeries: Display History of DBMonitor Overview from MONI







RSDB4DBH is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program displays an overview of the available database workload statistics recorded by the memory-based SQL database monitor...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

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


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 RSDB4DBH. "Basic submit
SUBMIT RSDB4DBH AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB4DBH VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: iSeries: Display History of DBMonitor Overview from MONI
Text Symbol: 035 = Statistics data for week beginning
Text Symbol: 036 = :
Text Symbol: 037 = Call Statistics
Text Symbol: 038 = Database Performance Statistics
Text Symbol: 039 = Statistics data of
Text Symbol: 040 = Not all files exist
Text Symbol: 041 = Delete statistics for week
Text Symbol: 042 = Delete statistics for one week
Text Symbol: 043 = MONI with RELID D4
Text Symbol: 044 = RSDB4DBH: GET_STATISTIC stoppend on error
Text Symbol: 045 = Average
Text Symbol: 046 = ExecTime(ms)
Text Symbol: 047 = For
Text Symbol: 048 = No.tables
Text Symbol: C25 = Last successful dump
Text Symbol: C26 = Last successful merge
Text Symbol: C27 = Last time merge started
Text Symbol: C28 = Last time merge skipped
Text Symbol: C29 = Oldest data from
Text Symbol: C30 = DB2/400 database monitor information:
Text Symbol: C31 = Database start
Text Symbol: C32 = Last reset
Text Symbol: C33 = Total database processing time (s)
Text Symbol: C34 = Last merge of database monitor tables
Text Symbol: T01 = DB2/400 Database Monitor History
Text Symbol: T02 = DB2/400 Database Monitor History Detail
Text Symbol: Y01 = ERROR in generating fieldcatalog
Text Symbol: Y02 = Table/structure does not exist.
Text Symbol: 003 = Summary:
Text Symbol: 004 = Timestamp
Text Symbol: 005 = User Calls
Text Symbol: 006 = COMMITs
Text Symbol: 007 = ROLLBACKs
Text Symbol: 008 = SELECTs
Text Symbol: 009 = INSERTs
Text Symbol: 010 = Checking existence of DBMon outfiles in R3QTEMP ...
Text Symbol: 012 = UPDATEs





Text Symbol: 013 = DELETEs
Text Symbol: 014 = DDL Stmts
Text Symbol: 015 = Others
Text Symbol: 016 = Date
Text Symbol: 017 = Table Scan
Text Symbol: 018 = Sorts
Text Symbol: 019 = Index Creates
Text Symbol: 020 = Temporary Files
Text Symbol: 021 = Indexes Advised
Text Symbol: 023 = Count
Text Symbol: 024 = Total Rows
Text Symbol: 025 = Tot.Time(s)
Text Symbol: 026 = Summary:
Text Symbol: 028 = Statistics data available
Text Symbol: 029 = from current week:
Text Symbol: 030 = from
Text Symbol: 031 = to
Text Symbol: 032 = from previous weeks:
Text Symbol: 033 = Number of dumps
Text Symbol: 034 = Weekly data


INCLUDES used within this REPORT RSDB4DBH

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:

POPUP_TO_CONFIRM_LOSS_OF_DATA
      CALL FUNCTION 'POPUP_TO_CONFIRM_LOSS_OF_DATA'
           EXPORTING
                TEXTLINE1 = 'Delete statistics for week'(041)
                TEXTLINE2 = SQHIST_WEEK_DATE
                TITEL     = 'Delete statistics for one week'(042)
           IMPORTING
                ANSWER    = I_ANSWER
           EXCEPTIONS
                OTHERS    = 1 . "#EC FB_OLDED

ENQUEUE_E_SAPWL_WL
  CALL FUNCTION 'ENQUEUE_E_SAPWL_WL'
       EXPORTING
            MODE_MONI      = 'E'
            RELID          = 'D4'
            SRTFD          = I_SRTFD
       EXCEPTIONS
            FOREIGN_LOCK   = 1
            SYSTEM_FAILURE = 2
            OTHERS         = 3.

DEQUEUE_E_SAPWL_WL
  CALL FUNCTION 'DEQUEUE_E_SAPWL_WL'
       EXPORTING
            MODE_MONI = 'E'
            RELID     = 'D4'
            SRTFD     = I_SRTFD.


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 RSDB4DBH or its description.


   
 

RSDB4DBH - iSeries: Display History of DBMonitor Overview from MONI
RSDB4DBH - iSeries: Display History of DBMonitor Overview from MONI
RSDB4DBA - ORACLE-Dependent FORMs for SAPDBA
RSDB4DBA - ORACLE-Dependent FORMs for SAPDBA
RSDB4BFT - Filter Backup Data into MONI, used in DB12
RSDB4BFT - Filter Backup Data into MONI, used in DB12