Nonstop Database, HiRDB Version 9 System Operation Guide
This method uses the database reorganization utility (pdrorg command) and the database load utility (pdload command) to migrate the table definition information and table data of the table that is currently in use to another HiRDB system. The following figure shows how the database reorganization utility and the database load utility are used to migrate table definition information and table data.
Figure 12-2 Using the database reorganization utility and the database load utility to migrate table definition information and table data
In the source system, use the database reorganization utility to output the definition information and table data, reverse-generated from the dictionary table, to an unload file for table migration. This operation is called an export. The operation of using the database load utility in the target system to define a table, using the unload file for table migration as input and storing the table data, is called an import. When the table is being migrated to a system that has a different endian format, the endian format is converted during import.
The following figure provides an overview of the procedure for migrating table definition information and table data to another HiRDB system.
Figure 12-3 Procedure for migrating table definition information and table data to another HiRDB system
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.