Skip to Content
author's profile photo Former Member
Former Member

client deletion completed with errors

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 05:02 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.