Skip to Content
avatar image
Former Member

xi full tablespace

Hi all,

I'm having problems with the tablespace PSAPXIDDB and I don't know how to free space in this. I tried deleting the oldest messages but the DB have the same free space (0%)and most of the messages was deleted although I couldn't delete the biggest messages that were sent yesterday.

Those messages has a EOIO quality service and has a split by 10000 recordsets because they have a 1.4G of size.

Could anybody tell me how can I free space? and how can I delete these messages that was posted yesterday? Do I need to do something else after running the deleting jobs?

thanks for your help.

Omar Hernandez

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 27, 2006 at 06:19 PM

    hi,

    >>>>Do I need to do something else after running the deleting jobs?

    but you did run archive too right?

    SXMB_ADM - schedule archive job and then schedule delete?

    Regards,

    michal

    -


    <a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions">XI FAQ - Frequently Asked Questions</a>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2006 at 08:40 PM

    Hi Michal, I have deleted almost all the messages and I still have the same problem. Do you know what else I can do? How can I delete manually cancelled mesagges?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Omar,

      Have you solved this problem? I have a similar issue on XI 3.0 (SP18). We have archived about 18GB to the file system. The deletion jobs have deleted about 100,000 of the 115,000 messages, but after the DB REORG, the free space has increased by less than 1GB.

      Background: I am aware of the pre-allocation of the database containers (files) at the file system level. I am talking about the free space as reported by transaction DB2, goto Space -> Tablespace.

      Thanks.

      Message was edited by: Derek Colley (added additional background)