pdrorg outputs the definition information for an unloaded table to the unload data file. During reloading, pdrorg compares the table definition information in the unload data file with that for the table to be reloaded to determine whether reloading is possible.
If the table definitions are the same, the unloaded table can be reloaded. However, whether or not reloading to a different table, transfer of table data to another system, or reloading to a table with a different table definition is possible depends on conditions.
If you are reloading table data to a different table, transferring table data to another system, or reloading table data to a table whose table storage conditions are different from those of the unloaded table, you must specify the following options:
If the unloaded table and the reload table employ the same partitioning method, the utility checks the items listed in Table 8-4 to determine whether or not their storage conditions are different. If their storage conditions are different, whether or not reloading is possible is determined by the criteria shown in Table 8-5 (this is applicable when reloading is to be performed in units of tables or schemas; reloading in units of RDAREAs is not supported at all).
Table 8-4 Storage condition check items when the unloaded table and reload table employ the same partitioning method
Partitioning method | Items checked | |
---|---|---|
Non-partitioning | None | |
Hash partitioning | Hash function | Function name |
Hash type | FIX or flexible | |
Column structure of partitioning key | Defined order | |
Storage RDAREAs | Number of storage RDAREAs, RDAREA IDs, RDAREA names, and server names | |
Key range partitioning | Column structure of partitioning key | Defined order and column IDs |
Start column of partitioning key | Column ID, data type, and defined length | |
Number of partitioning conditions | ||
Partitioning condition | Storage RDAREA IDs and condition values | |
Matrix partitioning | Column structure of partitioning key | Defined order |
Number of partitioning conditions | ||
Number of partitioning condition values | ||
Partitioning key conditions | Number of partitions in key, dimension number, partitioning column ID, data type, defined length, length of condition value, and condition value | |
Hash function | Function name | |
Hash type | FIX or flexible | |
Storage RDAREAs | Number of storage RDAREAs, RDAREA IDs, RDAREA names, and server names |
Table 8-5 Whether or not reloading is possible when storage conditions are different
-g1 | HiRDB conf | Partitioning conditions of unloaded table | Partitioning conditions of table to be reloaded | ||||||
---|---|---|---|---|---|---|---|---|---|
Key range ptn | Hash partitioning | Matrix partitioning | Not partitioned | ||||||
FIX | Flex | Key range and key range | Key range and hash | ||||||
Specified | HiRDB/Single Server | Key range partitioning | Y | Y | Y | Y | Y | Y | |
Hash ptn | FIX | Y | Y | Y | Y | Y | Y | ||
Flex | Y | Y | Y | Y | Y | Y | |||
Matrix ptn | Key range and key range | Y | Y | Y | Y | Y | Y | ||
Key range and hash | Y | Y | Y | Y | Y | Y | |||
Not partitioned | Y | Y | Y | Y | Y | Y | |||
HiRDB/Parallel Server | Key range partitioning | Y | Y | Y | Y | Y | Y | ||
Hash ptn | FIX | Y | Y | Y | Y | Y | Y | ||
Flex | Y | Y | Y | Y | Y | Y | |||
Matrix ptn | Key range and key range | Y | Y | Y | Y | Y | Y | ||
Key range and hash | Y | Y | Y | Y | Y | Y | |||
Not partitioned | Y | Y | Y | Y | Y | Y | |||
Omitted | HiRDB/Single Server | Key range partitioning | Y | Y | Y | Y | Y | Y | |
Hash ptn | FIX | N | Y | Y | Y | Y | Y | ||
Flex | N | Y | Y | Y | Y | Y | |||
Matrix ptn | Key range and key range | Y | Y | Y | Y | Y | Y | ||
Key range and hash | Y | Y | Y | Y | Y | Y | |||
Not partitioned | Y | Y | Y | Y | Y | Y | |||
HiRDB/Parallel Server | Key range partitioning | Y6 | N | Y2, 3 | N | N | Y5 | ||
Hash ptn | FIX | N | N | Y2, 4 | N | N | Y5 | ||
Flex | N | N | Y7 | N | N | Y5 | |||
Matrix ptn | Key range and key range | N | N | Y2, 3 | Y6 | N | Y5 | ||
Key range and hash | N | N | Y2, 3 | N | N | Y5 | |||
Not partitioned | N | N | Y2, 3 | N | N | Y2 |
Change to the table storage conditions | Whether or not reloading is supported | Remarks | ||
---|---|---|---|---|
Partitioning conditions changed | Partitioning conditions added | N | Terminates with an error. | |
Partitioning conditions deleted | ||||
Partitioning key value changed | ||||
Partitioning conditions not changed | Storage RDAREA changed | RDAREA name changed | Y | If the conditions of 2 and 5 are satisfied, the utility stores data in the RDAREA corresponding to the storage RDAREA used during unloading. |
Change made to the server containing the RDAREA | N | Terminates with an error. | ||
Storage RDAREA not changed | Partitioning key component column changed (such as column name and specification order) | N | Terminates with an error. |
Change to the table storage conditions | Whether or not reloading is supported | Remarks | |
---|---|---|---|
Storage RDAREA changed | RDAREA added | Y | If the conditions of 4 and 5 are satisfied, the utility stores data in the RDAREA used during unloading. Data is not stored in the added RDAREA. |
RDAREA deleted | N | Terminates with an error. | |
RDAREA renamed | |||
Change made to the server containing the RDAREA | |||
Storage RDAREA not changed | Hash function changed | Y | If the conditions of 4 and 5 are satisfied, the utility stores data in the RDAREA used during unloading. |
Partitioning key component column changed (such as column name and specification order) |
Reloading is prohibited in the following cases: