PSA Deletion

[Former Member]

Hi All,

I have some big PSA tables to be deleted in production.

I was just skeptical about running it over weekend as it will take a long time at first.

And i am sure it will overlap with the daily process chain.

My question is can simultaneous delete and load can happen in the same PSA table.

I guess it worked this weekend but still i want advice on this.

Regards,

Suyash

[former_member188011]

Hi Suyash:

The following statement was extracted from SAP Note 496637 - "DUMP: DBIF_RSQL_TABLE_UNKNOWN when you delete a PSA request"

>"For performance reasons, the contents of the PSA are sometimes deleted using transaction SE14."

Please be aware that you need to use Tcode SE14 very carefully specially on your PRODUCTION environment, because by mistake you could also delete the physical tables and not only the contents.

*Important Note: Double check to make sure you delete only the contents of the tables, not the table themselves.

After entering the PSA table name on T-Code SE14, click on the "Edit" button, select the "Delete data" radio button and click on the "Activate and adjust database" button.

Regards,

Francisco Milán.

[Former Member]

Hi Fransico,

Thx for the reply.

I have already created a chain to delete PSA.

The issue is i want to confirm is whether i can run PSA deletion while the PSA is getting loaded also.

I am not sure about the lock process which works while deletion.

Regards,

Suyash

[former_member182516]

No you can't do both the task at same time, the table will get locked.

bcoz PSA is a Table, table can be assessed and can perform only one activity at a time.

if you want to delete PSA -schedule the PSA deletion when there are no activities performed on that particular PSA table.

[Former Member]

Hi,

No you cant go with both things togeteher as both activites are going to be performed on same object.

your both request will get in hang state and object will be shown as locked, as your data volume is huge it will affect your system and report executions also.

You can carry out deletion of PSA in step by step process i.e you delete chunk of data one after another.

Hope this helps....

Regards,

[former_member324993]

see the How to..,maybe can help you.

[How to Archive PSA Data in SAP NetWeaver Business Intelligence (NW7.0)|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/a0974515-7225-2b10-14a1-f5abba35b19f]