12.1.1 Migrating a table to another HiRDB system

Organization of this subsection
(1) Limitations
(2) Information to be migrated
(3) Notes on RDAREAs (Important)
(4) Migration procedure

(1) Limitations

(2) Information to be migrated

The following information is migrated:

(a) Procedure for migrating table definition information

The dictionary import/export utility (pdexp command) is used to migrate table definition information in dictionary tables currently in use to another HiRDB system. The following table definition information is subject to migration:

Figure 12-1 shows the procedure for migrating table definition information with the dictionary import/export utility.

Figure 12-1 Migration of table definition information with the dictionary import/export utility

[Figure]

(b) Procedure for migrating table data

The database reorganization utility (pdrorg command) is used to migrate table data that is currently in use to another HiRDB system. Figure 12-2 shows the procedure for migrating table data with the database reorganization utility.

Figure 12-2 Migration of table data with the database reorganization utility

[Figure]

(3) Notes on RDAREAs (Important)

  1. Before table definition information is migrated, RDAREAs with the same names as in the source system must be created in the target system.
  2. If there are differences between the migration source system and the migration target system in the names of the RDAREAs for storing the table to be migrated or in the configurations of the servers for storing the RDAREAs, the -g option must be specified when the database reorganization utility (pdrorg command) is executed. Figure 12-3 shows an example of system configurations for which the -g option must be specified.

    Figure 12-3 Example of system configuration requiring the -g option

    [Figure]

(4) Migration procedure

Figure 12-4 provides an overview of the procedure for migrating a table to another HiRDB system.

Figure 12-4 Procedure for migrating a table to another HiRDB system

[Figure]