SAP Reports / Programs

SAP_SANITY_CHECK_DB4 SAP ABAP Report - Check of System Parameters







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


Text pool values


Title: Check of System Parameters
Text Symbol: 400 = SQL Error Occurred
Text Symbol: 410 = Error in Database Interface; See Developer Trace
Text Symbol: 420 = RSADMIN Parameter Check...
Text Symbol: 450 = Parallel Index Build with SMP- See SAP Note 601110
Text Symbol: 460 = Parameter DB4_PARALLEL_INDEX_BUILD not found
Text Symbol: 470 = Parameter DB4_PARALLEL_INDEX_BUILD =
Text Symbol: 480 = Check Availability of SMP...
Text Symbol: 481 = SMP is installed correctly
Text Symbol: 482 = SMP ist not installed
Text Symbol: 483 = SMP is incorrectly installed
Text Symbol: 484 = Release level does not function with OS
Text Symbol: 485 = More than one SMP release found
Text Symbol: 486 = SMP status could not be returned
Text Symbol: 487 = API_GETPRDINFO: Unexpected Status
Text Symbol: 500 = Check of RSADMIN Parameters for Fact View Use... (SAP Note 825930)
Text Symbol: 501 = Parameter USE_FACTVIEW Not Found
Text Symbol: 502 = Parameter USE_FACTVIEW =
Text Symbol: 505 = Check of RSADMIN Parameters for Condenser... (SAP Note 601109)
Text Symbol: 506 = Parameter RSCDS_USE_OLD Not Found
Text Symbol: 507 = Parameter RSCDS_USE_OLD =
Text Symbol: 508 = Parameter DB4_CONDENSE_MULTIPLE Not Found
Text Symbol: 509 = Parameter DB4_CONDENSE_MULTIPLE =
Text Symbol: 510 = Table Partitioning - See SAP Note #815186
Text Symbol: 511 = PSA Partitioning...
Text Symbol: 512 = Parameter DB4_PSA_PARTITIONING Not Found
Text Symbol: 513 = Parameter DB4_PSA_PARTITIONING =
Text Symbol: 514 = Fact Table Check...
Text Symbol: 515 = Check of RSADMIN Paramaters for Dim. Table Initialization... (SAP Note 425593)
Text Symbol: 516 = Parameter DB4_AUTO_INZPFM Not Found
Text Symbol: 517 = Parameter DB4_AUTO_INZPFM =
Text Symbol: 900 = EVI-Stage-2-Support (SAP Note 501572)
Text Symbol: 920 = Parallel Index Build with SMP (SAP Note 601110)
Text Symbol: 940 = Table Partitioning (SAP Note 815186)
Text Symbol: 999 = Test Selection
Text Symbol: 000 = This program only runs under DB2/400
Text Symbol: 020 = Information About Current Test Run...
Text Symbol: 021 = Instance:





Text Symbol: 022 = Date:
Text Symbol: 023 = Time:
Text Symbol: 024 = Caution
Text Symbol: 025 = Also Check the Other Instances:
Text Symbol: 030 = General Parameters
Text Symbol: 032 = Profile Parameter Not Set:
Text Symbol: 034 = No Records <> *DEFAULT Found
Text Symbol: 100 = EVI Stage 2 Support - See SAP Note 501572
Text Symbol: 110 = Check of Support Package Status...
Text Symbol: 120 = Check of Kernel and Database Interface...
Text Symbol: 130 = Kernel Release is
Text Symbol: 160 = - Use the Downwardly-Compatible Kernel 6.20
Text Symbol: 170 = See SAP Notes 501572 and 502999
Text Symbol: 180 = DW Patch Level is
Text Symbol: 185 = LIB_DBSL Patch Level is
Text Symbol: 190 = Checking Profile Parameters...
Text Symbol: 200 = Profile parameter could not be found:
Text Symbol: 210 = means inactive
Text Symbol: 220 = - See SAP Note 306823
Text Symbol: 230 = Check of Query Option Files
Text Symbol: 240 = This parameter needs to be removed
Text Symbol: 250 = See SAP Note 501572
Text Symbol: 260 = Parameter Not Set:
Text Symbol: 261 = Number of Triggers =
Text Symbol: 270 = Check of Database Indexes for Fact Tables
Text Symbol: 290 = Check of Especially Critical PTFs...
Text Symbol: 300 = DB and OS Release
Text Symbol: 301 = German Operating System V5R1 Found
Text Symbol: 302 = No German Operating System V5R1 Found
Text Symbol: 305 = Check of PTFs Against IBM InfoAPAR...
Text Symbol: 310 = Compare your PTF status with IBM InfoAPAR
Text Symbol: 320 = To do this, see SAP Note 144149


