11.4.1 Defining a multi-chunk table
To define a multi-chunk table, execute the CREATE TABLE statement in which chunk specification is specified.
Note that the contents of chunk specification differs between regular multi-chunk tables and archivable multi-chunk tables.
- When defining a regular multi-chunk table
-
Of chunk-specification, specify CHUNK=maximum-number-of-chunks only.
- When defining an archivable multi-chunk table
-
Specify the following:
-
CHUNK=maximum-number-of-chunks
-
chunk-archive-specification
-
For an example definition of multi-chunk table, see Example in Specification format and rules for the CREATE TABLE statement in the manual HADB SQL Reference.
Before you define an archivable multi-chunk table, you need to create an archive directory. Note the following when you operate on archive directories.
▪ Notes on archive directories
-
Do not delete archive directories that are being used. If you delete an archive directory being used, database compatibility is lost, and operations of the HADB server cannot be guaranteed.
-
Do not update or delete any files stored under an archive directory. If you update or delete such files, operations of the HADB server cannot be guaranteed.
-
Do not create directories or store files under an archive directory. If you do so, relevant directories and files might be deleted when an operation on an archivable multi-chunk table is performed.