8.9.17 report statement (specification of a file to which pdrorg tuning information is output)

The report statement specifies a file to which the tuning information is to be output during the execution of pdrorg.

Criterion
Specify the report statement if you want to output the tuning information.
Rules
  1. You can specify only one report statement.
  2. The system does not output the tuning information unless the report statement is specified.
Organization of this subsection
(1) Format
(2) Explanation
(3) Output format

(1) Format

report file=process-results-filename

(2) Explanation

(a) process-results-filename

[Figure]<pathname>

Specifies the absolute path name of the file to which the tuning information is to be output.

This file must be located at the host where pdrorg is executed.

(3) Output format

(a) Tuning information

pdrorg VV-RR(Object Option) *** DB REORGANIZATION *** 2003-03-31 11:06:07 ...........1

*** statistics report ***

execute time :   0: 1:46 ............................................................2
prepare time :   0: 0: 0 ............................................................3

*** shell/server information ***

name       cpu svrup(first) reciv  wait  sort  send unlod ixunl delet dtlod ixlod unldr
unldw(expnd) unput dtins ...........................................................4
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]-
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
pdrorg       0     0(    0) ***** ***** ***** ***** ***** ***** ***** ***** ***** *****
*****(*****) ***** *****
pdrorgm      8     7(    7)    27 ***** ***** 12.5k ***** ***** ***** ***** *****  248k
124k(*****)     3 *****
bes1        24 *****(*****)    14     0     2 6.24k     6 *****     1    16    57 *****
*****(*****) *****    16
bes2        26 *****(*****)    10     0     2 6.24k     6 *****     1    18    57 *****
*****(*****) *****    19
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]-
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
total       58     7(    7)    51     0     4 25.0k    12 *****     2    34   114  248k
124k(*****)     3    35 ............................................................5

*** buffer information ***

server   maxio minio sumio brreq bwreq bfhit hitrt  read write lrreq lbrht lbrrt lwreq lbwht
lbwrt lread lwrit flush bfupd bfred bfwrt cinsm cafls cafwr cfmax cfavg ldirc ldiuc ldihc
ldird ldiwt lbfshc .................................................................6
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]-
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
bes1         0     0    53 79.9k 44.3k 60.7k 76.1% 6.95k 12.2k     0     0 *****     0     0
*****     0     0 16.5k     0     0     0     0     0     0     0 1.00k 11.4k 11.4k     0
   0 11.4k 10.6k
bes2         0     0    52 79.9k 44.3k 60.8k 76.1% 6.95k 12.2k     0     0 *****     0     0
*****     0     0 16.5k     0     0     0     0     0     0     0 1.00k 11.4k 11.4k     0
   0 11.4k 10.6k
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]-
[Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure] [Figure]
total        0     0   105  160k 88.6k  121k 76.1% 13.9k 24.3k     0     0 *****     0     0
*****     0     0 33.1k     0     0     0     0     0     0     0 1.00k 22.8k 22.8k     0
   0 22.8k 21.3k

pdrorg terminated, return code=0 ...................................................7

Explanation
  1. Header information (version number and pdrorg start time)
  2. pdrorg processing time
  3. pdrorg preprocessing time
  4. Each server information:
    name: Shell name or server name
    cpu: CPU processing time (seconds)
    svrup(first): Server startup time (initial server access time) (seconds)
    reciv: Total wait time for communication from other processes (seconds)
    wait: Total time required for allocating locked resources (seconds)
    sort: Sorting time (seconds)
    send: Number of communications to other processes
    unlod: Unloading time (seconds)
    ixunl: Time spent to create index information files (applicable to index re-creation or index reorganization) (seconds)
    delet: Data deletion time (seconds)
    dtlod: Data loading time (seconds)
    ixlod: Time spent to create indexes from index information files (seconds)
    unldr: Unload data file input count
    unldw(expnd): Unload data file output count
    unput: Communication message processing time during unload operation (seconds)
    dtins: Communication message processing time during reload operation (seconds)
  5. Total value for each server information
  6. Each buffer information
    server: Name of back-end server
    maxio: Maximum input/output time (seconds)
    minio: Minimum input/output time (seconds)
    sumio: Total input/output time (seconds)
    brreq: Number of READ requests for data and index buffer
    bwreq: Number of WRITE requests for data and index buffer
    bfhit: Data and index buffer hit count
    hitrt: Data and index buffer hit ratio (%)
    read: Data and index buffer READ count
    write: Data and index buffer WRITE count
    lrreq: Number of READ requests for LOB buffer
    lbrht: LOB buffer READ hit count
    lbrrt: LOB buffer READ hit ratio (%)
    lwreq: Number of WRITE requests for LOB buffer
    lbwht: LOB buffer WRITE hit count
    lbwrt: LOB buffer WRITE hit ratio (%)
    lread: LOB buffer READ count
    lwrit: LOB buffer WRITE count
    flush: Buffer flush count
    bfupd: READ wait count during buffer updating
    bfred: READ wait count during buffer READ
    bfwrt: WRITE wait count during buffer WRITE
    cinsm: Internal information used by the system
    cafls: Internal information used by the system
    cafwr: Internal information used by the system
    cfmax: Internal information used by the system
    cfavg: Internal information used by the system
    ldirc: Number of times the random access local buffer was used to reference index pages
    ldiuc: Number of times the random access local buffer was used to update index pages
    ldihc: Of bfhit, buffer hit count for index pages in the random access local buffer
    ldird: Of read, the number of real READs for index pages in the random access local buffer
    ldiwt: Of write, the number of real WRITEs for index pages in the random access local buffer
    ldfshc: Of flush, number of times the random access local buffer was flushed
  7. pdrorg's return code
