SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

How to check and run db2 table statistics on sap system

Case

You want to check and update db2 statistics of an SAP System.

Solution

1) Find last statistics run of table for example T000. Execute following command as db2<sid>:

db2 “select STATS_TIME from syscat.tables where tabname=’T000′”

2) Execute runstat:

At first find db-owner:

db2 “select tabschema, tabname from syscat.tables where tabname like ‘%USR02%'”

If it yields SAPSR3, execute following command:

db2 “runstats on table SAPR3.T000 with DISTRIBUTION and detailed indexes all”

3) If you want to to run statistics for all table use dmdb6srp tool

dmdb6srp -n <SID> -t ALL

 

One thought on “How to check and run db2 table statistics on sap system

Leave a Reply

Your email address will not be published.

Related topics

How to get latest SAP news and messages by whatsapp

How to get latest SAP news, technology developments in WhatsApp ? Whatsapp is not an only messaging platform any more. More and more vendors, software […]

How to remove a cloned resource adapter in sap pi system

Case You have created or cloned a resource adapter in SAP PI system and now want to remove it. But delete button is not active […]

How to check and run db2 table statistics on sap system

Case You want to check and update db2 statistics of an SAP System. Solution 1) Find last statistics run of table for example T000. Execute […]

saposcol file owner and permissions

Case In order to be able to start saposcol successfully, you have to adapt its owner and file permissions properly Solution OS level, for example […]

Language Import

The language import must always be performed in client 000. The supplementation must first be performed in client 000 and can then be scheduled in […]