client deletion completed with errors

[Former Member]

Hi,

We ran a client deletion process in our quality system. The os is AS/400 and database is DB2.

DB size is around 300GB. It took around 4 days to complete. In the log it showed that "error while deleting table S260". The space in the database also is showing the same while before client deletion.

Please help me on this.

Thanks,

Sailesh K

[Former Member]

Hi,

Were there any activities in your QA during client deletion. There could be the problem with exclusive lock for this table while the process tried to remove the data out of it. Can you check if there were any other alerts duirng the time when the client deletion process run.

As for the space in the database, it will be shown as the same since you are not removing extents, you just cleaning the data from client-specific tables. You need to do reorg if you really want to claim a free space on a database level.

Regards,

Mike