hi,

DB2 8R3, in windows 2000 SP4.

I drop a container of a tablaspace (DMS). This tablespace have four cotainer:

1 of 10 GB a tree of 5 GB.

When I drop a container:
----------------------------------------------------------
db2 => ALTER TABLESPACE TBATTRIB DROP ( FILE 'F:\DB2INST1\cont04attrib' )

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20170N There is not enough space in the table space "TBATTRIB" for the
specified action. SQLSTATE=57059
----------------------------------------------------------

The tablespace
----------------------------------------------------------
Tablespace ID = 5
Name = TBATTRIB
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 6400000
Useable pages = 6399936
Used pages = 267728
Free pages = 6132208
High water mark (pages) = 6144016
Page size (bytes) = 4096
Extent size (pages) = 16
Prefetch size (pages) = 8
Number of containers = 4
Minimum recovery time = 2003-11-17-19.14.47.000000
---------------------------------------------------------

The High water mark be in 6144016, but, only 267728 page be used.

I run the command:
db2dart dwcorp /tsi 5 /np 0 /lhwm

But the water mak no change.

Any idea?
TIA.
Abel.

Correct me if I am wrong ...

The LHWM option in the db2dart gives suggestions on how to reduce the HWM .. It doesn't do the job for you ...

Cheers
Sathyaram

Hi sathyaram_s,

you are right, the db2dart no change parameters, but, how change the HWM? Is this possible.

Thanks.
Abel.

One option is the REORG Command

There are other options, I think ... But sorry, can't recall

Cheers
Sathyaram

Hi and tanks.

reorg all tables of the tablespace?

I think you db2dart with lhwm should be able to give the info about which table is holding the HWM ...


REORG the most transient table in the tablespace and check the HWM ... Continue this until the HWM becomes acceptably small ..

Or, you can take this opportunity to REORG all tables



Sathyaram

Hi,
I reorg all tables of the tablespace, but, the hwm not change.

I run the command:

reorg <nombre de tabla>

and the command db2dart:

db2dart <dbname> /tsi 5 /np 0 /lhwm

---------------------------------------------------------------------



__________________________________________________ ____________________________
_______ DART _______
D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
IBM DB2 NT
__________________________________________________ ____________________________
DART (V8.1.0) Report:
11/18/03 15:06:17 SA Eastern Standard Time
Database Name: DWCORP
Report name: DWCORP.RPT
Old report back-up: DWCORP.BAK
Database Subdirectory: F:\DB2INST1\NODE0000\SQL00001
Operational Mode: Database Inspection Only (INSPECT)
__________________________________________________ ____________________________
------------------------------------------------------------------------------
Action option: LHWM
Tablespace-ID: 5; Desired Highwater Mark (Number-pages): 0
Connecting to Buffer Pool Services...

Highwater mark processing - phase start.
NOTES: All highwater mark values and/or object sizes listed below are
given in extents and not pages (unless explicitly stated).
The object ID and object type are shown for each extent listed.
Extents marked with an asterisk (*) hold the first page of an
object and these extents can only be moved by dropping and
recreating that object.
Extents marked as belonging to objects with ID equal to 65534 or
65535 are SMP extents or object table extents and they are not
movable.
After following a step and before continuing on to the next one,
disconnect and reconnect to the database.
Highwater Mark: 6144016 pages, 384001 extents (extents #0 - 384000)
Lower highwater mark processing - phase start.
Current highwater mark: 384000
Desired highwater mark: 0
Number of used extents in tablespace: 15685
Number of free extents below original HWM: 368316
Number of free extents below desired HWM: 0
Number of free extents below current HWM: 368316
Final highwater mark: Extent #384000 (384001 extents, 6144016 pages).
** This cannot be lowered further as it holds an SMP extent which is
not movable.


Lower highwater mark processing - phase end.

Highwater mark processing - phase end.



---------------------------------------------------------------------

Any idea?
TIA
Abel

The db2dart output has the answer :


** This cannot be lowered further as it holds an SMP extent which is
not movable.


Cheers
Sathyaram

Hi,
I have the same unresizable container problem:
"This cannot be lowered further as it holds an SMP extent which is
not movable."

I wonder if you found a solution.
The only solution I found is dropping the tablespace;

Hi fsengonul,

I can't low the HWM, but, I think move all data to other TB and delete this TB with all your container.

do you understand why don't low this mark? I no.

Thank
Abel.

Thanks,
If I found an answer, I will inform you.

fsengonul

please, read this document:

http://www-1.ibm.com/support/docview...id=swg21006299

and tell me.
Abel.

Sorry for late reply.
But I couldn't reach that document.The link seems to be broken.
Could you send me the document via email,please?
ferhat.sengonul@isbank.com.tr
thanks

http://www-1.ibm.com/support/docview...id=swg21006299

The link is up now,I will read the document,
Thanks

Hi,
On my previous tries ; I was using db2dart while db2 was running.
This time, following the document, I first stopped db2 and then send the db2dart utility.And it worked
Thanks