The TCode DB02 in SAP is used to view the tablespace usage in an SAP system. It provides insights into the total size of the database and the table space utilization. This includes information such as the total database size, allocated space, used space and free space. The TCode can also be used to identify and find where a table or index is located in the database.


On this page, you will find links to SAP Documentation, Wiki & Help Pages, Q&A, similar/related TCodes, Source Tables, and Authorization Objects for DB02.

SAP Help, Wiki, Q&A and other resources for DB02

Click the above link for the full list of resources and help pages, only the first few are posted below

  •  Problems with Maximum Number of Extents (Oracle) - SAP Help Portal

    You should check on a regular basis whether there are tables or indexes that are close to reaching their maximum number of extents (MAXEXTENTS parameter). This applies in particular when you are transferring mass data to the SAP system.

    https://help.sap.com/docs/SAP_NETWEAVER_740/3364beced9d145a5ad185c89a1e04658/c43a712c505211d189550000e829fbbd.html

  •  Missing Indexes - SAP Help Portal

    Indexes which are defined in the ABAP Dictionary but are missing in the database or indexes which were created in the database but are unknown to the ABAP Dictionary are an especially important factor in performance problems. For this reason, there is a separate Missing indexes display, even though one is already included in the full check accessed via Database <-> ABAP Dictionary consistency.

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_740/3364beced9d145a5ad185c89a1e04658/c43a71e2505211d189550000e829fbbd.html

  •  Consistency Checks - SAP Help Portal

    Three different functions are provided for checking consistency between the ABAP Dictionary and the database:

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/3364beced9d145a5ad185c89a1e04658/c43a716d505211d189550000e829fbbd.html

  •  Displaying the Oracle Table Statistics - SAP Help Portal

    If you use Oracle with the cost-based Optimizer, you should create statistics for the database tables on a regular basis. You should analyze tables using BR*Tools and schedule them in the CCMS DBA scheduling calendar (transaction code DB13). Ensure regularly that tables or indexes were correctly analyzed.

    https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/3364beced9d145a5ad185c89a1e04658/c43a7153505211d189550000e829fbbd.html

  •  Extent Analysis (Oracle) - SAP Help Portal

    You can analyze the extent structure for all tablespaces. In addition to this list output, a second overview displays all tables and indexes with more than 4 extents. Alongside the size of the objects (in Kilobytes and blocks), the number of used extents and the value defined for the object for MAXEXTENTS are also displayed. You can, if you wish, start a detailed storage space analysis as a background job.

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/3364beced9d145a5ad185c89a1e04658/c43a71c8505211d189550000e829fbbd.html

  •  Tables/Index Analysis (Oracle) - SAP Help Portal

    Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/3364beced9d145a5ad185c89a1e04658/c43a71d5505211d189550000e829fbbd.html

  •  SAP/Oracle Database Monitor: Status of the Data - SAP Help Portal

    Choose Tools →Administration →Computing Center →Management System →Control →Performance Menu →Database →Tables / Indexes.

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_731_BW_ABAP/3364beced9d145a5ad185c89a1e04658/c43a7160505211d189550000e829fbbd.html

  •  Database Tables without a Unique Index - SAP Help Portal

    This function checks whether the tables defined in the ABAP Dictionary have a primary index and whether it was created with the "unique" option. (The existence of a primary key constraint is sufficient for some databases. This is also taken into account here.)

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_740/3364beced9d145a5ad185c89a1e04658/c43a7187505211d189550000e829fbbd.html

  •  Database - ABAP Dictionary Consistency - SAP Help Portal

    With this function, you can find all the database objects that are defined in the ABAP Dictionary but have not been created in the database (or were deleted). This function also displays objects that were created directly in the database and are therefore unknown in the ABAP Dictionary.

    "Alternatively, use transaction code DB02."

    https://help.sap.com/docs/SAP_NETWEAVER_740/3364beced9d145a5ad185c89a1e04658/c43a717a505211d189550000e829fbbd.html

  • Consistency Checks - SAP Help Portal

    top distinction between the objects defined in the ABAP Dictionary and the objects defined in the database ...

    "Alternatively, use transaction code DB02."

    https://help.sap.com/viewer/109543906c531014bd4bdd9908b40a7d/7.0.33/en-US/c43a716d505211d189550000e829fbbd.html

  • View the full list of resources, SAP Help/Wiki pages and Q&A for DB02


Related Transaction Codes

TCODE Description Functional Area
ST04 DB Performance Monitor Basis - Performance Monitors (TCC)
SM21 Online System Log Analysis Basis - SAP System Log
ST22 ABAP Dump Analysis Basis - Syntax, Compiler, Runtime
DB13 DBA Planning Calendar Basis - CCMS / Database Monitors for Oracle
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance

Tables for SAP Transaction Code DB02

TABLE Description Functional Area
DBA_TABLES Oracle: Row Structure of dba_tables BC - CCMS / Database Monitors for Oracle
RSDCUBE Directory of InfoCubes / InfoProvider BW - Data Basis
MONI Monitor table MONI Basis - Performance Monitors (TCC)
TSTC SAP Transaction Codes Basis - ABAP Runtime Environment
TSTCT Transaction Code Texts Basis - ABAP Runtime Environment
RSD1 Hierarchy for log.data packet/groups scheduler (old) BW - Data Staging

Authorization Objects for SAP Transaction Code DB02

AUTHORIZATION OBJECT Description Functional Area
WLM Assignment of Articles to Layout Modules
S_IWB Knowledge Warehouse
S_TCODE Transaction Code Check at Transaction Start
S_RZL_ADM CCMS: System Administration
S_USER_AGR Authorizations: Role Check
C_VKORG Transfer of Sales Organization Data

Most searched SAP Basis Components TCodes