- 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)
DB2TSBACK
List of tablespaces that need a backup
|
#transactional
|
Component: DB2 for z/OS
- 🔑 Keys (5)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical
- Other (29)
- 🔗 Relations
| Column Name | Description | |
|---|---|---|
| DATE_ANA | Date of the last check | |
| TIME_ANA | Time of the last check | |
| DBNAM | Database name | |
| TSNAM | Name of the tablespace | |
| TSPART | Partition number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| DATE_ANA | Date of the last check | |
| TIME_ANA | Time of the last check |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| NAME | Name of the tablespace | CHAR8 | |
| CREATOR | DB2 creator name | CHAR8 | |
| BPOOL | DB2 buffer pool name | DB2BPNAME | |
| LOCKRULE | Lock size of the tablespace | DB2LRULE | |
| LOCKMAX | Maximum number of locks per user before escalating | DB2LMAX | |
| CLOSERULE | Data sets for closure when limit of open data sets reached | DB2CRULE | |
| ENCODING | Default encoding scheme of the tablespace | DB2ENCODE | |
| LOCKPART | Lockpart for the tablespace | DB2LPART | |
| MAXROWS | Maximum number of rows that DB2 will place on a data page | DB2MROW | |
| PARTITIONS | Number of partitions of the tablespace or indexspace | DB2PART | |
| TYPE | Tablespace type | DB2TYPE | |
| SEGSIZE | Number of pages in each segment of a segmented tablespace | DB2SSIZE | |
| SPACE | Number of KB of DASD Storage Allocated to Tablespace | DB2SPACE | |
| NTABLES | Number of tables defined in the tablespace | DB2NTAB | |
| STATUS | Availability status of tablespace | DB2STATS | |
| STATSTIME | Date and time of last RUNSTATS | DB2TMSTMP | |
| ERASERULE | Datasets are to be erased when dropped | DB2ERULE | |
| DBNAME | Database name | D2DBNAME | |
| DSETPASS | The password for the datasets of the tablespace | DB2DPASS | |
| LOG | Whether the changes to a tablespace are to be logged | DB2LOG | |
| DSSIZE | Maximum size of a dataset in KBytes | DB2DSIZE | |
| PARTNR | Partition number | DB2SINT | |
| OPERATION | Date and time of last RUNSTATS | DB2TMSTMP | |
| NDAYS | Number of days since last invocation | DB2DAYS | |
| PERCOFFPOS | Different of far and near optimal position in page | DB2OFFPOS | |
| PERCINDREF | Different of far and near relocated position in page | DB2INDREF | |
| PERCDROP | Percentage of space occupied by rows of dropped tables | DB2CDROP | |
| EXTENTS | Number of extents of a tablespace | DB2EXTENT | |
| REASON | Reason running utility is recommended | DB2REASON |