SAP Knowledge Base Article - Preview

2871281 - Performance issues in DB2 z/OS using ADT Open Development Object (Ctrl-Shift-A)

Symptom

The ADT Open Development Object (Ctrl+Shift+A) search is taking a VERY long time to return results (~45 seconds).

ADT is ABAP Development Tools (the Eclipse-based ABAP IDE).

Here is the long running query

SELECT * FROM "RIS_QUICK_SEARCH"
WHERE 1 = 1 AND
"OBJECT_NAME" LIKE ? ESCAPE ? AND
NOT "OBJECT_NAME" LIKE ? ESCAPE ? AND
NOT "OBJECT_TYPE" = ? AND
NOT "OBJECT_NAME" LIKE ?
ORDER BY "RIS_QUICK_SEARCH" . "OBJECT_NAME" FETCH FIRST ? ROWS ONLY
FOR READ ONLY WITH UR


Read more...

Environment

Db2 z/OS any version

Product

SAP NetWeaver all versions

Keywords

Workbench , KBA , BC-DB-DB2 , DB2 for z/OS , BC-DWB-UTL-INR , Repository Infosystem , BC-DWB-AIE-REF , Refactoring, Quickfixes & Quick Assists , 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.