INCLUDES used within this REPORT SAP_SANITY_CHECK_DB4

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:

RPY_EXISTENCE_CHECK_CLAS call function 'RPY_EXISTENCE_CHECK_CLAS' exporting name = 'CL_DB4_ACTION_DIAG_BWSANITY_GP' exceptions not_exist = 1 others = 2.

DB6_CALL_COCKPIT CALL FUNCTION 'DB6_CALL_COCKPIT' EXPORTING ACTION = cl_db4_action=>bwsan_action_gp SYSTEM_ID = sy-sysid SHOW_LAUNCHPAD = 'X'.






DB_DBRELINFO CALL FUNCTION 'DB_DBRELINFO' IMPORTING dbinfo = l_dbinfo.

RSDU_PART_POSSIBLE_DB4 CALL FUNCTION 'RSDU_PART_POSSIBLE_DB4' CHANGING c_part_possible = l_part_possible.

TH_SERVER_LIST CALL FUNCTION 'TH_SERVER_LIST' TABLES list = l_server_list.

TH_SAPREL CALL FUNCTION 'TH_SAPREL' IMPORTING kern_rel = l_kernel_rel kern_dblib = l_db_lib kern_patchlevel = l_kernel_pl.

DB_DBRELINFO * CALL FUNCTION 'DB_DBRELINFO' * IMPORTING * dbinfo = l_dbinfo.

DB_DBSL_PATCHLEVEL CALL FUNCTION 'DB_DBSL_PATCHLEVEL' IMPORTING patchlevel = l_dbsl_pl.

RSD_CUBE_MULTI_GET_ONLY_DB CALL FUNCTION 'RSD_CUBE_MULTI_GET_ONLY_DB' EXPORTING i_read_all = rs_c_true i_objvers = rs_c_objvers-active i_cubetype = rsd_c_cubetype-basic_ic IMPORTING e_t_cube = l_t_cube.

RSDU_INFOCUBE_INDEXES_CHECK CALL FUNCTION 'RSDU_INFOCUBE_INDEXES_CHECK' EXPORTING i_infocube = -infocube i_complete_check = rs_c_true i_with_aggregates = rs_c_true i_double_facttab = l_efacttab_exists IMPORTING e_status = l_status * e_number_check = l_number_check EXCEPTIONS OTHERS = 0.

DB_DBHOST CALL FUNCTION 'DB_DBHOST' IMPORTING dbhost = l_dbhost.

AS4_GET_PTF_STATUS CALL FUNCTION 'AS4_GET_PTF_STATUS' EXPORTING hostname = l_dbhost licpgm = i_licpgm ptf_number = i_ptfnumber IMPORTING ptf_status = e_status ptf_status_txt = e_status_txt.

SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-450.

TH_SAPREL CALL FUNCTION 'TH_SAPREL' IMPORTING kern_rel = l_kernel_rel kern_dblib = l_db_lib kern_patchlevel = l_kernel_pl.

DB_DBRELINFO * CALL FUNCTION 'DB_DBRELINFO' * IMPORTING * dbinfo = l_dbinfo.

DB_DBSL_PATCHLEVEL CALL FUNCTION 'DB_DBSL_PATCHLEVEL' IMPORTING patchlevel = l_dbsl_pl.

SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = text-510.

RSDU_INFOCUBE_PART_CHECK_DB4 CALL FUNCTION 'RSDU_INFOCUBE_PART_CHECK_DB4' EXPORTING I_CUBE = space I_WITH_AGGREGATES = rs_c_true I_MAX_DETLEVEL = '1' CHANGING C_T_MSG = l_t_msg 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 SAP_SANITY_CHECK_DB4 or its description.