The report statement specifies a file to which the processing result of pdrbal is to be output.
report process-results-filename |
<pathname>
Specify the absolute path name of the file to which the processing result is to be output.
This must be the name of a regular file located at the host where pdrbal is executed.
/tmp/REPORT-table-identifier-unique-character-string
The following shows the output format of a pdrbal process results file:
pdrbal VV-RR(Object Option) *** DB REBALANCE *** yyyy-mm-dd HH:MM:SS [1]
------------------------------------------------------------------------
*** Table rebalance processing list ***
Schema name : robinson [2]
Table name : rev_table [3]
Table status : completed [4]
** Moved data information **
[5] [6] [7] [8] [9]
No. Server Table rdarea name Remove row Insert row
1 sds user01 1,000,000 0
2 sds user02 2,000,000 0
3 sds user03 0 3,000,000
Total 3,000,000 3,000,000
[10] [11]
** Rebalance information **
[12] [13] [14] [15]
No. Server Table rdarea name Status
1 sds user01 finished
2 sds user02 finished
3 sds user03
*** Exclusive execute information ***
Start time : 2000-05-05 11:12:13 [16]
End time : 2000-05-05 19:20:21 [17]
pdrbal terminated, return code=0 [18]