Show TOC

DB ProceduresLocate this document in the navigation structure

Use

The Problem Analysis user menu displays, among other things, database procedures.

Procedure

Open the Database Assistant (transaction code DB50) or the liveCache Assistant (transaction code LC10). Choose Start of the navigation path Problem Analysis Next navigation step DB Procedures End of the navigation path.

The display is part of the DBA Cockpit and can therefore also be called as follows:

  1. Open DBA Cockpit (transaction DBACOCKPIT).

  2. The display options in DBA Cockpit vary depending on which SAP NetWeaver release you are using.

    • Choose Start of the navigation path Diagnosis Next navigation step Database Objects Next navigation step DB Procedures End of the navigation path.

    • SAP NetWeaver 7.1: Choose Start of the navigation path Space Next navigation step  DB Procedures End of the navigation path.

Result

The system displays an overview of all loaded database procedures, their input and output parameters, and other details.

As well as an ABAP application, an application also includes a range of DB procedures in which time-critical parts of the application are implemented in C++. With SAP liveCache technology, DB procedures can process both SQL data and OMS data.

More Information