Creating and modifying cache segments
To create cache segments
Use the CREATE CACHE SEGMENT statement to define the name and size of the segment.
Use the ALTER TABLE ... ADD CACHE SEGMENT statement to assign a table or a data range to the segment.
In addition to assigning entire tables, the data range can be defined using a WHERE clause of the following types:
[WHERE range_specification]
range_specification ::= <column> < <value>
<column> > <value>
<column> = <value>
<column> <> <value>
<column> BETWEEN <value> AND <value>
<column> OLDERTHAN <value> DAYS
<column> OLDERTHAN <value> SECONDS
<column> NEWERTHAN <value> DAYS
<column> NEWERTHAN <value> SECONDS
The OLDERTHAN and NEWERTHAN syntax specifies date and time ranges; the data type of the columns must be DATE or TIMESTAMP.
To change the segment size
1 Use the ALTER TABLE ... SET POOLSIZE statement to set the new segment size.
2 Restart the server to make the change effective immediately. If you do not restart the server, the change is gradual.
To remove cache segments
Use the ALTER TABLE ... DROP CACHE SEGMENT statement to unassign a table from the segment.
Use the DROP CACHE SEGMENT statement to delete the cache segment definition from the database.
Restart the server to make the change effective immediately. If you do not restart the server, the change is gradual.
See also