- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- ABAP Runtime Environment - ABAP Language Issues Only (BC-ABA)
- ABAP Workbench, Java IDE and Infrastructure (BC-DWB)
- BW Service API (BC-BW)
- Basis Services / Communication Interfaces (BC-SRV)
- Basis pieces of Central Business Configuration (BC-CBC)
- Business Management (BC-BMT)
- Business Server Pages (BC-BSP)
- Change & Transport System (BC-CTS)
- Client/Server Technology (BC-CST)
- Component Integration / Installation Windows Components (BC-CI)
- Customizing (Use Subcomponents) (BC-CUS)
- Database Interface, Database Platforms (BC-DB)
- Business Suite on Adaptive Server Enterprise (BC-DB-SYB)
- DB-Independent Database Interface (BC-DB-DBI)
- DB2 Universal Database for UNIX / NT (BC-DB-DB6)
- DB2 for z/OS (BC-DB-DB2)
- Informix (BC-DB-INF)
- MaxDB (BC-DB-SDB)
- Oracle (BC-DB-ORA)
- SAP HANA Database (CCMS, Porting and DB Interface) (BC-DB-HDB)
- SQL Server in SAP NetWeaver Products (BC-DB-MSS)
- Technical Monitoring Cockpit Infrastructure for DB (BC-DB-MON)
- liveCache (BC-DB-LVC)
- liveCache Applications (BC-DB-LCA)
- Documentation and Translation Tools (BC-DOC)
- Enterprise Content Management (ECM) (BC-ECM)
- Enterprise Information Management (use subcomponents) (BC-EIM)
- Enterprise Service Infrastructure (BC-ESI)
- Exchange Infrastructure - Use subcomponents (BC-XI)
- Frontend Services - Use subcomponents (see SAP Note 1322184) (BC-FES)
- Guided Procedure (BC-GP)
- Help Infrastructure (BC-HLP)
- Information Lifecycle Management (BC-ILM)
- Installation Tools (Use Subcomponents) (BC-INS)
- Intelligent Scenario Lifecycle Management (BC-ISM)
- Internationalization (I18N) (BC-I18)
- Middleware (BC-MID)
- Musing Tools (BC-MUS)
- Operating System Platforms (BC-OP)
- Ready-to-Run R/3 (BC-RRR)
- SAP NetWeaver Mobile - Use subcomponents (BC-MOB)
- SAP Screen Personas (BC-PER)
- Security (BC-SEC)
- TREX (BC-TRX)
- Test Workbench (BC-TWB)
- Upgrade - General (BC-UPG)
- Use Subcomponents (BC-CCM)
- Use subcomponents (BC-NWA)
- Virtual Machine Container (BC-VMC)
- Web Dynpro (BC-WD)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
DB2DB02TBSIZE
Transaction DB02: List of tables and tablespace (Details)
|
#transactional
|
Component: DB2 for z/OS
- 🔑 Keys (4)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical
- Other (12)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| TBCREATOR | DB2 creator name | |
| TBNAME | Name of the table on which the index is defined | |
| STORDATE | Date when the storage information has been collected | |
| STORTIME | Time when the storage information has been collected |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| STORDATE | Date when the storage information has been collected | |
| STORTIME | Time when the storage information has been collected |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| TSNAME | Name of the tablespace | CHAR8 | |
| DBNAME | Database name | D2DBNAME | |
| PARTITIONS | Number of partitions of a tablespace or index | DB2SINT | |
| TBSIZE | Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | FLTP | |
| SPACEF | Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | FLTP | |
| STATSTIME | Date and time of last RUNSTATS | DB2TMSTMP | |
| TS_ALLOCSIZE | Total size of a tablespace (allocated storage in KB) | DEC11 | |
| TS_FREESIZE | Free size of a tablespace in KB (allocated minus used stor.) | DEC11 | |
| PCTUSED | Percentage of used size to allocated size of a tablespace | DEC3 | |
| RTS_TOTALROWS | Real Time Statistics: Number of rows in Table | FLTP | |
| AVGROWLENGTH | Average row length of table | ||
| RTS_ST_CHANGES | RUN.:Changed rows (insert, delete or update) absolute number | FLTP |