スケーラブルデータベースサーバ HiRDB Version 8 コマンドリファレンス(Windows(R)用)
pdrorg実行時の,チューニング情報を出力するファイルを指定します。
report file=処理結果ファイル名 |
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 |
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 [(a)のチューニング情報] pdrorg terminated, return code=0 ................................................8 |
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 [(a)のチューニング情報] pdrorg terminated, return code=4 ...............................................10 |
pdrorg VV-RR(Object Option) *** DB REORGANIZATION *** 2000-11-16 13:57:08 .......1 [-k unldの場合の情報] [-k reldの場合の情報]※ [(a)のチューニング情報] pdrorg terminated, return code=0 ................................................2 |
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.