Asset Reporting - Instances

 

Use this report to view information about the Instances within your environment. Some of the following fields are not available for all RDBMSs:

 

Instance Information tab

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

 

Database Information tab (Oracle only)

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