cancel
Showing results for 
Search instead for 
Did you mean: 

db2 reorganization

Former Member
0 Kudos

Hi,

Is it possbile to reorganize tablespaces in DB2? SAP documentation gives information about table reorganization.

Regards

Levent Akbas

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks for your help.

Best regards.

Former Member
0 Kudos

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