Nonstop Database, HiRDB Version 9 Command Reference
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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] [120] [121] [122] [123] [124] [125] [126]
*LN4* ARSTA HJMAX HJAVG TUSEG COMPC COMPT CMPMT EXTEC EXTET EXTMT
----- ----- ----- ----- ----- ----- ----- ----- ----- -----
*THREAD LOCK*
[130] [131] [132] [133] [134] [135] [136] [137] [138] [139] [140]
*LN1* LCKTC LCKWC LCKWT LCKTM LCKWQ LCKQM JBFTC JBFWC JBFWT JBFTM JBFWQ
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
[141] [142] [143] [144] [145] [146] [147]
*LN2* JBFQM BUFTC BUFWC BUFWT BUFTM BUFWQ BUFQM
----- ----- ----- ----- ----- ----- -----
uap01
service01
12 12 0 1.70k 142 26.0k 111
37 9 260 22 1.58k 132
*SQL OBJECT* 108 9 0 0 108 9 9.19k
*LN1* 96 0 168 0 0 0 108 108 204 108 0 [127]
** 8 0 14 0 0 0 9 9 17 9 0 [128]
*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* 8 0 0 0 0
0 0 0 0
*LN1* 41 2.32k 0 2.26k 97 64 0 0 0 0 0
** 3 194 0 188 5 0 0 0 0 0
*LN2* 0 0 0 0 64 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
*THREAD LOCK*
*LN1* 1.31k 8 542 140 0 0 84 38 466k 26.5k 7
** 68 0 12.3k 0
*LN2* 1 4.71k 1 74 74 0 0
** 74 0
uap02
service02
8 8 0 3.43k 428 5.93k 676
150 85 140 18 3.36k 420
*SQL OBJECT* 56 7 5 1 51 6 3.02k
*LN1* 96 0 204 0 12 0 124 124 256 124 16
** 5 0 10 0 1 0 6 6 13 6 1
*LN2* 0 0 36 0 12 0 16 16 52 16 16
** 0 2 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* 83 0 0 0 0
0 0 0 0
*LN1* 906 2.44k 156 1.60k 66 833 66 0 0 0 0
** 3 259 0 224 35 0 0 0 0 0
*LN2* 0 0 0 0 900 0 1 10 0 0 0
** 0 0 45 0 0 1 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 14 0 0 0 24 0 0
** 0 0 0
*THREAD LOCK*
*LN1* 2.34k 8 310 62 0 0 35 1 121k 121k 0
** 39 0 121k 0
*LN2* 0 5.83k 2 7.54k 7.48k 0 0
** 3.77k 0
*TOTAL* [129] 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
** 113 306 20 200 104 8 0 0 0 0
*LN2* 0 0 0 0 836 0 1 10 0 0 0
** 0 0 105 0 0 1 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 14 0 0 0 24 0 0 0
** 0 0 0 0 0 0 0 0 0 0 0
*STORED ROUTINE OBJECT* 0 0 0 0
*DB ACCESS* 83 0 0 0 0
0 0 0 0
*LN1* 948 4.77k 156 3.86k 81 897 66 0 0 0 0
** 47 238 8 193 45 3 0 0 0 0
*LN2* 0 0 0 0 900 0 1 10 0 0 0
** 0 0 45 0 0 1 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 14 0 0 0 24 0 0
** 0 0 0
*THREAD LOCK*
*LN1* 3.65k 16 852 140 0 0 119 39 586k 121k 7
** 53 0 15.0k 0
*LN2* 1 10.5k 3 7.62k 7.48k 0 0
** 2.54k 0
-----------------------------------------------------------------------------
FILE KIND LOG KIND FIRST LAST NUM
STJ uap 2012/02/03 09:29:28 2012/02/03 09:35:13 20
-----------------------------------------------------------------------------
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 2012/02/03 09:29:27 2012/02/03 09:31:04 98
dop 2012/02/03 09:29:27 2012/02/03 09:31:04 92
pcd ****/**/** **:**:** ****/**/** **:**:** 0
obj ****/**/** **:**:** ****/**/** **:**:** 0
sqh ****/**/** **:**:** ****/**/** **:**:** 0
buf 2012/02/03 09:30:00 2012/02/03 09:32:24 21
fil 2012/02/03 09:30:00 2012/02/03 09:32:24 224
dfw 2012/02/03 09:29:30 2012/02/03 09:32:24 71
idx 2012/02/03 09:30:00 2012/02/03 09:32:24 7
fsv ****/**/** **:**:** ****/**/** **:**:** 0
hba ****/**/** **:**:** ****/**/** **:**:** 0
2 STJ :/tmp/stjdata/pdstj2
sys 2012/02/03 09:34:58 2012/02/03 09:37:00 6
uap 2012/02/03 09:34:00 2012/02/03 09:36:17 19
sql 2012/02/03 09:33:59 2012/02/03 09:36:17 456
sop 2012/02/03 09:34:02 2012/02/03 09:36:16 65
dop 2012/02/03 09:34:02 2012/02/03 09:36:16 96
pcd ****/**/** **:**:** ****/**/** **:**:** 0
obj ****/**/** **:**:** ****/**/** **:**:** 0
sqh ****/**/** **:**:** ****/**/** **:**:** 0
buf 2012/02/03 09:34:10 2012/02/03 09:36:19 27
fil 2012/02/03 09:34:10 2012/02/03 09:36:19 288
dfw 2012/02/03 09:34:04 2012/02/03 09:36:19 41
idx 2012/02/03 09:34:10 2012/02/03 09:36:19 9
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)
Because the precision of the CPU time depends on the OS and the hardware being used, if the CPU time precision is greater than one millisecond, a displayed value might be smaller than the actual value.
- Average CPU time per UAP or transaction (CTIME
![[Figure]](FIGURE/ZUENG002.GIF)
EXEC) (milliseconds)
Because the precision of the CPU time depends on the OS and the hardware being used, if the CPU time precision is greater than one millisecond, a displayed value might be smaller than the actual value.
- 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 referenced#3
- Number of times a data page, index page, or directory page was updated#3
- Buffer hits count for data pages, index pages, or directory pages#3
- 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 page#3
- Number of times a LOB column data page was referenced#3
- Number of times a LOB column data page was updated#3
- Buffer hits count for referencing LOB column data pages#3
- 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 pages#3
- Global buffer flushes count#3
- READ waits count on global buffer#3
- WRITE waits count on global buffer#3
- Lock waits count on global buffer#3
- Number of times work table data was read from work table file to global buffer#3
- Number of times work table data was written from global buffer to work table file#3
- Number of times the contents of work table buffer were forcibly output to work table file due to shortage of work table buffer space#3
- 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 space#3
- With a table for which SEGMENT REUSE was specified, the number of times the mode changed from new page allocate to free page reuse#3
- Number of times data pages and index pages were referenced from the applicable UAP using the local buffer#3
- Number of times data pages and index pages were updated from the applicable UAP using the local buffer#3
- Local buffer hit count for data pages and index pages
If a random access UAP's buffer hit count (LDIHC/LDIRC ![[Figure]](FIGURE/ZUENG005.GIF)
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 buffer#3
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 used#3
- Number of times synchronization waits occurred during batch pre-read operation executed by asynchronous READ processes when the asynchronous READ facility is used#3
- 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 execution#3
- Total number of segments used during execution of SQL statements that use temporary tables
- Total number of times data compression processing was performed#4
This is the total number of times data compression processing was performed when data was inserted and updated in compressed columns.
- Total time spent for data compression processing (milliseconds)#4
This is the total time spent for data compression processing when data was inserted and updated in compressed columns.
- Maximum time spent for data compression processing (milliseconds)#4
This is the maximum time spent for one data compression process when data was inserted or updated in compressed columns.
- Total number of times data expansion processing was performed#4
This is the total number of times data expansion processing was performed when data was retrieved or updated in compressed columns.
- Total time spent for data expansion processing (milliseconds)#4
This is the total time (approximate value) spent for data expansion processing when data was retrieved or updated in compressed columns.
- Maximum time spent for data expansion processing (milliseconds)#4
This is the maximum time spent for one data expansion process when data was retrieved or updated in compressed columns.
- 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
- Number of thread-to-thread lock requests for the pool partition for locking
- Number of thread-to-thread lock-release waits for the pool partition for locking
- Total thread-to-thread lock-release wait time for the pool partition for locking (microseconds)#5, #6
This is the total thread-to-thread lock-release wait time for the pool partition for locking for this UAP. The average value indicates the value for one thread-to-thread lock-release wait for the pool partition for locking.
- Maximum thread-to-thread lock-release wait time for the pool partition for locking (microseconds)#5, #6
This is the maximum thread-to-thread lock-release wait time for the pool partition for locking for this UAP.
- Total number of requests in the thread-to-thread lock-release wait queue for the pool partition for locking
This is the total number of requests in the thread-to-thread lock-release wait queue for the pool partition for locking for this UAP. The average value indicates the time for one thread-to-thread lock-release wait for the pool partition for locking.
- Maximum number of requests in the queue for the pool partition for locking
This is the maximum number of requests in the thread-to-thread lock-release wait queue for the pool partition for locking for this UAP.
- Number of log flush requests
- Number of log flush waits
- Total log flush wait time (microseconds)#5, #6
This is the total thread-to-thread lock-release wait time for log flushing for this UAP. The average value indicates the time for one thread-to-thread lock-release wait for log flushing.
- Maximum log flush wait time (microseconds)#5, #6
This is the maximum thread-to-thread lock-release wait time for log flushing for this UAP.
- Total number of requests in the log flush wait queue
This is the total number of requests in the thread-to-thread lock-release wait queue for log flushing for this UAP. The average value indicates the number of requests for one thread-to-thread lock for log flushing.
- Maximum number of requests in the log flush queue
This is the maximum number of requests in the log flush queue for this UAP.
- Number of thread-to-thread lock requests for global buffer pool
- Number of thread-to-thread lock-release waits for global buffer pool
- Total thread-to-thread lock-release wait time for global buffer pool (microseconds)#5, #6
This is the total thread-to-thread lock-release wait time for global buffer lock acquisition processing for this UAP. The average value indicates the value for one thread-to-thread lock-release wait for global buffer pool.
- Maximum thread-to-thread lock-release wait time for global buffer pool (microseconds)#5, #6
This is the maximum thread-to-thread lock-release wait time for global buffer lock acquisition processing for this UAP.
- Number of requests in the thread-to-thread lock-release wait queue for global buffer pool
This is the total number of requests in the thread-to-thread lock-release wait queue for global buffer lock acquisition processing for this UAP. The average value indicates the time for one thread-to-thread lock-release wait for global buffer pool.
- Maximum number of requests in the thread-to-thread lock-release wait queue for global buffer pool
This is the maximum number of requests in the thread-to-thread lock-release wait queue for global buffer lock acquisition processing for this UAP.
- #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 configuration, 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.
- #4
- This information is for BINARY-type data.
- #5
- This information is output when the -w option is specified in the pdstbegin command to collect the thread-to-thread lock-release wait time. For details about the -w option in the pdstbegin command, see (4) Options under 2.109 pdstbegin (Start output of statistical information).
- #6
- Because the precision of the displayed values depends on the OS and the hardware being used, a displayed value might be smaller than the actual value.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.