The following shows the statistical information about UAPs.
pdstedit VV-RR(Object Option) ***** UAP INFORMATION *****
INPUT :/tmp/stjdata [1]
OUTPUT RANGE :**/**/** **:**:** - **/**/** **:**:** [2]
-----------------------------------------------------------------------------
HOST = test [3]
-----------------------------------------------------------------------------
EDIT TIME 2003/04/03 22:00:00 - 2003/04/03 23:00:00 [4]
UAP NAME [5]
SERVICE NAME [6] [7] [8] [9] [10] [11] [12] [13]
EXEC NORM ERROR TTIME TAVG CACHE LOCK
------------------------------ ----- ----- ----- ----- ----- ----- -----
[14] [15] [16] [17] [18] [19]
LMAX LAVG CTIME CTAVG SVEXT SVEXA
----- ----- ----- ----- -----
[20] [21] [22] [23] [24] [25] [26]
*SQL OBJECT* REQ RAVG HITS HAVG CRT CAVG SMAX
----- ----- ----- ----- ----- ----- -----
[27] [28] [29] [30] [31] [32] [33] [34] [35] [36] [37]
*LN1* COMT ROLB FROW DROW IROW UROW SET OPEN FETC CLOS DESC
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[38] [39] [40] [41] [42] [43] [44] [45] [46] [47] [48]
*LN2* SEL INS UPD DEL LOCK CRTT DRPT ALTT CRTI DRPI CMTT
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[49] [50] [51] [52] [53] [54] [55] [56] [57] [58] [59]
*LN3* CMTC CRTS DRPS GRTR GRTS GRTA GRTC GRTD RVKR RVKS RVKA
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[60] [61] [62] [63] [64] [65] [66] [67] [68] [69] [70]
*LN4* RVKC RVKD CRTV DRPV PRGT CRTP DRPP ALTP CALL DESI MISC
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[71] [72] [73] [74]
*STORED ROUTINE OBJECT* REQ RAVG HITS HAVG
----- ----- ----- -----
[75] [76] [77] [78] [79]
*DB ACCESS* MAXIO MINIO MWFN MWFEC MWFVL
----- ----- ----- ----- -----
[80] [81] [82] [83]
MWHTS MBSL1 MBSL2 MBSL3
----- ----- ----- -----
[84] [85] [86] [87] [88] [89] [90] [91] [92] [93] [94]
*LN1* IOTIM DIDRC DIDUC DIDHC DIDHR DIDRD DIDWT LBRFC LBUPC LBRHC LBUHC
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[95] [96] [97] [98] [99] [100] [101] [102] [103] [104] [105]
*LN2* LRFHR LUPHR LBRDC LBWTC BFSHC BRDWC BWTWC BLKWC WFRDC WFWTC WBFOC
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[106] [107] [108] [109] [110] [111] [112] [113] [114] [115] [116]
*LN3* SCHSK SCHCH LDIRC LDIUC LDIHC LDIRD LDIWT LBFSHC ARREQ ARWC ARWT
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[117] [118] [119]
*LN4* ARSTA HJMAX HJAVG
-----
uap01
service01
28 28 0 6.29k 225 3.93k 0
0 0 1.06k 38 5.85k 209
*SQL OBJECT* 136 5 37 1 99 4 4.13k
*LN1* 123 0 503 0 0 0 136 136 526 119 0 [118]
** 4 0 18 0 0 0 5 5 19 4 0 [119]
*LN2* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*STORED ROUTINE OBJECT* 0 0 0 0
*DB ACCESS* 0 0 0 0 0
0 0 0 0
*LN1* 12 1.37k 0 1.21k 89 156 0 0 0 0 0
** 0 49 0 43 6 0 0 0 0 0
*LN2* 0 0 0 0 141 0 0 0 0 0 0
** 0 0 5 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0
** 0 0 0
uap02
service02
5 5 0 5.28k 1.06k 6.77k 0
0 0 820 164 5.03k 1.01k
*SQL OBJECT* 106 21 29 6 77 15 4.13k
*LN1* 110 0 490 0 0 0 106 106 496 106 0
** 22 0 98 0 0 0 21 21 99 21 0
*LN2* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*STORED ROUTINE OBJECT* 0 0 0 0
*DB ACCESS* 0 0 0 0 0
0 0 0 0
*LN1* 14 1.30k 0 1.12k 87 175 0 0 0 0 0
** 3 259 0 224 35 0 0 0 0 0
*LN2* 0 0 0 0 137 0 0 0 0 0 0
** 0 0 27 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0
** 0 0 0
*TOTAL* [120] 33 33 0 11.6k 351 4.36k 0
0 0 1.88k 57 10.9k 330
*SQL OBJECT* 242 7 66 2 176 5 4.13k
*LN1* 233 0 993 0 0 0 242 242 1.02k 225 0
** 7 0 30 0 0 0 7 7 31 7 0
*LN2* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*STORED ROUTINE OBJECT* 0 0 0 0
*DB ACCESS* 0 0 0 0 0
0 0 0 0
*LN1* 26 2.67k 0 2.34k 88 331 0 0 0 0 0
** 1 81 0 71 10 0 0 0 0 0
*LN2* 0 0 0 0 278 0 0 0 0 0 0
** 0 0 8 0 0 0 0 0 0
*LN3* 0 0 0 0 0 0 0 0 0 0 0
** 0 0 0 0 0 0 0 0 0
*LN4* 0 0 0
** 0 0 0
-----------------------------------------------------------------------------
FILE KIND LOG KIND FIRST LAST NUM
STJ uap 2003/04/03 22:45:56 2003/04/03 22:56:24 33
-----------------------------------------------------------------------------
NO FILE KIND:LOG FILE NAME
LOG KIND FIRST LAST NUM
1 STJ :/tmp/stjdata/pdstj1
sys 2003/04/03 22:46:30 2003/04/03 22:46:30 2
uap 2003/04/03 22:45:56 2003/04/03 22:47:53 32
sql 2003/04/03 22:45:56 2003/04/03 22:47:53 898
sop 2003/04/03 22:45:56 2003/04/03 22:47:53 105
dop 2003/04/03 22:45:56 2003/04/03 22:47:52 113
pcd 2003/04/03 22:45:56 2003/04/03 22:47:53 759
obj ****/**/** **:**:** ****/**/** **:**:** 0
sqh 2003/04/03 22:45:56 2003/04/03 22:47:53 145
buf 2003/04/03 22:46:32 2003/04/03 22:46:32 3
fil 2003/04/03 22:46:32 2003/04/03 22:46:32 28
dfw 2003/04/03 22:45:58 2003/04/03 22:47:31 53
idx 2003/04/03 22:46:32 2003/04/03 22:46:32 1
fsv ****/**/** **:**:** ****/**/** **:**:** 0
hba ****/**/** **:**:** ****/**/** **:**:** 0
2 STJ :/tmp/stjdata/pdstj2
sys 2003/04/03 22:48:31 2003/04/03 22:56:35 10
uap 2003/04/03 22:47:54 2003/04/03 22:56:24 67
sql 2003/04/03 22:47:53 2003/04/03 22:56:24 623
sop 2003/04/03 22:47:53 2003/04/03 22:54:12 74
dop 2003/04/03 22:47:53 2003/04/03 22:56:23 102
pcd 2003/04/03 22:47:53 2003/04/03 22:56:24 516
obj ****/**/** **:**:** ****/**/** **:**:** 0
sqh 2003/04/03 22:47:53 2003/04/03 22:56:24 144
buf 2003/04/03 22:56:45 2003/04/03 22:56:45 3
fil 2003/04/03 22:56:45 2003/04/03 22:56:45 28
dfw 2003/04/03 22:48:04 2003/04/03 22:56:45 18
idx 2003/04/03 22:56:45 2003/04/03 22:56:45 1
fsv ****/**/** **:**:** ****/**/** **:**:** 0
hba ****/**/** **:**:** ****/**/** **:**:** 0 |
- Explanation
- Name of input statistics unload file or name of the directory containing the input statistics unload file (maximum of 58 bytes)
- Output range (output start date/time to output end date/time)
- Name of host requesting output of UAP or service statistical information
- Edit period (collection start time to collection end time)
- UAP name
This is the name of the UAP for which statistical information was edited.
- Service name
This is the name of the service for which statistical information was edited. This name depends on the type of UAP that accessed HiRDB.1
- UAP or transaction executions count
This is the number of times the same UAP or transaction was executed according to the statistics log information.
When UAP statistical information is obtained for UAP execution unit, the utility counts the number of times the UAP issued DISCONNECT as the executions count.
- UAP or transaction normal terminations count
This is the number of times the same UAP or transaction terminated normally according to the statistics log information.
- UAP or transaction abnormal terminations count
Number of times the last transaction executed by the UAP or transaction terminated in rolled-back status according to the statistics log information.
- UAP or transaction execution time (milliseconds)
This is the total execution time for the same UAP or transaction according to the statistics log information.
If UAP statistical information is collected in units of UAP executions, the utility treats the time elapsed before the UAP issued DISCONNECT since it issued CONNECT as the execution time.
- Average UAP or transaction execution time (milliseconds)
This is the average execution time for the same UAP or transaction according to the statistics log information.
If UAP statistical information is collected in units of UAP executions, the utility treats the time elapsed before the UAP issued DISCONNECT since it issued CONNECT as the execution time.
- Size of table definition information buffer (bytes)
This is the average size of the table definition information buffer used for the table definition information that was acquired by the same UAP or transaction according to the statistics log information.
- Total lock release wait time for the UAP or transaction (milliseconds)2
This is the total lock release wait time for the UAP or transaction.
- Maximum lock release wait time for the UAP or transaction (milliseconds)2
This is the maximum lock release wait time for the UAP or transaction.
- Average lock release wait time for one UAP or transaction (milliseconds)2
This is the average lock release wait time for one UAP or transaction.
- Total CPU time for all servers within the transaction (milliseconds)
- Average CPU time per UAP or transaction (CTIME
EXEC) (milliseconds) - Total single server or front-end server processing time for the UAP or transaction (milliseconds)
- Average single server or front-end server processing time per UAP or transaction (SVEXT
EXEC) (milliseconds) - Number of SQL object acquisition requests
This is the number of SQL object acquisition requests for the SQL statements issued by the same UAP or transaction within the specified time period.
- Number of SQL object acquisition requests by UAP or transaction
This is the average number of SQL object acquisition requests per UAP or transaction execution for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- SQL object buffer hits count
This is the number of times a requested SQL object was found in the SQL object buffer for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- SQL object buffer hits count per UAP or transaction
This is the average number of times per UAP or transaction execution a requested SQL object was found in the SQL object buffer for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- SQL object creations count
This is the number of times an SQL object was created for the SQL statements issued by the same UAP or transaction within the specified time period.
- SQL object creations count per UAP or transaction
This is the average number of times per UAP or service execution that an SQL object was created for the SQL statements issued by the same UAP or transaction within the specified time period.
If this value is large, the size of the SQL object buffer should be increased.
- Maximum size of SQL objects created (bytes)
This is the maximum size of the SQL objects created for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- COMMIT statement executions count
This is the number of times the COMMIT statement issued by the same UAP or transaction was executed within the specified time period.
- ROLLBACK statement executions count
This is the number of times the ROLLBACK statement issued by the same UAP or transaction was executed within the specified time period.
- Actually retrieved rows count
This is the number of retrieved rows returned to the UAP or transaction by the FETCH and SELECT statements that were issued by the same UAP or transaction within the specified time period.
- Actually deleted rows count
This is the number of rows deleted by the DELETE statement that was issued by the same UAP or transaction within the specified time period.
- Actually inserted rows count
This is the number of rows inserted by the INSERT statement that was issued by the same UAP or transaction within the specified time period.
- Actually updated rows count
This is the number of rows updated by the UPDATE statement that was issued by the same UAP or transaction within the specified time period.
- SETUP statement executions count
This is the number of times preprocessing was executed by the same UAP or transaction within the specified time period.
- OPEN statement executions count
This is the number of times the OPEN statement was executed by the same UAP or transaction within the specified time period.
- FETCH statement executions count
This is the number of times the FETCH statement was executed by the same UAP or transaction within the specified time period.
- CLOSE statement executions count
This is the number of times the CLOSE statement was executed by the same UAP or transaction within the specified time period.
- DESCRIBE statement executions count
This is the number of times the DESCRIBE statement was executed by the same UAP or transaction within the specified time period.
- SELECT statement executions count
This is the number of times the SELECT statement was executed by the same UAP or transaction within the specified time period.
- INSERT statement executions count
This is the number of times the INSERT statement was executed by the same UAP or transaction within the specified time period.
- UPDATE statement executions count
This is the number of times the UPDATE statement was executed by the same UAP or transaction within the specified time period.
- DELETE statement executions count
This is the number of times the DELETE statement was executed by the same UAP or transaction within the specified time period.
- LOCK statement executions count
This is the number of times the LOCK statement was executed by the same UAP or transaction within the specified time period.
- CREATE TABLE executions count
This is the number of times CREATE TABLE was executed by the same UAP or transaction within the specified time period.
- DROP TABLE executions count
This is the number of times DROP TABLE was executed by the same UAP or transaction within the specified time period.
- ALTER TABLE executions count
This is the number of times ALTER TABLE was executed by the same UAP or transaction within the specified time period.
- CREATE INDEX executions count
This is the number of times CREATE INDEX was executed by the same UAP or transaction within the specified time period.
- Number of times DROP INDEX issued by the UAP or transaction was executed
This is the number of times DROP INDEX was executed by the same UAP or transaction within the specified time period.
- COMMENT (TABLE) executions count
This is the number of times COMMENT (TABLE) was executed by the same UAP or transaction within the specified time period.
- COMMENT (COLUMN) executions count
This is the number of times COMMENT (COLUMN) was executed by the same UAP or transaction within the specified time period.
- CREATE SCHEMA executions count
This is the number of times CREATE SCHEMA was executed by the same UAP or transaction within the specified time period.
- DROP SCHEMA executions count
This is the number of times DROP SCHEMA was executed by the same UAP or transaction within the specified time period.
- GRANT RDAREA executions count
This is the number of times GRANT RDAREA was executed by the same UAP or transaction within the specified time period.
- GRANT SCHEMA executions count
This is the number of times GRANT SCHEMA was executed by the same UAP or transaction within the specified time period.
- GRANT access privilege executions count
This is the number of times GRANT access privilege was executed by the same UAP or transaction within the specified time period.
- GRANT CONNECT executions count
This is the number of times GRANT CONNECT was executed by the same UAP or transaction within the specified time period.
- GRANT DBA executions count
This is the number of times GRANT DBA was executed by the same UAP or transaction within the specified time period.
- REVOKE RDAREA executions count
This is the number of times REVOKE RDAREA was executed by the same UAP or transaction within the specified time period.
- REVOKE SCHEMA executions count
This is the number of times REVOKE SCHEMA was executed by the same UAP or transaction within the specified time period.
- REVOKE access privilege executions count
This is the number of times REVOKE access privilege was executed by the same UAP or transaction within the specified time period.
- REVOKE CONNECT executions count
This is the number of times REVOKE CONNECT was executed by the same UAP or transaction within the specified time period.
- REVOKE DBA executions count
This is the number of times REVOKE DBA was executed by the same UAP or transaction within the specified time period.
- CREATE VIEW executions count
This is the number of times CREATE VIEW was executed by the same UAP or transaction within the specified time period.
- DROP VIEW executions count
This is the number of times DROP VIEW was executed by the same UAP or transaction within the specified time period.
- PURGE TABLE statement executions count
This is the number of times the PURGE TABLE statement was executed by the same UAP or transaction within the specified time period.
- CREATE PROCEDURE executions count
This is the number of times CREATE PROCEDURE was executed by the same UAP or transaction within the specified time period.
- DROP PROCEDURE executions count
This is the number of times DROP PROCEDURE was executed by the same UAP or transaction within the specified time period.
- ALTER PROCEDURE executions count
This is the number of times ALTER PROCEDURE was executed by the same UAP or transaction within the specified time period.
- CALL statement executions count
This is the number of times the CALL statement was executed by the same UAP or transaction within the specified time period.
- DESCRIBE statement (INPUT) executions count
This is the number of times the DESCRIBE statement (INPUT) was executed by the same UAP or transaction within the specified time period.
- Other executions count
This is the other executions count for the same UAP or transaction within the specified time period.
- Number of stored procedure object acquisition requests
This is the number of stored procedure object acquisition requests for the SQL statements issued by the same UAP or transaction within the specified time period.
- Number of stored procedure object acquisition requests per UAP or transaction
This is the average number of stored procedure object acquisition requests per UAP or transaction execution made for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- SQL object buffer hits count
This is the number of times a requested stored procedure object was found in the SQL object buffer for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- SQL object buffer hits count per UAP or transaction
This is the average number of times per UAP or transaction execution that a requested stored procedure object was found in the SQL object buffer for the SQL statements that were issued by the same UAP or transaction within the specified time period.
- Maximum database input/output time (milliseconds)
- Minimum database input/output time per operation (milliseconds)
- Maximum number of work table files used by UAP
- Maximum number of work table files added for use by UAP
- Maximum size of work table file used by UAP (MB)
- Estimated hash size required to expand all hash data at one time during hash join or subquery hash execution (KB)
- Maximum packet size after level 1 packet division during hash join, subquery hash execution (KB)
- Maximum packet size after level 2 packet division during hash join, subquery hash execution (KB)
- Maximum packet size after level 3 packet division during hash join, subquery hash execution (KB)
- Total input/output time for the database (milliseconds)
- Number of times a data page, index page, or directory page was referenced3
- Number of times a data page, index page, or directory page was updated3
- Buffer hits count for data pages, index pages, or directory pages3
- Buffer hit rate for data pages, index pages, or directory pages (DIDHC
DIDRC) (%) - Actual number of READ operations on a data page, index page, or directory page
- Actual number of WRITE operations on a data page, index page, or directory page3
- Number of times a LOB column data page was referenced3
- Number of times a LOB column data page was updated3
- Buffer hits count for referencing LOB column data pages3
- Buffer hits count for updating LOB column data pages
- Buffer hit rate for referencing LOB column data pages (LBRHC
LBRFC) (%) - Buffer hit rate for updating LOB column data pages (LBUHC
LBUPC) (%) - Actual number of READ operations on LOB column data pages
- Actual number of WRITE operations on LOB column data pages3
- Global buffer flushes count3
- READ waits count on global buffer3
- WRITE waits count on global buffer3
- Lock waits count on global buffer3
- Number of times work table data was read from work table file to global buffer3
- Number of times work table data was written from global buffer to work table file3
- Number of times the contents of work table buffer were forcibly output to work table file due to shortage of work table buffer space3
- With a table for which SEGMENT REUSE was specified, the number of times the mode changed from new page allocate to free page reuse and then changed back to new page allocate again because there was no reusable space3
- With a table for which SEGMENT REUSE was specified, the number of times the mode changed from new page allocate to free page reuse3
- Number of times data pages and index pages were referenced from the applicable UAP using the local buffer3
- Number of times data pages and index pages were updated from the applicable UAP using the local buffer3
- Local buffer hit count for data pages and index pages
If a random access UAP's buffer hit count (LDIHC/LDIRC
100) is low, you need to tune the applicable local buffer.3
- Number of real READs on data pages and index pages from the applicable UAP using the local buffer3
If the prefetch facility is used, this value includes the number of pre-READs achieved by prefetching. If the buffer hit rate (LDIHC/LDIRC
100) is low, this value is greater than the number of real READs.
- Number of real WRITEs on data pages and index pages from the applicable UAP using the local buffer
- Local buffer flush count (number of times the buffer contents were discarded to read new pages)3
- Number of batch pre-read requests issued to asynchronous READ processes when the asynchronous READ facility is used3
- Number of times synchronization waits occurred during batch pre-read operation executed by asynchronous READ processes when the asynchronous READ facility is used3
- Synchronous wait time during batch pre-read operation executed by asynchronous READ processes when the asynchronous READ facility is used (milliseconds)3
- Synchronous READ time during the first top-page batch read operation when the asynchronous READ facility is used (milliseconds)3
- Maximum comparison count when a hash row partitioning table was searched during hash join, subquery hash execution
- Average comparison count when a hash row partitioning table was searched during hash join, subquery hash execution3
- Total value of each item per UAP or transaction execution
- Average value of each item per UAP or transaction execution
- Grand total for each item
- 1 The following table shows the service name that is displayed for each type of UAP:
UAP type | Displayed service name |
---|
Open/TP1 UAP | Service requested from Open/TP1 SUP (service using program) to SPP (service provider program) | Name of the corresponding service |
Service requested from TP1/Message Control to MHP (message handling program) |
Other | 31 consecutive asterisks (*) |
Other types of UAP |
2 For a HiRDB/Parallel Server, this is the total lock release wait time in the transaction (including parallel processing).
3 If the information is output for each transaction, this is the cumulative CONNECT value.