serices wrote:I thought there would be the answer to my problem, but unfortunately do not have a DBA for DB2 and the logic of the DB is not easy to learn. The solutions presented here serve only to improve the reading logs.
Hi,
well this is why DBAs are still needed
Actually what you want to achive is not the simplest task in DB2.
First off runn a reorg command on all the tables where you have deleted a lot of rows. Reorganization is done on table level in DB2 LUW (Linux, Unix and Windows).
So the command (from the shell ) could b
db2 reorg table <schemaname>.<tabname>
This will physically delete the rows which you just have marked as deleted so far.
Secondly because the space is allocated by tablespaces - in your situation by an automatic storage tablespace try running following command to reduce the size of the tablespace and returning it to the file system:
db2 alter tablspace <tablespacename> reduce
Any further reduction of space is a lot more work and needs someone with DB2 skills.
kind regards
Michael