Filter
Top Products
© Copyright IBM Corp. 1999 iii
Contents
Figures ......................................................xi
Tables .......................................................xv
Preface .....................................................xvii
The Team That Wrote This Redbook . ..................................xvii
CommentsWelcome ...............................................xix
Part 1. Introduction and Summary ...................................................1
Chapter 1. Introduction..........................................3
Chapter 2. Summary of Considerations ............................5
2.1 DB2 and Storage Management ..................................5
2.1.1 Benefits of DFSMS .......................................5
2.1.2 Managing DB2 Data Sets with DFSMS . .......................6
2.1.3 Examples for Managing DB2 Data Sets with DFSMS . ............6
2.2 DB2andStorageServers......................................6
2.2.1 DataPlacement..........................................6
2.2.2 LargeCache............................................6
2.2.3 LogStructuredFile.......................................7
2.2.4 RAMACArchitecture......................................7
2.2.5 SMS Storage Groups . . . ..................................7
2.2.6 Performance Management .................................8
Part 2. DB2 and System Managed Storage ............................................9
Chapter 3. DB2 Storage Objects .................................11
3.1 DB2Overview..............................................11
3.2 DB2DataObjects...........................................11
3.2.1 TABLE ...............................................12
3.2.2 TABLESPACE..........................................12
3.2.3 INDEX................................................13
3.2.4 INDEXSPACE..........................................13
3.2.5 DATABASE............................................13
3.2.6 STOGROUP...........................................13
3.3 Creating Table Spaces and Index Spaces. . . ......................13
3.3.1 DB2 Defined and Managed ................................14
3.3.2 User Defined and Managed................................14
3.4 DB2SystemTableSpaces....................................15
3.4.1 TheDB2CatalogandDirectory.............................15
3.4.2 The Work Database .....................................15
3.4.3 SYSIBM.SYSCOPY......................................16
3.4.4 SYSIBM.SYSLGRNX ....................................16
3.5 DB2ApplicationTableSpaces .................................17
3.6 DB2RecoveryDataSets .....................................17
3.6.1 BootstrapDataSets .....................................17
3.6.2 Active Logs ............................................18
3.6.3 Archive Logs ...........................................19
3.6.4 ImageCopies..........................................20
3.6.5 OtherCopies...........................................22