Use this report to view information about the Instances within your environment. Some of the following fields are not available for all RDBMSs:
Field Name |
Description |
RDBMS Type |
RDBMS under which an Instance is running (e.g., Sybase, Oracle, SQL Server, etc.) |
Name |
name of an Instance |
Version |
version of the RDBMS under which an Instance is running |
Home Directory |
full path of the Oracle or Sybase home directory |
Logonid |
login ID that Tivoli Storage Resource Manager uses when logging into an Instance |
Port |
port on which an Instance listens for requests |
Number of Databases |
number of databases associated with an Instance |
Number of Devices |
number of devices associated with an Instance |
Number of Data Files |
number of data files associated with an Instance |
Number of Fragments |
number of fragments associated with an Instance |
Number of Log Files |
number of log files associated with an Instance |
Number of Log Fragments |
number of log fragments associated with an Instance |
Total Size of all Storage |
amount of storage space allocated to an Instance |
Mirror Overhead |
amount of storage space allocated to the mirrored devices in an Instance |
Capacity of Data Files |
amount of space allocated to the data files associated with an Instance |
Free Space of Data Files |
amount of free space available on the data files associated with an Instance |
Capacity of Data Fragments |
amount of space allocated to the data fragments associated with a Sybase Instance |
Free Space in Data Fragments |
amount of free space available on the data fragments associated with a Sybase Instance |
Capacity of Log Files |
amount of space allocated to the log files associated with an Instance |
Free Space of Log Files |
amount of free space available on the log files associated with an Instance |
Capacity of Log Fragments |
amount of space allocated to the log fragments associated with a Sybase Instance |
Free Space in Log Fragments |
amount of free space available on the log fragments associated with a Sybase Instance |
Probe Status |
status of the last Probe run against an Instance |
Last Probe Time |
date/time when an Instance was last probed |
Field Name |
Description |
Name |
name of the Instance under which the database is running |
Block Size |
amount of storage space allocated to each of the blocks in a database |
Log Mode |
indicates whether the database is creating archived logs |
Status |
indicates the status of a database, such as Read, Write, etc. |
Maximum Number of Instances |
maximum number of instances for a parallel server environment |
Maximum Number of Tablespaces |
number of tablespaces associated with a database |
Maximum Number of Data Files |
maximum number of data files that can be created in a database (as defined in the control file) |
Number of Data Files |
number of data files associated with a database |
Maximum Number of Log Files |
maximum number of log files that can be created in a database (as defined in the control file) |
Number of Log Files |
number of log files associated with a database |
Total Size of All Storage |
total amount of storage space consumed by a database |
Capacity of Data Files |
amount of storage space allocated to the data files associated with all the Oracle Instances |
Free Space of Data Files |
amount of unused storage space in a database's data files |
Create Time |
date/time when a database was created |
Discovered Time |
date/time when a database was discovered by Tivoli Storage Resource Manager |
Dropped Time |
date/time when a database was dropped |