DB6SQC is an SAP tcode in package STU6. View some details about DB6SQC tcode in SAP.
- DB6SQC tcode used for : DB6: Analyze SQL Cache in SAP
- Package : STU6 (DB6: Performance-Monitor (UNIX/Windows))
- ABAP Program : SAPLSDB6CCMS
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.
DB6SQC related transaction codes
| Tcode | Note |
|---|---|
| DB6SQC | DB6: Analyze SQL Cache |
| DB6CST | DB6: Analyze Cumulative SQL Trace |
| DB6CST_LST | DB6: Analyze Cumulative SQL Trace |
| /SDF/SQL | Display SQL Monitor Data |
| DB6EXPLAIN | DB6: Explain SQL Statement |
| /UI2/CACHE | Register service for UI2 cache use |
| DB6EXL | DB6: Analyze Exclusive Lock Waits |
| DB6TAC | DB6: Analyze Table Snapshot |
| 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 |
Tables in the same package as DB6SQC
SAP tables in package STU6, which also contains transaction DB6SQC.
| 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 |