Skip to Content
avatar image
Former Member

Reduce Size ZARIXBC1 Archiving Information Structure table

Hi,

Is there any standard report for deleting entries of ZARIX tables in XI in order to reduce its size?

The size of our ZARIXBC1 table is 20GB already, is huge.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 20, 2009 at 05:11 PM

    Hi,

    I do not think there is a standard report to reduce entries of a custom table.

    If it's a custom development it should have its' own archiving report.

    What is ZARIXBC1 used for?

    Regards,

    Sergio

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2009 at 10:15 AM

    Hi Ajay,

    Your solution indeed reduces the size of the table but, also the sessions for which we deleted structures went into error, is this normal? if so what is the impact in a PRD environment?

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Yes, that is correct. This will lead to set the archive session no into error or Red signal light.

      In Production system,

      1. User should raise a request for the year and period he wants to retrieve archive data from the archive server,

      2. we will activate archive infostructure and built the data for that session no (that particular Year/period). 3. This data can be accessed for 14 days or 2 weeks and then we have to delete built structure for that archive session no and deactivate it.

      Or Depending on the business need you can change your plans like - Last one year of archived data can be retrieved from the archive. If user required any further old data they have to raise a request

      Above process will help in maintaining / controlling the size of ZARIX table size.

      -Thanks,

      Ajay

  • avatar image
    Former Member
    Mar 24, 2009 at 10:58 AM

    Hi Ajay,

    As procedure we delete any archive file older than 30 days, so can we safely delete infostructure records from ZARIX table also older than 30 days right?

    Also if I understood correctly after deleting the infostructure the session goes into error/red light since we can no longer build the related data from the archives due to the missing infostructures right?

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      >

      > Hi Ajay,

      >

      > As procedure we delete any archive file older than 30 days, so can we safely delete infostructure records from ZARIX table also older than 30 days right?

      i do not recommend deleting the archive files. leave them be. you might want to set up an externa server where you can store those archive files (for eternal 😊 keeping). there are 3rd party products available, but generally everything supporting archive link for an interface will do. to reduce the size of the ZARIX, go analyze the thingy. go to transaction SARI and search for the object your big ZARIX comes from.

      >

      > Also if I understood correctly after deleting the infostructure the session goes into error/red light since we can no longer build the related data from the archives due to the missing infostructures right?

      >

      > Thanks in advance.

      i would do it another way. if you want to reduce your ZARIX* to zero, you might be fastest by dropping the table using tx. SE14 - you can rebuild the thing every time you choose. if you just want to reduce the size to say - documents of the actual fiscal year (or whatever criteria match your wishes) go to tx. SARI -> object name (like IDOC) -> 'status per archive'. here you can choose which archives you want to be removed from the ZARIX, meaning: for those archives you select there and then process using button 'reduce structure' the single rows in table ZARIXBC1 will be deleted. thus you can keep just as much as are needed.

  • avatar image
    Former Member
    Mar 21, 2009 at 02:27 AM

    Hi,

    By using standard functionality - Delete structure selecting the archive session no you can delete the data from the ZARIX table. If you want to delete ZARIX table for infostructure then use Delete table that helps in deleting the respective table for Infostructure.

    -Thanks,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded