SAP Reports / Programs

comments icon Comments

RSDB4UPD SAP ABAP Report - Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon)







RSDB4UPD is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report is used for to merge the current output of the memory-based SQL database monitor into the SAP Database performance tables SQ*_DB4 (parameter del_data = 'N', default) and for deleting old data from the SAP database performance tables SQ*_DB4 (parameter del_data = 'Y' and parameter date specifying what 'old' means)...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 RSDB4UPD 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 RSDB4UPD. "Basic submit
SUBMIT RSDB4UPD AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB4UPD VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon)
Text Symbol: Y02 = Table/structure does not exist.
Text Symbol: Y01 = ERROR in generating fieldcatalog
Text Symbol: C34 = Last merge of database monitor tables
Text Symbol: C33 = Total DB processing time (s)
Text Symbol: C32 = Last reset
Text Symbol: C31 = Database start
Text Symbol: C30 = DB2/400 Database monitor information:
Text Symbol: C29 = Oldest data from
Text Symbol: C28 = Last time DBMon Merge skipped
Text Symbol: C27 = Last time DBmon Merge started
Text Symbol: C26 = Last successful DBmon Merge
Text Symbol: C25 = Last successful DBmon Dump
Text Symbol: 021 = Unicode conversion
Text Symbol: 020 = Could find previous dump timestamp
Text Symbol: 019 = No. of deleted records
Text Symbol: 018 = Table Name
Text Symbol: 017 = Reason Code
Text Symbol: 016 = Could not find previous dump timestamp.
Text Symbol: 015 = RSDB4UPD stopped on error!
Text Symbol: 014 = Dequeue set for E_DB4DBMON.
Text Symbol: 013 = Enqueue set for E_DB4DBMON.
Text Symbol: 012 = Could not find previous dump timestamp.
Text Symbol: 011 = Checking completed successfully.
Text Symbol: 010 = Checking existence of DBMon outfiles in R3QTEMP ...
Text Symbol: 007 = RSDB4UPD stopped due to errors. See previous messages.
Text Symbol: 006 = Merge completed for SAP table
Text Symbol: 005 = Updating
Text Symbol: 004 = Getting the SQL names of indexes ...
Text Symbol: 003 = Getting the SQL names of tables/views ...
Text Symbol: 002 = Getting info from outfile ...
Text Symbol: 001 = Start Merge for SAP table


INCLUDES used within this REPORT RSDB4UPD

INCLUDE RSDB4API.


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:

ENQUEUE_E_DB4DBMON
  call function 'ENQUEUE_E_DB4DBMON'
    exporting
      mode_sq1000_db4 = 'X'
      mode_sqtext_db4 = 'X'
      mode_sqhvar_db4 = 'X'
      mode_sq3000_db4 = 'X'
      mode_sq3001_db4 = 'X'
      mode_sq3002_db4 = 'X'
      mode_sq3003_db4 = 'X'
      mode_sq3004_db4 = 'X'
      mode_sq3007_db4 = 'X'
      mode_sq3008_db4 = 'X'
    exceptions
      foreign_lock    = 1
      system_failure  = 2
      others          = 3.

DEQUEUE_E_DB4DBMON
    call function 'DEQUEUE_E_DB4DBMON'
      exporting
        mode_sq1000_db4 = 'X'
        mode_sqtext_db4 = 'X'
        mode_sqhvar_db4 = 'X'
        mode_sq3000_db4 = 'X'
        mode_sq3001_db4 = 'X'
        mode_sq3002_db4 = 'X'
        mode_sq3003_db4 = 'X'
        mode_sq3004_db4 = 'X'
        mode_sq3007_db4 = 'X'
        mode_sq3008_db4 = 'X'.

DEQUEUE_E_DB4DBMON
  call function 'DEQUEUE_E_DB4DBMON'
    exporting
      mode_sq1000_db4 = 'X'
      mode_sqtext_db4 = 'X'
      mode_sqhvar_db4 = 'X'
      mode_sq3000_db4 = 'X'
      mode_sq3001_db4 = 'X'
      mode_sq3002_db4 = 'X'
      mode_sq3003_db4 = 'X'
      mode_sq3004_db4 = 'X'
      mode_sq3007_db4 = 'X'
      mode_sq3008_db4 = 'X'.

DEQUEUE_E_DB4DBMON
  call function 'DEQUEUE_E_DB4DBMON'
    exporting
      mode_sq1000_db4 = 'X'
      mode_sqtext_db4 = 'X'
      mode_sqhvar_db4 = 'X'
      mode_sq3000_db4 = 'X'
      mode_sq3001_db4 = 'X'
      mode_sq3002_db4 = 'X'
      mode_sq3003_db4 = 'X'
      mode_sq3004_db4 = 'X'
      mode_sq3007_db4 = 'X'
      mode_sq3008_db4 = 'X'.

