06469nam 2200589Ia 450 991080999610332120200520144314.0(CKB)1000000000243488(OCoLC)137342277(CaPaEBR)ebrary10112982(SSID)ssj0000280541(PQKBManifestationID)11207432(PQKBTitleCode)TC0000280541(PQKBWorkID)10291483(PQKB)11256655(MiAaPQ)EBC3306829(Au-PeEL)EBL3306829(CaPaEBR)ebr10112982(EXLCZ)99100000000024348820040811d2003 uy 0engurcn|||||||||txtccrIBM TotalStorage Expert reporting how to produce built-in and customized reports /[Daniel Demer, David McFarlane]1st ed.[S.l.] IBM, International Technical Support Organizationc20031 online resource (378 p.) IBM redbooks"October 2003."0-7384-9923-4 Includes bibliographical references and index.Front cover -- Contents -- Tables -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. IBM TotalStorage Expert reporting overview -- 1.1 The scope and structure of this book -- 1.2 What is IBM TotalStorage Expert? -- 1.3 Ordering information -- Chapter 2. TotalStorage Expert data gathering and storage -- 2.1 Product co-requisite components -- 2.2 Report mechanics and graphical presentation -- 2.3 DB2 Universal Database (UDB) overview -- 2.3.1 Introduction and a brief history of DB2 -- 2.3.2 DB2 database servers today -- 2.3.3 DB2 and data management -- 2.3.4 RDBMS overview -- 2.3.5 Entities between a user and the data -- 2.3.6 DB2 UDB user roles -- 2.3.7 DB2 UDB components -- 2.4 TotalStorage Expert DB2 UDB tables overview -- 2.5 TotalStorage database table organization -- 2.6 TotalStorage Expert database tables -- Chapter 3. SQL overview -- 3.1 Getting familiar with SQL -- 3.2 Understanding a relational database table -- 3.2.1 Data types -- 3.2.2 Keys -- 3.2.3 Connecting to a database -- 3.3 Writing Structured Query Language (SQL) -- 3.4 Summary -- Chapter 4. Data extraction tools and tips -- 4.1 General recommendations -- 4.2 Ways to run SQL -- 4.3 IBM DB2 Utilities Command Center features -- 4.3.1 Command line processor -- 4.3.2 Command Center -- 4.4 IBM DB2 DataJoiner -- 4.5 QMF for Windows -- 4.6 Requirements for reports -- Chapter 5. TotalStorage Expert management built-in reports -- 5.1 Tree structure of TotalStorage built-in reports -- 5.1.1 TotalStorage Expert Built-in reports for ESS by type -- 5.1.2 TotalStorage Expert built-in reports for ETL (VTS) by type -- 5.2 Extracting data from built in reports for customization -- 5.2.1 Performance report example -- 5.2.2 Performance report example #2 -- 5.3 Viewing hardware asset management reports.5.3.1 Viewing an ESS hardware asset summary report -- 5.3.2 Viewing a detail report for an ESS -- 5.3.3 Viewing an LIC summary report -- 5.4 Viewing the ESS capacity management reports -- 5.4.1 Viewing an ESS summary report -- 5.4.2 Viewing a SCSI/FC host summary report -- 5.4.3 Viewing a historical capacity report -- 5.4.4 Capacity management report considerations -- 5.5 Viewing performance management reports -- 5.5.1 Viewing ranked performance reports -- 5.5.2 Viewing performance and threshold summary reports -- 5.5.3 Viewing Logical Volume reports -- 5.5.4 Viewing Disk Utilization Summary report -- 5.5.5 Viewing disk information and Cache Summary report -- 5.5.6 Viewing Cache Summary report -- 5.5.7 Considerations on performance summary reports -- 5.5.8 Viewing performance detail reports -- 5.6 Viewing host volume and mapping reports -- 5.6.1 Interface for viewing host volume data: Host data collected -- 5.6.2 Interface for viewing host volume data: No host data collected -- 5.6.3 View data for a single volume by the LUN serial number -- 5.6.4 View data for a single volume by the device name on a host -- 5.6.5 Neither asset/capacity or host data collected -- Chapter 6. Customized reports -- 6.1 Data exporting methods for TotalStorage Expert -- 6.1.1 Basic TotalStorage table extractions to a file -- 6.2 Global table extractions to worksheet files -- 6.3 Samples of customized reports -- 6.3.1 Sample ESS hourly cache transfer report by nickname -- 6.3.2 Simple script output to a file or screen -- 6.3.3 Sample ESS disk level performance report -- 6.3.4 Asset/performance volume statistics data collection script -- 6.3.5 Sample ESS hourly performance report -- 6.3.6 Sample ESS threshold events report script -- 6.3.7 Sample ESS performance (highest utilized arrays) report -- 6.3.8 Sample of assigned storage by ESS report.6.3.9 ESS Host volume assignment by attach type -- 6.3.10 Sample ESS volume level performance data -- 6.3.11 Example of summary-hierarchical query statements -- 6.3.12 Example of ranked IO request query statement -- 6.3.13 Sample report using SAS script -- Appendix A. Data extraction scripts -- Scripts for extracting all database tables -- Windows 2000 platform -- Sample script for extracting volume level performance data -- Asset and performance volume statistics data collection script -- AIX platform -- SAS custom script -- Appendix B. TotalStorage Expert database table layouts -- Appendix C. Additional material -- Locating the Web material -- Using the Web material -- System requirements for downloading the Web material -- How to use the Web material -- Glossary -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- fHow to get IBM Redbooks -- Help from IBM -- Index -- Back cover.IBM redbooks.Storage area networks (Computer networks)Computer storage devicesStorage area networks (Computer networks)Computer storage devices.004.6Demer Daniel1684694McFarlane David1684695International Business Machines Corporation.International Technical Support Organization.MiAaPQMiAaPQMiAaPQBOOK9910809996103321IBM TotalStorage Expert reporting4056316UNINA