DB6EXPLAIN is a SAP tcode coming under BC module and SAP_BASIS component. View some details about DB6EXPLAIN tcode in SAP.
- DB6EXPLAIN tcode used for : DB6: Explain SQL Statement in SAP
- Module : BC-DB-DB6 (DB2 Universal Database for UNIX / NT)
- Parent Module : BC (Basis Components)
- Package : STU6 (DB6: Performance-Monitor (UNIX/Windows))
- ABAP Program : SAPLSDBACCMS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is transaction code in SAP?Transaction code shortly known as tcode, is a shortcut code to access different functional areas in SAP. It avoid users from long menu path to reach a report. Instead of that users can type the corresponding transaction code and press enter, the corresponding SAP page will load. It’s a good practice to remember or note down the transaction codes that we need to use in our regular work.
DB6EXPLAIN related transaction codes
| Tcode | Note |
|---|---|
| DB6EXPLAIN | DB6: Explain SQL Statement |
| /SDF/SQL | Display SQL Monitor Data |
| DB6CST | DB6: Analyze Cumulative SQL Trace |
| DB6CST_LST | DB6: Analyze Cumulative SQL Trace |
| DB6SQC | DB6: Analyze SQL Cache |
| SDBE | Explain an SQL Statement |
| EXPL_MSS | Call the explain in a new window |
| DB02_MSS | Db02 for MS SQL Server |
| SQLM | SQL Monitor |
| SQLMD | Display SQL Monitor Data |
| SQLR | SQL Trace Interpreter |
| SQLSTMT_MSS | Display SQL for abap in new window |
| ST04_MSS | St04 for MS SQL Server |
| SWLT | SQL Performance Tuning Worklist |
| RSODSO_SQLTRACE | SQL Statements for MPP DataStores |
Tables in the same package as DB6EXPLAIN
SAP tables in package STU6, which also contains transaction DB6EXPLAIN.
| Table | Description |
|---|---|
| DB6MON | DB6: Datacluster for monitor reset data |
| DB6PMHT | DB6: Detail Record of Table and Index Space Statistics |
| DB6PMHSB | DB6: Buffer Pool Statistics History |
| DB6PMHSD | DB6: Database Performance Statistics History |
| DB6PMHST | DB6: Snapshot Table History |
| DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics |
| DB6PMHXT | DB6: Detail Record of Tablespace and DB Table/Index Stats |
| DB6GSDTBS | DB6: Cumulated Table-Specific Snapshot Data |
| DB6HISTBS | DB6: Cumulated Table-Specific Snapshot Data |
| DB6IREORG | DB6: Database REORG Check Information: Indexes |
| DB6JOBTAB | DB6: parallel processing of tables through jobs |
| DB6PMCK_P | DB6: All Backed Up Tablespaces of History File |