wtdbspace

wtdbspace ORACLE Tablespace Usage: Tablespace Used for Allocated Used Free %Used %Free ------------------ ---------------- --------------- ------------ ------------ ----------- ----------- CM_TS Data 1500 MB 111.87 MB 1388.06 MB 7.45 % 92.54 % CWMLITE Data 20 MB 9.31 MB 10.62 MB 46.55 % 53.45 % DRSYS Data 20 MB 9.62 MB 10.31 MB 48.10 % 51.89 % EXAMPLE Data 200 MB 137.68 MB 62.25 MB 68.84 % 31.15 % INDX Data 25 MB 0 MB 24.93 MB 0 % 100 % ODM Data 20 MB 9.31 MB 10.62 MB 46.55 % 53.45 % SYSTEM Data 600 MB 413.93 MB 186 MB 68.98 % 31.01 % TEMP Temporary 400 MB 0 MB 0 MB 0 % 100 % TOOLS Data 10 MB 0 MB 9.93 MB 0 % 100 % TS_EVT_REP Data 300 MB 83.68 MB 216.25 MB 27.89 % 72.10 % TS_INDEXES Data 800 MB 405.12 MB 394.81 MB 50.63 % 49.36 % TS_REC_LOG Data 250 MB 9.43 MB 240.5 MB 3.77 % 96.23 % TS_REST_DATA Data 200 MB 9 MB 190.93 MB 4.5 % 95.5 % TS_SLOTS_TASK Data 500 MB 222.18 MB 277.75 MB 44.43 % 55.57 % UNDOTBS1 Data 2045 MB 22.17 MB 2022.68 MB 1.08 % 98.92 % USERS Data 25 MB 0.56 MB 24.37 MB 2.24 % 97.76 % XDB Data 65 MB 44.18 MB 20.75 MB 67.96 % 32.04 % Table Details: Name Rows Data pages Index pages -------------------- ------------ ------------------- ------------------- TEC_T_ASSIGN_EG 6 1024 KB 1024 KB TEC_T_ASSIGN_OP 2 1024 KB 1024 KB TEC_T_CONSOLES 3 1024 KB 1024 KB TEC_T_EG_WHRCLAUSE 6 1024 KB 1024 KB TEC_T_ENUMERATIONS 14 1024 KB 1024 KB TEC_T_EVENT_GROUPS 6 1024 KB 1024 KB TEC_T_EVT_REC_LOG 14319 9664 KB 1024 KB TEC_T_EVT_REP 5332 85696 KB 27008 KB TEC_T_GEM_THRESHLD 0 1024 KB 1024 KB TEC_T_ISA 1344 1024 KB 1024 KB TEC_T_OPERATORS 4 1024 KB 1024 KB TEC_T_SLOTS_EVT 97143 226496 KB 346752 KB TEC_T_TASK_REP 34 1024 KB 1024 KB ------------------- ------------------- 332096 KB 385024 KB Table Name Tablespace Index Name Tablespace -------------------- ------------------ -------------------- ------------------ TEC_T_ASSIGN_EG TS_REST_DATA TEC_ASIGNEGCON_IDX TS_INDEXES TEC_ASIGNEGEG_IDX TS_INDEXES TEC_T_ASSIGN_OP TS_REST_DATA TEC_ASIGNOPCON_IDX TS_INDEXES TEC_ASIGNOPOP_IDX TS_INDEXES TEC_T_CONSOLES TS_REST_DATA TEC_I_CONSOLES TS_INDEXES TEC_T_EG_WHRCLAUSE TS_REST_DATA TEC_I_EG_WHRCLAUSE TS_INDEXES TEC_T_ENUMERATIONS TS_REST_DATA TEC_I_ENUMERATIONS TS_INDEXES TEC_T_EVENT_GROUPS TS_REST_DATA TEC_I_EVENT_GROUPS TS_INDEXES TEC_T_EVT_REC_LOG TS_REC_LOG TEC_I_EVT_REC_LOG TS_INDEXES TEC_T_EVT_REP TS_EVT_REP TEC_EVTRP_LMOD_IDX TS_INDEXES TEC_I_EVT_REP TS_INDEXES TEC_T_GEM_THRESHLD TS_REST_DATA TEC_IDX_GEM_1 TS_INDEXES TEC_T_ISA TS_REST_DATA TEC_ISA_CHILD_IDX TS_INDEXES TEC_ISA_PARENT_IDX TS_INDEXES TEC_T_OPERATORS TS_REST_DATA TEC_I_OPERATORS TS_INDEXES TEC_T_SLOTS_EVT TS_SLOTS_TASK TEC_I_SLOTS_EVT TS_INDEXES TEC_T_TASK_REP TS_SLOTS_TASK TEC_I_TASK_REP TS_INDEXES

Syntax

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

Description

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

Notes:

This must be run on the event server, unless noted otherwise.
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.

Authorization

user

Options

-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.

Examples

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*

Copyright © 1996-2009 by Dr. Nikolai Bezroukov. www.softpanorama.org was created as a service to the UN Sustainable Development Networking Programme (SDNP) in the author free time. Submit comments This document is an industrial compilation designed and created exclusively for educational use and is placed under the copyright of the Open Content License(OPL). Site uses AdSense so you need to be aware of Google privacy policy. Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.

Disclaimer:

The statements, views and opinions presented on this web page are those of the author and are not endorsed by, nor do they necessarily reflect, the opinions of the author present and former employers, SDNP or any other organization the author may be associated with.
We do not warrant the correctness of the information provided or its fitness for any purpose
In no way this site is associated with or endorse cybersquatters using the term "softpanorama" with other main or country domains (e.g. softpanorama.com) with bad faith intent to profit from the goodwill belonging to someone else.

Last modified: September 15, 2009