The technical settings of a table define how the table will be handled when it is created in the database, that is whether the table will be buffered and whether changes to data records of the table will be logged.
The most important parameters are:
data class defines the physical area of the database (tablespace) in which the table should be created.
Size category: The
size category defines the size of the extents created for the table.
When the table is created in the database, the required information about the memory area to be selected and the extent size is determined from the technical settings.
buffering permission defines whether the table may be buffered.
Buffering type: If the table may be buffered, you must define a buffering type (full, single-record, generic). The
buffering type defines how many table records are loaded into the buffer when a table entry is accessed.
Logging: This parameter defines whether changes to the table entries should be logged. If
logging is switched on, each change to a table record is recorded in a log table.
- Buffering permission: The
The Convert to transparent table flag (
transparent flag) is also displayed for pooled tables or for tables which were converted into transparent tables earlier on with this flag.
Maintaining Technical Settings
Buffering Database Tables