Use the QUERY STATUS command to display information about system parameters.
Use this command for the following reasons:
- To display the service level of the server
- To display information about the general server parameters, such as those defined by the SET commands
- To request information about client sessions, such as the availability of the server, password authentication, accounting settings, or the retention period for the information retained in the activity log
- To display information about the central scheduler, such as the central scheduling mode of the server
- To display the maximum number of repeated attempts that are allowed after a failed attempt to execute a scheduled command
- To display whether sub-files can be backed up to this server, as indicated by the SET SUBFILE command
Privilege class
Any administrator can issue this command.
Parameters
None.
Example: Query the status of a configuration manager
Display general information about server parameters. The command is issued from a configuration manager. For descriptions of displayed fields, see Field descriptions.query statusYou can also use the QUERY STATUS command to display information about the target replication server. The command is issued from a target replication server.
query status
Server Name: SERVER1
Server host name or IP address: 9.115.44.121
Server TCP/IP port number: 5511
Server URL:
Crossdefine: Off
Server Password Set: Yes
Server Installation Date/Time: October 12, 2008 07:18:16 AM
Server Restart Date/Time: October 12, 2008 01:05:35 PM
Authentication: On
Password Expiration Period: 90 Day(s)
Invalid Sign-on Attempt Limit: 0
Minimum Password Length: 0
Registration: Closed
Subfile Backup: No
Inbound Sessions Disabled: DRSERVER1 DRSERVER2
Outbound Sessions Disabled: DRSERVER2 DRSERVER3
Availability: Enabled
Accounting: Off
Activity Log Retention: 1 Day(s)
Activity Summary Retention Period:
Activity Log Number of Records: 15,623
Activity Log Size: 18 M
License Audit Period: 30 Day(s)
Last License Audit: October 12, 2008 07:43:35 AM
Server License Compliance: Valid
Central Scheduler: Active
Maximum Sessions: 25
Maximum Scheduled Sessions: 12
Event Record Retention Period: 10 Day(s)
Client Action Duration: 5 Day(s)
Schedule Randomization Percentage: 25
Query Schedule Period: Client's Choice
Maximum Command Retries: Client's Choice
Retry Period: Client's Choice
Client-side Deduplication Verification Level: 0%
Scheduling Modes: Any
Active Receivers: CONSOLE ACTLOG
Configuration manager: On
Refresh interval: 60
Last refresh date/time: October 12, 2008 07:43:45 AM
Context Messaging: On
Table of Contents (TOC) Load Retention: 120 Minute(s)
Machine Globally Unique ID:
Archive Retention Protection: Off
Database Reporting Mode: Partial
Database Directories: c:\tsm_data\db_stg,
e:\tsm_data\db_stg,g:\storage\db_stg
Database Total Space: 3,497,600
Database Used Space: 2,856,645.5
Database Free Space: 320,477.281
Free Space Available (MB): 17,725.25
Encryption Strength: AES
Client CPU Information Refresh Interval: 180
OutBound Replication: Enabled
Target Replication Server: DRSERVER
Default Replication Rule for Backup: ALL_DATA
Default Replication Rule for Archive: ALL_DATA
Default Replication Rule for Space Managed: ALL_DATA
Replication Record Retention Period: 14 Day(s)
LDAP User: cn=tsmserver,cn=Users,dc=ibm,dc=com
LDAP Password Set: Yes
Default Authentication: LDAP
Failover High Level Address: 9.230.99.66
Server Name: SERVER1
Server host name or IP address: 9.115.44.121
Server TCP/IP port number: 5511
Server URL:
Crossdefine: Off
Server Password Set: Yes
Server Installation Date/Time: October 12, 2008 07:18:16 AM
Server Restart Date/Time: October 12, 2008 01:05:35 PM
Authentication: On
Password Expiration Period: 90 Day(s)
Invalid Sign-on Attempt Limit: 0
Minimum Password Length: 0
Registration: Closed
Subfile Backup: No
Inbound Sessions Disabled: DRSERVER1 DRSERVER2
Outbound Sessions Disabled: DRSERVER2 DRSERVER3
Availability: Enabled
Accounting: Off
Activity Log Retention: 1 Day(s)
Activity Summary Retention Period:
Activity Log Number of Records: 15,623
Activity Log Size: 18 M
License Audit Period: 30 Day(s)
Last License Audit: October 12, 2008 07:43:35 AM
Server License Compliance: Valid
Central Scheduler: Active
Maximum Sessions: 25
Maximum Scheduled Sessions: 12
Event Record Retention Period: 10 Day(s)
Client Action Duration: 5 Day(s)
Schedule Randomization Percentage: 25
Query Schedule Period: Client's Choice
Maximum Command Retries: Client's Choice
Retry Period: Client's Choice
Client-side Deduplication Verification Level: 0%
Scheduling Modes: Any
Active Receivers: CONSOLE ACTLOG
Configuration manager: On
Refresh interval: 60
Last refresh date/time: October 12, 2008 07:43:45 AM
Context Messaging: On
Table of Contents (TOC) Load Retention: 120 Minute(s)
Machine Globally Unique ID:
Archive Retention Protection: Off
Database Reporting Mode: Partial
Database Directories : /space/trible/db2/cn_db2/dbp
ath1,/space/trible/db2/cn_db
2/dbpath2
Database Total Space : 3,497,600
Database Used Space : 2,856,645.5
Database Free Space : 320,477.281
Free Space Available (MB): 17,725.25
Encryption Strength: AES
Client CPU Information Refresh Interval: 180
OutBound Replication: Enabled
Target replication server: DRSERVER
Default Replication Rule for Backup: ALL_DATA
Default Replication Rule for Archive: ALL_DATA
Default Replication Rule for Space Managed: ALL_DATA
Replication Record Retention Period: 14 Day(s)
LDAP User: uid=tsmserver,ou=Users,cn=aixdata
LDAP Password Set: Yes
Default Authentication: LDAP
Failover High Level Address: 9.230.99.66
Server Name: SERV1
Server host name or IP address: 9.115.44.121
Server TCP/IP port number: 1699
Server URL:
Crossdefine: On
Server Password Set: Yes
Server Installation Date/Time: 10/30/2008 01:27:01 PM
Server Restart Date/Time: 10/30/2008 01:27:37 PM
Authentication: On
Password Expiration Period: 90 Day(s)
Invalid Sign-on Attempt Limit: 0
Minimum Password Length: 0
Registration: Closed
Subfile Backup: No
Inbound Sessions Disabled: DRSERVER1 DRSERVER2
Outbound Sessions Disabled: DRSERVER2 DRSERVER3
Availability: Enabled
Accounting: Off
Activity Log Retention: 5 Day(s)
Activity Summary Retention Period: 30 Day(s)
Activity Log Number of Records: 15,623
Activity Log Size: 18 M
License Audit Period: 30 Day(s)
Last License Audit: 10/30/2008 01:27:03 PM
Server License Compliance: Valid
Central Scheduler: Active
Maximum Sessions: 25
Maximum Scheduled Sessions: 12
Event Record Retention Period: 10 Day(s)
Client Action Duration: 5 Day(s)
Schedule Randomization Percentage: 25
Query Schedule Period: Client
Maximum Command Retries: Client
Retry Period: Client
Client-side Deduplication Verification Level: 0%
Scheduling Modes: Any
Active Receivers: CONSOLE ACTLOG
Configuration manager: Off
Refresh interval: 60
Last refresh date/time:
Context Messaging: Off
Table of Contents(TOC) Load Retention: 120 Minute(s)
Machine Globally Unique ID:
Archive Retention Protection: Off
Database Reporting Mode: Partial
Database Directories: /space/trible/db2/cn_db2/dbp
ath1,/space/trible/db2/cn_db
2/dbpath2
Database Total Space: 3,497,600
Database Used Space: 2,856,645.5
Database Free Space: 320,477.281
Free Space Available (MB): 17,725.25
Encryption Strength: AES
Client CPU Information Refresh Interval: 180
OutBound Replication: Enabled
Target replication server: DRSERVER
Default Replication Rule for Backup: ALL_DATA
Default Replication Rule for Archive: ALL_DATA
Default Replication Rule for Space Managed: ALL_DATA
Replication Record Retention Period: 14 Day(s)
LDAP User: uid=tsmserver,ou=Users,cn=aixdata
LDAP Password Set: Yes
Default Authentication: LDAP
Failover High Level Address: 9.230.99.66Field descriptions
- Server Name
- Specifies the name of the server.
- Server host name or IP address
- Specifies the server TCP/IP address.
- Server TCP/IP port number
- Specifies the server port address.
- Server URL
- Specifies the URL address of the server that issued this command.
- Crossdefine
- Specifies whether another server running the DEFINE SERVER command automatically defines itself to this server. See the SET CROSSDEFINE command.
- Failover High Level Address
- Specifies the high level address for the failover server that is used by the client. Client restore operations fail over to this high level address when the interface that is used by the client is different from the interface used by replication.
- Server Password Set
- Specifies whether the password has been set for the server.
- Server Installation Date/Time
- Specifies the date and time when the server was installed.
- Server Restart Date/Time
- Specifies the last date and time when the server was started.
- Authentication
- Specifies whether password authentication is set on or off.
- Password Expiration Period
- Specifies the period, in days, after which the administrator or client node password expires.
- Invalid Sign-on Attempt Limit
- Specifies the number of invalid sign-on attempts before a node is locked.
- Minimum Password Length
- Specifies the minimum number of characters for the password.
- Registration
- Specifies whether client node registration is open or closed.
- Subfile Backup
- Specifies whether subfiles can be backed up to this server, as indicated by the SET SUBFILE command.
- Inbound Sessions Disabled
- Specifies the names of servers from which server-to-server communications are not allowed. To enable inbound server sessions, use the ENABLE SESSIONS command.
- Outbound Sessions Disabled
- Specifies the names of servers to which server-to-server communications are not allowed. To enable outbound server sessions, use the ENABLE SESSIONS command.
- Availability
- Specifies whether the server is enabled or disabled.
- Accounting
- Specifies whether an accounting record is generated at the end of each client node session.
- Activity Log Retention
- Specifies the number of days information is retained in the activity log, or the size of the log.
- Activity Summary Retention Period
- Specifies the number of days information is retained in the SQL activity summary table.
- Activity Log Number of Records
- Specifies the number of records in the activity log.
- Activity Log Size
- Specifies the size of the activity log.
- License Audit Period
- Specifies the period, in days, after which the license manager automatically audits the Tivoli® Storage Manager license. Additional licensing information is available by using the QUERY LICENSE command.
- Last License Audit
- Specifies the date and time when the last license audit occurred. Additional licensing information is available by using the QUERY LICENSE command.
- Server License Compliance
- Specifies whether the server is in compliance (Valid) or out of compliance (Failed) with the license terms. Use the QUERY LICENSE command to see what factors are causing the server to fail to comply with the license terms.
- Central Scheduler
- Specifies whether central scheduling is running (active or inactive).
- Maximum Sessions
- Specifies the maximum number of client/server sessions.
- Maximum Scheduled Sessions
- Specifies the maximum number of client/server sessions available for processing scheduled work.
- Event Record Retention Period
- Specifies the number of days central scheduler event records are retained.
- Client Action Duration
- Specifies the duration of the period during which the client processes the schedule defined with the DEFINE CLIENTACTION command.
- Schedule Randomization Percentage
- Specifies how much of the startup window is used for running scheduled events in client-polling mode.
- Query Schedule Period
- Specifies the frequency with which clients poll the server to obtain scheduled work, in client-polling mode. If the value in this field is Client, the polling frequency is determined by the client node.
- Maximum Command Retries
- Specifies the maximum number of times that a client scheduler tries to run a scheduled command after a failed attempt. If the value in this field is Client, the client node determines the maximum number.
- Retry Period
- Specifies the number of minutes between failed attempts by the client scheduler to contact the server or to run a scheduled command. If the value in this field is Client, the client node determines the number of minutes.
- Client-side Deduplication Verification Level
- Specifies a percentage of extents to be verified by the Tivoli Storage Manager server. The extents are created during client-side data deduplication.
- Scheduling Modes
- Specifies the central scheduling modes supported by the server.
- Active Receivers
- Specifies the receivers for which event logging has begun.
- Configuration manager
- Specifies whether the server is a configuration manager.
- Refresh interval
- Specifies the interval that elapses before the managed server requests a refresh of any changes from a configuration manager.
- Last refresh date/time
- If the server is a managed server, specifies the date and time of the last successful refresh of configuration information from the configuration manager.
- Context Messaging
- Specifies whether context messaging is enabled or disabled.
- Table of Contents (TOC) Load Retention
- Specifies the approximate number of minutes that unreferenced TOC data are retained in the database.
- Machine Globally Unique ID
- The globally unique identifier (GUID) as of the last time that the server was started. This GUID identifies the host system to which the current server belongs.
- Archive Retention Protection
- Specifies if archive data retention protection is activated or deactivated.
- Database Reporting Mode
- Specifies the level of database diagnostic reporting to be presented
on the service console and activity log.
- None
- Specifies that no database diagnostic reporting is performed. This setting should not normally be used.
- Partial
- Specifies that the only events that are reported are those that are exceptions and that might represent errors. This is the default.
- Full
- Specifies that all database diagnostic information is reported. This includes information that is normal and expected.
- Database Directories
- Specifies the locations of the database directories.
- Database Total Space
- Specifies the total amount of space that is available, both used and free, in megabytes.
- Database Used Space
- Specifies the total amount of space currently in use, in megabytes.
- Database Free Space
- Specifies the space remaining in the file system where the path is located.
- Encryption Strength
- Indicates data encryption strength: AES or DES.
- Client CPU Information Refresh Interval
- Specifies the number of days that elapse between client scans for CPU information that is used for PVU estimation.
- Outbound replication
- Specifies whether replication processing is enabled or disabled. If outbound replication is disabled, new replication processes cannot start on the server.
- Target replication server
- Specifies the name of the server that is the target for node replication operations. If a target replication server does not exist, this field is blank.
- Default Replication Rule for Backup
- Specifies the server replication rule that applies to backup data.
The following values are possible:
- ALL_DATA
- Replicates active and inactive backup data. The data is replicated with a normal priority.
- ACTIVE_DATA
- Replicates only active backup data. The data is replicated with a normal priority.
- ALL_DATA_HIGH_PRIORITY
- Replicates active and inactive backup data. The data is replicated with a high priority.
- ACTIVE_DATA_HIGH_PRIORITY
- Replicates only active backup data. The data is replicated with a high priority.
- NONE
- Backup data is not replicated.
- Default Replication Rule for Archive
- Specifies the server replication rule that applies to archive
data. The following values are possible:
- ALL_DATA
- Replicates archive data. The data is replicated with a normal priority.
- ALL_DATA_HIGH_PRIORITY
- Replicates archive data. The data is replicated with a high priority.
- NONE
- Archive data is not replicated.
- Default Replication Rule for Space Managed
- Specifies the server replication rule that applies to space-managed
data. The following values are possible:
- ALL_DATA
- Replicates space-managed data. The data is replicated with a normal priority.
- ALL_DATA_HIGH_PRIORITY
- Replicates space-managed data. The data is replicated with a high priority.
- NONE
- Space-managed data is not replicated.
- Replication Record Retention Period
- Specifies the number of days that replication history records are retained in the database of the source replication server.
- Default Authentication
- Specifies the default password authentication method: LOCAL or
LDAP. When you issue the SET DEFAULTAUTHENTICATION command, you define the resulting authentication method for all REGISTER ADMIN and REGISTER NODE commands. The default is LOCAL.
Authentication Target Authentication Method Tivoli Storage Manager server LOCAL LDAP directory server LDAP - LDAP Password Set
- This output field shows if a password is defined for the user ID that is named in the SET LDAPUSER command. The values are YES and NO. If YES, the user ID that is named in the SET LDAPUSER command can issue administrative commands on the LDAP namespace reserved for Tivoli Storage Manager. If NO, issue the SET LDAPPASSWORD command to set the password for the user ID that is named in the SET LDAPUSER command.
- LDAP User
- Specifies the user ID that is named in the SET LDAPUSER command. This user ID can issue administrative commands on the namespace reserved for Tivoli Storage Manager on the LDAP directory server.
Related commands
| Command | Description |
|---|---|
| BEGIN EVENTLOGGING | Starts event logging to a specified receiver. |
| DISABLE REPLICATION | Prevents outbound replication processing on a server. |
| DISABLE SESSIONS | Prevents new sessions from accessing Tivoli Storage Manager but permits existing sessions to continue. |
| ENABLE REPLICATION | Allows outbound replication processing on a server. |
| ENABLE SESSIONS | Resumes server activity following the DISABLE command or the ACCEPT DATE command. |
| END EVENTLOGGING | Ends event logging to a specified receiver. |
| QUERY LICENSE | Displays information about licenses and audits. |
| SET ACCOUNTING | Specifies whether accounting records are created at the end of each client session. |
| SET ACTLOGRETENTION | Specifies the number of days to retain log records in the activity log. |
| SET AUTHENTICATION | Specifies whether clients are prompted for a password at the beginning of a session. |
| SET CONTEXTMESSAGING | Specifies to turn on context messaging to debug an ANR9999D message. |
| SET CPUINFOREFRESH | Specifies the number of days between client scans for workstation information used for PVU estimates. |
| SET CROSSDEFINE | Specifies whether to cross define servers. |
| SET DEDUPVERIFICATIONLEVEL | Specifies the percentage of extents verified by the server during client-side deduplication. |
| SET DEFAULTAUTHENTICATION | Specifies the default password authentication method for any REGISTER NODE or REGISTER ADMIN commands. |
| SET EVENTRETENTION | Specifies the number of days to retain records for scheduled operations. |
| SET LDAPPASSWORD | Sets the password for the LDAPUSER. |
| SET LDAPUSER | Sets the user who oversees the passwords and administrators on the LDAP directory server. |
| SET MAXCMDRETRIES | Specifies the maximum number of retries after a failed attempt to execute a scheduled command. |
| SET MAXSCHEDSESSIONS | Specifies the maximum number of client/server sessions available for processing scheduled work. |
| SET PASSEXP | Specifies the number of days after which a password is expired and must be changed. |
| SET QUERYSCHEDPERIOD | Specifies the frequency for clients to obtain scheduled work, in client-polling mode. |
| SET RANDOMIZE | Specifies the randomization of start times within a window for schedules in client-polling mode. |
| SET REGISTRATION | Specifies whether users can register themselves or must be registered by an administrator. |
| SET RETRYPERIOD | Specifies the time between retry attempts by the client scheduler. |
| SET CONTEXTMESSAGING | Specifies to turn on context messaging to debug an ANR9999D message. |
| SET SCHEDMODES | Specifies the central scheduling mode for the server. |
| SET SERVERHLADDRESS | Specifies the high-level address of a server. |
| SET SERVERLLADDRESS | Specifies the low-level address of a server. |
| SET SERVERNAME | Specifies the name by which the server is identified. |
| SET SERVERPASSWORD | Specifies the server password. |
| SET SUMMARYRETENTION | Specifies the number of days to retain information for the activity summary table. |
| SET TOCLOADRETENTION | Specifies the number of minutes to retain information for unreferenced TOC sets. |