🗃 DB2
DB2 Introduction
Beginner 🕑 15 min read
👁 0 views
15
Code Example
## DB2 Introduction
DB2 is IBM's relational database management system for z/OS mainframes, providing enterprise-grade data management.
### What is DB2?
DB2 for z/OS is:
- Relational database (RDBMS)
- SQL-compliant
- ACID-compliant
- Highly scalable and available
### Key Components
| Component | Purpose |
|-----------|---------|
| Catalog | System tables metadata |
| Buffer Pools | Memory for data pages |
| Tablespaces | Physical storage |
| Databases | Logical containers |
### DB2 Objects
1. **Database** - Logical container
2. **Tablespace** - Physical storage
3. **Table** - Data storage
4. **Index** - Access optimization
5. **View** - Virtual table
6. **Synonym** - Alias name
### SQL Categories
- **DDL**: CREATE, ALTER, DROP
- **DML**: SELECT, INSERT, UPDATE, DELETE
- **DCL**: GRANT, REVOKE
### DB2 Subsystem
Collection of DB2 components sharing memory and resources.