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
Useable pages = 332736
Used pages = 268480
---------------
I thoroughly checked that only tables' data (no indexes or LOBs) lie in this tablespace, run statistics for each table in tablespace and computed:
Allocated pages: "sum( fpages ) from syscat.tables" == 256679
(for tables in tablespace SY810T4K)
Surprisingly, this number is not equal to "Used pages" number returned by "list tablespaces" command.
Who may use the rest of the uses pages in tablespace ?
"Used pages" - "Allocated pages" = 268480 - 256679 = 11801 LOST (?) pages.
Thank you in advance,
--
Konstantin Andreev. 6 3839
They are not LOST. When was the last time u ran REORG on the tables
in this tablespace ?
U might need to re-claim the space using REORG
cheers...
Shashi Mannepalli
Konstantin Andreev wrote:
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
Useable pages = 332736
Used pages = 268480
---------------
I thoroughly checked that only tables' data (no indexes or LOBs) lie in this tablespace, run statistics for each table in tablespace and computed:
Allocated pages: "sum( fpages ) from syscat.tables" == 256679
(for tables in tablespace SY810T4K)
Surprisingly, this number is not equal to "Used pages" number returned by "list tablespaces" command.
Who may use the rest of the uses pages in tablespace ?
"Used pages" - "Allocated pages" = 268480 - 256679 = 11801 LOST (?) pages.
Thank you in advance,
--
Konstantin Andreev.
"Konstantin Andreev" <pl**********@datatech.ruwrote in message
news:e8**********@dns.comcor.ru...
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
Useable pages = 332736
Used pages = 268480
---------------
I thoroughly checked that only tables' data (no indexes or LOBs) lie in
this tablespace, run statistics for each table in tablespace and computed:
Allocated pages: "sum( fpages ) from syscat.tables" == 256679
(for tables in tablespace SY810T4K)
Surprisingly, this number is not equal to "Used pages" number returned by
"list tablespaces" command.
Who may use the rest of the uses pages in tablespace ?
"Used pages" - "Allocated pages" = 268480 - 256679 = 11801 LOST (?)
pages.
Thank you in advance,
--
Konstantin Andreev.
The ANSI Standards Board has set those pages to NULL and you will never see
them again.
Shashi Mannepalli wrote:
They are not LOST. When was the last time u ran REORG on the tables in this tablespace ?
Never, yesterday, a month ago... it does not matter. You are looking in wrong place.
U might need to re-claim the space using REORG
REORG <tablereclaims pages excessively allocated for this <table(fpages - npages). REORG has nothing to do with pages, used in tablespace, but *NOT* allocated by any table. For sure, I have run REORG and RUNSTAT for each table in tablespace, but got just another number of LOST pages:
---------------
db2 =list tablespaces show detail
...
Tablespace ID = 22
Used pages = 268480
---------------
db2 =select sum(fpages) from syscat.tables where tbspaceid=22
1
-----------
270105
LOST: (270105 - 268480) = 11847 pages.
Cheers,
Konstantin Andreev.
>
>Let the tablespace SY810T4K is almost full: --------------- db2 =list tablespaces show detail ... Name = SY810T4K Type = Database managed space Contents = Any data Total pages = 332800 Useable pages = 332736 Used pages = 268480 ---------------
I thoroughly checked that only tables' data (no indexes or LOBs) lie in this tablespace, run statistics for each table in tablespace and computed:
Allocated pages: "sum( fpages ) from syscat.tables" == 256679 (for tables in tablespace SY810T4K)
Surprisingly, this number is not equal to "Used pages" number returned by "list tablespaces" command. Who may use the rest of the uses pages in tablespace ?
"Used pages" - "Allocated pages" = 268480 - 256679 = 11801 LOST (?) pages.
DMS managed tablespaces require overhead of one extent per container.
Also, free pages aren't freed up unless you do an offline reorg. You
should see them as pending free on a tablespace snapshot...PG
Konstantin Andreev wrote:
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
Useable pages = 332736
Used pages = 268480
---------------
I thoroughly checked that only tables' data (no indexes or LOBs) lie in this tablespace, run statistics for each table in tablespace and computed:
Allocated pages: "sum( fpages ) from syscat.tables" == 256679
(for tables in tablespace SY810T4K)
Surprisingly, this number is not equal to "Used pages" number returned by "list tablespaces" command.
Who may use the rest of the uses pages in tablespace ?
"Used pages" - "Allocated pages" = 268480 - 256679 = 11801 LOST (?) pages.
Thank you in advance,
--
Konstantin Andreev.
DMS managed tablespaces require overhead of one extent per container.
Its actually more than that. The one extent/container you quote is for
the container tag only - this is reflected in the disparity between
'total pages' and 'usable pages'.
There is additional overhead associated with the tablespace's metadata
- both per-tablespace (ie, the SMP extents) and per-object within the
tablespace (ie, the EMP extents for each object).
jsoh
Check this technote http://www-1.ibm.com/support/docview...=utf-8&lang=en
cheers...
Shashi Mannepalli
Josh Tiefenbach wrote:
DMS managed tablespaces require overhead of one extent per container.
Its actually more than that. The one extent/container you quote is for
the container tag only - this is reflected in the disparity between
'total pages' and 'usable pages'.
There is additional overhead associated with the tablespace's metadata
- both per-tablespace (ie, the SMP extents) and per-object within the
tablespace (ie, the EMP extents for each object).
jsoh
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...
|
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...
|
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...
|
by: cbielins |
last post by:
One of our tablespaces is in an offline state:
Tablespace ID = 9
Name = xxx_xxxx
Type = Database managed...
|
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...
|
by: Raghava |
last post by:
hi all,
i was working on DB2 and came across an issue. i.e. can a tablespace be
rollforwarded to POINT-IN-TIME?
the scenario is as follows:
i created a data base and a tablespace in it.
i have...
|
by: Alvin SIU |
last post by:
Hi all,
I am now doing development using DB2.
Q1.
There is one tablespace to store 5 tables.
But, when in production, there will be one tablespace for EACH of the
tables.
|
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...
|
by: deshaipet |
last post by:
Hi friends -
I created a automatic storage tablespace with a pagesize of 16 K and initial size of 64 MB.
create large tablespace test_tbsp1 pagesize 16k managed by automatic storage autoresize...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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: 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: 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...
|
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,...
|
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...
| |