Monitoring X100
View Information about a Database
Use the vwinfo command to display information about a database that uses X100 tables.
By default, vwinfo displays various statistics about the database. You can supply options on the command to display other information. Issue vwinfo ‑h to see the list of available options.
To display database statistics
Issue any one of the following commands at the operating system prompt. All these commands produce the same output:
vwinfo dbname
vwinfo -s dbname
vwinfo --stats dbname
Example statistics output is shown under vwinfo Statistics Display.
To display the active configuration for the database
Issue either of these commands, which produce the same output:
vwinfo ‑c dbname
vwinfo ‑‑config dbname
The current configuration settings for the specified database are displayed. Here is an excerpt from a typical output:
+-------------------------------+-------------------------------+
|config |value |
+----------------------------+-----------------------------+
|cbm.block_size |524288 |
|cbm.bufferpool_size |536870912 |
|cbm.compression_lz4_enabled |false |
|cbm.group_size |8 |
+----------------------------+-----------------------------+
To display the disk usage of tables
Issue either of these commands, which produce the same output:
vwinfo ‑T dbname
vwinfo ‑‑table_block_use dbname
Note: To limit the output to a specified table, use the ‑t (or ‑‑table) option, as follows:
vwinfo ‑T ‑t tablename dbname
Note: Here is an excerpt from a typical output:
+------------------------+------------------------+--------------------+
|schema_name |table_name |block_count |
+------------------------+------------------------+--------------------+
|user1 |part | 30|
|user1 |partsupp | 208|
+------------------------+------------------------+--------------------+
Note: Disk usage is shown in the number of disk blocks.
To display the PDT usage of tables
Issue either of these commands, which produce the same output:
vwinfo -M dbname
vwinfo --table_pdt_use dbname
To limit the output to a specified table, use the -t (or --table) option, as follows:
vwinfo -M -t tablename dbname
To display information on open transactions and active sessions
Issue either of these commands, which produce the same output:
vwinfo –o dbname
vwinfo ‑‑open_transactions dbname
Last modified date: 01/30/2023