SAP ABAP Function Module RSDU_ANALYZE_TABLE_DB2 (Create Statistics for Cost-Based Optimizer for the Specified Tables)
Hierarchy
☛
SAP_BW (Software Component) SAP Business Warehouse
⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390
⤷
RSCOREDB2 (Package) BI Core Porting: DB2-z/OS
SAP_BW (Software Component) SAP Business Warehouse⤷
BW-SYS-DB-DB2 (Application Component) BW DB2 for OS/390⤷
RSCOREDB2 (Package) BI Core Porting: DB2-z/OS
Basic Data
| Function Module | RSDU_ANALYZE_TABLE_DB2 | Create Statistics for Cost-Based Optimizer for the Specified Tables |
| Function Group | RSDU_CORE_UTIL_DB2 | Database-Specific Functions in LEAN |
| Program Name | SAPLRSDU_CORE_UTIL_DB2 | |
| INCLUDE Name | LRSDU_CORE_UTIL_DB2U03 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Changing |
C_PROCESSED | TYPE | RS_BOOL | RS_C_FALSE | Boolean | ||
 Importing |
I_T_TABLNM | TYPE | RSDU_T_TABLNM | Tables to Be Analyzed | |||
| Importing |
I_TABLNM | TYPE | RSD_TABLNM | Table to Be Analyzed | |||
| Importing |
I_PERCENTAGE | TYPE | I | 10 | Percentage for ESTIMATE Clause | ||
| Importing |
I_TEMP_TABLE | TYPE | RS_BOOL | RS_C_FALSE | True = Table is Temporary | ||
| Importing |
I_FORCE_ESTIMATE | TYPE | RS_BOOL | RS_C_FALSE | True = Do not Compute Statistics, If Possible | ||
| Importing |
I_PERCENTAGE_SPECIFIED | TYPE | RS_BOOL | RS_C_FALSE | Percentage Explicitly Specified | ||
| Importing |
I_FORCE_RUNSTATS | TYPE | RS_BOOL | RS_C_FALSE | Always Recalculate Statistics | ||
| Importing |
I_PARTITION | TYPE | I | 0 | Process Only Active for This Partition | ||
| Importing |
I_SIMULATE | TYPE | RS_BOOL | RS_C_FALSE | Do Not Execute RUNSTATS But Display Generated Commands | ||
| Importing |
I_CHECK_MISSING_DISTRIB | TYPE | RS_BOOL | RS_C_TRUE | Check Missing Distributions for Dimensions (Fact Tables) | ||
| Importing |
I_REPORT_YES | TYPE | RS_BOOL | RS_C_FALSE | RUNSTATS Option REPORT YES | ||
| Importing |
I_SHOW_RUNSTATS_PROTOCOL | TYPE | RS_BOOL | RS_C_FALSE | True = Displays sysprint Output of RUNSTATS | ||
| Importing |
I_FORCE_STATISTICS | TYPE | RS_BOOL | RS_C_FALSE | True = User Triggered Statistics | ||
| Importing |
I_CONNECTION | TYPE | DBCON_NAME | 'R/3*' | Logical Name for a Database Connection | ||
| Importing |
I_NUM_PARALLEL_PROC | TYPE | I | 0 | Number of RUNSTATS Running in Parallel | ||
| Importing |
I_T_COLGROUP_SPEC | TYPE | DB2_T_STRING | Table for COLGROUP Statistics | |||
 Exception |
ANALYZE_FAILED | TYPE | ANALYZE Failed | ||||
| Exception |
TABLE_DOES_NOT_EXIST | TYPE | |||||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20110909 |
| SAP Release Created in | 730 |
