SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | DB2 for z/OS(BC-DB-DB2) SAP BC
RSDB2CLN SAP ABAP Report - DB2/390: Database Objects Cleanup
RSDB2CLN 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 RSDB2CLN 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 RSDB2CLN. "Basic submit
SUBMIT RSDB2CLN AND RETURN. "Return to original report after report execution complete
SUBMIT RSDB2CLN VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: DB2/390: Database Objects Cleanup
Text Symbol: 000 = Search for or drop DB objects not needed
Text Symbol: 001 = Search for or drop empty stogroups
Text Symbol: 002 = No action
Text Symbol: 003 = Search for empty stogroups
Text Symbol: 004 = Drop empty stogroups
Text Symbol: 005 = Search for or drop empty databases
Text Symbol: 006 = No action
Text Symbol: 007 = Search for empty databases
Text Symbol: 008 = Drop empty databases
Text Symbol: 009 = Search for or drop empty tablespaces
Text Symbol: 010 = No action
Text Symbol: 011 = Search for empty tablespaces
Text Symbol: 012 = Drop empty tablespaces
Text Symbol: 013 = Search for or drop tables QCM#PUT______
Text Symbol: 014 = No action
Text Symbol: 015 = Search for tables QCM#PUT______
Text Symbol: 016 = Drop tables QCM#PUT______
Text Symbol: 017 = Include databases SY00*
INCLUDES used within this REPORT RSDB2CLN
INCLUDE: SDB3FDB2, RUTRANDU.
INCLUDE: SDB3FDB2, RUTRANDU.
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:
STRF_SETNAME call function 'STRF_SETNAME' exporting dirtype = gc_acttype filename = gv_protlist subdir = gc_subprot importing file = gv_protfile.
SUBST_WRITE_PROTOCOL call function 'SUBST_WRITE_PROTOCOL' exporting acttype = gc_acttype ifname = gv_protfile importing efname = gv_protfile tables p_tab = gt_prot.
SUBST_APPEND_PROTOCOL call function 'SUBST_APPEND_PROTOCOL' exporting l_level = gc_lev_1 l_msag = gc_msag l_msgnr = gc_msgnr l_severity = sev l_v1 = v1 tables p_tab = gt_prot.
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 RSDB2CLN or its description.
RSDB2CLN - DB2/390: Database Objects Cleanup RSDB2CLN - DB2/390: Database Objects Cleanup RSDB2CKRD - Detail List in Dialog Window RSDB2CKRD - Detail List in Dialog Window RSDB2CKDB - DB2 for OS/390: System Check Parameter Configuration RSDB2CKDB - DB2 for OS/390: System Check Parameter Configuration