on 12-29-2008 1:01 PM
Hi,
Is it possbile to reorganize tablespaces in DB2? SAP documentation gives information about table reorganization.
Regards
Levent Akbas
Hi Levent,
there is no native tablespace reorganization command for DB2 LUW but there is a job available in the SAP DBA Planning calendar called 'REORG of Tables in Tablespaces(s)'. This job can be used to reorganize all tables which are stored within a specific tablespace. It simply gets the list of all tables of this tablespace out of the SYSCAT and then calls the REORG command table by table. The job is sometimes useful to reduce the high-water mark of tablespaces and reclaim space. Reduction of the high-water mark might not be perfect, as the REORG command does not necessarily move tables to free parts at the beginning.
Best regards
Ralf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks.
So 'REORG of Tables in Tablespaces(s)' reorganizes tables within the tablespace. Our problem is with fragmentation after reorganization.
In Oracle tablespace reorg. is done by creating all reorganized tables in a new tablespace and after reorganization tablespace is renamed to its original name.
Is this possible for DB2?
Thank you for your answer.
Regards
Hi,
We were doing reorganization on one of our larges table until sapdata filesystems became full and reorganization canceled.
Now we have full filesystems. How can we remove whatever reorganization created to open space in our filesystems?
Any help will be useful and rewarded.
Thanks in advance
Sezai
Thanks for your help.
Best regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Levent ,
if you want to move your tables/indexes to another tablespace you could use DB6CONV .
See SAP Note
362325 DB6: Table conversion using DB6CONV
if you just want to release disk space from tablespace to the operating system , let us know your
DB2 Version and whether your tablespaces are using "automatic storage" .
Best regards
dirk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.