DB2 is an SAP tcode in package STU3. View some details about DB2 tcode in SAP.
- DB2 tcode used for : DB2 z/OS: Select Database Activities in SAP
- Package : STU3 (Development Class for Database Monitor)
- ABAP Program : SAPLSDB2CCMS_ANALYSIS
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.
DB2 related transaction codes
| Tcode | Note |
|---|---|
| DB2 | DB2 z/OS: Select Database Activities |
| DB2X | DB2/390: database check |
| DB2B | DB2 z/OS: Buffer pool tuning |
| DB2C | DB2 z/OS: Catalog Browser |
| DB2C_OLD | DB2 z/OS: Catalog Browser |
| DB2J | DB2 z/OS: Manage JCL Jobs |
| DB2SPACE | DB2: Space Analysis |
| DB2SYSPARM | DB2: System Parameters |
| DB2T | DB2 z/OS - Timeout Monitor |
| DB2U | DB2 z/OS: Long Running Transactions |
| DB2_IXFIX | DB2-z/OS: index fix (padded, codepg) |
| DB2ACCEL | DB2 Accelerator Control Center |
| DB2D | DB2 z/OS - Deadlock Monitor |
| DB2W | DB2 z/OS: Workload Manager Monitor |
| VC10 | Report Tree - Select Addresses |
Tables in the same package as DB2
SAP tables in package STU3, which also contains transaction DB2.
| Table | Description |
|---|---|
| DB2LOGS | RFC - Active Log Shortage |
| DB2LRUR | RFC - Long Running URs |
| DB2MISC | Miscellaneous CCMS on DB2 for z/OS settings and properties |
| DB2TBLX | RFC - Table Extents |
| DB2LODLK | RFC - Deadlock Table |
| DB2LODRS | RFC - Deadlock Resources |
| DB2LOTHW | RFC - Timeout Waiter and Holder |
| DB2LOTRS | RFC - Timeout Resources |
| DB2RFCCONN | RFC - Connection |
| DB2THREAD2 | |
| STU3COTABC | Definition of DB2 OS/390 and OS/390 Commands(Customer Table) |
| STU3COTABS | Definition of DB2 for OS/390 and OS/390 Commands (SAP Table) |