db2 reorganization

[Former Member]

Hi,

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

Regards

Levent Akbas

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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