Database is getting bigger

[mathiasbx]

Hi @ll,

i have a problem with the database on our 6.2.5 TSM Server.

In the last time, i've deleted backups with 400TB backup volume. File Server, Database... etc.

But the database becomes not smaller, she grows on and on.

Here are my settins in the dsmserv.opt

* =====================================================================
ALLOWREORGTABLE YES
* =====================================================================
REORGBEGINTIME 06:00
* =====================================================================
REORGDURATION 12
* =====================================================================
ALLOWREORGINDEX YES
* =====================================================================
DB_DB2_KEEPTABLELOCK NO

Has anyone the same problem or a solution?

Mathias

 

[marclant]

Hi,

The solution is not always easy or obvious. Should start with this technote:
http://www-01.ibm.com/support/docview.wss?uid=swg21452146

And also this if you use dedup:
http://www-01.ibm.com/support/docview.wss?uid=swg21592404

Marc...

 

[mathiasbx]

Hi Marc, thanks for your help.

The first document I already knew. i ran the steps last week, but only with a minimal reduction.

Dedup is not in use.

I´ve opened a support ticket. I'm curious what the support says.

Mathias

 

[rowl]

I have been working on a similar issue. One thing I discovered is that some tablespace reorgs can take a very, very long time. I am currently monitoring a BACKUP_OBJECTS table that started on 12/21/13 and is still running (it's 2/10/14 as I post this), just over 50% done at this point. I enabled index reorg on this DB too, so sometime in March/April I should be able to run the filespace reduction process and recover some space and level set our size.

db2pd -d tsmdb1 -reorg

is the command support gave us to monitor this process. If you compare the CurCount to MaxCount values you an see how far along the process is. The status periodically switches between Paused and Started to allow other processing to run.

-Rowl