Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

14.3.6 Statistical information about HiRDB files for database manipulation

The following shows the statistical information about HiRDB files for database manipulation:

 
pdstedit VV-RR          ***** HiRDB FILE INFORMATION *****
INPUT          :/tmp/pdstj1 [1]
OUTPUT RANGE   :**/**/** **:**:** - **/**/** **:**:** [2]
-----------------------------------------------------------------------------
HOST = test [3]
-----------------------------------------------------------------------------
EDIT TIME 1996/10/30 00:00:00 - 1996/10/31 00:00:00 [4]
               [5]    [6]    [7]    [8]    [9]    [10]   [11]   [12]
         *LN1* SYNC-R SYNC-W AIO-R  AIO-W  LISTIO OPEN   CLOSE  IOERR
               -----  -----  -----  -----  -----  -----  -----  -----
SERVER : sds [13]
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt0/h001
   *RDAREA NAME :RDMASTER [15]
         *LN1*    67    142      0     85     85      8      7      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt0/h002
   *RDAREA NAME :RDDIR01
         *LN1*    67    116      0     81     81      8      7      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt0/h003
   *RDAREA NAME :RDDIC01
         *LN1*   824  2.15k      0  2.00k  2.00k     19     19      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt1/u001
   *RDAREA NAME :RU01
         *LN1*   256    483      0    401    401     23     22      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt2/u002
   *RDAREA NAME :RU02
         *LN1*   261    501      0    416    416     26     25      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt3/u003
   *RDAREA NAME :RU03
         *LN1*   254    467      0    384    384     23     22      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt4/u001
   *RDAREA NAME :RULOB01
         *LN1*    16     43      0     33     33      4      4      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt4/u002
   *RDAREA NAME :RULOB02
         *LN1*    16     43      0     33     33      4      4      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt4/u011
   *RDAREA NAME :RUBLOB01
         *LN1*    30     59      0      0      0      7      7      0
 *FILE NAME : /DB6G/si1/kado/single/pddir/iospt4/u012
   *RDAREA NAME :RUBLOB02
         *LN1*     0      0      0      0      0      0      0      0
 *TOTAL* [16]
         *LN1* 1.79k  4.00k      0  3.43k  3.43k    122    117      0
-----------------------------------------------------------------------------
FILE KIND   LOG KIND   FIRST                 LAST                         NUM
STJ         fil        1996/10/30 10:38:19   1996/10/30 12:31:45          440
-----------------------------------------------------------------------------
 

Explanation
  1. Name of input statistics unload file or name of the directory containing the input statistics unload file (maximum of 58 bytes)
  2. Output range (output start date/time to output end date/time)
  3. Name of host requesting output of statistical information about HiRDB files for database manipulation
  4. Edit period (collection start time to collection end time)
  5. Synchronous READs count
    This is the number of times pages were read from the HiRDB file in the synchronous mode.
  6. Synchronous WRITEs count
    This is the number of times pages were written to the HiRDB file in the synchronous mode.
  7. Information used by the system (not by users).
  8. Asynchronous WRITEs count
    This is the number of times pages were written to the HiRDB file in the asynchronous mode.
    This value is the sum of the following values:
    • Number of times pages were written to the HiRDB file during deferred write trigger processing
    • Number of times pages were written to the HiRDB file during synchronization point dump
  9. Information used by the system (not by users).
  10. Open operations count
    This is the number of times HiRDB file open processing was executed.
  11. Close operations count
    This is the number of times HiRDB file close processing was executed.
  12. Input/output errors count
    This is the number of times an error occurred during HiRDB file input/output operations.
  13. Server name
    This is the name of server requesting output of statistical information about HiRDB files for database manipulation.
  14. Name of HiRDB file#
    This is the name of the HiRDB for which statistical information was edited.
  15. Name of RDAREA
    This is the name of RDAREA using the corresponding HiRDB file.
  16. Totals for each item

#
This item might be blank if the open attribute of the RDAREA indicated in 15 is not INITIAL and this RDAREA has never been accessed. Ignore a record whose value for this item is blank. You can check the HiRDB files that constitute the RDAREA by using the database condition analysis utility with -k phys -f specified.