(a) process-results-filename

<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.

(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
                                          -
           
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
                                          -
           
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
                                             
                                           -
        
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
                                             
                                           -
        
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: Command 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 ( 10³ for time and count)
   M: Mega ( 10⁶ for time and count)
   G: Giga ( 10⁹ 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 : 0 ............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 : 0 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 (0 is always displayed for generation)
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 : 0 ...........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 c:\pdrorg\INDEX-TABLE11-RD011-aaaa14376 index INDEX11 RD021 c:\pdrorg\INDEX-TABLE11-RD021-aaaa14380 index INDEX11 RD012 c:\pdrorg\INDEX-TABLE11-RD012-baaa14376 index INDEX11 RD013 c:\pdrorg\INDEX-TABLE11-RD013-caaa14376 index INDEX11 RD014 c:\pdrorg\INDEX-TABLE11-RD014-daaa14376 index INDEX11 RD022 c:\pdrorg\INDEX-TABLE11-RD022-baaa14380 index INDEX11 RD023 c:\pdrorg\INDEX-TABLE11-RD023-caaa14380 index INDEX11 RD024 c:\pdrorg\INDEX-TABLE11-RD024-daaa14380 return code=0 ..........................................................8 No.2 table name : TABLE12 skipped.....................9 return code=4 No.3 table name : TABLE21 generation : 0 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 c:\pdrorg\INDEX-TABLE21-RD011-aaaa14378 index INDEX21 RD021 c:\pdrorg\INDEX-TABLE21-RD021-aaaa14745 index INDEX21 RD012 c:\pdrorg\INDEX-TABLE21-RD012-baaa14378 index INDEX21 RD013 c:\pdrorg\INDEX-TABLE21-RD013-caaa14378 index INDEX21 RD014 c:\pdrorg\INDEX-TABLE21-RD014-daaa14378 index INDEX21 RD022 c:\pdrorg\INDEX-TABLE21-RD022-baaa14745 index INDEX21 RD023 c:\pdrorg\INDEX-TABLE21-RD023-caaa14745 index INDEX21 RD024 c:\pdrorg\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 (0 is always displayed for generation)
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