DB02MSS SAP tcode - Db02 for MS SQL Server DB02MSS (Db02 for MS SQL Server) is a standard SAP transaction code available within R/3 SAP systems depending on your version and release level. Below for your convenience is a few details about this tcode including any standard documentation available. How to find the table size in SAP system from SAP GUI 1. T-code DB02- Space - Segments - Detailed Analysis - enter values into fields. Start first table analysis for desired table. Once it is finished display the analysis with the same t-code. Notice this t-code just gets no of entries of the table instead of table size. Transaction code DB02 is to analyze and monitor database statistics (db growth, table space size, missing index & etc). Table Space analysis through DB02 for PSA and Change log deletion strategies. By Viral Shah, Accenture. Introduction: This document tells you how to use DB02 in BI to make policy or decision for Deletion of PSA and Change log table. Use DB02 T-code for check the table space of the PSA, DSO and cube and change logs.
SAP TCode (Transaction Code) - DB02
SAP Tcode | DB02 |
Description | Tables and Indexes Monitor |
Package | STUN_DBA |
Program Name | RSDB0002 |
Screen Number | 1000 |
Transaction Type | R |
Module | Basis Components ► Use Subcomponents ► Monitoring ► Performance Monitors (TCC) |
The SAP TCode DB02 is used for the task : Tables and Indexes Monitor. The TCode belongs to the STUN_DBA package.
SAP Performance Monitors (TCC) Tcodes
Tcode | Description | Module |
---|---|---|
ST10 | Table Call Statistics | BC-CCM-MON-TUN |
AL12 | Display Table Buffer (Exp. Session) | BC-CCM-MON-TUN |
DB01 | Analyze Exclusive Lockwaits | BC-CCM-MON-TUN |
DB05 | Analysis of a Table Acc. to Index | BC-CCM-MON-TUN |
DB02 | Tables and Indexes Monitor | BC-CCM-MON-TUN |
OS01 | LAN check with ping | BC-CCM-MON-TUN |
DB03 | Parameter changes in database | BC-CCM-MON-TUN |
ST04 | DB Performance Monitor | BC-CCM-MON-TUN |
AL13 | Display Shared Memory (Expert Mode) | BC-CCM-MON-TUN |
OSS1 | Logon to SAP Service Marketplace | BC-CCM-MON-TUN |
Objects missing in the database
Sap Db02 Sql Command Editor
Objects of the ABAP Dictionary which were not found in the database are
displayed here.
This is relevant particularly for customer objects if for example the object was purposely deleted from the database during development or if a database error occurred during creating.
Incomplete or incorrect transports and canceled conversions can also result in the object not being found on the database.
SAP Performance Monitors (TCC) Tcodes
Tcode | Description | Module |
---|---|---|
ST10 | Table Call Statistics | BC-CCM-MON-TUN |
AL12 | Display Table Buffer (Exp. Session) | BC-CCM-MON-TUN |
DB01 | Analyze Exclusive Lockwaits | BC-CCM-MON-TUN |
DB05 | Analysis of a Table Acc. to Index | BC-CCM-MON-TUN |
DB02 | Tables and Indexes Monitor | BC-CCM-MON-TUN |
OS01 | LAN check with ping | BC-CCM-MON-TUN |
DB03 | Parameter changes in database | BC-CCM-MON-TUN |
ST04 | DB Performance Monitor | BC-CCM-MON-TUN |
AL13 | Display Shared Memory (Expert Mode) | BC-CCM-MON-TUN |
OSS1 | Logon to SAP Service Marketplace | BC-CCM-MON-TUN |
Objects missing in the database
Sap Db02 Sql Command Editor
Objects of the ABAP Dictionary which were not found in the database are
displayed here.
This is relevant particularly for customer objects if for example the object was purposely deleted from the database during development or if a database error occurred during creating.
Incomplete or incorrect transports and canceled conversions can also result in the object not being found on the database.
Sap sm69 trace. If there was neither an incomplete transport nor a canceled conversion, the object can usually be simply created on the database.
Other Checks
There is a check whether the primary index of tables defined in the ABAP Dictionary were created uniquely on the database.
Dedication 6 reloaded free download. Download/Stream Lil Wayne's mixtape, Dedication 6, for Free at MixtapeMonkey.com - Download/Stream Free Mixtapes and Music Videos from your favorite Hip-Hop/R&B artists. The easiest way to Download Free. Download Lil Wayne and DJ Drama's Dedication 6 mixtape. Lil Wayne & DJ Drama – Dedication 6. Dedication 6 is an official mixtape by Lil Wayne hosted by DJ Drama, which was released on Christmas Day in 2017. There are a total of 15 tracks on the tape that include Weezy rapping over different music artists' beats and making them his own. You can read the lyrics here and view the tracklist. Lil Wayne & DJ Drama – D6: Reloaded Dedication 6: Reloaded is an official mixtape by Lil Wayne hosted by DJ Drama, which was released on January 26th, 2018. There are a total of 20 tracks on the tape with the majority of them being freestyles over different music artists' beats that Weezy made his own. Download/Stream Lil Wayne's mixtape, D6: Reloaded, for Free at MixtapeMonkey.com - Download/Stream Free Mixtapes and Music Videos from your favorite Hip-Hop/R&B artists. The easiest way to Download Free.
A further check is mainly for objects in the basis system, which cannot be described at all or which cannot be completely described in the ABAP Dictionary for technical reasons. Crack acrobat 9 pro.
Sap Messages Tcode
If inconsistencies are detected for these objects, they are also displayed here. Generally further information about the type of inconsistency will also be provided.
Db02 Tcode In Sap Basis
These checks are only inserted in the tree if at least one object was found.
Optional Indexes (Indexes not created)
Indexes which are defined in the ABAP Dictionary as optional DB indexes are displayed here.
Db02 Tcode In Sap Abap
You see here the indexes that are created in the database although according to the definition in the ABAP Dictionary they should not be created at all or not be created in this database.
Sap T Code Mm03
The indexes that are missing in the database although they should be created for this database system are also displayed.