Manuels d'utilisation pour IBM 5655-DB2

Table des matières

• Contents

  5
• Figures

  13
• Tables

  17
• Preface

  19
  • The Team That Wrote This Redbook

    19
  • Comments Welcome

    21
• Chapter 1. Introduction

  25
• Chapter 2. Summary of Considerations

  27
  • 2.1 DB2 and Storage Management

    27
    • 2.1.1 Benefits of DFSMS

      27
    • 2.1.2 Managing DB2 Data Sets with DFSMS

      28
    • 2.1.3 Examples for Managing DB2 Data Sets with DFSMS

      28
  • 2.2 DB2 and Storage Servers

    28
    • 2.2.1 Data Placement

      28
    • 2.2.2 Large Cache

      28
    • 2.2.3 Log Structured File

      29
    • 2.2.4 RAMAC Architecture

      29
    • 2.2.5 SMS Storage Groups

      29
    • 2.2.6 Performance Management

      30
• Chapter 3. DB2 Storage Objects

  33
  • 3.1 DB2 Overview

    33
  • 3.2 DB2 Data Objects

    33
    • 3.2.1 TABLE

      34
    • 3.2.2 TABLESPACE

      34
    • 3.2.3 INDEX

      35
    • 3.2.4 INDEXSPACE

      35
    • 3.2.5 DATABASE

      35
    • 3.2.6 STOGROUP

      35
  • 3.3 Creating Table Spaces and Index Spaces

    35
    • 3.3.1 DB2 Defined and Managed

      36
    • 3.3.2 User Defined and Managed

      36
  • 3.4 DB2 System Table Spaces

    37
    • 3.4.1 The DB2 Catalog and Directory

      37
    • 3.4.2 The Work Database

      37
    • 3.4.3 SYSIBM.SYSCOPY

      38
    • 3.4.4 SYSIBM.SYSLGRNX

      38
  • 3.5 DB2 Application Table Spaces

    39
  • 3.6 DB2 Recovery Data Sets

    39
    • 3.6.1 Bootstrap Data Sets

      39
    • 3.6.2 Active Logs

      40
    • 3.6.3 Archive Logs

      41
    • 3.6.4 Image Copies

      42
    • 3.6.5 Other Copies

      44
  • 3.7 Other DB2 Data Sets

    44
    • 3.7.1 DB2 Library Data Sets

      44
    • 3.7.2 DB2 Temporary Data Sets

      44
  • 3.8 DB2 Data Sets Naming Conventions

    44
    • 3.8.1 Table Space and Index Space Names

      45
    • 3.8.2 BSDS Names

      45
    • 3.8.3 Active Log Names

      45
    • 3.8.4 Archive Log and BSDS Backup Names

      46
    • 3.8.5 Image Copy Names

      46
• Chapter 4. System Managed Storage Concepts and Components

  47
  • 4.1 Background

    47
  • 4.2 Evolution

    47
  • 4.3 DFSMS/MVS Components

    48
    • 4.3.1 DFSMSdfp

      48
    • 4.3.2 DFSMSdss

      49
    • 4.3.3 DFSMShsm

      50
    • 4.3.4 DFSMSrmm

      53
    • 4.3.5 DFSMSopt

      53
    • 4.3.6 SMF Records 42(6)

      54
  • 4.4 Benefits

    54
• Chapter 5. Storage Management with DFSMS

  57
  • 5.1 Introduction

    57
    • 5.1.1 Base Configuration

      57
    • 5.1.2 Class and Storage Group Definitions

      58
  • 5.2 Automatic Class Selection Routines

    58
  • 5.3 SMS Classes

    60
    • 5.3.1 Data Class

      60
    • 5.3.2 Storage Class

      61
    • 5.3.3 Management Class

      63
    • 5.3.4 Storage Group

      65
  • 5.4 Naming Standards

    68
  • 5.5 Examples

    68
• Chapter 6. Managing DB2 Databases with SMS

  69
  • 6.1 SMS Examples for DB2 Databases

    69
    • 6.1.1 Using ISMF to Display SMS Constructs

      69
    • 6.1.2 SMS Data Class

      69
    • 6.1.3 SMS Storage Class

      70
    • 6.1.4 SMS Management Class

      71
    • 6.1.5 SMS Storage Groups

      72
    • 6.1.6 DB2 STOGROUPs and SMS Storage Groups

      74
    • 6.1.7 Assigning SMS Classes to DB2 Table Spaces and Index Spaces

      75
    • 6.1.8 Table Space and Index Space Names for SMS

      78
    • 6.1.9 Managing Partitioned Table Spaces with SMS

      78
  • 6.2 User Databases

    79
    • 6.2.1 Online Production Databases

      80
    • 6.2.2 Batch Production Databases

      80
    • 6.2.3 Data Warehouse Databases

      80
    • 6.2.4 Development and Test Databases

      81
    • 6.2.5 Summary

      81
  • 6.3 DB2 System Databases

    82
    • 6.3.1 Catalog and Directory Databases

      82
    • 6.3.2 Work Database

      83
    • 6.3.3 Summary

      83
