Skip to Content
Actions

Simple way of finding list of PSA tables and Size in BW system

March 3, 2014 | 962 Views |
Follow

Most of the times, we would like to know complete information about PSA tables to perform system cleaning and to keep space available for system performance as part or System Maintenance.

1)  First we need to find list of PSA tables available in BW system. To achieve this we need to go to DB02 Tcode first and select “Tables and Indexes” as shown given below.

1 - Tables and Indexes.png

2) Provide input as shown given below and hit enter.

2 - proivde input.png

3) You will get the information as shown given below.

3 - List of tables.png

4) Now perform sorting on size in descending order. Here we will get to know the PSA tables according to their size.

4 - Table sizes in sorting order.png

5) Now based on the table name, we can find the data source information.

Please go to SE11, provide PSA table name for which you want to find the Data Source Name as shown given below.

5 - Data Source Name.png

With this information, we can find the PSA table sizes and their data source names to take action further to keep system clean.

Hope this will help you.

Regards,

Ravi K Chandragiri

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Madhav Vikranth

    Simple but very useful. Thanks for this.

     

    I have a question. I am sorry if it’s silly. But, I am not able to find “Tables and Indexes” in my system at DB02. So, is it some kind of setting that we need to request Basis?

     

    Thanks,

    Vikranth.

    (0) 

Leave a Reply