Finding the Largest PSA table

[Former Member]

Hello Guys,

Can you please suggest how to find the largest PSA table in DB02 for SQL database.

Much Appreciated if any links or documents provided.

Regards,

Shathish kumar

[Former Member]

Dear

you can refer to following link

Tablespace Analysis (Oracle) - Monitoring in the CCMS - SAP Library

Regards

[Former Member]

Hi Satish,

You can find the list of lasrgest growing tables using below query....

db2 "select substr(a.tabname,1,30), (a.fpages*PAGESIZE/1024) as TAB_SIZE from syscat.tables a, syscat.tablespaces b where a.TBSPACEID=b.TBSPACEID ORDER BY TAB_SIZE desc"|more

For PSA tables you can include an attribute in where clause like below...

where a.tabname like '%BIC%'

here it will list all the table that contains BIC in thier name

Regards,

Prithviraj

[Sriram2009]

Hi kumar

Could you refer the SCN link

BR

SS