wtdbspace [-R rim_object_name] [-t temp_dev_name,...] [-d data_dev_name,... | -T ]

The wtdbspace command provides statistics about used and free space in the event database.

1. This must be run on the event server, unless noted otherwise.
2. The system where this command is run must have the bash, perl, and wrimsql programs available, unless noted otherwise. Run this program from bash.

If you use an Informix database, you must run the wtdbspace script as the Tivoli Enterprise Console Informix user on the system that has the Informix database server installed, and the database environment must be sourced. If the Informix server is on a different system than the event server, you must copy the wtdbspace script (located in the $BINDIR/bin directory on the event server) to the Informix server or make the script available by an NFS mount. The wrimsql command is not needed when running wtdbspace on the Informix database server.

If you use an DB2 database, you must run the wtdbspace script as the Tivoli Enterprise Console DB2 user on the RIM host from the DB2 command line processor, and the database environment must be sourced. If the RIM host is on a different system than the Tivoli Enterprise Console server, you must copy the wtdbspace script (located in the $BINDIR/bin directory on the event server) and the db2_runstats script (located in the $BINDIR/TME/TEC/sql directory on the event server) to the DB2 server or make the scripts available by an NFS mount. The wrimsql command is not needed when you are running the wtdbspace command for a DB2 database.

user

 

-d data_dev_name,...

The names of the data devices to report on. The following table indicates the data device types for each product:

Product	Data device types
DB2	table space names
Informix	dbspace names
Microsoft SQL Server	file group names
Oracle	table space names
Sybase	logical device names

Each name is separated by a comma or a space. If using spaces to separate names, the entire list should be enclosed in double quotation marks. If no names are specified, then all device names in the database are reported on.

This command supports the use of the asterisk character as a matching character. It can be used at the the beginning of a name, the end, or both. For example, to specify a list of data devices that all begin with "tec", specify "tec*" for data_dev_name.

-R rim_object_name

The name of the RIM object. The default value is tec.

-t temp_dev_name,...

The name of the temporary devices to report on. The following table indicates the temporary devices for each product:

Product	Temporary Devices
DB2	temporary table spaces defined for the database
Informix	DBSPACETEMP
Microsoft SQL Server	TEMPDB
Oracle	temporary table spaces defined for the database
Sybase	TEMPDB

Each name is separated by a comma. If no names are specified, then all temporary devices named in the database are reported on.

This command supports the use of the asterisk character as a matching character. It can be used at the the beginning of a name, the end, or both. For example, to specify a list of temporary devices that all begin with "tec", specify "tec*" for temp_dev_name.

-T

Shows all Tivoli Enterprise Console data devices and all temporary data devices. This parameter cannot be used with the -d parameter.

The following example shows the space used for a RIM object named mssql_tec and shows the information for data devices TEC_DATA1 and TEC_DATA2 and temporary devices TEC_TEMP1 and TEC_TEMP2:

wtdbspace -R mssql_tec -d TEC_DATA2,TEC_TEMP2 -t "TEC_TEMP1 TEC_TEMP2"

The following example shows the space used for the RIM object for data devices that begin with the letters "TEC" and the temporary devices that begin with the letters "TEC":

wtdbspace -d TEC* -t TEC*