Table size in Portal SAP system

[Former Member]

Hi All,

Please let us know the process of checking largest table size in Portal SAP system.

Regards,

Raja

[Former Member]

Hi Raja,

Navigate to DB02-->Segments-->Overview-->TopSizes.

There you can find the size of all tables, indexes etc.

Thanks,

Pavan

[divyanshu_srivastava3]

What is your database ?

[Former Member]

Hi,

Our database is DB2.

Regards,

Raj

[divyanshu_srivastava3]

If you portal is connected to central system, then use DBACockpit navigating to Space →Largest Table

[Former Member]

Hi,

I am getting the below error message.Please advise.

Required data collectors 'Tables (Storage)' and 'Indexes (Storage)' are not set up properly

Regards,

Raj

[former_member188883]

Hi Raj,

Please connect to DB2 database and execute the below query

db2> SELECT TABSCHEMA, TABNAME, SUM(DATA_OBJECT_P_SIZE),  SUM(INDEX_OBJECT_P_SIZE), SUM(LONG_OBJECT_P_SIZE),

   SUM(LOB_OBJECT_P_SIZE), SUM(XML_OBJECT_P_SIZE) FROM SYSIBMADM.ADMINTABINFO GROUP BY TABSCHEMA, TABNAME;

This query will give you list of tables with their physical size. You may download the same into excel and perform sorting .

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Thanks. This query will help to find the Growth details date wise.

Regards,

MK

[Former Member]

Hi,

Is there any possibility to check history of growth particular table in db2 through command line.

Regards,

raj

[former_member188883]

Hi Raj,

Through query I am not very sure but using dbacockpit you may achieve the same.

Space: History - Overview (DB2 UDB for UNIX and Windows) (SAP Library - CCMS: SAP/DB2 UDB for UNIX a...

Configure your portal system into central system ( Solution manager) and you can configure remote monitoring for the same.

Regards,

Deepak Kori