Hello,

I have copied in my reminder notes on how I reclaimed the unused table
space.

db2 "select 'db2 reorg table ' || rtrim(tabschema) || '.' || tabname || '
ALLOW NO ACCESS ;' from syscat.tables where tbspace = 'USERSPACE1'" >
reorg.txt
Run the output after slight editing - connect & remove blank lines etc

db2dart nm_pr_cp /LHWM /TSI 2 /NP 2500000
db2dart nm_pr_cp /RHWM /TSI 2


The nm_pr_cp is the database and it must be stopped.
/RHWM works better than /LHWM but needs a backup after.

/LHWM suggest how to lower high water mark

/TSI 2 on TableSpace Id 2

/NP 2500000 the new target for the high water mark.



Follow the advice and then run


alter tablespace userspace1 resize (all 1 G)
alter tablespace userspace1 resize (all 5334 M)


where all containers will be reset to 1 Gigabyte in size.
In userspace1 on nm_pr_cp where there are 6 containers the
tablespace will end up as 6 gigabytes.




Option RHWM requires a database backup afterwards


Regards
Glyn Owen

NOTICE
This e-mail and any attachments are intended for the addressee(s) only and may be confidential. They may contain legally privileged or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then please delete both messages. This notice should not be removed.

DB2 & UDB email list listserv db2-l LazyDBA home page