db2 issue

manikandank_1984 · #1 (**permalink**) 08-04-09, 01:24

Hi,

I am using ECC 6.0 and db2 database.I have deleted some clients in sap.The total size of that client is 10GB.After deleting i done the reorg for all the tables through db13.The filesystem size not reducing is increasing why this problem?Please help me.

Regards,
Raj

ibm_db2_rocks · #2 (**permalink**) 08-05-09, 02:11

I think.. it may be due to High Water Mark for that tablepsace.
If possible, can you unload data, drop the table and then recreate it ?

n_i · #3 (**permalink**) 08-05-09, 07:50

Quote:

Originally Posted by ibm_db2_rocks

If possible, can you unload data, drop the table and then recreate it ?

That does not at all guarantee that the HWM will be lowered. db2dart with the /lhwm switch can be used to suggest ways to lower the tablespace high water mark (if this is indeed the problem).

Internet Services

Web Development

Digital Marketing

Consumer Tech