db_execute check data performance

[Former Member]

Hello!

Does anybody know a way to tune the MaxDB "Check database" job?

We are running it for about 5 hours on a ERP 100GB box.

What are the options for this check, is it possible to run it multi thread?

//Fredrik

[former_member229109]

Hello Fredrik,

Please see the information at the MaxDB SDN Wiki first:

https://wiki.sdn.sap.com/wiki/display/MaxDB ->

MaxDB Support Guide -> Check database structure

If you are SAP customer, please review the SAP note:

940420 FAQ: Database structure check (VERIFY)

727099 Using database structure checks (Verify)

698644 Database structure checks (verify) take a long time

***

If you will have additional questions on your topic, please check & post the current database version info too.

< You could use the dbm command "show version" or check the knldiag file in the database rundirectory, for example, to get the database version information. >

Thank you and best regards, Natalia Khlopina