The systabamdata system catalog table stores the table-specific hashing parameters of tables that were created with a primary access method.
The systabamdata table has the following columns.
| Column | Type | Explanation | |
|---|---|---|---|
| tabid | INTEGER | Identifying code of the table | |
| am_param | CHAR(256) | Access method parameter choices | |
| am_space | VARCHAR(128) | Name of the storage space holding the data values | |
The am_param column stores configuration parameters that determine how a primary access method accesses a given table. Each configuration parameter in the am_param list has the format keyword=value or keyword.
The am_space column specifies the location of the table. It might reside in a cooked file, a different database, or an sbspace within the database server.
The tabid column is the primary key to the systables table. This column is indexed and must contain unique values.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]