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
- You can specify only one report statement.
- 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
<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
- Header information (version number and pdload start time)
- pdload processing time
- pdload preprocessing time
- 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)
- Total value for information about each server
- 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
- pdload's return code
- Notes
- 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 (
103 for time and count)
M: Mega (
106 for time and count)
G: Giga (
109 for time and count)
- If there is no corresponding output information, the system displays *****.
- The processing time less than one second is rounded off. This means that a value less than one second is displayed as 0 second.