The QUERY SYSTEM command combines multiple queries of your Tivoli® Storage
Manager system into
a single command. This command can be used to collect statistics and
provide information for problem analysis by IBM service.
About this task
When you enter the QUERY SYSTEM command, the server issues
the following queries:
- QUERY ASSOCIATION
- Displays all client nodes that are associated with one or more
client schedules
- QUERY COPYGROUP
- Displays all backup and archive copy groups (standard format)
- QUERY DB
- Displays information about the database (detailed format)
- QUERY DBSPACE
- Displays display information about the directories used by the
database.
- QUERY DEVCLASS
- Displays all device classes (detailed format)
- QUERY DOMAIN
- Displays all policy domains (standard format)
- QUERY LOG
- Displays information about the recovery log (detailed format)
- QUERY MGMTCLASS
- Displays all management classes (standard format)
- QUERY OPTION
- Displays all server options
- QUERY PROCESS
- Displays information about all active background processes
- QUERY SCHEDULE
- Displays client schedules (standard format)
- QUERY SESSION
- Displays information about all administrative and client node
sessions in standard format
- QUERY STATUS
- Displays general server parameters, such as those defined by SET
commands
- QUERY STGPOOL
- Displays information about all storage pools (detailed format)
- QUERY VOLUME
- Displays information about all storage pool volumes (standard
format)
- QUERY VOLHISTORY
- Displays sequential volume history information that has been collected
by the server.
- SELECT
- Displays the results of two SQL queries:
select platform_name,count(*) from nodes group by platform_name
select stgpool_name,devclass_name,count(*) from volumes
group by stgpool_name,devclass_name
The first command
displays the number of client nodes by platform.
The second
command displays the name and associated device class of all storage
pools having one or more volumes assigned to them.