SAP Reports / Programs

RSDB2MAS SAP ABAP Report - DB2-z/OS: Mass Processing







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


Text pool values


Selection Text: A_DEFN =
Selection Text: A_DEFS = YES
Selection Text: A_DEFY =
Selection Text: A_TSPI =
Selection Text: A_TSPM =
Selection Text: A_TSPS = &&TEXT-118&&
Selection Text: F_BUFN =
Selection Text: F_BUFS = &&TEXT-118&&
Selection Text: F_BUFY =
Selection Text: F_DSCN =
Selection Text: F_DSCS = &&TEXT-118&&
Selection Text: F_DSCY =
Selection Text: F_DSXN =
Selection Text: F_DSXS = &&TEXT-118&&
Selection Text: F_DSXY =
Selection Text: F_EMPN =
Selection Text: F_EMPS =
Selection Text: F_EMPY =
Selection Text: F_ISON =
Selection Text: F_ISOS =
Selection Text: F_ISOY =
Selection Text: M_HITS = Maximum number of hits
Selection Text: S = Table
Selection Text: X_GENREP =
Selection Text: X_NEWDB =
Title: DB2-z/OS: Mass Processing
Text Symbol: 126 = and:
Text Symbol: 127 = Reduce number of databases
Text Symbol: 128 = Generate dependent reports after conversion
Text Symbol: 129 = Properties
Text Symbol: 130 = No tables found
Text Symbol: 131 = Growth-partitioned tablespace
Text Symbol: 132 = Located in growth-partitioned tablespace
Text Symbol: 133 = Compression activated for all indexes
Text Symbol: 134 = Create all indexes with COMPRESS YES
Text Symbol: 135 = COMPRESS YES
Text Symbol: 136 = COMPRESS NO
Text Symbol: 137 = Current COMPRESS setting





Text Symbol: 138 = (tables and indexes)
Text Symbol: 139 = (only indexes)
Text Symbol: 125 = Data set exists for one or more indexes
Text Symbol: 015 = Stop
Text Symbol: 016 = Continue
Text Symbol: 017 = Cancel
Text Symbol: 021 = Table
Text Symbol: 022 = Database
Text Symbol: 023 = Tabspace
Text Symbol: 024 = Size
Text Symbol: 026 = Status
Text Symbol: 030 = Do you really want to delete
Text Symbol: 031 = the selected requests?
Text Symbol: 032 = Delete requests
Text Symbol: 033 = Request:
Text Symbol: 040 = Scheduled
Text Symbol: 041 = Running
Text Symbol: 042 = Cancelled
Text Symbol: 043 = Converted
Text Symbol: 044 = Range-partitioned
Text Symbol: 100 = Filter
Text Symbol: 102 = Number of hits:
Text Symbol: 103 = Yes
Text Symbol: 104 = No
Text Symbol: 105 = Empty
Text Symbol: 106 = Tablespace data set exists
Text Symbol: 107 = Buffered by SAP system
Text Symbol: 109 = Isolated in own tablespace
Text Symbol: 110 = Intented action
Text Symbol: 111 = Recreate in:
Text Symbol: 112 = Tablespace of same type
Text Symbol: 113 = Single-table tablespace
Text Symbol: 114 = Multi-table tablespace
Text Symbol: 115 = with:
Text Symbol: 116 = DEFINE NO
Text Symbol: 117 = DEFINE YES
Text Symbol: 118 = *
Text Symbol: 119 = Current DEFINE settings
Text Symbol: 120 = Entered into ICNV





Text Symbol: 121 = Please refer to SAP note 330289 for details on how to use this report!
Text Symbol: 122 = Info
Text Symbol: 123 = is larger than
Text Symbol: 124 = KB and should be converted using ICNV. Do you really want to adjust this table using standard conversion?


INCLUDES used within this REPORT RSDB2MAS

INCLUDE: SDB3FDB2, LBTCHDEF.
INCLUDE: SDB3FDB2, LBTCHDEF.


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:

RSLG_WRITE_SYSLOG_ENTRY call function 'RSLG_WRITE_SYSLOG_ENTRY' exporting data_word1 = t_mass-tabname sl_message_area = 'D4' sl_message_subid = '0' exceptions others = 5.

SUBST_CHECK_CENTRAL_BASIS call function 'SUBST_CHECK_CENTRAL_BASIS' exporting iv_devc = d-low importing ev_incb = flag_bas.

DB2_LOG_DISPLAY call function 'DB2_LOG_DISPLAY' exporting object1 = o-table objtype = sign_tb changing rc = subrc.

DB_STORAGE_CLEAR call function 'DB_STORAGE_CLEAR' exporting dbsys = db2_sys for_table_and_indexes = 'X' tabname = dd_tabname exceptions not_found = 1 db_error = 2 other_error = 3 others = 4.

DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting dbsys = db2_sys tabname = dd_tabname indexname = dd_indexname useflag = 'X' tables storpar = dd_tmp exceptions db_error = 1 other_error = 2 others = 3.

DB_STORAGE_GET call function 'DB_STORAGE_GET' exporting dbsys = db2_sys tabname = dd_tabname indexname = dd_indexname source_hierarchy = sh importing source = src tables storpar = dd_tmp exceptions mapping_error = 1 db_error = 2 uncomplete_parameter = 3 others = 4.

DB_GET_INDEXES call function 'DB_GET_INDEXES' exporting tabname = dd_tabname tables dbindexes = db_index.

POPUP_TO_CONFIRM_STEP call function 'POPUP_TO_CONFIRM_STEP' exporting textline1 = text-030 textline2 = text-031 titel = text-032 importing answer = answer exceptions others = 1.

BP_START_DATE_EDITOR call function 'BP_START_DATE_EDITOR' exporting stdt_dialog = 'Y' stdt_input = sc stdt_opcode = 14 importing stdt_modify_type = flag stdt_output = sc exceptions others = 1.

DD_MASS_REQUESTS_STATE call function 'DD_MASS_REQUESTS_STATE' tables requests = t_mass exceptions others = 1.

DD_DBUT_OBJ_STATE call function 'DD_DBUT_OBJ_STATE' exporting objname = t_mass-tabname objtype = 'TABL' importing request = t_mass-severity jobstate = t_mass-jobstate.

DD_DBUT_REQUEST_DELETE call function 'DD_DBUT_REQUEST_DELETE' exporting objname = dd_table objtype = 'TABL' exceptions nothing_to_delete = 1 abort_function = 2 delete_failed = 3 delete_not_provide = 4 others = 5.

DD_TABL_CNV_LOCK call function 'DD_TABL_CNV_LOCK' exporting tabname = dd_table exceptions lock_refused = 1 op_failure = 2 object_locked = 3 illegal_execmode = 4 activation_not_successfull = 5 cannot_check_dbms = 6 old_dbms_version = 7 others = 8.

DD_MASS_REQUESTS_INSERT call function 'DD_MASS_REQUESTS_INSERT' exporting objname = tbatg-tabname objtype = 'TABL' fct = 'CFR' success_mess_type = space modeflag = 'B' importing subrc = subrc exceptions unexpected_error = 1 others = 2.

DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting tabname = x_tabname importing x030l_wa = w_x030l tables x031l_tab = t_x031l exceptions not_found = 1 no_fields = 2 others = 3.

POPUP_TO_CONFIRM



call function 'POPUP_TO_CONFIRM' exporting titlebar = title text_question = txt text_button_1 = b1_txt icon_button_1 = b1_icon text_button_2 = b2_txt icon_button_2 = b2_icon default_button = b_def display_cancel_button = b3_canc popup_type = type importing answer = reply.

BP_JOB_SELECT call function 'BP_JOB_SELECT' exporting jobselect_dialog = btc_no jobsel_param_in = job_sel enddate = '99990101' importing jobsel_param_out = job_sel tables jobselect_joblist = jobs exceptions others = 1.

BP_JOBLIST_PROCESSOR_SM37B call function 'BP_JOBLIST_PROCESSOR_SM37B' exporting joblist_opcode = btc_joblist_edit tables joblist = jobs exceptions others = 1.

DB2_STORAGE_EDIT call function 'DB2_STORAGE_EDIT' exporting object1 = table objtype = sign_tb.

DD_JOB_CLOSE call function 'DD_JOB_CLOSE' exporting jobname = job_name1 jobcount = job_id startcond = sc success_mess_type = 'I' exceptions others = 1.

BP_START_DATE_EDITOR call function 'BP_START_DATE_EDITOR' exporting stdt_dialog = 'N' stdt_input = sc stdt_opcode = 14 importing stdt_output = sc exceptions others = 1.

JOB_OPEN call function 'JOB_OPEN' exporting jobname = job_name importing jobcount = job_count exceptions others = 1.

DD_JOB_CLOSE call function 'DD_JOB_CLOSE' exporting jobname = job_name jobcount = job_count startcond = sc success_mess_type = space exceptions others = 1.

BP_START_DATE_EDITOR call function 'BP_START_DATE_EDITOR' exporting stdt_dialog = 'N' stdt_input = sc stdt_opcode = 14 importing stdt_output = sc exceptions others = 1.

JOB_OPEN call function 'JOB_OPEN' exporting jobname = job_name importing jobcount = job_count exceptions others = 1.

DD_JOB_CLOSE call function 'DD_JOB_CLOSE' exporting jobname = job_name jobcount = job_count startcond = sc success_mess_type = space exceptions others = 1.



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