Skip to Content
Author's profile photo Former Member

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

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

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Check with BASIS Team, they can help you on this.

      Author's profile photo Curtis MacKenzie
      Curtis MacKenzie

      use largest tables and filter on */BIC/B*

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi ravi chandragiri ,

       

      Smart way of finding PSA tables and sizes Thanks for sharing.

       

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member

      Good snippet to do this job.

       

      Thanks for sharing,

      Hari Charan BR

      Author's profile photo abilash n
      abilash n

      Thanks Ravi for showing very simple way.....

      Author's profile photo Phani KV
      Phani KV

      Hi,

       

      Nice document.

       

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Superb blog Ravi. Really very useful. Thanks for shariing...:)

       

      Regards,

      Poorna

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you all for liking this blog.

      Author's profile photo Yogesh Narwani
      Yogesh Narwani

      Hello Ravi,

       

      Its a very useful blog in terms of optimization or value addition .Appreciate for sharing the same.

       

      Regards

      YN

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Yogesh.

      Author's profile photo Former Member
      Former Member

      Nice man....