Monitoring
View Information about a Database
Use the vwinfo command to display information about a database that uses Vector 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 (see X100 Configuration Parameters) 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
To limit the output to a specified table, use the ‑t (or ‑‑table) option, as follows:
vwinfo ‑T ‑t tablename dbname
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: 11/09/2022