/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
As for the utility, INSPECT reads through all of the data base in a single process, and checks each and every page for consistency. This just takes time. The runtime consumed thereby heavily depends on the performance of the I/O subsystem, and on the amount of workload that is competing for available resources.
Needless to say that INSPECT itself has impact on performance of the rest of the environment. Note that all data needs to go through the bufferpool. It therefore is a good idea to have this separated from productive work.
In summary, INSPECT performance is susceptible i/o subsystem speed and system load.
Read more...
Environment
- IBM DB2 LUW (DB6) any release
Product
Keywords
DB2INSPECT , INSPECT , performance , tuning , corruption , KBA , SV-PERF-DB-IBM , IBM related performance issues , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)