SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)
Enhancing SQL/MX Database Performance
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
15-12
Using SCF STATS DISK to Monitor SQL/MX
Statistics and Reuse Failures
For information about methods for reducing the incidence of reuse failures in an
SQL/MX buffer, see Strategies for Reducing Reuse Failures
on page 15-14.
Publish/Subscribe counters
4-> stats disk $data02,sqlmx
STORAGE - Stats DISK \DMR15.$DATA02
The following are the Publish/Subscribe counters:
Publish/Subscribe bytes.. 54765 KB
Max Subscribers.......... 512 Keys In Use...... 0
Subscribers Active....... 0 Resyncs.......... 0
Maximum Tables........... 512
Tables Active............ 0
Publish/Subscribe bytes denote the number of kilo bytes allocated for
publish/subscribe events.
Max Subscribers denote the maximum number of subscribers allowed per disk
volume (512).
Subscribers Active denote the number of active subscribers.
Maximum Tables denote the maximum number of tables allowed per disk volume
for publish/subscribe operations (512).
Tables Active denote the number of tables on the disk with atleast one active
subscriber.
Keys In Use – NonStop Data Access Manager (DAM) adds an entry into a list if the
position of a streaming cursor in the table logically succeeds the position of the
newly published row. Keys in Use denote the number of keys in this list and can be
either a primary key, clustering key, or a system generated key.
Resyncs is not used currently. 0 is always displayed against this field.
DP2 Savepoint counters
The following are the DP2 Savepoint counters:
Savepoint Buffer Data.... 1024 KB Max.............. 16384 KB
- 16KB Blocks - - - - - - - - - - - Failures - - - - - - - -
Max...................... 16 SavePoint Limit.. 12
In Use................... 0 Buffer Full...... 0
Memory Pressure.. 0
No Memory........ 0
Savepoint Buffer Data denotes the current size of buffer allocated to hold savepoint
data. The value is in KB. The minimum value is 1024KB.