Get Started. It's Free
or sign up with your email address
Rocket clouds
DB2 on z/OS by Mind Map: DB2 on z/OS

1. System Objects

1.1. DB2 Directory(DSNDB01)

1.1.1. SCT02

1.1.2. SPT01

1.1.3. SYSSPUXA

1.1.4. SYSSPUXB

1.1.5. SYSLGRNX

1.1.6. SYSUTILX

1.1.7. DBD01

1.2. DB2 Catalog(DBNDB06)

1.2.1. SYSIBM.SYSDATABASE

1.2.2. SYSIBM.SYSTABLESPACE

1.2.3. SYSIBM.SYSTABLES

1.2.3.1. Table information

1.2.3.2. Column information

1.2.3.3. Authorization information

1.3. DB2 Log

1.3.1. Active

1.3.2. Archive

1.4. Bootstrap

1.5. Buffer Pool

1.5.1. BP0

1.5.1.1. BP1

1.5.1.2. BP2

1.5.1.3. BP49

1.5.2. BP8K0

1.5.3. BP16K0

1.5.4. BP32K

1.6. Default DB(DSBDB04)

1.7. Work File DB(DSBDB07)

2. System Connections

2.1. Batch

2.1.1. DB2 Utilities

2.2. CICS

2.3. IMS

2.4. WebSphere

2.5. TSO/CAF

2.5.1. QMF

2.6. DDF

2.7. RRSAF

3. Address Spaces

3.1. MSTR

3.2. IRLM

3.3. DBM1

3.4. DIST

3.5. WLMn

4. Performance Monitoring and Tuning

5. Data

5.1. Data Structure

5.1.1. Database

5.1.1.1. Table Space

5.1.1.1.1. Table/View

5.1.1.1.2. Index

5.1.2. Storage Group

5.1.3. Schema

5.2. Data Integrity

5.2.1. Constraints

5.2.1.1. Unique constraints

5.2.1.1.1. Unique Key

5.2.1.2. Referential constraints

5.2.1.2.1. Parent Key

5.2.1.2.2. Foreign Key

5.2.1.3. Check constraints

5.2.2. Triggers