Skip to Content
avatar image
Former Member

Truncate TABLE PSA table-index part

Dear all,

I have a doubt about the truncate action on BW of PSA table.

To speed the activity and empty some tablespace I have truncated for example the PSA /BIC/B0000025000 and all table and index parts have emptied, so, on the contrary of disk space, the table part and index part from 00001 to 00050 for example are no longer used and the next uploads creates partition 00051.

The question is: I must drop all index and table part previously emptied?

If yes a must keep in mind some indications?

I could have some problem to leave this table and index part empty, for example about performance or inconsistence?

There is some contraindication to truncate PSA?

Can i use program 'RSAR_CLEANUP_PSA_DIRECTORY' to delete its?

Thanks for your help.

Best Regards

Daniele

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 14, 2008 at 11:48 AM

    Hi,

    check Note 733371 - CleanUp for inconsistent PSA directory entries

    might helps you

    regards,

    kaushal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      its talks about a program 'SAP_PSA_ZEROCORRECT' imported automatically with SP 11, i have level 13 os SP BI but i didn't find that program, 
      do you have some idea about that?
      

      992248 not doesn't tells that SAP_PSA_ZEROCORRECT is available with SP11.

      SAP_PSA_ZEROCORRECT is attached to sap Note 856097 - Check and repair program for Note 849857

      first implement sap note 856097 using snote, you get that program, execute the program and check the result.

      regards,

      kaushal

  • avatar image
    Former Member
    Mar 05, 2008 at 11:32 AM

    Hi Kaushal,

    i have solved my problem.

    For the error:

    Fatal error occured, DO NOT USE correct option

    For errors 'wrongly present in partition' refer to NOTE 849857 / 992248

    of report RSAR_PSA_CLEANUP_DIRECTORY; in the rest of log (transaction SLG1) we can find this entries:

    Request : ODSR_48YLZTXG8FFEOU547U93MMQEF missed in partition 0001

    Request : ODSR_48YLZTXG8FFEOU547U93MMQEF stored in wrong partition 0000

    that must be delete manually.

    After that we can execute the report RSAR_PSA_CLEANUP_DIRECTORY in repair option.

    Best Regards

    Daniele

    Add comment
    10|10000 characters needed characters exceeded