|
|
Home | Switchboard | Unix Administration | Red Hat | TCP/IP Networks | Neoliberalism | Toxic Managers |
| (slightly skeptical) Educational society promoting "Back to basics" movement against IT overcomplexity and bastardization of classic Unix | |||||||
|
|
|
|
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
Notes:
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.
| 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 |
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.
| 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.
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*
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 quotes : Somerset Maugham : Marcus Aurelius : Kurt Vonnegut : Eric Hoffer : Winston Churchill : Napoleon Bonaparte : Ambrose Bierce : Bernard 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 DOS : Programming Languages History : PL/1 : Simula 67 : C : History of GCC development : Scripting 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-Month : How 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 Technology is dominated by two types of people: those who understand what they do not manage and those who manage what they do not understand ~Archibald Putt. Ph.D
Copyright © 1996-2021 by Softpanorama Society. www.softpanorama.org was initially created as a service to the (now defunct) UN Sustainable Development Networking Programme (SDNP) without any remuneration. This document is an industrial compilation designed and created exclusively for educational use and is distributed under the Softpanorama Content License. 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 to buy a cup of coffee for authors of this site |
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 Softpanorama society. We do not warrant the correctness of the information provided or its fitness for any purpose. 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.
Last modified: March 12, 2019
