Front cover -- Contents -- Figures -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Special notice -- Comments welcome -- Part 1 NAS and NetApp filer -- Chapter 1. Introduction to DB2 UDB, NAS, and SAN -- 1.1 Introduction to DB2 UDB -- 1.1.1 DB2 Universal Database packaging -- 1.1.2 The Universal Database -- 1.1.3 DB2's query optimizer -- 1.1.4 DB2 utilities -- 1.2 Introduction to Network Attached Storage -- 1.2.1 File servers -- 1.2.2 Network appliances -- 1.2.3 Benefits of NAS -- 1.3 Introduction to Storage Area Networks -- 1.3.1 Storage Area Network -- 1.3.2 Benefits of SAN -- Chapter 2. DB2 UDB, NAS, and SAN terminology and concepts -- 2.1 DB2 terminology and concepts -- 2.1.1 Instances -- 2.1.2 Databases -- 2.1.3 Buffer pools -- 2.1.4 Table spaces -- 2.1.5 Tables, indexes, and long data -- 2.1.6 DB2 UDB and parallelism -- 2.1.7 Registry and environment variables -- 2.1.8 A word about DB2EMPFA -- 2.1.9 Backup and recovery -- 2.2 NAS terminology and concepts -- 2.2.1 Network file system protocols -- 2.2.2 File I/O -- 2.2.3 Local Area Networks (LANs) -- 2.3 Storage Area Network terminology and concepts -- 2.3.1 SAN storage -- 2.3.2 SAN fabric -- 2.3.3 SAN applications -- Chapter 3. Introduction to the NetApp® filer -- 3.1 The Network Appliance™ Filer -- 3.2 System architecture -- 3.2.1 NVRAM implementation -- 3.2.2 RAID environment -- 3.2.3 Write Anywhere File Layout (WAFL) -- 3.2.4 Snapshots -- Chapter 4. NetApp® filer terminology and concepts -- 4.1 Understanding RAID -- 4.1.1 Levels of RAID -- 4.1.2 Eliminating the parity disk bottleneck -- 4.1.3 Using multiple RAID groups -- 4.1.4 Performance and RAID configuration -- 4.2 WAFL implementation -- 4.2.1 Meta-data lives in files -- 4.2.2 A tree of blocks -- 4.2.3 A word about write allocation -- 4.3 Snapshots -- 4.3.1 Snapshots and the block-map file.

4.4 Volumes and Quota Trees -- 4.4.1 Quota trees -- Chapter 5. DB2 and the NetApp filer -- 5.1 DB2/NetApp filer design considerations -- 5.2 Interacting with a Network Appliance filer -- 5.2.1 Using FilerView® -- 5.3 Creating volumes on a Network Appliance filer -- 5.4 Creating qtrees on a Network Appliance filer -- 5.5 Managing NFS exports (UNIX only) -- 5.6 Filer volumes and qtrees with DB2 UDB -- 5.7 Creating DB2 UDB databases on a filer -- 5.7.1 Setting the appropriate environment/registry variables -- 5.7.2 Creating DB2 UDB databases -- 5.7.3 Verifying the location of a database -- 5.7.4 Improving the performance of SMS table spaces -- 5.7.5 Changing the storage location of database log files -- Chapter 6. Backup and recovery options for databases that reside on NetApp® filers -- 6.1 Backup methods available -- 6.2 Designing a DB2 database with filer -- 6.3 Suspending and resume database I/O -- 6.3.1 WRITE SUSPEND -- 6.3.2 WRITE RESUME -- 6.3.3 DB2INIDB -- 6.4 Using NetApp Snapshots with a DB2 database -- 6.4.1 Taking a Snapshot -- 6.4.2 Restoring a DB2 UDB database from a filer Snapshot -- 6.4.3 DataLink considerations -- Chapter 7. Diagnostics and performance monitoring -- 7.1 The DB2 Database System Monitor -- 7.1.1 The snapshot monitor -- 7.1.2 Event monitors -- 7.2 Operating system monitoring tools -- 7.2.1 The top program -- 7.2.2 Virtual memory statistics - vmstat -- 7.2.3 Process state - ps -- 7.3 Network Appliance filer monitoring tools -- 7.3.1 sysstat -- 7.3.2 ifstat -- 7.3.3 netstat -- 7.3.4 df -- Part 2 DB2 working with IBM NAS -- Chapter 8. Terminology and concepts of IBM NAS -- 8.1 The IBM TotalStorage NAS 200 and 300 concept -- 8.1.1 System architecture -- 8.1.2 NAS Server Engine -- 8.1.3 Storage subsystems -- 8.1.4 Pre-loaded code -- 8.2 IBM NAS terminology -- 8.2.1 Hard disks and adapters.

