スケーラブルデータベースサーバ HiRDB Version 8 コマンドリファレンス(UNIX(R)用)
システムの稼働に関する統計情報を次に示します。
pdstedit VV-RR(Object Option) ***** SYSTEM INFORMATION ***** INPUT :/tmp/stjdata [1] OUTPUT RANGE :**/**/** **:**:** - **/**/** **:**:** [2] ----------------------------------------------------------------------------- HOST = test [3] ----------------------------------------------------------------------------- EDIT TIME 2000/12/11 14:00:00 - 2000/12/11 14:20:00 [4] SERVER : ******** [5] [6] [7] [8] [9] FREQ MAX MIN AVG ----- ----- ----- ----- <SCHEDULE>[10] QUEUE LENGTH[11] 66 1 1 1 MESSAGE LENGTH[12] 66 1.55k 548 973 <PROCESS>[13] # OF USER SERVER ABORT[14] 0 # OF SYSTEM SERVER ABORT[15] 0 # OF PROCESS[16] 13 10 12 # OF PROCESS ON SERVICE[17] 3 0 0 # OF REQ PROCESS OVER MAX[18] 0 <TRANSACTION>[19] # OF COMMIT[20] 105 # OF ROLLBACK[21] 3 <NAME>[22] # OF CACHE HIT[23] 0 # OF LOCAL HIT[24] 364 # OF LOOK-UP[25] 364 <RPC>[26] # OF TIME OUT[27] 0 # OF ERROR[28] 0 RESPONSE ON OWN UNIT[29] 81 308k 1 10.2k RESPONSE TO OTHER UNIT[30] 0 0 0 0 EXEC TIME ON OWN UNIT[31] 759 311k 0 2.19k EXEC TIME FROM OTHER UNIT[32] 0 0 0 0 # OF SEND TO OWN PRCS[33] 0 # OF SEND TO OTHER PRCS[34] 63 # OF SEND TO OTHER UNIT[35] 0 # OF RECV FROM OWN PRCS[36] 0 # OF RECV FROM OTHER PRCS[37] 0 # OF RECV FROM OTHER UNIT[38] 0 # OF REGISTERED PORTS[39] 0 0 0 0 # OF ASSIGNED PORTS[40] 0 0 0 0 <LOCK>[41] WAIT TIME[42] 0 0 0 0 QUEUE LENGTH[43] 0 0 0 0 # OF DEADLOCK[44] 0 % OF USE LOCK TABLE[45] 1 0 0 0 # OF REQUEST WAIT QUEUE[124] 1 0 0 0 <SHARED MEMORY>[46]STATIC GET SIZE[47] 0 0 0 0 STATIC POOL SIZE[48] 0 0 0 0 DYNAMIC GET SIZE[49] 216 1.20M 1.19M 1.19M DYNAMIC POOL SIZE[50] 216 657k 652k 655k SIZE EXCEPT GLOBAL BUFFER[51] 23.3M STATIC SIZE[52] 1.58M DYNAMIC SIZE[53] 1.19M SIZE FOR GLOBAL BUFFER[54] 344k <SYNC POINT>[55] SYNC POINT GET INTERVAL[56] 2 109k 44.4k 76.8k SYNC POINT GET TIME[57] 2 1.01k 1.01k 1.01k <LOG>[58] # OF BUFFER FULL[59] 35 # OF WAIT THREAD[60] 0 OUTPUT BLOCK LENGTH[61] 418 32.0k 332 8.26k NOT BUS LENGTH[62] 418 32.0k 332 8.26k # OF BUFFER FOR WAIT I/O[63] 0 0 0 0 # OF WRITE TO FILE[64] 2.68k # OF WRITE ERROR[65] 0 LOG FILE SWAP TIME[66] 3 131 60 90 LOG INPUT DATA LENGTH[67] 96 32.0k 32.0k 32.0k # OF READ FROM FILE[68] 2 # OF READ ERROR[69] 0 FILE WRITE TIME[125] 2.68k 77.4k 9.17k 19.7k FILE READ TIME[126] 2 42 29 36 # OF BUFFERING[127] 12.5k <DICTIONARY>[70] # OF TBL-DEF GET REQ[71] 29 # OF TBL-CACHE HIT[72] 28 # OF CACHED TBL-DEF[73] 1 7 7 7 USED TBL-DEF SIZE[74] 1 9.23k 9.23k 9.23k TBL-CACHE SIZE[75] 1 60.2k 60.2k 60.2k # OF ACCESS PRIV CHECK[76] 0 # OF CACHE HIT (AP CHECK)[77] 0 # OF CON/DBA DEF GET REQ[78] 39 # OF CON/DBA CACHE HIT[79] 39 # OF CON/DBA CACHED USER[80] 0 0 0 0 DICT SERV TRANS DATA SIZE[81] 0 0 0 0 # OF TRANS[82] 0 # OF VIEW DEF GET REQ[83] 0 # OF VIEW CACHE HIT[84] 0 # OF VIEW CACHED DEF[85] 0 USED VIEW SIZE[86] 0 0 0 0 VIEW CACHE SIZE[87] 0 0 0 0 CACHE-MISS VIEW SIZE[88] 0 0 0 0 # OF TYPE-DEF GET REQ[89] 0 # OF TYPE-DEF CACHE HIT[90] 0 # OF CACHED TYPE-DEF[91] 0 0 0 0 TYPE-DEF CACHE SIZE[92] 0 0 0 0 TYPE-DEF CACHE TOTAL SIZE[93] 0 0 0 0 TYPE-DEF CACHE ALLOC SIZE[94] 0 0 0 0 # OF RTN-DEF GET REQ[95] 0 # OF RTN-DEF CACHE HIT[96] 0 # OF CACHED RTN-DEF[97] 0 0 0 0 RTN-DEF CACHE SIZE[98] 0 0 0 0 RTN-DEF CACHE TOTAL SIZE[99] 0 0 0 0 RTN-DEF CACHE ALLOC SIZE[100] 0 0 0 0 # OF PLG-RTN GET REQ[101] 0 # OF PLG-RTN CACHE HIT[102] 0 # OF REGISTRY GET REQ[103] 0 # OF REGISTRY CACHE HIT[104] 0 # OF CACHED REGISTRY-DEF[105] 0 0 0 0 REGISTRY CACHE SIZE[106] 0 0 0 0 REGISTRY CACHE TOTAL SIZE[107]0 0 0 0 DIRECTORY USER CHECK TIME[108]2 33.0k 20.2k 26.6k GROUP CHECK TIME[109] 2 217 179 198 <FES-BES-DIC(SDS) # OF SQLOBJ INFO GET[111] 90 INFORMATION> # OF CACHE HIT (SQLOBJ)[112] 63 [110] # OF CACHED SQLOBJ[113] 27 32 6 19 CACHED SQLOBJ TOTAL SIZE[114]27 86.0k 17.0k 52.0k # OF SWAP OUT SQLOBJ[115] 0 REQUEST SQLOBJ SIZE[116] 27 3.65k 1.74k 2.67k # OF STRT INFO GET[117] 0 # OF CACHED HIT (STRT)[118] 0 # OF CACHED STRT[119] 0 0 0 0 CACHED STRT TOTAL SIZE[120] 0 0 0 0 # OF SWAP OUT STRT[121] 0 REQUEST STRT SIZE[122] 0 0 0 0 # OF STRT RECOMPILE[123] 0 ----------------------------------------------------------------------------- FILE KIND LOG KIND FIRST LAST NUM STJ sys 2000/12/11 14:08:29 2000/12/11 14:08:29 1 ----------------------------------------------------------------------------- NO FILE KIND:LOG FILE NAME LOG KIND FIRST LAST NUM 1 STJ :/tmp/stjdata/pdstj01 sys ****/**/** **:**:** ****/**/** **:**:** 0 uap 2000/12/11 15:33:53 2000/12/11 15:36:53 104 sql 2000/12/11 15:33:53 2000/12/11 15:36:53 536 sop 2000/12/11 15:33:53 2000/12/11 15:34:05 12 dop 2000/12/11 15:33:53 2000/12/11 15:36:53 144 pcd ****/**/** **:**:** ****/**/** **:**:** 0 obj ****/**/** **:**:** ****/**/** **:**:** 0 sqh ****/**/** **:**:** ****/**/** **:**:** 0 buf 2000/12/11 15:33:41 2000/12/11 15:36:54 18 fil 2000/12/11 15:33:41 2000/12/11 15:36:54 150 dfw 2000/12/11 15:33:41 2000/12/11 15:36:54 7 idx 2000/12/11 15:33:41 2000/12/11 15:36:54 6 2 STJ :/tmp/stjdata/pdstj02 sys 2000/12/11 14:08:29 2000/12/11 14:08:29 2 uap 2000/12/11 14:06:30 2000/12/11 14:09:07 52 sql 2000/12/11 14:06:30 2000/12/11 14:09:07 496 sop 2000/12/11 14:06:30 2000/12/11 14:07:14 27 dop 2000/12/11 14:06:30 2000/12/11 14:09:06 120 pcd ****/**/** **:**:** ****/**/** **:**:** 0 obj ****/**/** **:**:** ****/**/** **:**:** 0 sqh ****/**/** **:**:** ****/**/** **:**:** 0 buf 2000/12/11 14:06:30 2000/12/11 14:09:08 12 fil 2000/12/11 14:06:30 2000/12/11 14:09:08 100 dfw 2000/12/11 14:06:30 2000/12/11 14:09:08 1077 idx 2000/12/11 14:06:30 2000/12/11 14:09:08 4 3 STJ :/tmp/stjdata/pdstj03 sys ****/**/** **:**:** ****/**/** **:**:** 0 uap 2000/12/11 15:33:53 2000/12/11 15:36:53 104 sql 2000/12/11 15:33:53 2000/12/11 15:36:53 536 sop 2000/12/11 15:33:53 2000/12/11 15:34:05 12 dop 2000/12/11 15:33:53 2000/12/11 15:36:53 144 pcd ****/**/** **:**:** ****/**/** **:**:** 0 obj ****/**/** **:**:** ****/**/** **:**:** 0 sqh ****/**/** **:**:** ****/**/** **:**:** 0 buf 2000/12/11 15:33:41 2000/12/11 15:36:54 18 fil 2000/12/11 15:33:41 2000/12/11 15:36:54 150 dfw 2000/12/11 15:33:41 2000/12/11 15:36:54 7 idx 2000/12/11 15:33:41 2000/12/11 15:36:54 6 4 STJ :/tmp/stjdata/pdstj04 sys ****/**/** **:**:** ****/**/** **:**:** 0 uap 2000/12/11 15:58:46 2000/12/11 15:59:18 52 sql 2000/12/11 15:58:46 2000/12/11 15:59:18 268 sop 2000/12/11 15:58:45 2000/12/11 15:58:55 17 dop 2000/12/11 15:58:45 2000/12/11 15:59:17 72 pcd ****/**/** **:**:** ****/**/** **:**:** 0 obj ****/**/** **:**:** ****/**/** **:**:** 0 sqh ****/**/** **:**:** ****/**/** **:**:** 0 buf 2000/12/11 15:58:39 2000/12/11 15:59:18 9 fil 2000/12/11 15:58:39 2000/12/11 15:59:18 75 dfw 2000/12/11 15:58:39 2000/12/11 15:59:18 3 idx 2000/12/11 15:59:10 2000/12/11 15:59:18 2 |
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.