Ansicht
Dokumentation

rsdb/staton - Activate Extended Table Statistics

------------------------------------------------------------------------

|  rsdb/staton:  Activate Extended Table Statistics                    |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Activates extended table access statistics (call statistics) in      |

| the performance monitor.  The extended table access statistics       |

| (call statistics) let you monitor the following, by table:           |

| the requests passed by SAP applications to the SAP data base         |

| interface; and the resulting data base calls issued by the data      |

| base interface to the data base system.  Together with the           |

| Setup/Buffer statistics, the extended table statistics are useful    |

| for tuning the SAP table buffers (partial and complete table         |

| buffer).  You should run your system with call statistics            |

| activated if you wish to make use of SAP's Early Watch Program       |

| for obtaining optimal performance from your system.                  |

| Shared Memory Usage                                                  |

| The extended table statistics are collected in a region of shared    |

| memory but are transferred to the performance monitoring data        |

| base with the ordinary performance monitoring records.  The          |

| amount of shared memory allocated is from the NTAB (number of        |

| entries in table DDNTT) and is static.  No dynamic expansion of      |

| the statistics structure is needed.  The statistics in the shared    |

| memory region are deleted if the SAP System in which they are        |

| being collected is restarted. You should therefore transfer the      |

| statistics to the performance monitoring data base before            |

| restarting the application server(s) in which the statistics are     |

| active.                                                              |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Use:  Tuning (collection of statistics)                              |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Who may change:  Customers.                                          |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Valid under the following operating systems:  All.                   |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Valid under the following database systems:  All.                    |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Dependencies upon other parameters:  None.                           |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Effects upon other parameters:                                       |

| %%rsdb/stattime%%                                                    |

| %%ipc/shm_psize_40%%                                                 |

| %%rsdb/stattime%% :  To include access times in the extended         |

| table statistics, set the parameter shown above as well.             |

------------------------------------------------------------------------



------------------------------------------------------------------------

| Value type/format and range:  Acceptable values:                     |

| 1:  Activate extended table access statistics (call statistics).     |

| 0:  Deactivate collection of statistics.                             |

------------------------------------------------------------------------





------------------------------------------------------------------------ 

| Short Description : Activate Extended Table Statistics 

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Applications Area : Database 

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Parameter Type : B 

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Changes allowed : E 

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Valid for Operating System : * 

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Dynamic switchable :  

------------------------------------------------------------------------ 



------------------------------------------------------------------------ 

| Same on all Servers :  

------------------------------------------------------------------------