Notes
  1. Each item is displayed with a maximum length of three digits. If a value exceeds three digits, the system rounds up the fourth digit and displays the value with a decimal point and one of the units shown as follows:
    k: Kilo ([Figure] 103 for time and count)
    M: Mega ([Figure] 106 for time and count)
    G: Giga ([Figure] 109 for time and count)
  2. If there is no corresponding output information, the system displays *****.
  3. The processing time less than one second is rounded off. This means that a value less than one second is displayed as 0 second.
(b) Processing result of reorganization in units of schemas
-k unld

pdrorg VV-RR(Object Option) *** DB REORGANIZATION *** 2000-11-16 13:27:36 .......1

*** schema unload processing list ***

schema name : USER01 ............................................................2

No.1     table name : TABLE11                    generation : 01 ............3

        rdarea name ...........4           row count ...........................5
        RD011                                 31,267
        RD021                                 31,540
        RD012                                 31,167
        RD013                                 31,169
        RD014                                 31,363
        RD022                                 31,366
        RD023                                 31,024
        RD024                                 31,104
                                 total       250,000 ...........................6

        return code=0 ..........................................................7

No.2     table name : TABLE21                     generation : 01

        rdarea name                        row count
        RD011                                  1,246
        RD021                                  1,310
        RD012                                  1,264
        RD013                                  1,300
        RD014                                  1,286
        RD022                                  1,228
        RD023                                  1,165
        RD024                                  1,201
                                 total        10,000

        return code=0

[Tuning information of (a)]

pdrorg terminated, return code=0 ................................................8

Explanation
  1. Header information (version number and pdrorg start time)
  2. Schema name
  3. Table identifier and generation number (the generation number is displayed only when the inner replica facility is used)
  4. Table storage RDAREA name
  5. Number of rows unloaded per RDAREA
  6. Number of rows unloaded per table
  7. Return code when one table was unloaded
  8. pdrorg's return code
-k reld

pdrorg VV-RR(Object Option) *** DB REORGANIZATION *** 2000-11-16 17:02:01 .......1

*** schema reload processing list ***

schema name : USER01 ............................................................2

No.1     table name : TABLE11                    generation : 01 ...........3

        rdarea name ...........4           row count ...........................5
        RD011                                 31,267
        RD021                                 31,540
        RD012                                 31,167
        RD013                                 31,169
        RD014                                 31,363
        RD022                                 31,366
        RD023                                 31,024
        RD024                                 31,104
                                 total       250,000 ...........................6

*** index information file assign list *** ......................................7

index INDEX11 RD011 /tmp/INDEX-TABLE11-RD011-aaaa14376
index INDEX11 RD021 /tmp/INDEX-TABLE11-RD021-aaaa14380
index INDEX11 RD012 /tmp/INDEX-TABLE11-RD012-baaa14376
index INDEX11 RD013 /tmp/INDEX-TABLE11-RD013-caaa14376
index INDEX11 RD014 /tmp/INDEX-TABLE11-RD014-daaa14376
index INDEX11 RD022 /tmp/INDEX-TABLE11-RD022-baaa14380
index INDEX11 RD023 /tmp/INDEX-TABLE11-RD023-caaa14380
index INDEX11 RD024 /tmp/INDEX-TABLE11-RD024-daaa14380

        return code=0 ..........................................................8

No.2     table name : TABLE12                        skipped.....................9

        return code=4

No.3     table name : TABLE21                        generation : 01

        rdarea name                        row count
        RD011                                  1,246
        RD021                                  1,310
        RD012                                  1,264
        RD013                                  1,300
        RD014                                  1,286
        RD022                                  1,228
        RD023                                  1,165
        RD024                                  1,201
                                 total        10,000

*** index information file assign list ***

index INDEX21 RD011 /tmp/INDEX-TABLE21-RD011-aaaa14378
index INDEX21 RD021 /tmp/INDEX-TABLE21-RD021-aaaa14745
index INDEX21 RD012 /tmp/INDEX-TABLE21-RD012-baaa14378
index INDEX21 RD013 /tmp/INDEX-TABLE21-RD013-caaa14378
index INDEX21 RD014 /tmp/INDEX-TABLE21-RD014-daaa14378
index INDEX21 RD022 /tmp/INDEX-TABLE21-RD022-baaa14745
index INDEX21 RD023 /tmp/INDEX-TABLE21-RD023-caaa14745
index INDEX21 RD024 /tmp/INDEX-TABLE21-RD024-daaa14745

        return code=0

[Tuning information of (a)]

pdrorg terminated, return code=4 ...............................................10

Explanation
  1. Header information (version number and pdrorg start time)
  2. Schema name
  3. Table identifier and generation number (the generation number is displayed only when the inner replica facility is used)
  4. Table storage RDAREA name
  5. Number of rows reloaded per RDAREA
  6. Number of rows reloaded per table
  7. Information about index information files (applicable if -i n is specified)
    index index-identifier index-storage-RDAREA-name index-information-filename
  8. Return code when one table was reloaded
  9. Indicates that reload processing was skipped, in which the system outputs the return code when one table was reloaded
  10. pdrorg's return code
-k rorg

pdrorg VV-RR(Object Option) *** DB REORGANIZATION *** 2000-11-16 13:57:08 .......1

[Information for -k unld]

[Information for -k reld]*

[Tuning information of (a)]

pdrorg terminated, return code=0 ................................................2

* The schema name is not output.

Explanation
  1. Header information (version number and pdrorg start time)
  2. pdrorg's return code