5.4.17 report statement (specification of a file to which pdload tuning information is output)

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

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 pathname of the file to which the tuning information is to be output.

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

(3) Output format

The following shows the tuning information to be output:

pdload VV-RR(Object Option) *** DB LOAD *** 2003-03-31 11:11:27 ..................1

*** statistics report ***

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

*** shell/server information ***

name       cpu svrup(first) reciv  wait  sort  send delet dtlod ixlod dtins ......4
---------------------------------------------------------------------------
pdload       0     0(    0) ***** ***** ***** ***** ***** ***** ***** *****
pdloadm      5     4(    4)    28 ***** ***** 5.76k ***** ***** ***** *****
bes1        21 *****(*****)     7     0     2 2.88k     1    26    67    27
bes2        22 *****(*****)     4     0     1 2.88k     1    28    67    29
---------------------------------------------------------------------------
total       48     4(    4)    39     0     3 11.5k     2    54   134    56 ......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
--------------------------------------------------------------------------------
-----------------------------------------------------------------------------
------------------------------------------
bes1         0     0    71 64.5k 44.3k 52.4k 81.1%     3 12.2k     0     0 *****
   0     0 *****     0     0 10.6k     0     0     0     0     0     0     0
1.00k 11.4k 11.4k     0     0 11.4k 10.6k
bes2         0     0    71 64.5k 44.3k 52.4k 81.1%     3 12.2k     0     0 *****
   0     0 *****     0     0 10.6k     0     0     0     0     0     0     0
1.00k 11.4k 11.4k     0     0 11.4k 10.6k
--------------------------------------------------------------------------------
-----------------------------------------------------------------------------
------------------------------------------
total        0     0   142  129k 88.6k  105k 81.1%     6 24.3k     0     0 *****
   0     0 *****     0     0 21.3k     0     0     0     0     0     0     0
1.00k 22.8k 22.8k     0     0 22.8k 21.3k

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

Explanation
  1. Header information (version number and pdload start time)
  2. pdload processing time
  3. pdload preprocessing time
  4. Information about each server:
    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
    delet: Data deletion time (seconds)
    dtlod: Data loading time (seconds)
    ixlod: Index creation time (seconds)
    dtins: Communication message processing time (seconds)
  5. Total value for information about each server
  6. Information about each buffer:
    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 index pages were referenced using the random access local buffer
    ldiuc: Number of times index pages were updated using the random access local buffer
    ldihc: In bfhit, the buffer hit count for index pages in the random access local buffer
    ldird: In read, the number of real READs for index pages in the random access local buffer
    ldiwt: In write, the number of real WRITEs for index pages in the random access local buffer
    ldfshc: In flush, the buffer flush count in the random access local buffer
  7. pdload'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.