Start of Content Area

Function documentation DB Memory Parameters  Locate the document in its SAP Library structure

Use

You can maintain database storage parameters for PSA tables, master data tables, InfoCube fact- and dimension tables, as well as DataStore object tables and error stack tables of the data transfer process (DTP).

Use this setting to determine how the system handles the table when it creates it in the database:

·         Use Data Type to set in which physical database area (tablespace) the system is to create the table. Each data type (master data, transaction data, organization- and Customizing data, and customer data) has its own physical database area, in which all tables assigned to this data type are stored. If selected correctly, your table is automatically assigned to the correct area when it is created in the database.

Recommendation

We recommend you use separate tablespaces for very large tables.

You can find information about creating a new data type in SAP Note 0046272 (Introduce new data type in technical settings).

·         Via Size Category, you can set the amount of space the table is thought to need in the database. Five categories are available in the input help. You can also see here how many data records correspond to each individual category. When creating the table, the system reserves an initial storage space in the database. If the table later requires more storage space, it obtains it as set out in the size category. Correctly setting the size category prevents there being too many small extents (save areas) for a table. It also prevents the wastage of storage space when creating extents that are too large.

You can use the maintenance for storage parameters to better manage databases that support this concept.

You can find additional information about the data type and size category parameters in the ABAP Dictionary table documentation, under Technical Settings.

PSA Table

For PSA tables, you access the database storage parameter maintenance by choosing Goto   Technical Attributes in DataSource maintenance. In dataflow 3.x, you access this setting Extras Maintain DB-Storage Parameters in the menu of the transfer rule maintenance.

You can also assign storage parameters for a PSA table already in the system. However, this has no effect on the existing table. If the system generates a new PSA version (a new PSA table) due to changes to the DataSource, this is created in the data area for the current storage parameters.

InfoObject Tables

For InfoObject tables, you can find the maintenance of database storage parameters under Extras Maintain DB Storage Parameters in the InfoObject maintenance menu.

InfoCube/Aggregate Fact and Dimension Tables

For fact and dimension tables, you can find the maintenance of database storage parameters under Extras DB Performance   Maintain DB Storage Parameters in the InfoCube maintenance menu.

DataStore Object Tables (Activation Queue and Table for Active Data)

For tables of the DataStore object, you can find the maintenance of database storage parameters under Extras DB Performance   Maintain DB Storage Parameters in the DataStore object maintenance menu.

DTP Error Stack Tables

You can find the maintenance transaction for the database memory parameters for error stack tables by choosing Extras  Settings for Error Stack in the DTP maintenance.

 

 

End of Content Area