Manuals / IBM / Computer Equipment / Server

IBM 5655-DB2, 5695-DF1 manual Xiv Storage Management with DB2 for OS/390

Models: 5695-DF1 5655-DB2

1 274

Download 274 pages 18.18 Kb

Page 16

xivStorage Management with DB2 for OS/390

Image 16

IBM 5655-DB2, 5695-DF1 manual Xiv Storage Management with DB2 for OS/390

Contents

Storage Management with DB2 for OS/390 Page Storage Management with DB2 for OS/390 SeptemberTake Note Contents Iv Storage Management with DB2 for OS/390 Page Storage Class Management Class Storage Group Summary Page Viii Storage Management with DB2 for OS/390 List of Abbreviations Index Itso Redbook Evaluation Storage Management with DB2 for OS/390 Figures Xii Storage Management with DB2 for OS/390 Xiii Xiv Storage Management with DB2 for OS/390 Tables Xvi Storage Management with DB2 for OS/390 Preface Team That Wrote This RedbookXviii Storage Management with DB2 for OS/390 Comments Welcome IBM UKYour comments are important to us XixXx Storage Management with DB2 for OS/390 Part 1. Introduction and Summary Storage Management with DB2 for OS/390 Introduction Storage Management with DB2 for OS/390 DB2 and Storage Management Summary of ConsiderationsBenefits of Dfsms Data Placement DB2 and Storage ServersManaging DB2 Data Sets with Dfsms Examples for Managing DB2 Data Sets with DfsmsRamac Architecture Log Structured FileSMS Storage Groups Performance Management Part 2. DB2 and System Managed Storage Storage Management with DB2 for OS/390 DB2 Storage Objects DB2 OverviewDB2 Data Objects Tablespace Index Indexspace Database StogroupTablespace Creating Table Spaces and Index Spaces Index1 DB2 Defined and Managed User Defined and ManagedDB2 Catalog and Directory DB2 System Table SpacesWork Database DSNDB01.SYSLGRNX DB2 Recovery Data Sets Bootstrap Data SetsDB2 Application Table Spaces DsntipnActive Logs Impact of Log Size on Backup and Recovery StrategySizing Active Logs DB2 LOG Active LOG Archive + Active LOG Archive LogsImage Copies Image Copy AvailabilityImage Copy Options Application Read ProcessingApplication Write Processing Image Copy Failures During RecoveryDeleting Image Copies and Archive Logs Other DB2 Data Sets DB2 Data Sets Naming ConventionsOther Copies 1 DB2 Library Data SetsBsds Names Table Space and Index Space NamesActive Log Names Archive Log and Bsds Backup Names Image Copy NamesBackground System Managed Storage Concepts and ComponentsEvolution DFSMS/MVS Components DFSMSdfpIsmf for the End User Ismf Primary Option Menu DFSMS/MVSDFSMSdss Ismf for the Storage AdministratorFunctionality Filtering DFSMShsmConverting Data to SMS DFSMShsm Environment Space ManagementAvailability Management DFSMSrmm DFSMSoptBenefits SMF RecordsSystem Managed Storage Concepts and Components Storage Management with DB2 for OS/390 Base Configuration Storage Management with DfsmsIntroduction Source Control Data SetAutomatic Class Selection Routines Class and Storage Group DefinitionsCommunications Data Set Define Classes and Storage GroupsACS Routine Process Data Class SMS ClassesDescription Storage Class Planning for ImplementationStorage Class Attributes Management Class Management Class Attributes Storage Group Planning for Implementation Mapping Devices to Storage Groups for Performance Naming Standards ExamplesUsing Ismf to Display SMS Constructs Managing DB2 Databases with SMSSMS Examples for DB2 Databases SMS Data ClassScdbmed SMS Storage ClassData Class Application Selection SMS Management Class MCDB22 SGDB20SGDB21 SGDB22Sgdbtest Sgdbxxxx6 DB2 STOGROUPs and SMS Storage Groups Pool Storage Group AlterAssigning SMS Classes to DB2 Table Spaces and Index Spaces PoolHigh Level Qualifier Filter Database Name FilterTable Space Name Filter High Level Qualifier CodesTable Space Name Codes SET &STOGROUP EQ SGDB2GRASET &STOGROUP EQ SGDB2GRB SET &STOGROUP EQ SGDB2GRCManaging Partitioned Table Spaces with SMS Table Space and Index Space Names for SMSLet SMS Manage Everything Use One SMS Storage Group for Each Partition User DatabasesUse One SMS Storage Group for One Partitioned Table Space Online Production Databases Batch Production DatabasesData Warehouse Databases Storage ClassesSummary Development and Test DatabasesScdbmed Scdbtest Scdbfast DB2 System Databases Catalog and Directory DatabasesDirectory Good Very High Storage Management with DB2 for OS/390 Managing DB2 Recovery Data Sets with SMS SMS Examples for DB2 Recovery Data SetsMcdbicd McdbicwMcdbicm MCDBLV2Sgdbich SgdbicSgdbarch Sgdbactl Assigning SMS Classes to DB2 Recovery Data SetsSGDB2PLG Bsds Data OrganizationPerformance AvailabilityBackup Active LogsACS Example MigrationArchive Logs Example Vsam Definition of One Active LogDsntipa Allocation Units === CYLPrimary Quantity === Secondary QTYImage Copies Scdbic Scdbich Summary Sgdbic Sgdbich SgdbarchStorage Management with DB2 for OS/390 Converting DB2 to Systems Managed Storage OverviewAdvantages of SMS Managing DB2 Data Dfsms FITSMS Management Goals Positioning for Implementation Prerequisite PlanningConversion Process Service Level AgreementSequence Converted with Movement MethodologyConverted in Place SMS Implementation NaviQuest Post ImplementationStorage Management with DB2 for OS/390 Part 3. DB2 and Storage Servers Storage Management with DB2 for OS/390 1 3380 and 3390 Volumes Disk Environment OverviewEvolution of Disk Architecture ArraysLog Structured File and SnapShot Timed evolutionary view of the dataShips LOG Virtual Volumes FTT TNTDisk Control Units Storage ServerStorage Devices Cache ManagementLogical Control Unit Track Caching Read Record CachingWrite Record Caching Quickwrite Sequential CachingNo Caching-Bypass Cache No Caching-Inhibit Cache LoadCapabilities Paths and Bandwidth EvolutionDual Copy Schema of a Backup with Concurrent Copy Concurrent CopyVirtual Concurrent Copy Remote CopyPprc Profile of a Pprc WriteNeed for Time-Consistency Geographically Dispersed Parallel SysplexImplementation ProcessingExtended Remote Copy Compression XRC Data FlowSequential Data Striping Storage Management with DB2 for OS/390 Avoiding I/O Operations DB2 I/O Operations103 Normal Read Data Read OperationsSequential Prefetch List Prefetch Dynamic PrefetchPrefetch Quantity Data Management Threshold Sequential Prefetch Threshold Data Write OperationsAsynchronous Writes Tuning Write Frequency Synchronous WritesImmediate Write Threshold Write QuantityBuffer Updates Synchronous Write Synchronous Read TOT4K Total Bpool HIT Ratio % GetpagesSEQ. Prefetch Reqs List Prefetch Reqs DYN. Prefetch ReqsBuffer Updates BP4Commit Getpage RequestNo Wait Force Log WritesPhysical Writes Two-Phase Commit Log Writes Writing to Two LogsNowait Force Async SyncAvoid Device Contention Improving Log Write PerformanceLOG Output Buffer Size Devices for Log Data SetsLog Reads Preformat New Active Log Data SetsAvoid Device Contention Improving Log Read PerformanceActive Log Size Log Input BufferActive Log Size Archive to Disk and TapeLog Sizing Parameters Calculating Average Log Record SizeBsds Access Requests LOG ActivityMinute Thread Commit WRITE-NOWAIT11.1 DB2 PM Overview O Performance and Monitoring Tools119 Accounting I/O Information 11.1.1.1 I/O OperationsStatistics I/O Information 11.1.1.2 I/O SuspensionsData I/O Operations 121PREF.DISABLED-NO Buffer Log ActivityBP4 Read Operations Minute Thread Commit Bpool HIT Ratio %Performance I/O Information and I/O Activity 123Minute Thread WRITE-NOWAIT Write Output LOG BuffersRMF Monitoring Buffer Pool Totals AET Total I/O RequestsTotal Read I/O Requests Total Write Requests Synchronous WritesRMF Report Analysis Cache Subsystem Activity ReportsReports Cache Subsys 125Cache Subsystem Status Cache Subsystem Overview127 C H E S U B S Y S T E M a C T I V I T YCache Subsystem Device Overview Direct Access Device Activity ReportReports Device Dasd 129 R E C T a C C E S S D E V I C E a C T I V I T YAVG Conn Time * Device Activity RATE/1000*100 Queuing Activity ReportReports IOQ Channel Path Activity Repor t131 Using RMF Reports Resource Level AnalysisRMF Reporting at Storage Group Level Device Activity Rate 1,042.261 AVG Conn TimeTools Providing More In-Depth Analysis than RMF Spreadsheet Tools for RMF AnalyzisGlobal View of a DB2 I/O by DB2 PM and RMF Disk Storage Server Ixfp Monitoring135 Device Performance Reports Cache Effectiveness Report 137Space Utilization Report IBM Itso Pokeepsie139 2B00Storage Management with DB2 for OS/390 12.1 DB2 Case Study Analysis Case StudyGeneral Analysis SQL DML Total Select Insert Update Delete DB2 ClassCPU Time TCBTime Not Accounted Data Access BP0BP2 BP4Suspend Times Synchronous I/O12.1.3.3 I/O Rate Asynchronous Read I/OPrograms Parallelism Storage Server Analysis ConclusionsRMF Views Summary of I/O operationsReduction Device Activity Report Analysis 12.2.1.2 I/O Queuing Activity Report AnalysisChannel Path Activity Report Analysis E U I N GCase Study RMF Cache Subsystem Activity Extracts Ixfp View Device Performance Overall SummaryCache effectiveness Overall Summary Space Utilization SummaryCase Study Summary 28.1DB2 PM I/O Summary Cache Activity 2715 216 DiskStorage Management with DB2 for OS/390 Part 4. Appendixes 159Storage Management with DB2 for OS/390 Appendix A. Test Cases for DB2 Table Space Data Sets Test EnvironmentCU0 CU1 CU2 CU3 161Create Stogroup SGRV1CU0 Volumes RV1CU0 Vcat DB2V610Z Partitioned Table Space, DB2 Defined, Without SMSCreate Eight STOGROUPs Create the DatabaseDisplay a Volume Create the Table SpaceVOLUMESRV2CU1 Partitioned Table Space, User Defined, Without SMSDefine Cluster for 16 Partitions SHAREOPTIONS3 DataDB2 Table Spaces Using SMS, Existing Names DB2V610Z.DSNDBD.BPAOLOR1.PART2.I0001.A005DB2V610Z.DSNDBD.BPAOLOR1.PART2.I0001.A013 SYS1.VTOCIX.RV2CU1Scdbtest Scdbfast Scdbmed Scdbcrit Storage Class DefineSMS.SCDS1.SCDS Storage Class for Test DB2 TablespacesManagement Class Test Case 3 Storage Class Routine ExtractConditional Management Class DefineManagement Class Filtlist Definitions Filtlist MCDB20 Pool Storage Group Define Storage GroupSgdbtest Storage Group Volume Selection SMSACS Testing Results Ismf Test CasesCreate Stogroup SGRV1CU0 Volumes Vcat DB2D Updating the Active Configuration6 DB2 Definitions Data Set Allocation Results DB2 Table Spaces Using SMS, Coded Names Scdbtest Scdbmed Scdbfast ScdbcritMCDB0 MCDB1 MCDB2 Storage ClassStorage Groups Filtlist MCDB21 INCLUDEDB2P.DSNDB%.*.M1 Filtlist MCDB22 INCLUDEDB2D.DSNDB%.*.T24 DB2 Definitions Partitioned Table Space Using SMS Distribution UCAT.VSBOX09 History SmsdataDefine Volumes to SMS Storage Group 3 DB2 DefinitionsPart 2 Using Stogroup SGRV1CU0 Part 8 Using Stogroup SGRV1CU0DB2D.DSNDBD.BPAOLOR1.PART1.I0001.A005 DB2D.DSNDBD.BPAOLOR1.PART1.I0001.A003Partitioned Table Spaces Using SMS, User Distribution Line Volume Free Alloc FragCreate Storage Groups DB2D.DSNDBC.BPAOLOR1.PART1.I0001.A001Line Storgrp VIO Auto Migrate System Storage Group ListName Type Maxsize Unit Migrate Or SYS Group Test Case 6 Storage Group ACS Routine Extract Create Tablespace Beta BPAOLOR1 Data SET ListLine Alloc Operator Data SET Name Space Used SerialAppendix B. Test Cases for DB2 Recovery Data Sets Bsds and Active LogsSMS Storage Class 185SMS Management Class Storage Class Name ScdbactlIf &DSN EQ &ACTLOG Then do SET &MGMTCLAS = Mcdbactl Exit END Select When &STORCLAS = Scdbactl SET &STORGRP = Sgdbactl When &STORCLAS = ScdbactlStorage Group SET &STORGRP = SGDB2PLG ENDIndex NAMEDB2P.BSDS01.INDEX RECORDS5 Idcams Definition Extract for BsdsIdcams System Services Define Cluster Name DB2P.LOGCOPY1.DS01 VOLUMESRV1CU1 ReuseDB2P.BSDS01 DB2P.BSDS01.INDEXDB2P.LOGCOPY1.DS01 DB2P.LOGCOPY1.DS01.DATADB2P.LOGCOPY1.DS02 DB2P.LOGCOPY1.DS02.DATAFiltlist Dbarch Select When &DSN = &DBSYSSET &STORCLAS = Scdbarch Otherwise SET &STORCLAS = END DSNJ003I =DB2P DSNJOFF3 Full Archive LOG Volume SET &STORGRP = SgdbactlSET &STORGRP = Sgdbarch END =DB2P Archive LOG ModequiesceMCDBLV2 Filtlist Ichigh Filtlist IcstdFiltlist ICW Filtlist ICDFiltlist ICM SET &STORGRP = Sgdbich END Storage Group Routine Extract Incorporating Image CopiesIGD101I SMS Allocated to Ddname Syscopy Dsntrace DD SYSOUT= SYSCOPY1 DDVOL SER NOS= RV2CU0 Scdbich Storage Management with DB2 for OS/390 Appendix C. DB2 PM Accounting Trace Report 201DB2 Version DB2 PM Accounting Trace Report Storage Management with DB2 for OS/390 Appendix D. DB2 PM Statistics Report 205Location DB2 PM Statistics Report Group Boag Statistics Report Long Plan Allocation Attempts Display Utility TERMINATED-NO Storage Auth SUCC-PLAN-W/O Catalog Quantity Minute Thread Location USIBMT6BOAPLX DB2 Performance Monitor Group Boag General Quantity Minute Thread Pages Written PER Write I/O General Quantity Minute Thread Commit BP2 Read Operations Storage Management with DB2 for OS/390 BP4 Read Operations Quantity Minute 60274.00 1776.11 30.1K BP5 Read Operations Quantity Minute 46.00 23.00 106.55 60274.00 1776.11 30.1K Appendix E. Disk Storage Server Reports 223U I N G T I V I T Y Disk Storage Server Reports C H E B S Y S T E M T I V I T Y C H E B S Y S T E M 30.3 CU-ID 2BC0 Ssid 008B Rate Count 26.8 38.6 CU-ID 2CC0 Ssid 200A System R E C T C E S S V I C E T I V I T Y Ixfp Extract Reports Cache Effectiveness Overall Summary Space Utilization Summary Report Appendix F. Special Notices 239IBM  DB2 MVS/ESA Appendix G. Related Publications International Technical Support Organization PublicationsRedbooks on CD-ROMs 241Other Publications Web SitesHow to Get Itso Redbooks 243IBM Redbook Fax Order Form Please send me the followingList of Abbreviations 245Redundant array Index Numerics 247Dump 249 Scds SDMWrite Threshold Itso Redbook Evaluation 251Storage Management with DB2 for OS/390 SG24-5462