ENQUEUE_E_DB4DBMON
    call function 'ENQUEUE_E_DB4DBMON'
      exporting
        mode_sq1000_db4 = 'X'
        mode_sqtext_db4 = 'X'
        mode_sqhvar_db4 = 'X'
        mode_sq3000_db4 = 'X'
        mode_sq3001_db4 = 'X'
        mode_sq3002_db4 = 'X'
        mode_sq3003_db4 = 'X'
        mode_sq3004_db4 = 'X'
        mode_sq3007_db4 = 'X'
        mode_sq3008_db4 = 'X'
      exceptions
        foreign_lock    = 1
        system_failure  = 2
        others          = 3.

DEQUEUE_E_DB4DBMON
      call function 'DEQUEUE_E_DB4DBMON'
        exporting
          mode_sq1000_db4 = 'X'
          mode_sqtext_db4 = 'X'
          mode_sqhvar_db4 = 'X'
          mode_sq3000_db4 = 'X'
          mode_sq3001_db4 = 'X'
          mode_sq3002_db4 = 'X'
          mode_sq3003_db4 = 'X'
          mode_sq3004_db4 = 'X'
          mode_sq3007_db4 = 'X'
          mode_sq3008_db4 = 'X'.

DEQUEUE_E_DB4DBMON
    call function 'DEQUEUE_E_DB4DBMON'
      exporting
        mode_sq1000_db4 = 'X'
        mode_sqtext_db4 = 'X'
        mode_sqhvar_db4 = 'X'
        mode_sq3000_db4 = 'X'
        mode_sq3001_db4 = 'X'
        mode_sq3002_db4 = 'X'
        mode_sq3003_db4 = 'X'
        mode_sq3004_db4 = 'X'
        mode_sq3007_db4 = 'X'
        mode_sq3008_db4 = 'X'.

ENQUEUE_E_RSTDBMON
  call function 'ENQUEUE_E_RSTDBMON'
    exporting
      mode_sq1000_rst = 'X'
    exceptions
      foreign_lock    = 1
      system_failure  = 2
      others          = 3.

DEQUEUE_E_RSTDBMON
      call function 'DEQUEUE_E_RSTDBMON'
        exporting
          mode_sq1000_rst = 'X'.

DEQUEUE_E_RSTDBMON
      call function 'DEQUEUE_E_RSTDBMON'
        exporting
          mode_sq1000_rst = 'X'.

DEQUEUE_E_RSTDBMON
    call function 'DEQUEUE_E_RSTDBMON'
      exporting
        mode_sq1000_rst = 'X'.

DEQUEUE_E_RSTDBMON
        call function 'DEQUEUE_E_RSTDBMON'
          exporting
            mode_sq1000_rst = 'X'.

DEQUEUE_E_RSTDBMON
        call function 'DEQUEUE_E_RSTDBMON'
          exporting
            mode_sq1000_rst = 'X'.

DEQUEUE_E_RSTDBMON
  call function 'DEQUEUE_E_RSTDBMON'
    exporting
      mode_sq1000_rst = 'X'.

DEQUEUE_E_DB4DBMON
    call function 'DEQUEUE_E_DB4DBMON'
      exporting
        mode_sq1000_db4 = 'X'
        mode_sqtext_db4 = 'X'
        mode_sqhvar_db4 = 'X'
        mode_sq3000_db4 = 'X'
        mode_sq3001_db4 = 'X'
        mode_sq3002_db4 = 'X'
        mode_sq3003_db4 = 'X'
        mode_sq3004_db4 = 'X'
        mode_sq3007_db4 = 'X'
        mode_sq3008_db4 = 'X'.

SCP_GET_CODEPAGE_KIND
    call function 'SCP_GET_CODEPAGE_KIND'
      importing
        cpkind = l_cpkind.

RSLG_WRITE_SYSLOG_ENTRY
      call function 'RSLG_WRITE_SYSLOG_ENTRY'
        exporting
          data_word1       = 'RSDB4UPD'
          data_word2       = 'Unicode conversion'(021)
          sl_message_area  = 'AU'
          sl_message_subid = 'X'.


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


   
 

RSDB4UPD - Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon)
RSDB4UPD - Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon)
RSDB4TSC - Database Performance: Table Scans
RSDB4TSC - Database Performance: Table Scans
RSDB4TREE - Include RSDB4TREE
RSDB4TMP - iSeries: Template Program for LockMonitor RSDB4LCK