• Chapter 7. Managing DB2 Recovery Data Sets with SMS

  85
  • 7.1 SMS Examples for DB2 Recovery Data Sets

    85
    • 7.1.1 SMS Data Class

      85
    • 7.1.2 SMS Storage Class

      85
    • 7.1.3 SMS Management Class

      86
    • 7.1.4 SMS Storage Groups

      87
    • 7.1.5 Assigning SMS Classes to DB2 Recovery Data Sets

      88
  • 7.2 BSDS

    89
    • 7.2.1 Storage Class

      89
    • 7.2.2 Management Class

      89
    • 7.2.3 Storage Group

      90
    • 7.2.4 ACS Example

      90
  • 7.3 Active Logs

    90
    • 7.3.1 Storage Class

      91
    • 7.3.2 Management Class

      91
    • 7.3.3 Storage Group

      91
    • 7.3.4 ACS Example

      91
  • 7.4 Archive Logs

    91
    • 7.4.1 Storage Class

      93
    • 7.4.2 Management Class

      93
    • 7.4.3 Storage Group

      93
    • 7.4.4 ACS Example

      93
  • 7.5 Image Copies

    93
    • 7.5.1 Storage Class

      94
    • 7.5.2 Management Class

      94
    • 7.5.3 Storage Group

      95
  • 7.6 Summary

    95
• Chapter 8. Converting DB2 to Systems Managed Storage

  97
  • 8.1 Overview

    97
  • 8.2 Advantages of SMS Managing DB2 Data

    97
  • 8.3 SMS Management Goals

    98
  • 8.4 Positioning for Implementation

    99
    • 8.4.1 Prerequisite Planning

      99
    • 8.4.2 Service Level Agreement

      100
  • 8.5 Conversion Process

    100
    • 8.5.1 Sequence

      100
    • 8.5.2 Methodology

      101
    • 8.5.3 SMS Implementation

      102
    • 8.5.4 Post Implementation

      103
  • 8.6 DFSMS FIT

    103
  • 8.7 NaviQuest

    103
• Chapter 9. Disk Environment Overview

  107
  • 9.1 Evolution of Disk Architecture

    107
    • 9.1.1 3380 and 3390 Volumes

      107
    • 9.1.2 Arrays

      107
    • 9.1.3 Log Structured File and SnapShot

      108
    • 9.1.4 Virtual Volumes

      110
  • 9.2 Disk Control Units

    111
    • 9.2.1 Storage Server

      111
    • 9.2.2 Storage Devices

      112
    • 9.2.3 Logical Control Unit

      112
  • 9.3 Cache Management

    112
    • 9.3.1 Track Caching

      113
    • 9.3.2 Read Record Caching

      113
    • 9.3.3 Write Record Caching (Quickwrite)

      114
    • 9.3.4 Sequential Caching

      114
    • 9.3.5 No Caching—Bypass Cache

      114
    • 9.3.6 No Caching—Inhibit Cache Load

      114
    • 9.3.7 DB2 Cache Parameters (DSNTIPE)

      114
    • 9.3.8 Dynamic Cache Management Enhancement

      114
  • 9.4 Paths and Bandwidth Evolution

    115
  • 9.5 Capabilities

    115
    • 9.5.1 Dual Copy

      115
    • 9.5.2 Concurrent Copy

      116
    • 9.5.3 Virtual Concurrent Copy

      117
    • 9.5.4 Remote Copy

      117
    • 9.5.5 Compression

      122
    • 9.5.6 Sequential Data Striping

      123
• Chapter 10. DB2 I/O Operations

  125
  • 10.1 Avoiding I/O Operations

    125
  • 10.2 Data Read Operations

    126
    • 10.2.1 Normal Read

      126
    • 10.2.2 Sequential Prefetch

      126
    • 10.2.3 Dynamic Prefetch

      127
    • 10.2.4 List Prefetch

      127
    • 10.2.5 Prefetch Quantity

      127
    • 10.2.6 Data Management Threshold

      128
    • 10.2.7 Sequential Prefetch Threshold

      129
  • 10.3 Data Write Operations

    129
    • 10.3.1 Asynchronous Writes

      129
    • 10.3.2 Synchronous Writes

      130
    • 10.3.3 Immediate Write Threshold

      130
    • 10.3.4 Write Quantity

      130
    • 10.3.5 Tuning Write Frequency

      130
  • 10.4 Log Writes

    133
    • 10.4.1 Asynchronous Writes

      134
    • 10.4.2 Synchronous Writes

      134
    • 10.4.3 Writing to Two Logs

      134
    • 10.4.4 Two-Phase Commit Log Writes

      134
    • 10.4.5 Improving Log Write Performance

      136
  • 10.5 Log Reads

    137
    • 10.5.1 Improving Log Read Performance

      138
    • 10.5.2 Active Log Size

      139
