10.3.9 report statement (specification of a process results file)

The report statement specifies a file to which the processing result of pdrbal is to be output.

Criterion
Specify the report statement to create a process results file in a directory other than /tmp on the host where pdrbal is executed.
Rules
  1. When the report statement is omitted, the utility creates a process results file in /tmp on the host where pdrbal is executed.
  2. The contents of the process results file are not guaranteed until pdrbal is terminated.
  3. If pdrbal terminates with return code = 8, the utility may not output the part of the information following Moved data information. If output, the information was obtained after rollback (at the commit point immediately before the occurrence of the error).
Organization of this subsection
(1) Format
(2) Explanation
(3) Name of the process results file created when the report statement is omitted
(4) Output format

(1) Format

report process-results-filename

(2) Explanation

(a) process-results-filename

[Figure]<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.

(3) Name of the process results file created when the report statement is omitted

The utility assigns the following name to a created process results file:

/tmp/REPORT-table-identifier-unique-character-string

For example, if the table name is TABLE1, then the following name is assigned to a created process results file:
/tmp/PEPORT-TABLE1-aaaa00001

(4) Output format

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]

Explanation
  1. Header information for the process results
    VV-RR: Version number
    yyyy-mm-dd HH:MM:SS: Date and time pdrbal was started
  2. Schema name
  3. Table identifier
  4. Table rebalancing status
    completed: Rebalancing completed
    processing: Rebalancing underway
  5. Sequence number of the source or target RDAREA
  6. Name of the server containing the source or target RDAREA
  7. Name of the source or target RDAREA
  8. Number of rows moved (deleted) from the source RDAREA
  9. Number of rows moved (added) to the target RDAREA
  10. Total number of rows moved (deleted) from the source RDAREAs
  11. Total number of rows moved (added) to the target RDAREAs
  12. Sequence number of table storage RDAREA
  13. Name of the server containing the table storage RDAREA
  14. Number of table storage RDAREA
  15. RDAREA rebalancing status
    finished: Rebalancing completed
    processing: Rebalancing underway
    error: Terminated with error
    blank: Added RDAREA
  16. Date and time rebalance operation started
  17. Date and time rebalance operation terminated
  18. pdrbal's return code