Hello,
I need to get an overview of all my tablespaces, how full they are, and
which containers are connected to them.
I know of LIST TABLESPACE CONTAINERS, but it's annoying to have to look up
the tablespace ID before LIST TABLESPACE CONTAINERS can be used. And LIST
TABLESPACE CONTAINERS doesn't seem to be universally available (e.g., it
seems that db2batch doesn't support it).
So:
Is there a way to use SQL to find containers allocated to tablespaces? -
I'm thinking about some kind of system table/view, alike
SYSIBM.SYSTABLESPACES. - That way I could join between SYSTABLESPACES and
other relevant tables to get my full list.
--
Regards,
Troels Arvin
3  1811 
In article <eo**********@news.net.uni-c.dk>, tr****@arvin.dk says...
Hello,
I need to get an overview of all my tablespaces, how full they are, and
which containers are connected to them.
I know of LIST TABLESPACE CONTAINERS, but it's annoying to have to look up
the tablespace ID before LIST TABLESPACE CONTAINERS can be used. And LIST
TABLESPACE CONTAINERS doesn't seem to be universally available (e.g., it
seems that db2batch doesn't support it).
So:
Is there a way to use SQL to find containers allocated to tablespaces? -
I'm thinking about some kind of system table/view, alike
SYSIBM.SYSTABLESPACES. - That way I could join between SYSTABLESPACES and
other relevant tables to get my full list.
Using DB2 V9 you can use the CONTAINER_UTILIZATION administrative view
to get this info, it's documented at http://tinyurl.com/2x2zwq.
also you can use from v8.2 onwards db2pd -db <dbname-tablespaces
Gert van der Kooij wrote:
In article <eo**********@news.net.uni-c.dk>, tr****@arvin.dk says...
Hello,
I need to get an overview of all my tablespaces, how full they are, and
which containers are connected to them.
I know of LIST TABLESPACE CONTAINERS, but it's annoying to have to look up
the tablespace ID before LIST TABLESPACE CONTAINERS can be used. And LIST
TABLESPACE CONTAINERS doesn't seem to be universally available (e.g., it
seems that db2batch doesn't support it).
So:
Is there a way to use SQL to find containers allocated to tablespaces? -
I'm thinking about some kind of system table/view, alike
SYSIBM.SYSTABLESPACES. - That way I could join between SYSTABLESPACES and
other relevant tables to get my full list.
Using DB2 V9 you can use the CONTAINER_UTILIZATION administrative view
to get this info, it's documented at http://tinyurl.com/2x2zwq.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dylan |
last post by:
I'd like to compare two containers. They should be considered
equivalent if both containers have the same number of elements with
the same values, no matter what order the values are in.
For...
|
by: JustSomeGuy |
last post by:
I need a class that is essentially a matrix (template) class.
I need to be able add rows and columns as needed.
any one know of such a class?
|
by: phil_gg04 |
last post by:
Dear C++ Experts,
Over the last couple of months I have been writing my first program
using shared memory. It has been something of an "in-at-the-deep-end"
experience, to say the least. At...
|
by: Matthias Kaeppler |
last post by:
Hi,
in my program, I have to sort containers of objects which can be 2000
items big in some cases. Since STL containers are based around copying
and since I need to sort these containers quite...
|
by: Gregory |
last post by:
I have a question about using STL containers in C++ class public
interface.
Lets say that I want to return some container from class method or
accept class method parameter as some container. For...
|
by: bob |
last post by:
Hi,
Given:
1) Custom containers that have nothing to do with vector, deque, list,
map etc,
2) a custom version of new and delete defined for these containers,
customNew and customDelete,...
|
by: Jean-Marc Blaise |
last post by:
IBM recommends to place each ts container on a different physical disk.
What about the impacts if all containers (DMS) are in the same FS (supported
by multiple disks) ?
Does DB2 preallocate...
|
by: Nindi73 |
last post by:
HI
If I define the class DoubleMap such that
struct DoubleMap : public std::map<std::string, double>{};
Is there any overhead in calling std::map member functions ?
Moreover are STL...
|
by: jimxoch |
last post by:
Hi list,
Most STL containers are storing their data on the heap. (although some
std::string implementations are notable exceptions) Of course, using
the heap as storage increases flexibility and...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
