Softpanorama

May the source be with you, but remember the KISS principle ;-)
Contents Bulletin Scripting in shell and Perl Network troubleshooting History Humor

wtdbspace

wtdbspace Provides space usage statistics for the event database.
 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:

  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.

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*

Etc

FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe this constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit exclusivly for research and educational purposes.   If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner. 

ABUSE: IPs or network segments from which we detect a stream of probes might be blocked for no less then 90 days. Multiple types of probes increase this period.  

Society

Groupthink : Two Party System as Polyarchy : Corruption of Regulators : Bureaucracies : Understanding Micromanagers and Control Freaks : Toxic Managers :   Harvard Mafia : Diplomatic Communication : Surviving a Bad Performance Review : Insufficient Retirement Funds as Immanent Problem of Neoliberal Regime : PseudoScience : Who Rules America : Neoliberalism  : The Iron Law of Oligarchy : Libertarian Philosophy

Quotes

War and Peace : Skeptical Finance : John Kenneth Galbraith :Talleyrand : Oscar Wilde : Otto Von Bismarck : Keynes : George Carlin : Skeptics : Propaganda  : SE quotes : Language Design and Programming Quotes : Random IT-related quotesSomerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose BierceBernard Shaw : Mark Twain Quotes

Bulletin:

Vol 25, No.12 (December, 2013) Rational Fools vs. Efficient Crooks The efficient markets hypothesis : Political Skeptic Bulletin, 2013 : Unemployment Bulletin, 2010 :  Vol 23, No.10 (October, 2011) An observation about corporate security departments : Slightly Skeptical Euromaydan Chronicles, June 2014 : Greenspan legacy bulletin, 2008 : Vol 25, No.10 (October, 2013) Cryptolocker Trojan (Win32/Crilock.A) : Vol 25, No.08 (August, 2013) Cloud providers as intelligence collection hubs : Financial Humor Bulletin, 2010 : Inequality Bulletin, 2009 : Financial Humor Bulletin, 2008 : Copyleft Problems Bulletin, 2004 : Financial Humor Bulletin, 2011 : Energy Bulletin, 2010 : Malware Protection Bulletin, 2010 : Vol 26, No.1 (January, 2013) Object-Oriented Cult : Political Skeptic Bulletin, 2011 : Vol 23, No.11 (November, 2011) Softpanorama classification of sysadmin horror stories : Vol 25, No.05 (May, 2013) Corporate bullshit as a communication method  : Vol 25, No.06 (June, 2013) A Note on the Relationship of Brooks Law and Conway Law

History:

Fifty glorious years (1950-2000): the triumph of the US computer engineering : Donald Knuth : TAoCP and its Influence of Computer Science : Richard Stallman : Linus Torvalds  : Larry Wall  : John K. Ousterhout : CTSS : Multix OS Unix History : Unix shell history : VI editor : History of pipes concept : Solaris : MS DOSProgramming Languages History : PL/1 : Simula 67 : C : History of GCC developmentScripting Languages : Perl history   : OS History : Mail : DNS : SSH : CPU Instruction Sets : SPARC systems 1987-2006 : Norton Commander : Norton Utilities : Norton Ghost : Frontpage history : Malware Defense History : GNU Screen : OSS early history

Classic books:

The Peter Principle : Parkinson Law : 1984 : The Mythical Man-MonthHow to Solve It by George Polya : The Art of Computer Programming : The Elements of Programming Style : The Unix Haterís Handbook : The Jargon file : The True Believer : Programming Pearls : The Good Soldier Svejk : The Power Elite

Most popular humor pages:

Manifest of the Softpanorama IT Slacker Society : Ten Commandments of the IT Slackers Society : Computer Humor Collection : BSD Logo Story : The Cuckoo's Egg : IT Slang : C++ Humor : ARE YOU A BBS ADDICT? : The Perl Purity Test : Object oriented programmers of all nations : Financial Humor : Financial Humor Bulletin, 2008 : Financial Humor Bulletin, 2010 : The Most Comprehensive Collection of Editor-related Humor : Programming Language Humor : Goldman Sachs related humor : Greenspan humor : C Humor : Scripting Humor : Real Programmers Humor : Web Humor : GPL-related Humor : OFM Humor : Politically Incorrect Humor : IDS Humor : "Linux Sucks" Humor : Russian Musical Humor : Best Russian Programmer Humor : Microsoft plans to buy Catholic Church : Richard Stallman Related Humor : Admin Humor : Perl-related Humor : Linus Torvalds Related humor : PseudoScience Related Humor : Networking Humor : Shell Humor : Financial Humor Bulletin, 2011 : Financial Humor Bulletin, 2012 : Financial Humor Bulletin, 2013 : Java Humor : Software Engineering Humor : Sun Solaris Related Humor : Education Humor : IBM Humor : Assembler-related Humor : VIM Humor : Computer Viruses Humor : Bright tomorrow is rescheduled to a day after tomorrow : Classic Computer Humor

The Last but not Least


Copyright © 1996-2016 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. This document is an industrial compilation designed and created exclusively for educational use and is distributed under the Softpanorama Content License.

The site uses AdSense so you need to be aware of Google privacy policy. You you do not want to be tracked by Google please disable Javascript for this site. This site is perfectly usable without Javascript.

Original materials copyright belong to respective owners. Quotes are made for educational purposes only in compliance with the fair use doctrine.

FAIR USE NOTICE This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available to advance understanding of computer science, IT technology, economic, scientific, and social issues. We believe this constitutes a 'fair use' of any such copyrighted material as provided by section 107 of the US Copyright Law according to which such material can be distributed without profit exclusively for research and educational purposes.

This is a Spartan WHYFF (We Help You For Free) site written by people for whom English is not a native language. Grammar and spelling errors should be expected. The site contain some broken links as it develops like a living tree...

You can use PayPal to make a contribution, supporting development of this site and speed up access. In case softpanorama.org is down you can use the at softpanorama.info

Disclaimer:

The statements, views and opinions presented on this web page are those of the author (or referenced source) 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.

Last modified: July 30, 2013