
HP NonStop Shadowbase Command Definitions
Database Specification Command Descriptions
HP NonStop Shadowbase Command Reference Manual—785421-002
207
COLLNAME – The COLLNAME option allows for displaying only statistics
for DBSs of CONS fed from the specified COLL.
MATRIX – If the MATRIX option is specified, the statistics are output in the
more detailed matrix format used by the STATS AUD, DETAIL and
ESTATS AUD commands for the CONS FILE STATS and CONS DBS
STATS sections. By default, the new simpler format is used.
In order to display statistics at the file level for all DBSs for the CONS
object CON1, for example, the following command would be used:
ESTATS DBS *, FILESTATS, CONSNAME CON1
An example of the format of the output of the ESTATS DBS command
with the ALL option (the default) is shown here:
+ESTATS DBS *
ESTATS DBS AT 02-04 14:50:10
===============================================================================
-----------------------------------DBS STATS----------------------------------
SYSTEM: \H2
COLL JZCL2
CONS JZCN2
DBS: PPDF4DDLDBS
EVENT TYPE DO UNDO TRANSFORMED IGNORED
-------------- ----------- ----------- ----------- -----------
INSERT 2 0 0 0
UPDATE 0 0 0 0
U->I INSERT 0 0 0 0
I->U UPDATE 0 0 0 0
DELETE 0 0 0 0
CREATE 0 0 0 0
ALTER 0 0 0 0
PURGE 0 0 0 0
PURGEDATA 0 0 0 0
TOTALS 2 0 0 0
------------------------------------------------------------------------------
-----------------------------------FILE STATS---------------------------------
SYSTEM: \H2
COLL JZCL2
CONS JZCN2
DBS: PPDF4DDLDBS
SOURCE: \H2.$JMZ.TFMNTTGT.SQLTABL2 LEV: 02-04 14:25:42.452
TARGET: \H2.$JMZ.TFMNTTGT.SQLTABL2 LIO: 02-04 14:25:43.468
EVENT TYPE DO UNDO TRANSFORMED IGNORED
-------------- ----------- ----------- ----------- -----------
INSERT 2 0 0 0
UPDATE 0 0 0 0
U->I INSERT 0 0 0 0
I->U UPDATE 0 0 0 0
DELETE 0 0 0 0
CREATE 0 0 0 0
ALTER 0 0 0 0
PURGE 0 0 0 0
PURGEDATA 0 0 0 0
TOTALS 2 0 0 0
------------------------------------------------------------------------------
===============================================================================
Comentarios a estos manuales