SAP Reports / Programs
RSDB4003 SAP ABAP Report - File Activity
RSDB4003 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 the file activity in the DB2/400 database...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 RSDB4003 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 RSDB4003. "Basic submit
SUBMIT RSDB4003 AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB4003 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: File Activity
Text Symbol: 029 = TOP 30 - Inserts
Text Symbol: 030 = TOP 30 - Updates
Text Symbol: 031 = TOP 30 - Deletes
Text Symbol: 032 = TOP 30 - Logical reads
Text Symbol: 033 = TOP 30 - Physical reads
Text Symbol: 034 = No data found
Text Symbol: 035 = Statistic values reset at
Text Symbol: 036 = Statistic values since reset at
Text Symbol: 037 = Statistics of Physical Accesses on DB2/400 Database
Text Symbol: 050 = RSDB4003 is only valid for
Text Symbol: 051 = Database System DB2/400
Text Symbol: 052 = Display data or perform new analysis
Text Symbol: 053 = Perform analysis now?
Text Symbol: 054 = New analysis may take a long time
Text Symbol: 055 = Quality (%)
Text Symbol: C25 = Inactive since
Text Symbol: C26 = Active since
Text Symbol: C27 = Last trimmed
Text Symbol: C28 = Oldest data from
Text Symbol: C29 = Last data refresh
Text Symbol: C30 = DB2/400 Database monitor information:
Text Symbol: C31 = Database start
Text Symbol: C32 = Last reset
Text Symbol: C34 = Last analysis
Text Symbol: D01 = Performance monitor data as of
Text Symbol: P04 = file activity
Text Symbol: 001 = File name
Text Symbol: 002 = Reads
Text Symbol: 003 = Physical reads
Text Symbol: 004 = OPENs
Text Symbol: 005 = CLOSEs
Text Symbol: 006 = INSERTs
Text Symbol: 007 = UPDATEs
Text Symbol: 008 = DELETEs
Text Symbol: 009 = Perform new analysis
Text Symbol: 010 = Operation may take a long time!
Text Symbol: 011 = Perform analysis in background now ?
Text Symbol: 012 = RSDB4090
Text Symbol: 013 = HB
Text Symbol: 014 = Requests
Text Symbol: 015 = Physical Accesses on DB2/400 Database
Text Symbol: 016 = Since Database Start
Text Symbol: 017 = Reset
Text Symbol: 018 = Since Reset
Text Symbol: 020 = Opens
Text Symbol: 021 = Closes
Text Symbol: 022 = Inserts
Text Symbol: 023 = Updates
Text Symbol: 024 = Deletes
Text Symbol: 025 = Logical Reads
Text Symbol: 026 = Physical Reads
Text Symbol: 027 = TOP 30 - Opens
Text Symbol: 028 = TOP 30 - Closes
INCLUDES used within this REPORT RSDB4003
INCLUDE RSGRAFDD.
INCLUDE RSDB4MNF.
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:
ST04_DB4_GET_FILE_INFO CALL FUNCTION 'ST04_DB4_GET_FILE_INFO' exporting reset_flag = p_reset_flag dbhost = dbhost schemaname = schemaname TABLES it_filestats = finfo_itab EXCEPTIONS no_data_found = 1 OTHERS = 3.
POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING defaultoption = 'N' titel = 'Perform new analysis'(009) textline1 = 'Operation may take a long time!'(010) textline2 = text-011 cancel_display = ' ' IMPORTING answer = answer.
BP_JOB_SELECT_SM37B CALL FUNCTION 'BP_JOB_SELECT_SM37B' EXPORTING jobselect_dialog = 'N' jobsel_param_in = batch_jobselect TABLES jobselect_joblist_b = batch_joblist EXCEPTIONS invalid_dialog_type = 1 jobname_missing = 2 no_jobs_found = 3 selection_canceled = 4 username_missing = 5 OTHERS = 6.
SIMPLE_BATCH_JOB_SUBMIT CALL FUNCTION 'SIMPLE_BATCH_JOB_SUBMIT' "QWI290496 EXPORTING program = 'RSDB4090'(012) EXCEPTIONS submit_failed = 4.
BP_JOB_SELECT_SM37B CALL FUNCTION 'BP_JOB_SELECT_SM37B' EXPORTING jobselect_dialog = 'N' jobsel_param_in = batch_jobselect TABLES jobselect_joblist_b = batch_joblist EXCEPTIONS invalid_dialog_type = 1 jobname_missing = 2 no_jobs_found = 3 selection_canceled = 4 username_missing = 5 OTHERS = 6.
SIMPLE_BATCH_JOB_SUBMIT CALL FUNCTION 'SIMPLE_BATCH_JOB_SUBMIT' "QWI290496 EXPORTING program = 'RSDB4090'(012) EXCEPTIONS submit_failed = 4.
POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING defaultoption = 'N' titel = 'Perform new analysis'(009) textline1 = 'New analysis may take a long time'(054) textline2 = 'Perform analysis now?'(053) cancel_display = ' ' IMPORTING answer = answer.
BP_JOB_SELECT_SM37B CALL FUNCTION 'BP_JOB_SELECT_SM37B' EXPORTING jobselect_dialog = 'N' jobsel_param_in = batch_jobselect TABLES jobselect_joblist_b = batch_joblist EXCEPTIONS invalid_dialog_type = 1 jobname_missing = 2 no_jobs_found = 3 selection_canceled = 4 username_missing = 5 OTHERS = 6.
SIMPLE_BATCH_JOB_SUBMIT CALL FUNCTION 'SIMPLE_BATCH_JOB_SUBMIT' "QWI290496 EXPORTING program = 'RSDB4090'(012) EXCEPTIONS submit_failed = 4.
CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_interface_check = ' ' i_callback_program = call_back_prog i_callback_pf_status_set = 'SET_PF_STATUS' i_callback_user_command = 'USER_COMMAND' * i_structure_name = 'DBSTATTDB4' is_layout = p_list_layout it_fieldcat = p_field_cat it_excluding = p_status_exclusions * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = ' ' it_events = list_events * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = TABLES t_outtab = p_filestats * EXCEPTIONS * PROGRAM_ERROR = 1 * OTHERS = 2 .
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 RSDB4003 or its description.