Nonstop Database, HiRDB Version 9 System Operation Guide
Before you can change partitioning storage conditions, you must unload data; after you have changed the partitioning storage conditions, you must reload the data. It is important that you check that the original number of items of data before the change matches the number of items of data after the data has been re-registered. The two methods described below are provided for this purpose. If you need a highly accurate check of the number of data items, we recommend that you use the second method.
pddbst -t table-name -s |
RD Area Name : RD002 Server : bes1 Status : Original RD Area Name : RD002 Generation Number : 0 Replica RD Area Count : 0 History1 Hold Status : Hold Code : 0 Hold Time : History2 Hold Status : Hold Code : 0 Hold Time : Job Name : Line Count : Index Method : Unused Segment: 3999 Search Mode : INS Segment Reuse : - segments Reuse Search Failure : 0/ 0 Used(Full) Used( Full) Sum Segment 100%( 0%) 1( 0) 1 Page 30%( 0%) 3( 0) 10 Row Count : 200 RD Area Name : RD004 Server : bes2 Status : Original RD Area Name : RD004 Generation Number : 0 Replica RD Area Count : 0 History1 Hold Status : Hold Code : 0 Hold Time : History2 Hold Status : Hold Code : 0 Hold Time : Job Name : Line Count : Index Method : Unused Segment: 3999 Search Mode : INS Segment Reuse : - segments Reuse Search Failure : 0/ 0 Used(Full) Used( Full) Sum Segment 100%( 0%) 1( 0) 1 Page 20%( 0%) 2( 0) 10 Row Count : 100 |
If the numbers of data items do not match, the following are possible causes and corrective measures:
Possible cause | Corrective measure |
---|---|
When the database load utility was executed to load data, the creation mode was used. You must use the addition mode. | You must use a backup to restore the system, then re-execute the utility. |
Data loading was not executed for the RDAREA into which the data was supposed to be loaded. | Load data from the unload data file into the correct RDAREA. |
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.