Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

dbs/db6/statistics_restore - Decision what kind of DB statistics data to restore for DB2 (for AIX)

dbs/db6/statistics_restore - Decision what kind of DB statistics data to restore for DB2 (for AIX)

CPI1466 during Backup   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/db6/statistics_restore |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Decision what kind of DB statistics data to rest |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
|For DB2 for AIX, updates of the database statistics during table |
|conversion are controlled through parameter |
|dbs/db6/statistics_restore. |
|The default value for the parameter is 'tci'. |
| 't' stands for tables, 'c' for columns and 'i' for indexes |
| If the parameter is set to TCI, the statistics of the object set by |
| the value are updated when the tables or indexes are |
| converted. |
|Examples : tci : Statistics for tables, columns, and indexes |
| tc : Statistics for tables und columns |
| ti : Statistics for tables und indexes |
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
Online / background conversions, upgrade
------------------------------------------------------------------------
| Unit : |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: |
------------------------------------------------------------------------
tci
------------------------------------------------------------------------
| Who is permitted to make changes: |
------------------------------------------------------------------------
SAP or customer as directed by SAP
------------------------------------------------------------------------
| Limitations for operating systems: |
------------------------------------------------------------------------
-
------------------------------------------------------------------------
| Limitations for database systems: |
------------------------------------------------------------------------
DB2 only (for AIX)
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
------------------------------------------------------------------------
Related : dbs/db6/statistics_store
dbs/db6/statistics_restore is only activated in the system, if
dbs/db6/statistics_store was active previously:
Only the statistics data that the activeness of
dbs/db6/statistics_store can save, can be restored.
See dbs/db6/statistics_store
------------------------------------------------------------------------
| Valid Input, Formats, Areas: |
------------------------------------------------------------------------
't', 'c', 'i' are interpreted as information.
Other characters are ignored.
Maximum length that can be interpreted: 3

------------------------------------------------------------------------
| Short Description : Decision what kind of DB statistics data to restore for DB2 (for AIX)
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : S
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : W
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------


PERFORM Short Reference   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 5489 Date: 20211202 Time: 014456     sap01-206 ( 5 ms )