473,727 Members | 2,008 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SMS TableSpace - Reorg not releasing space.

Running DB2 9.1 on Redhat Linux 4.1.

Storage management indicates that the pages stored in a file based SMS
container occupy 7 gig of the total space allocated which is 50gig. I
wrote a script to reorg and runstat all the tables in the tablespace
but the reorgs are not releasing space to the file system. Is there
anything that would cause this?

Jun 30 '08 #1
1 2844
"Patrick Finnegan" <fi************ **@gmail.comwro te in message
news:ea******** *************** ***********@d1g 2000hsg.googleg roups.com...
Running DB2 9.1 on Redhat Linux 4.1.

Storage management indicates that the pages stored in a file based SMS
container occupy 7 gig of the total space allocated which is 50gig. I
wrote a script to reorg and runstat all the tables in the tablespace
but the reorgs are not releasing space to the file system. Is there
anything that would cause this?
You are probably mistaken. What makes you think storage is not being

Keep in mind that a table can actually get larger after a reorg, since DB2
will recreate the percent free on each page (default is 10%). This percent
free may have been used during inserts.
Jun 30 '08 #2

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: Ulrich Sprick | last post by:
Hi all, (DB2 V7.1 for WinNT) I am looking for a way to determine the free space in my tablespace (containers), but I can't find out. The tablespace in question is a system managed tablespace in a raw partition. The Control Center always reports 100% usage (although I can insert data...). The "list tablespace containers for n show detail" command shows the number of usable pages, but they are almost equal to the total number of pages. ...
by: mairhtin o'feannag | last post by:
Hello, I have a tablespace striped across three drives, call them 1,2,3, just to be clever. :) I allocated a lot more space (DMS) than I should have, since I didn't know a way to estimate the space required (long story, but the original space was in one huge tablespace for all tables ((35 million row tables)) and I needed to segregate them out into separate tablespaces for backup and restore purposes. So I allocated, like 4 million...
by: Michael Raz via DBMonster.com | last post by:
We are in SAP R/3 using z/OS DB2 V7.1 as our DB Server. SAP uses a table called VBDATA for it's internal intermediate needs just inserting in it's primary transaction a row and then selects and deletes the row in it's secondary transaction. The table is basically empty. During our peak time we have just a few tens of rows in the table. The problem is that the tablespace is constantly growing - goes into
by: Michel Esber | last post by:
Hello, DB2 V8 FP 10 running Linux RedHat 4.0. I have created a system temporary tablespace and now I want to delete it. However: $ db2 "drop tablespace reorg" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it
by: Sue | last post by:
Hi, I have a DB2 database with database managed (DMS) tablespaces. One of the tables that I have contains BLOB data. Recently I noticed that 75% of the tablespace for this table was being used up. So I deleted 50 records from the table freeing about 50 to 100 GB of space. But even after deleting the records I found that the %age of tablespace used still remains the same at 75%. What will I need to do to reclaim the deleted space so that...
by: Patrick | last post by:
I have a tablespace that contains the LOB data for 3 tables which exist in other tablespaces. Even after reorging the LOB tablespace with the LONG option, the high water mark is still too high. I want to be able to shrink the tablespace below the current high water mark and return the excess space back to the filesystem. Is there another way to lower the HWM without exporting the data to another tablespace, dropping and recreating the...
by: Konstantin Andreev | last post by:
Hello, all. Let the tablespace SY810T4K is almost full: --------------- db2 =list tablespaces show detail ... Name = SY810T4K Type = Database managed space Contents = Any data Total pages = 332800
by: Troels Arvin | last post by:
Hello, A DB2 v. 8 DMS tablespace ran full. Subsequently, almost all data in the tablespace has been deleted, but "LIST TABLESPACES SHOW DETAIL" keeps stating that the tablespace has 0 free pages. I've tried running a REORG on all remaining tables; that didn't help. Trying to create a table in the tablespace yields: bash-3.00$ db2 "create table foobar (x int not null) in s_problemspace" DB21034E The command was processed as an SQL...
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
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: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
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: 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: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.