You can use the General tab in the Materialized Query Tables editor to specify the physical properties of materialized query tables. Refer to your DB2 database documentation for detailed information on specific DB2 objects and properties.
To specify general physical properties for a materialized query table
The Materialized Query Table editor opens.
Specifies to activate or deactivate the compression of NULL and zero-length data values in the table for all datatypes of BLOB, CLOB, DBLOB, LONG VARCHAR, or LONG VARGRAPHIC.
Specifies whether or not the table row is compressed. Select true or false from the drop-down menu.
Specifies whether action logging is augmented. Valid values: None, Changes, Changes (including long vars).
Indicates that the selected materialized query table has the restriction on drop. Clear the check box to remove the restriction on dropping the table, and the database and table space that contain the table.
Specifies whether or not logging is to be performed while creating, recreating, or reorganizing indexes on this table.
Specifies to avoid logging any insert, update, and delete activity.
Specifies the lock type. Select a value from the drop-down menu: Row, Table, or Block Insert.
Specifies the encoding scheme for string data stored in the table. Valid Values: ASCII, UNICODE.
Indicates the security policy to associate with the materialized query table. Select a security policy from the drop-down list.
Specifies that index access should be used on this table wherever possible for SQL operations. Clear the check box to specify NOT VOLATILE.
Specifies that append processing is used for the selected table. Clear the check box to indicate APPEND NO.
Specifies the audit policy for the selected table. Create or select from the drop-down list.
Indicates what percentage of each page to leave as free space when the table is loaded or reorganized. Enter an integer in the text box.
Your changes are saved and the Materialized Query Tables dialog closes.
Note: Click Cancel to close the dialog without saving your changes.
Copyright © 2013 CA.
All rights reserved.
|
|