IBM TotalStorage Expert reporting : how to produce built-in and customized reports / [Daniel Demer, David McFarlane].

Format:

Book

Author/Creator:

Demer, Daniel.

Contributor:

McFarlane, David.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Storage area networks (Computer networks).

Computer storage devices.

Physical Description:

1 online resource (378 p.)

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, c2003.

Language Note:

English

Contents:

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.

Notes:

"October 2003."

Includes bibliographical references and index.

OCLC:

137342277