Manuals / IBM / Computer Equipment / Server

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

Models: 5695-DF1 5655-DB2

1 274

Download 274 pages 18.18 Kb

Page 274

SG24-5462-00

Printed in the U.S.A.

Storage Management with DB2 for OS/390

SG24-5462-

00

Image 274

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

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 Your comments are important to us Comments WelcomeIBM UK 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 Managing DB2 Data Sets with Dfsms Data PlacementDB2 and Storage Servers 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 Data Objects DB2 Storage ObjectsDB2 Overview 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 Application Table Spaces DB2 Recovery Data SetsBootstrap Data Sets DsntipnActive Logs Impact of Log Size on Backup and Recovery StrategySizing Active Logs DB2 LOG Active LOG Archive + Active LOG Archive LogsImage Copy Options Image CopiesImage Copy Availability Application Read ProcessingApplication Write Processing Image Copy Failures During RecoveryDeleting Image Copies and Archive Logs Other Copies Other DB2 Data SetsDB2 Data Sets Naming Conventions 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 Ismf for the End User DFSMS/MVS ComponentsDFSMSdfp 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 Introduction Base ConfigurationStorage Management with Dfsms Source Control Data SetCommunications Data Set Automatic Class Selection RoutinesClass and Storage Group Definitions 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 ExamplesSMS Examples for DB2 Databases Using Ismf to Display SMS ConstructsManaging DB2 Databases with SMS SMS Data ClassScdbmed SMS Storage ClassData Class Application Selection SMS Management Class SGDB21 MCDB22SGDB20 SGDB22Sgdbtest Sgdbxxxx6 DB2 STOGROUPs and SMS Storage Groups Pool Storage Group AlterAssigning SMS Classes to DB2 Table Spaces and Index Spaces PoolTable Space Name Filter High Level Qualifier FilterDatabase Name Filter High Level Qualifier CodesSET &STOGROUP EQ SGDB2GRB Table Space Name CodesSET &STOGROUP EQ SGDB2GRA 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 Data Warehouse Databases Online Production DatabasesBatch Production 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 SetsMcdbicm McdbicdMcdbicw MCDBLV2Sgdbich SgdbicSgdbarch Sgdbactl Assigning SMS Classes to DB2 Recovery Data SetsSGDB2PLG Performance BsdsData Organization AvailabilityACS Example BackupActive Logs MigrationArchive Logs Example Vsam Definition of One Active LogPrimary Quantity === DsntipaAllocation Units === CYL Secondary QTYImage Copies Scdbic Scdbich Summary Sgdbic Sgdbich SgdbarchStorage Management with DB2 for OS/390 Advantages of SMS Managing DB2 Data Converting DB2 to Systems Managed StorageOverview 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 Evolution of Disk Architecture 1 3380 and 3390 VolumesDisk Environment Overview 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 CachingNo Caching-Bypass Cache Write Record Caching QuickwriteSequential Caching 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 Immediate Write Threshold Tuning Write FrequencySynchronous Writes Write QuantitySEQ. Prefetch Reqs Buffer Updates Synchronous Write Synchronous ReadTOT4K Total Bpool HIT Ratio % Getpages List Prefetch Reqs DYN. Prefetch ReqsCommit Buffer UpdatesBP4 Getpage RequestNo Wait Force Log WritesPhysical Writes Two-Phase Commit Log Writes Writing to Two LogsNowait Force Async SyncLOG Output Buffer Size Avoid Device ContentionImproving Log Write Performance Devices for Log Data SetsLog Reads Preformat New Active Log Data SetsActive Log Size Avoid Device ContentionImproving Log Read Performance Log Input BufferLog Sizing Parameters Active Log SizeArchive to Disk and Tape Calculating Average Log Record SizeMinute Thread Commit Bsds Access RequestsLOG Activity WRITE-NOWAIT11.1 DB2 PM Overview O Performance and Monitoring Tools119 Accounting I/O Information 11.1.1.1 I/O OperationsData I/O Operations Statistics I/O Information11.1.1.2 I/O Suspensions 121BP4 Read Operations PREF.DISABLED-NO BufferLog Activity Minute Thread Commit Bpool HIT Ratio %Minute Thread Performance I/O Information and I/O Activity123 WRITE-NOWAIT Write Output LOG BuffersTotal Read I/O Requests RMF MonitoringBuffer Pool Totals AET Total I/O Requests Total Write Requests Synchronous WritesReports Cache Subsys RMF Report AnalysisCache Subsystem Activity Reports 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 YReports IOQ AVG Conn Time * Device Activity RATE/1000*100Queuing Activity Report Channel Path Activity Repor t131 Using RMF Reports Resource Level AnalysisTools Providing More In-Depth Analysis than RMF RMF Reporting at Storage Group LevelDevice Activity Rate 1,042.261 AVG Conn Time 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 CPU Time SQL DML Total Select Insert Update DeleteDB2 Class TCBTime Not Accounted BP2 Data AccessBP0 BP4Suspend Times Synchronous I/O12.1.3.3 I/O Rate Asynchronous Read I/OPrograms Parallelism RMF Views Storage Server AnalysisConclusions 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 CU0 CU1 CU2 CU3 Appendix A. Test Cases for DB2 Table Space Data SetsTest Environment 161Create Eight STOGROUPs Create Stogroup SGRV1CU0 Volumes RV1CU0 Vcat DB2V610ZPartitioned Table Space, DB2 Defined, Without SMS Create the DatabaseDisplay a Volume Create the Table SpaceDefine Cluster for 16 Partitions VOLUMESRV2CU1Partitioned Table Space, User Defined, Without SMS SHAREOPTIONS3 DataDB2V610Z.DSNDBD.BPAOLOR1.PART2.I0001.A013 DB2 Table Spaces Using SMS, Existing NamesDB2V610Z.DSNDBD.BPAOLOR1.PART2.I0001.A005 SYS1.VTOCIX.RV2CU1SMS.SCDS1.SCDS Scdbtest Scdbfast Scdbmed ScdbcritStorage Class Define 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 MCDB0 MCDB1 MCDB2 DB2 Table Spaces Using SMS, Coded NamesScdbtest Scdbmed Scdbfast Scdbcrit 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 DefinitionsDB2D.DSNDBD.BPAOLOR1.PART1.I0001.A005 Part 2 Using Stogroup SGRV1CU0Part 8 Using Stogroup SGRV1CU0 DB2D.DSNDBD.BPAOLOR1.PART1.I0001.A003Create Storage Groups Partitioned Table Spaces Using SMS, User DistributionLine Volume Free Alloc Frag 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 Line Alloc Create Tablespace Beta BPAOLOR1Data SET List Operator Data SET Name Space Used SerialSMS Storage Class Appendix B. Test Cases for DB2 Recovery Data SetsBsds and Active Logs 185SMS Management Class Storage Class Name ScdbactlIf &DSN EQ &ACTLOG Then do SET &MGMTCLAS = Mcdbactl Exit END Storage Group Select When &STORCLAS = ScdbactlSET &STORGRP = Sgdbactl When &STORCLAS = Scdbactl SET &STORGRP = SGDB2PLG ENDIndex NAMEDB2P.BSDS01.INDEX RECORDS5 Idcams Definition Extract for BsdsDB2P.BSDS01 Idcams System ServicesDefine Cluster Name DB2P.LOGCOPY1.DS01 VOLUMESRV1CU1 Reuse DB2P.BSDS01.INDEXDB2P.LOGCOPY1.DS02 DB2P.LOGCOPY1.DS01DB2P.LOGCOPY1.DS01.DATA DB2P.LOGCOPY1.DS02.DATAFiltlist Dbarch Select When &DSN = &DBSYSSET &STORCLAS = Scdbarch Otherwise SET &STORCLAS = END SET &STORGRP = Sgdbarch END DSNJ003I =DB2P DSNJOFF3 Full Archive LOG VolumeSET &STORGRP = Sgdbactl =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 Redbooks on CD-ROMs Appendix G. Related PublicationsInternational Technical Support Organization Publications 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