• Chapter 11. I/O Performance and Monitoring Tools

  141
  • 11.1 DB2 PM Overview

    141
    • 11.1.1 Accounting I/O Information

      142
    • 11.1.2 Statistics I/O Information

      143
    • 11.1.3 Performance I/O Information and I/O Activity

      145
  • 11.2 RMF Monitoring

    146
    • 11.2.1 RMF Report Analysis

      147
    • 11.2.2 Using RMF Reports

      154
  • 11.3 IXFP Monitoring

    157
    • 11.3.1 Device Performance Reports

      158
    • 11.3.2 Cache Effectiveness Report

      159
    • 11.3.3 Space Utilization Report

      160
• Chapter 12. Case Study

  163
  • 12.1 DB2 Case Study Analysis

    163
    • 12.1.1 General Analysis

      163
    • 12.1.2 Data Access

      166
    • 12.1.3 Suspend Times

      167
    • 12.1.4 Conclusions

      169
  • 12.2 Storage Server Analysis

    169
    • 12.2.1 RMF Views

      169
    • 12.2.2 IXFP View

      174
  • 12.3 Case Study Summary

    176
• Appendix A. Test Cases for DB2 Table Space Data Sets

  183
  • A.1 Test Environment

    183
  • A.2 Partitioned Table Space, DB2 Defined, Without SMS

    184
    • A.2.1 Create Eight STOGROUPs

      184
    • A.2.2 Create the Database

      184
    • A.2.3 Create the Table Space

      185
    • A.2.4 Display a Volume

      185
  • A.3 Partitioned Table Space, User Defined, Without SMS

    186
    • A.3.1 DEFINE CLUSTER for 16 Partitions

      186
    • A.3.2 CREATE STOGROUP

      186
    • A.3.3 CREATE DATABASE

      186
    • A.3.4 CREATE TABLESPACE

      186
    • A.3.5 Display a Volume

      187
  • A.4 DB2 Table Spaces Using SMS, Existing Names

    187
    • A.4.1 Storage Classes

      188
    • A.4.2 Management Class

      189
    • A.4.3 Storage Group

      191
    • A.4.4 ISMF Test Cases

      193
    • A.4.5 Updating the Active Configuration

      194
    • A.4.6 DB2 Definitions

      194
    • A.4.7 Data Set Allocation Results

      195
  • A.5 DB2 Table Spaces Using SMS, Coded Names

    196
    • A.5.1 Storage Class

      196
    • A.5.2 Management Class

      197
    • A.5.3 Storage Groups

      197
    • A.5.4 DB2 Definitions

      199
    • A.5.5 Data Set Allocation Results

      199
  • A.6 Partitioned Table Space Using SMS Distribution

    200
    • A.6.1 Define Volumes to SMS Storage Group

      201
    • A.6.2 ACS Routines

      201
    • A.6.3 DB2 Definitions

      201
    • A.6.4 Data Set Allocation Results

      202
  • A.7 Partitioned Table Spaces Using SMS, User Distribution

    203
    • A.7.1 Create Storage Groups

      203
    • A.7.2 ACS Routines

      204
    • A.7.3 DB2 Definitions

      205
    • A.7.4 Data Set Allocation Results

      205
• Appendix B. Test Cases for DB2 Recovery Data Sets

  207
  • B.1 BSDS and Active Logs

    207
    • B.1.1 SMS Storage Class

      207
    • B.1.2 SMS Management Class

      208
    • B.1.3 Storage Group

      209
    • B.1.4 ISMF Test Cases

      210
    • B.1.5 Data Set Allocation Results

      211
  • B.2 Archive Logs

    213
    • B.2.1 Storage Class

      213
    • B.2.2 Management Class

      214
    • B.2.3 Storage Group

      215
    • B.2.4 Data Set Allocation Results

      215
  • B.3 Image Copies

    216
    • B.3.1 Storage Class

      217
    • B.3.2 Management Class

      218
    • B.3.3 Storage Group

      219
    • B.3.4 Data Set Allocation Results

      219
• Appendix C. DB2 PM Accounting Trace Report

  223
• Appendix D. DB2 PM Statistics Report

  227
• Appendix E. Disk Storage Server Reports

  245
• Appendix F. Special Notices

  261
• Appendix G. Related Publications

  263
  • G.1 International Technical Support Organization Publications

    263
  • G.2 Redbooks on CD-ROMs

    263
  • G.3 Other Publications

    264
  • G.4 Web Sites

    264
• How to Get ITSO Redbooks

  265
  • IBM Redbook Fax Order Form

    266
• List of Abbreviations

  267
• Index

  269
• ITSO Redbook Evaluation

  273