Hi,
How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespa ces, but it doesn't seem to give me that
information.
Thanks
Rahul
4  1958 
Rahul B wrote:
Hi,
How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespa ces, but it doesn't seem to give me that
information.
Thanks
Rahul
You can try looking at the number of active pages if your statistics are
current.
Phil Sherman
On Sep 6, 7:37 pm, Phil Sherman <psher...@ameri tech.netwrote:
Rahul B wrote:
Hi,
How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespa ces, but it doesn't seem to give me that
information.
Thanks
Rahul
You can try looking at the number of active pages if your statistics are
current.
Phil Sherman
Can you please elaborate a bit on that?
Rahul
Rahul B wrote:
Hi,
How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespa ces, but it doesn't seem to give me that
information.
Look at a tablespace snapshot.
Either, 'get snapshot for tablespaces on <yourdb>' or you can use the
SYSIBMADM.SNAPC ONTAINER administrative view.
Ian wrote:
Rahul B wrote:
>Hi,
How can i find out the space that is currently not utilized/utilized
in the tablespace?
I tried from syscat.tablespa ces, but it doesn't seem to give me that
information.
Look at a tablespace snapshot.
Either, 'get snapshot for tablespaces on <yourdb>' or you can use the
SYSIBMADM.SNAPC ONTAINER administrative view.
Oops, SYSIBMADM.SNAPC ONTAINER doesn't have this information. You want
SYSIBMADM.SNAPT BSP_PART.
Ian This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bing Wu |
last post by:
I have a user defined tablespace:
Tablespace ID = 4
Name = DATASPACE
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 15360000
|
by: Oliver Stratmann |
last post by:
Hello All!
I've got a problem with our DB2/NT 8.1.0 Database.
The following SELECT on a big Table (2,5 Million rows) finishes with the
Error "Unable to
allocate new pages in table space "TEMPSPACE1".". Sometimes some rows are
displayed.
We tried all the hints of the Docs but it won't work.
Can anybody give me a hint in which way this problem should be analyzed?
I'm sorry ti bother You, but this is the last idea i've had.
|
by: Fred |
last post by:
Hello,
I found a CLOB column in a DMS table that programmers were using to
store tiny strings (less than a couple kilobytes). Since CLOB columns
can only allocate entire kilobytes of space at best (when created with
the COMPACT qualifier), I know that this was wasting a lot of space in
the long tablespace. I added a VARCHAR(2048) column to that table so
it could hold those small strings instead, which allowed me to null
out the tiny...
|
by: N |
last post by:
Hi,
I got an error during load on a couple of
the tables. And it seems to be complaining that
I'm running out of tempspace (possibly during
index rebuild). Below is the load command and
error. What I do not understand is why DB2 is
trying to rebuild the index in TBS_STEMP03 even
though I explicitly tell it to use TBS_STEMP01
in the load statement. According to my calculation,
TBS_STEMP01 should have enough space for LOAD
|
by: Yasaswi Pulavarti |
last post by:
does a command like,
db2 drop table tabschema.tabname when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi
| | |
by: randi_clausen |
last post by:
I am trying to resize a DMS tablespace container in a database.
There is only one table in this tablespace and it is at 89% full
currently. The command executes successfully but still the size
doesn't change (trying both through the alter TS GUI screen and typing
the alter command in the Command Center).
I read in this group that I needed to perform a reorg on the table for
the change to take effect--that is when I get the 289 error. So...
|
by: Raja Shekar |
last post by:
HI Every body ,
I would like to know whether is it mandatory to give Tablespace page
size and Bufferpool page size equal..? i also heard like while creating
tablespace if pages size of tablespace and bufferpool , the statement
itself will fail ...why i'm asking is if we chose a different page size
( ofcourse less than bufferpool page size ) only it shoud affect the
performance of db2 ..
Thanks in Advance
Raja Shekar
|
by: mike_dba |
last post by:
I am using DMS raw. I have a tablespace which is defined with 5
containers each allocated at 1.5 GB for a total of about 7.5 GB. I did
a major deletion followed by a reorg and a runstats. I am not
regaining as much space as anticipated. Additionally, the
syscat.tables and syscat.indexes show my usage to be small. How do I
determine who is using all the space ?
The list tablespaces shows -
Usable pages = 7.4 GB
Used pages = 6.2 GB
|
by: James |
last post by:
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any
way to avoid this?
Thanks
James
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
