| DBOBJ |
Name of Database Object |
AM_DBOBJ |
|
CHAR |
|
30 |
0 |
|
| DOTYP |
Type of Database Object |
AM_DOTYP |
|
CHAR |
|
2 |
0 |
Possible values
| 01 |
Table |
| 02 |
Tablespace |
| 03 |
Indexspace |
| 04 |
Table Partition |
| 05 |
Index Partition |
| AA |
Fixed Statistics |
|
| OBJOW |
Owner of the Database Object |
AM_DBOWN |
|
CHAR |
|
30 |
0 |
|
| DBTYP |
Database |
DBSYSTEM |
|
CHAR |
|
10 |
0 |
Possible values
| SAP DB |
SAP DB |
| DB6 |
DB2 UDB |
| INFORMIX |
INFORMIX |
| ORACLE |
Oracle |
| DB2 |
DB2/CS |
| DB400 |
DB2/400 |
| MSSQL |
Microsoft SQL Server |
| HDB |
SAP In-Memory Computing Engine |
| SYBASE |
Sybase ASE |
|
| VWTYP |
Type of Usage of Table Entry |
AM_VWTYP |
|
CHAR |
|
2 |
0 |
Possible values
| A |
Application table monitor (also possibly with DB optimizer) |
| O |
Only for optimizer (STANDARD) |
|
| ACTIV |
Control Flag for Update of Statistics |
AM_ACTVE |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Active (automatic check and possible analysis) (default) |
| I |
Ignore (no automatic check) |
| N |
Negative (statistics deleted) |
| U |
Forced (automatic check with analysis) |
| R |
Restrictive (negative - Changes can only be made by SAP) |
| P |
Priority (as "Active", but executed first) |
|
| OBJEC |
Identification of EDM cluster |
UDCLUID |
|
CHAR |
|
10 |
0 |
|
| AEDAT |
Change/Insert Date in Control Table |
AM_AENDDAT |
|
DATS |
|
8 |
0 |
|
| SIGNI |
Significance for Collection of Statistics |
AM_SIGNI |
|
INT1 |
|
3 |
0 |
Possible values
| 1 |
INFORMIX: HIGH for all index columns |
| 2 |
INFORMIX: HIGH for leading, MEDIUM for other index columns |
|
| AMETH |
Analysis Method for Collecting Statistics |
AM_AMETH |
|
CHAR |
|
4 |
0 |
Possible values
| E |
Estimate Statistics (Standard) |
| EH |
Estimate Statistics and Generate Histograms |
| EI |
Estimate Statistics and Evaluate Structure of Indexes |
| EX |
Estimate Statistics/Generate Histograms/Evaluate Structure |
| C |
Create Exact Statistics |
| CH |
Create Exact Statistics and Generate Histograms |
| CI |
Create Exact Statistics and Evaluate Structure of Indexes |
| CX |
Create Exact Statistics/Generate Histograms/Eval. Structure |
| A |
Estimate Statistics with Auto Sample Size |
| AH |
Generate Statistics with Auto Sample Size and Histograms |
| AI |
Statistics with Auto Sample + Structure Eval. of Indexes |
| AX |
Statistics with Auto Sample + Histograms + Structure Eval. |
| DB6B |
DB2/UDB: Statistics Basis for Tables and Indexes (Standard) |
| DB6T |
DB2/UDB: Basis Statistics for Tables |
| DB6I |
DB2/UDB: Basis Statistics for Indexes |
| DB6A |
DB2/UDB: Distribution Frequency for Tables and Indexes |
| DB6D |
DB2/UDB: Distribution Frequency for Tables |
| DB6X |
DB2/UDB: Distribution Frequency for Indexes |
| DB6E |
DB2/UDB: Distribution Frequency: Tables, Basis for Indexes |
| DB6Y |
DB2/UDB: Basis for Tables, Distribution Frequency Indexes |
|
| OPTIO |
Sample Size for Collection of Statistics |
AM_OPTIO |
|
CHAR |
|
5 |
0 |
|
| TOBDO |
TODO Flag: Create New Statistics |
AM_TOBDO |
|
CHAR |
|
1 |
0 |
Possible values
| X |
New analysis required |
| NULL |
No new analysis required |
|
| HISTO |
HISTORY Flag: With History |
AM_HISTO |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Track history of creation of statistics |
| NULL |
Do not track history of creation of statistics (STANDARD) |
|
| TDDAT |
Date on Which the ToDo Flag Was Set |
AM_TDDAT |
|
DATS |
|
8 |
0 |
|
| DURAT |
Estimated runtime of table analysis |
AM_DURAT |
|
TIMS |
|
6 |
0 |
|
| PLAND |
Customer Flag: Customer Setting |
AM_PLAND |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Default parameters cannot be overwritten |
| NULL |
Default parameters can be overwritten (STANDARD) |
|
