DB2 UDB exploitation of NAS technology / [Lijun (June) Gu ... et al.].

Format:

Book

Contributor:

Gu, Lijun.

International Business Machines Corporation. International Technical Support Organization.

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Physical Description:

xx, 268 p. : ill.

Edition:

1st ed.

Place of Publication:

San Jose, Calif. : IBM Corp., International Technical Support Organization, 2002.

Language Note:

English

Contents:

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.

Notes:

"July 2002."

"SG24-6538-00."

Includes bibliographical references and index.

OCLC:

842285407