SAP Reports / Programs | SAP Business Information Warehouse | Basis System and Installation | BW DB2 for OS/390(BW-SYS-DB-DB2) SAP BW
SAP_ASSIGN_BPOOL_DB2 SAP ABAP Report - SAPASSIGNBPOOLDB2
SAP_ASSIGN_BPOOL_DB2 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_ASSIGN_BPOOL_DB2 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_ASSIGN_BPOOL_DB2. "Basic submit
SUBMIT SAP_ASSIGN_BPOOL_DB2 AND RETURN. "Return to original report after report execution complete
SUBMIT SAP_ASSIGN_BPOOL_DB2 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Text Symbol: 300 = Error Has Occurred; Error Code:
Text Symbol: 220 = All Buffer Pool Assignments Are Correct
Text Symbol: 210 = No Object Matches the Selection Criteria
Text Symbol: 200 = Status Unknown
Text Symbol: 190 = No Action Necessary
Text Symbol: 180 = STOP DATABASE Terminated with Errors
Text Symbol: 170 = START DATABASE Terminated with Errors
Text Symbol: 160 = ALTER BUFFERPOOL Terminated, DB Stopped
Text Symbol: 150 = ALTER BUFFERPOOL Terminated with Errors
Text Symbol: 140 = ALTER BPOOL and DB Restart Completed Successfully
Text Symbol: 130 = ALTER BUFFERPOOL Run Successfully
Text Symbol: 120 = ALTER BUFFERPOOL Possible
Text Symbol: 110 = Change of Page Size; ALTER not possible
Text Symbol: 100 = DB Object Does Not Exist
Text Symbol: 090 = Ouput Correct Buffer Pool Assignments Too
Text Symbol: 080 = Aggregates Too
Text Symbol: 070 = InfoCube
Text Symbol: 060 = Execute STOP/START DATABASE
Text Symbol: 050 = Execute ALTER BUFFERPOOL
Text Symbol: 040 = Simulation
Text Symbol: 030 = Output
Text Symbol: 020 = Objects
Text Symbol: 010 = Execution
INCLUDES used within this REPORT SAP_ASSIGN_BPOOL_DB2
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:
RSD_CUBE_GET call function 'RSD_CUBE_GET' exporting i_infocube = l_infocube i_objvers = rs_c_objvers-active i_bypass_buffer = rs_c_false i_with_atr_nav = rs_c_false importing e_s_cube = l_s_cube e_t_dime = l_t_dime exceptions infocube_not_found = 1 illegal_input = 2 others = 3.
RSD_FACTTAB_GET_FOR_CUBE call function 'RSD_FACTTAB_GET_FOR_CUBE' exporting i_infocube = l_infocube importing e_facttab = l_ffacttab e_comptab = l_efacttab exceptions others = 8.
STU3_EXECUTE_DB2COMMAND call function 'STU3_EXECUTE_DB2COMMAND' exporting fb_db2command = in_tab tables fb_result_tab = out_tab exceptions rs_auth_failure = 1 rs_internal_error = 2 request_to_old = 3 no_buffer_space_in_shm = 4 unvalid_request_id = 5 answer_is_not_yet_available = 6 communication_error = 7 answer_not_possible = 8 communication_buffer_to_small = 9 unknown_error = 10 illegal_parameter = 11 ifi_error = 12 other_exception = 13 others = 14.
RSDU_GET_INDEX_NAME_DB2 call function 'RSDU_GET_INDEX_NAME_DB2' exporting i_tablnm = i_tablnm i_indexnumber = i_prim_idxid importing e_index = g_s_status-idxname e_index_exists = l_exists.
RSDU_GET_INDEX_NAME_DB2 call function 'RSDU_GET_INDEX_NAME_DB2' exporting i_tablnm = i_tablnm i_indexnumber = l_s_dd12v-indexname importing e_index = g_s_status-idxname e_index_exists = l_exists.
STU3_EXECUTE_DB2COMMAND call function 'STU3_EXECUTE_DB2COMMAND' exporting fb_db2command = in_tab tables fb_result_tab = out_tab exceptions rs_auth_failure = 1 rs_internal_error = 2 request_to_old = 3 no_buffer_space_in_shm = 4 unvalid_request_id = 5 answer_is_not_yet_available = 6 communication_error = 7 answer_not_possible = 8 communication_buffer_to_small = 9 unknown_error = 10 illegal_parameter = 11 ifi_error = 12 other_exception = 13 others = 14.
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_ASSIGN_BPOOL_DB2 or its description.
SAP_ASSIGN_BPOOL_DB2 - SAPASSIGNBPOOLDB2 SAP_ASSIGN_BPOOL_DB2 - SAPASSIGNBPOOLDB2 SAP_ANALYZE_ALL_INFOCUBES - Create DB Statistics for all Infocubes SAP_ANALYZE_ALL_INFOCUBES - Create DB Statistics for all Infocubes SAP_AGGREGATES_DEACTIVATE - Deactivating the Aggregates of an InfoCube SAP_AGGREGATES_DEACTIVATE - Deactivating the Aggregates of an InfoCube