8.2.2 Arrays, logical disks, and volumes -- 8.2.3 RAID support -- 8.2.4 File system I/O -- 8.2.5 Backup and recovery functions -- 8.3 Backup and recovery in IBM NAS products -- 8.4 IBM NAS Persistent Storage Manager (PSM) -- 8.4.1 How PSM works - overview -- 8.4.2 PSM cache contents -- 8.4.3 PSM True Image: read-only or read-write -- Chapter 9. Introduction to IBM NAS -- 9.1 IBM Network Attached Storage - overview -- 9.2 IBM TotalStorage Network Attached Storage -- 9.2.1 The IBM TotalStorage Network Attached Storage 200 -- 9.2.2 The IBM TotalStorage Network Attached Storage 300 -- Chapter 10. Configuration of IBM NAS 200 and 300 -- 10.1 Our environment -- 10.1.1 Create db2 user account -- 10.1.2 Add computer to domain -- 10.2 Setting up IBM NAS 200 -- 10.2.1 Connecting to the NAS 200 -- 10.2.2 Default configuration -- 10.2.3 Setting up storage -- 10.2.4 Add NAS 200 to domain -- 10.2.5 Creating a share volume -- 10.3 Setting up the IBM NAS 300 -- 10.3.1 Default configuration -- 10.3.2 Setting up storage on the NAS 300 -- 10.3.3 Setting up the Cluster Server -- 10.3.4 Create clustered share volume -- 10.4 Getting connected to NAS -- 10.4.1 Accessing the shares from our Windows clients -- 10.4.2 Accessing the shares for DB2 user -- Chapter 11. DB2 installation on IBM NAS -- 11.1 DB2 for Windows on IBM NAS -- 11.1.1 DB2 for Windows Objects on IBM NAS -- Chapter 12. Backup and recovery options for DB2 UDB and IBM NAS -- 12.1 Backup and recovery considerations on IBM NAS -- 12.1.1 DB2 UDB standard backup and recovery methods -- 12.1.2 DB2 UDB NAS True Image support -- 12.2 DB2 UDB considerations for PSM True Images -- 12.2.1 Getting DB2 UDB prepared for IBM NAS True Image -- 12.2.2 PSM configuration -- 12.2.3 Options for IBM NAS True Image copies -- 12.2.4 Creating an IBM NAS True Image -- 12.2.5 Restoring an IBM NAS True Image.

12.2.6 Accessing True Image copy - overview -- 12.2.7 Some considerations about cache size and location -- 12.3 Using IBM NAS True Image with DB2 UDB -- 12.3.1 System environment -- 12.3.2 Taking a True Image of an offline DB2 UDB database -- 12.3.3 Taking a True Image of an online DB2 UDB database -- 12.3.4 PSM True Image copy as DB2 UDB True Image database -- 12.3.5 Creating a DB2 backup from a True Image -- 12.3.6 Version recovery from a PSM True Image -- 12.3.7 Roll-forward recovery from a True Image -- Chapter 13. IBM NAS high availability -- 13.1 NAS 200 high availability -- 13.2 NAS 300 high availability -- 13.3 Failover tests on NAS 300 -- 13.3.1 Creating a failover event -- 13.3.2 Failover response -- 13.3.3 Load balancing -- 13.3.4 Administration considerations for NAS -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.