Home

Tivoli Storage Manager Reporting - e

1. 117 64 Client results of operations 0000 cece eee 118 65 Data movement by filesize and total throughput 119 66 Client data throughput by platform 0000 e cee eee 120 67 Total objects restored for clients 200000 cee eee 121 68 Non scheduled server operations 0 00 c eee ee eee 123 69 How much data is processed by daily server operations 124 70 What is the average hourly throughput rate for server operations 125 71 Reports available on storage health 0 0 00 126 72 How does platform affect client throughput rates 128 73 Summary of client messages by TSM software level 129 74 Show how to read the related views and the file names for location in the ta bles below132 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 50 pm 6109LOT fm Tables Copyright IBM Corp 2000 xi 6109LOT fm Draft Document for Review April 18 2000 1 50 pm xii Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 35 am 6109pref fm Preface This redbook addresses the problem of generating meaningful presentation style reports from Tivoli Storage Management data sources We concentrate on the use of Tivoli Decision Support and the Storage Management Analysis Guide as part of an integrated Tivoli Storage Management reporting solution The book builds the u
2. to the client name Sessions associated with specific clients If an operation was not initiated the session name is set to None Note The layer can have Operation Unknown for scheduled operations that were not initiated Appendix A Retate views tor the tabte anatysis T41 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What is the TSM_srvsch rpt This view provides a summary of TSM_msg rpt status of scheduled administrative operations TSM_srvnosch rpt scheduled administrative Use this view to determine the results operations of scheduled administrative operations and determine failures that need to be corrected This view applies to administrative operations that use the Tivoli Storage Manager scheduler Report parameters are provided to specify e Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server 142 Tivoli Storage Manager R
3. To identify the specific client names associated with a platform use the view TSM_cli003 How many clients are registered with each server Select the platform level of interest from the dimension line and drill down on a server Note If a client does not report its platform Platform Not Reported appears This occurs for older versions of client software TSM_cli003 ppr TSM_cli004 ppr Which are my 10 fastest clients TSM_cl010 ppr This view provides a list of the ten Tivoli Storage Manager clients that have the highest aggregate throughput KB s over the last 7 days Use this view to identify the top performing clients A layer is provided to select a specific server or an aggregate of all servers can be displayed TSM_cl018 ppr TSM_cl011 ppr TSM_cl012 ppr TSM_clb005 ppr TSM_cl014 ppr Appendix A Relate views for the table analysis 161 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What are client throughput rates TSM_cl017 ppr This view provides the throughput KB s for Tivoli Storage Manager clients Throughputs are calculated based on the last 7 days of client session activity Use this view to identify aggregate throughput rates for all client associated with each Tivoli Storage Manager Server Also you can drill down to see specific client session throughp
4. ox and continue down the list in the Tivoli Storage Management Decision Support Loader 46 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Server List Noe None neptune on pranres2 Remove PALANA ON PRANRES2 pranres4 on pranres 2 37200 AM Figure 10 DSL server list setup From the table list add the tables as in Figure 11 that should be loaded These are the elements you want to see in the reports that will be shown from the Tivoli Discovery Interface Select ox and continue to Data Source Chapter 4 Configuration and Implementation 47 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm a Update Table List x Tables to add Tables to Load Eddo __ lt Remove __ lt Remove P AIE P lt lt Remove All lt lt Remove All DB DBVOLUMES DEVCLASSES DRIVES EVENTS FILESPACES LOG LOGVOLUMES NODES STATUS gt Apply OK Cancel Figure 11 Tables to be loaded in the DSL e The data source setup will need to point to the RDBMS server where all the data will be stored so that reports can be made from the database The data is collected stored and analyzed from the Tivoli Storage Management server as in Figure 12 userid s and passwords greyed out DSN should be your database machine UID is the user id to the database Microsoft SQL DB2 Oracle Password that is r
5. 0 0 02 ee 127 6 7 Comprehensive Tivoli Storage Management reporting 129 Appendix A Relate views for the table analysis 131 Appendix B Using the additional material 175 B 1 Using the CD ROM or diskette 00 0000 e eee eee 175 B 1 1 System requirements for using the CD ROM or diskette 175 B 1 2 How to use the CD ROM or diskette 00 00 175 B 2 Locating the additional material on the Internet 175 B 3 Using the Web material 1 2 0 0 0 e eee ee 176 B 3 1 System requirements for downloading the Web material 176 B 3 2 How to use the Web material 0 0 00 176 Appendix C Special notices 0 2 0 177 Appendix D Related publications 0 181 D 1 IBM Redbooks publications 00 aeaa 181 D 2 IBM Redbooks collections 0 0c eee eee 182 D 3 Tivoli Storage Management publications 000085 182 How to get IBM Redbooks 0 00 e eee eee 185 IBM Redbooks fax order form 02 00 cee eee eee ee 186 GIOSSANY o re oi aaa a ace Bi a Kea ed ade D aa 187 INDEX erana ea een Hae Rare AE tae Pa oe ae Pee Ea ees 189 IBM Redbooks review 00 eee eee 191 Vii 6109TOC fm Draft Document for Review April 18 2000 1 49 pm viii Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 50 pm
6. 113204K 700968K Figure 49 CPU utilization 100 while TSMDSL is running 5 2 2 Cleanup of RDBMS records Cleanup of data records which you no longer want to report on in the RDBMS Microsoft SQL DB2 Oracle are required in any database that is used This could be performed by the Database Administrators Another method of doing data cleanup is called pruning This is performed by the Tivoli Storage Management Administrators by using a parameter to specify the length of time data will be retained in the reporting database When the Decision Support Loader is run after the number of days specified in this parameter data exceeding the parameter is expired from the reporting database The maximum length of time you can specify is 366 days Chapter 5 Operational Procedures for Storage Management Analysis 97 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm The Decision Support Loader is set to prune approximately one thousand records at a time You can change this default setting by modifying the number of records specified in the following line in the configuration file ApproxRecordsToPrunePerBatch 1000 Should you have a large number of records to prune specifying a small number of records in the above line can slow the Decision Support Loader processing time The number of records that your system can process depends on the size of the transaction log defined during the database configuration Transaction lo
7. 2000 1 48 pm 6109ch03 fm 3 2 What size machines and why is this important The RDBMS and tsmdsl machines themselves have minimum configuration specifications See Chapter 5 2 4 Duplicating to other file servers on page 98 for more on this However depending on usage other processor components can be stressed Consider I O performance CPU utilization memory usage and data storage availability when planning for Storage Management Analysis or trouble shooting problems If too many Storage Management Analysis reports are open simultaneously this can effect memory and cause unpredictable results Also in the case of cube reporting memory on the PC video card can be restrictive This situation can be unpredictable as well Generally these situations can be isolated by running only the failing set s of reports and noting results 3 3 Choosing a relational database for SMA Three alternatives are presently supported with Tivoli Decision Support and Storage Management Analysis These are Oracle DB2 and MSSQL See the RDBMS section in Chapter 2 3 1 Tivoli Storage Manager reporting database on page 29 Most Tivoli Storage Management administrators will go with the relational technology that is available in their organization This is a good decision because this affords you an established and supported environment Utilize the talents of your DBA group We cover a typical DBS dialog in Chapter 4 4 4 Setup guide for ODBC
8. ANRSOD ss recons CRA hualld magle vember bud h tame header ANRSGSID ss econs 02219 rong segmentgroup Kd ound h tame header ANRSGSOD sereoo 02225 Wrong sequence amber und h frame eager Figure 22 Example of a Seagate Crystal Report A Cognos report can be seen from the Tivoli Discovery Interface in Figure 23 on page 66 Cognos Powerplay Cubes can be created and used to display multidimensional graphical views Queries are issued against the Tivoli Storage Manager Reporting database to generate data source files Cognos uses the data from these files to generate a cube which can be seen in the Chapter 4 Configuration and Implementation 65 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Tivoli Discovery Administrator The cube is a multidimensional database that 66 can be viewed using Powerplay reports The Tivoli Decision Support Administrator controls the creation of the cube by performing a two step process TDS Administrator first creates data source files comma separated value files csv or txt by exporting the queries from the relational database Cognos Transformer takes the data source files and summarizes the data and packages this information into a compressed cube file Tivoli Discovery Interface How does platform affect client throughput rates 0 x ial File Edt View Inset Explore Calculate Format Tools Window Help 18 x ulaj al E Glo ofa 52 galala ile
9. How does TSM_clb004 ppr This view provides an hourly summary TSM_clb002 ppr time of day of Tivoli Storage Manager client TSM_clb003 ppr affect client session activity for the last 7 days session activity Use this information to determine hourly client session activity A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly session activity of all client operations or a specific client operation can be selected What time of TSM_clb001 ppr This view lets you look at an estimate TSM_clb003 ppr day do peak of the hourly Tivoli Storage Manager TSM_clb004 ppr data transfers client data transfer activity This hourly occur estimate is based on the last 7 days of information Use this view to determine when peak data transfer activity occurs for each client operation This can be useful for capacity planning purposes as well as assist with client scheduling A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly throughput of all client operations or a specific client operation can be selected 172 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Which clients TSM_cl00
10. Tivoli Decisions Support with Storage Management Analysis is the tool of choice 130 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm Appendix A Relate views for the table analysis This appendix will show the related views to specific file names which will allow you to make reference to the tables In order to understand what these tables do and how they work you will be required to click on view tab in the sub window at the bottom and look at the file names as in the Figure 74 On finding the file name you can cross reference the file name with the tables below and find out how they are related to one another also allowing a futher exploration of the break downs for related views Copyright IBM Corp 2000 131 132 6109ax01 fm fat Eo Case Fmt Tos Wit Heb Ba fa i Si lo How much time is spent daily waiting for media access aie tata 3 pouT Ube tilted e eerie Tilia nape E reese cent He ee id ov chn etc chietate fd Vielebesveape dd daed ime sree la ec J O Tusa Wees lied evef Ho hn et og eda Short ioc kt ew im Fee C punigon intemeiat Tase Taldra TLE divitesmpitcusiteten Kemenet Talet Taaa Bete altain teaa dhogdin ee keanaan TwluaptengreiPets 13 948 i ja f Hili Feito Hy Bots Poles Sat Fah Dengen Kanak Related Views for How much
11. clients have spent the most time performing operations and what those operations were A layer is provided to select a specific server or an aggregate of all servers can be displayed TSM_cl018 ppr TSM_cl010 ppr TSM_cl012 ppr TSM_clb005 ppr TSM_cl014 ppr How does TCP IP address affect client throughput TSM_cl012 ppr This view presents Tivoli Storage Manager client throughput for the last 7 days based on network addresses Use this information to determine how tcp ip addresses can affect throughput A layer is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided to explore subnets to determine potential sources of performance problems TSM_cl018 ppr TSM_cl011 ppr TSM_cl010 ppr TSM_clb005 ppr TSM_cl014 ppr Appendix A Relate views for the table analysis 163 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views How does platform affect client throughput rates TSM_clb005 ppr This view provides a summary of Tivoli Storage Manager client throughput by platform Information is based on the last 7 days activity Use this information to identify performance trends based on Tivoli Storage Manager client platform Drill down is provided for each TSM server The drill down levels are as follows e Tivoli Storage Manager se
12. 1 49 pm 6109ch04 fm Create a New Data Source to SQL Server ef Op LAV Stee Figure 35 Process options to be applied Select any processing option you want to apply or use the default settings Figure 35 Click Finish to open the opBc Microsoft SQL Server Setup dialog box Chapter 4 Configuration and Implementation 79 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm ODBC Microsoft SOL Server Setup Figure 36 Test data source for connection Check the configuration summary to make sure the setting matchs the ones you entered in the setup wizard If the settings do not match click ox to return to the Data Source Administrator and repeat the SQL ODBC setup proceure to adjust option settings If t the settings are correct Click Test Data Source to establish a connection to the specified SQL server and verify option settings Figure 36 80 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm SOL Server DDEC Bates Source T est H pe a eee r ao zo cs Gee ace Bo so A ace sig ees EE a oe es SA oes ee s ace cee es EA mo B So or a ee cs Ee a eo es See oes ee Sa Sac eee Figure 37 Data source test complete Click ox to exit the setup wizard and return to the Data Source Administrator If the data source test failed you can repeat the SQL ODBC setup procedure to adjust option settings Figure 37 From the Data So
13. 2000 1 49 pm The admin users must be able to specify the username password and the network share name that will be used by the Tivoli Decision support Scheduler service to create a network connection Error 81727 The option on the Tools menu used to re register the MS DAO Library file dao350 dll will not work if the path to the file contains a space Process Scheduler Service Error 81071 Error message Unable to connect to the data source The database does not exist or is read only When trying to connect to a shared data drive As per the above this is what the Tivoli Decision Support Patch fixes The patch is a self extracting file and is run from the start menu and select G Run 4 2 2 Tivoli Storage Management client as an ODBC data source The Tivoli Storage Management server is the source of data used for event and performance information This data is transferred to the relational database Tivoli Storage Manager Reporting Database One Tivoli Storage Manager reporting database can be used to contain the data from multiple Tivoli Storage Manager servers The reporting databases are initially supported by Oracle DB2 and Microsoft SQL The new Tivoli Storage Management ODBC data source is setup in the Control Panel gt ODBC The latest version to be installed is the Tivoli Storage Management ODBC Driver 3 07 01 00 When adding a new Tivoli Storage Management data source refer to Figure 14 52 T
14. 2222MB minimum Operating System 2222Windows UNIX S390 Processor 222 or higher Memory 2222MB Other 2222CD ROM drive B 1 2 How to use the CD ROM or diskette You can access the contents of the CD ROM or diskette by pointing your Web browser at the file index html in the CD ROM or diskette root directory and following the links found there Alternatively you can create a subdirectory folder on your workstation and copy the contents of the CD ROM or diskette into this folder B 2 Locating the additional material on the Internet The CD ROM diskette or Web material associated with this redbook is also available in softcopy on the Internet from the IBM Redbooks Web server Point your Web browser to ftp www redbooks ibm com redbooks SG24 Alternatively you can go to the IBM Redbooks Web site at Copyright IBM Corp 2000 175 6109addm fm Draft Document for Review April 18 2000 1 48 pm http www redbooks ibm com Select the Additional materials and open the directory that corresponds with the redbook form number B 3 Using the Web material The additional Web material that accompanies this redbook includes the following File name Description 22222222 zip Zipped Code Samples 22222222 zip Zipped HTML Documents 22222222 zip Zipped Presentations B 3 1 System requirements for downloading the Web material The following system configuration is reco
15. Ama 171825 Ama 17 18 15 AMG 17 e Ama 17 51 10 AM 17 51 19 AM 13128 maz 1 02 AM 18 41 0 AMG 18 42 40 maz 1905 16 AMG 19 11 amaz 10 19 mmz 1056 IMAZ 10 425 maz 105657 maz 1057 amz 1110 17 amaz 11 1935 mmz 112556 MAZ 1134 11 napuna on arn as END TIME Mea 5 16 nazam 5 47 19 nazam 100 5 nazam 1031 40 nazam 1123531 Mazza 145425 aa 10 42 12 naam 12 023 naam Ir naam i625 naam 1625 naam 6a 2 naam i630 naam ies naam 171225 naam 1 E54 naam 150 naam 17 1 naam 175121 naam 17510 naam 13132 naam 13 47 naam 13 4121 naam 13 42 45 naam 1505 naam 19 11 18 meam 102935 Bam 10 0 BLAN 10 477 meam 08 ewan 1057 st Mea 1m AZLA 11 19 42 ewan 112532 Mew 13a Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting Draft Document for Review April 18 2000 9 33 am ACTIITY FULL_OBBACKU EXPIRATION STGPOOL BACKI STGPOOL BACKI STGPOOL BACKI EXPIRATION EXPIRATION EXPIRATION EXPIRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION WIG RATION WIGRATION MIGRATION MIGRATION MIGRATION WIGRATION MIGRATION MIGRATION MIGRATION WIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION MIGRATION Figure 68 Non scheduled server operations EXAMINED z 12 19 Si SAAR PF a E e e RRYoGHAATRIFARDASA HAAR PROCESSED FAILED o 3 190 a SRYGAARTSREARSAAAASHAAAAoOGoG HBA AR BY
16. Copyright IBM Corp 2000 33 6109ch03 fm Draft Document for Review April 18 2000 1 48 pm TSM Server and TSM Database E S m Stand alone machine running Enterprise Database the Discovery Administrator the and Shared Data the Discovery tsmdsl program Interface and System Management Analysis components Figure 3 Minimum Tivoli Decision Support and Storage Management Analysis reporting system You may want Tivoli Decision Support installed on several machines if you have only a few users who want full control and will have frequent access to reports However you may want only the Tivoli Storage Management Administrator to use Tivoli Decision Support but then provide for multiple Storage Management Analysis machines as shown in Figure 4 34 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch03 fm dient systems running Discovery Interface and Storage Management Analysis E E E m a aa Lit File Server running System running Tivoli Shared Data Decision Support Components of TDS and tsmds program Figure 4 Storage Management Analysis reporting system with file server and multiple SMA clients These factors will dictate what you decide on using stand alone or network mode for Ti
17. Figure 50 and Figure 51 on page 103 On the lower sub window there will be additional graphs or reports that the original can be referred to as in the following example It is possible to find that an error from a client or file server did not only fail on the backups but it may have failed due to a operating system failure Looking at the report What messages should be concerned with e Summarizes client messages by severity 100 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm To take you further into exploring other graphs showing other possible errors and how they can be related to one another view the additional options in the related views tab The related views tab points to other graphs such as e Summarizes client messages issued by platform e What are the top 10 client messages e What are the top 10 client with the most problems e What day of week do peak client error rates occur There are many reports that reference related views as per Figure 52 and Figure 53 To be able to view the related views the options below will need to be opened up and in the lower sub window click on the related views tab Chapter 5 Operational Procedures for Storage Management Analysis 101 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm Tivoli Discovery Interface How much time is spent daily waiting for media access gd Ele Edt View Inset Explore Calou
18. Guide will have a set of topics and views Each view represents a separate report The Discovery Interface can be used by people that have different roles in an organization System Administrator is a role currently defined with Tivoli Decision Support A Storage Administrator will be considered an equivalent role When a specific role is selected the topic map displays views that are most useful to someone in that role When System Administrator is selected as a role all Tivoli Storage Manager Guide views will be displayed CognosPower Play Imbedded and installed as an integrated and core part of Tivoli Decision Support The Discovery Interface uses Cognos Powerplay reports The Cognos Powerplay cubes provide numerous 30 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch02 fm dimensions and measures that allow the user to view data in additional ways than the pre defined views shipped with the Guide e Seagate Crystal Imbedded and installed as an integrated and core part of Tivoli Decision Support The Discovery Interface uses Seagate s Crystal Reports to allow the user to view data in additional ways than the pre defined views shipped with the Guide 2 4 2 Storage Management Analysis Guide e Out of box reports This sets up the reporting links to the reporting data base Cognos and Crystal This is done via Tivoli Decision Support and its GUI interface that lets you access these reports
19. ODBC s are vital for the communication to the RDBMS with out the connection there will be no communications between the TSM server and the RDBMS Below are a few steps to configure Microsoft SQL DB2 for ODBC connections to the RDBMS This should be done by the DB TSM administrators Microsoft SQL ODBC setup From the create New Data Source dialog box select soL Server Figure 30 Chapter 4 Configuration and Implementation 73 6109ch04 fm 74 Create New Data Source Draft Document for Review April 18 2000 1 49 pm Microsoft dB ase Driver dbf Microsoft Excel Driver xls Microsoft FoxPro D river dbF Microsoft ODBC for Oracle Microsoft Paradox Driver db Microsoft Text Driver txt csv Mi oft Visual FoxPro D river rel SM ODBC32 Driver Figure 30 Creating a new data source 4 00 3711 08 4 00 3711 08 4 00 3711 08 2 573 3711 00 4 00 3711 08 4 00 3711 08 6 00 8426 00 32 70 06 23 3 07 00 00 Click Finish to open the Create a New Data Source to SQL Server setup wizard Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Create a New Data Source to SQL Server Figure 31 symbolic name and a specified IPP addressr Enter a symbolic name for the data source and any descriptive text and specify the IP address or system name of the server Figure 31 Click Next Chapter 4 Configuration and Implementation 75 6109ch04 fm Draft D
20. Storage Manager Reporting Draft Document for Review April 18 2000 9 35 am 61090rd fm How to get IBM Redbooks This section explains how both customers and IBM employees can find out about IBM Redbooks redpieces and CD ROMs A form for ordering books and CD ROMs by fax or e mail is also provided Redbooks Web Site http www redbooks ibm com Search for view download or order hardcopy CD ROM Redbooks from the Redbooks Web site Also read redpieces and download additional materials code samples or diskette CD ROM images from this Redbooks site Redpieces are Redbooks in progress not all Redbooks become redpieces and sometimes just a few chapters will be published this way The intent is to get the information out much quicker than the formal publishing process allows E mail Orders Send orders by e mail including information from the IBM Redbooks fax order form to e mail address In United States usib6fpl ibmmail com Outside North America Contact information is in the How to Order section at this site http www elink ibmlink ibm com pb1 pbl Telephone Orders United States toll free 1 800 879 2755 Canada toll free 1 800 IBM 4YOU Outside North America Country coordinator phone number is in the How to Order section at this site http www elink ibmlink ibm com pb1 pbl e Fax Orders United States toll free 1 800 445 9269 Canada 1 403 267 4455 Outside North America Fax phone number is in
21. Tivoli Storage Manager reporting database can be used to contain data from multiple Tivoli Storage Manager servers The Tivoli Storage Manager reporting databases that are initially supported are e Oracle V8 1 e DB2 V5 0 e MS SQL v7 0 A schema is provided with Tivoli Decision Support for Storage Management Analysis that contains the definitions of the tables used in the RDBMS for these three 2 3 2 RDBMS schemas During the installation of the Decision Support Loader the required database schemas are installed in the same directory as the Decision Support Loader The default installation path is program files tivoli tsm decision schemas The appropriate schemas should be copied into the RDBMS 2 4 Tivoli Decision Support Tivoli Decision Support and Storage Management Analysis must reside on a NT 4 0 SP4 level or better platform Tivoli Decision Support operates on Windows 95 Windows 98 and Windows NT 4 Windows 2000 support will be added at a future date Note that Tivoli Decision Support does not pre requisite the Tivoli Framework You may have multiple Tivoli Decision Support servers in the same reporting system Chapter 2 Tivoli Decision Support for Storage Management Analysis Component Overview 29 6109ch02 fm Draft Document for Review April 18 2000 1 48 pm 2 4 1 Tivoli Decision Support Tivoli Decision Support version 2 1 is required Tivoli Decision Support includes several components You must decide which co
22. and installation alternatives In this chapter we will present some considerations when installing Tivoli Decision Support for Storage Management Analysis Besides the configuration alternatives discussed in the previous chapter there are some additional processing alternatives we will bring to your attention Also there are a few pitfalls which can impair functionality of the product which we will bring to your attention 4 1 1 What scheduler to use The Tivoli Storage Manager Administrator must decide which scheduler will work best in their existing infrastructure You will have multiple cubes for reporting data as described in Chapter 2 4 1 Tivoli Decision Support on page 30 Periodically you will want to rebuild the cubes to update the data to be reported The build process can be scheduled to execute automatically and at regular intervals We recommend staggering the start times of the multiple cube builds so that they do not process simultaneously This will improve performance for each build process Also make sure that the cube builds are scheduled after the Tivoli Storage Management Decision Support Loader job runs because this job must finish in order to have new data available for the cubes The loader job should also be executed via a scheduler You have three scheduler options available use in this component set 4 1 1 1 Tivoli Storage Management scheduler This is the recommended scheduler to choose for tsmdsl exe
23. be displayed Drill down is provided to view the specific message counts associated with a severity Drill through is provided to view the specific message text associated with the selected messages What are the TSM_srvmsg001 ppr This view provides a list of the most TSM_srvmsg002 ppr top 10 server commonly issued Tivoli Storage TSM_srvmsg003 ppr messages Manager server messages over the TSM_srmsg004 ppr last 7 days Use this information to identify the most common problems that are occurring with servers A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill through is provided to view the specific message text associated with the selected messages 136 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Summarize TSM_srvmsg002 ppr This view summarizes Tivoli Storage TSM_srvmsg001 ppr server error Manager server messages by severity TSM_srvmsg003 ppr messages by S Severe E Error W Warning TSM_srvmsg004 ppr severity D Diagnostic Information includes messages issued the last 7 days Use this information to identify the most important server problems requiring resolution A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided to view the speci
24. categorization of TSM_cl015 ppr sessions by client sessions based on file size and file size and performance thresholds Information performance is based on the last 7 days of activity thresholds File size is categorized as follows e SMALL average file size lt 10 KB e MEDIUM average file size between 10 KB and 256 MB e LARGE average file size gt 256 Performance is categorized as follows GOOD Client session throughput gt XX KB sec AVERAGE Client session throughput lt xx KB sec and gt yy KB sec e SLOW Client session throughput lt yy KB sec Use this information to help understand how client session performance is distributed across the various file size categories A layer is provided to select a specific server or an aggregate of all servers can be displayed What is the TSM_clb002 ppr This view provides a daily summary of TSM_clb003 ppr average daily Tivoli Storage Manager client throughput for throughput for the last 7 days client operations Use this information to determine how day of week can affect client operations A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly throughput of all client operations or a specific client operation can be selected 170 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38
25. client restore backup tasks themselves A good Storage Management Analysis report on this is in Figure 64 Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 117 6109ch06 fm B What are the results of all operations that occurred Draft Document for Review April 18 2000 9 33 am What are fhe results of all operations fhaf occurred for a client Sener Hame Tucson on prorez Borvor Tucsan an Drees Mode ADS MPERF EXO TIME AMOS 10 142751 BTO RT IME AMG 10 14 19 35 ARDS 14 10 DU71 14 41 12 AMOS 17 144128 AMET 14 43 11 JETS 16135 DOUD 16 14 45 DD tai AT aS ts a amp OC see ves ZED 16201 ATS 162105 BTART TIME END TIME 201310 101808 A0310 10 18 15 W030 10 187 D0310 10 18 47 BTART IME END TIME BEBBION s735 7 43 7 45 Ef eE 11 fr BEBBION 535 SSE BEBBION antut AFFECTED FOJLED 1154 o BACKUP BYTES K E 175243 2 o 1 KE z a o 6ari Meo cagot tr BACKUP Mode reoord g br OOBMPERF antul AFFECTED FAILED 6 o ARCHIVE BYTES KE 1 158 o 11 750 Me cages tr ARCHIVE antut FOILED BACKUP AFFECTED BYTES KE ile Es COMPLETE YES YES YES YES YES COMPLETE YES YE COMPLETE amn 13635 ADDU 15845 n 13655 ADDU 1 652 am 13656 DD 12 ST sis ST inst VE 1Z2 s pi5 Whelare he esuk ofall operators Pal ocoured trad AOS 12 11D5P Figure 64 Client results of operations 118
26. event business and performance problems In this chapter we will highlight a few of the problem areas Tivoli Storage Management Administrators may face the types of questions that can be answered and the different kinds of reports that are available through the use of Tivoli Decision Support and Storage Management Analysis Storage Management Analysis provides a mechanism to make Tivoli Storage Management s events performance and the fulfilment of business requirements readily visible by employing a variety of formats and reporting levels You will find these reports to be appropriate and informative to the Information Systems technician Tivoli Storage Management Administrator or the company executive Other reporting tools used for Tivoli Storage Manager Results from query command issued via Tivoli Storage Manager SQL queries via Tivoli Storage Management macros or scripts Extractions of the Tivoli Storage Management server activity log Extractions from Client logs Extractions from Tivoli Storage Manager accounting file Platform specific operating system commands and monitors Spreadsheets E mail These tools can be applied in a variety of ways and combinations to achieve the desired result 1 1 Defining function within the IS infrastructure Business data is commonly recognized as a valuable internal asset The protection of this data is the job of Tivoli Storage Management In addition there are massiv
27. levels do levels are being used with each Tivoli clients use Storage Manager server Information is based on the most recent data extracted from Tivoli Storage Manager servers This report can be used to identify the distribution of Tivoli Storage Manager client software levels in your environment This information can be used to identify servers with down level client software To identify the specific client names associated with a software level use the view TSM_cli003 How many clients are registered with each server Select the client software level of interest from the dimension line and drill down on a server Note If a client does not report its platform SW Level Not Reported appears This occurs for older versions of client software 160 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Which platforms do clients use TSM_cli005 ppr This view presents a summary of what operating system platforms are used by Tivoli Storage Manager clients Information is based on the most recent data extracted from Tivoli Storage Manager servers Use this to help understand what operating systems platforms are connecting to Tivoli Storage Manager servers Drill down is provided for an operating system to view what versions of the operating system are being used
28. messages that are TSM_clmsg002 ppr messages issued for each Tivoli Storage TSM_clmsg004 ppr issued by Manager client platform during the last TSM_clmsg005 ppr platform 7 days TSM_clmsg006 ppr Use this information to identify problems that are related to a specific client platform Messages include the following Severe S Error E Warning W and Diagnostic D A layer is provided to select a specific server or an aggregate of all servers can be displayed Drill down on a platform is provided as follows Platform Name Operating System Levels Message counts for selected operating system level Drill through is provided to view the specific message text associated with the selected messages Appendix A Relate views for the table analysis 135 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views Summarize TSM_clmsg004 ppr This view summarizes Tivoli Storage TSM_clmsg001 ppr client Manager client messages by severity TSM_clmsg002 ppr messages by Messages are included from the last 7 TSM_clmsg003 ppr severity days TSM_clmsg005 ppr TSM_clmsg006 ppr Use this information to identify the most important client problems requiring resolution Messages include the following Severe S Error E Warning W and Diagnostic D A layer is provided to select a specific server or an aggregate of all servers can
29. of the week Running HF1 6109ch01 fm Draft Document for Review March 10 2000 3 51 pm Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch02 fm Chapter 2 Tivoli Decision Support for Storage Management Analysis Component Overview In this section we describe the various software and hardware components that make up a complete Tivoli Decision Support for Storage Management Analysis reporting solution We describe software levels required and the function of each component These components are shown in Figure 3 Tivoli Decision Support for Storage Management Analysis requires three base products e Tivoli Storage Manager A Relational Database System e Tivoli Decision Support Copyright IBM Corp 2000 25 6109ch02 fm Draft Document for Review April 18 2000 1 48 pm ia Taigaa fae Figure 3 Components of an SMA reporting environment 26 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch02 fm 2 1 Tivoli Storage Manager servers The Tivoli Storage Manager database is the source of information used for event and performance information Version 3 7 2 or later of the Tivoli Storage Management server is required This is because data is extracted from the Tivoli Storage Manager server from new tables included in this version
30. on 9076 SP2 ADSM for OS 2 Advanced Topics ADSM VSE Implementation Guide ADSM with Other Products A Practical Guide to Network Storage Manager Using ADSM to Back Up Databases Using ADSM to Back Up Lotus Notes Using ADSM to Back Up and Recover Microsoft Exchange Server Hierarchical Storage Management for NetWare ADSM and AvailHSM Implementation Using ADSM to Back Up OS 2 LAN Server and Warp Server Backup Recovery and Availability with DB2 Parallel Edition on RISC 6000 ADSM Operation and Management with TME10 Copyright IBM Corp 2000 Publication Number SG24 5416 SG24 5477 SG24 4631 SG24 4880 SG24 2595 G24 4724 SG24 4867 G24 5472 G24 2231 SG24 5742 SG24 5244 SG24 4878 GG24 4499 SG24 4740 SG24 4266 G24 2242 SG24 4335 SG24 4534 SG24 5266 SG24 4713 SG24 4682 SG24 4695 G24 2214 181 6109bibl fm Draft Document for Review April 18 2000 1 48 pm D 2 IBM Redbooks collections Redbooks are also available on the following CD ROMs Click the CD ROMs button at http www redbooks ibm com for information about all the CD ROMs offered updates and formats CD ROM Title Collection Kit Number System 390 Redbooks Collection SK2T 2177 Networking and Systems Management Redbooks Collection SK2T 6022 Transaction Processing and Data Management Redbooks Collection SK2T 8038 Lotus Redbooks Collection SK2T 8039 Tivoli Redbooks Collection SK2T 8044 AS 400 Redbooks Collection SK2T 2849 Netfinity Hardware and
31. pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the TSM_clb003 ppr This view provides an estimate of the TSM_clb002 ppr average hourly throughput for Tivoli Storage hourly Manager client operations This hourly throughput for estimate is based on the last 7 days of client information operations Use this information to determine how time of day can affect client operations A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly throughput of all client operations or a specific client operation can be selected What is the TSM_srvb001 ppr This view provides an estimate of the TSM_srv001 ppr average hourly throughput for Tivoli Storage hourly Manager server operations This throughput hourly estimate is based on the last 7 rate for server days of information operations Use this information to determine how time of day can affect server operations A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Appendix A Relate views for the table analysis 171 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views
32. processed during the TSM_srvb002 ppr processed by last four weeks of Tivoli Storage daily server Manager server operations Tivoli operations Storage Manager server operations include database backup storage pool backup migration expiration reclamation and move data Information is presented by day of week Use this report to help you verify operations are being performed on the desired days and desired frequencies The amount of data processed can be used to assist with capacity panning and determine if there are maybe issues with the times Tivoli Storage Manager operations are occuring A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Drill down is provided for a specific day of the week as follows e View the last 4 weeks activity associated with a specific day of the week e View the specific session activity associated with a specific date 158 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views How does TSM_srvb002 ppr This view provides an hourly summary TSM_srv001 ppr time of day of Tivoli Storage Manager server TSM_srv002 ppr affect server session activity for the last 7 days session activity U
33. report as well Our purpose here is to demonstrate Storage Management Analysis as an usable tool with relevant out of box reporting for Tivoli Storage Management The reports presented in this chapter have drill down reporting related views and can isolate reporting by server by viewing particular layers As mentioned in proceeding chapters see the Tivoli Decision Support Users Guide on the use of these features The use of these features increases the power and value of all the reports we will present in this chapter 6 1 Scheduling for efficiency The questions What is the resource impact on my server when run my client schedules and What is the best way to change my backups and archive schedules to allow efficient scheduling are closely related To answer them we must decide what elements define resource usage and whether we can express those elements in measurable terms For example total data volume and throughput would be useful and they are measurable Most of the time the Tivoli Storage Management Administrator is not monitoring the system when scheduled backups or archives are running because they are typically run during off shift hours To deal with this situation scripts are often written and executed at repeated intervals to snapshot CPU usage I O to devices and media waits The report derived from that exercise can indicate changes which will make the system process more effic
34. the How to Order section at this site http www elink ibmlink ibm com pb1 pbl This information was current at the time of publication but is continually subject to change The latest information may be found at the Redbooks Web site IBM Intranet for Employees IBM employees may register for information on workshops residencies and Redbooks by accessing the IBM Intranet Web site at http w3 itso ibm com and clicking the ITSO Mailing List button Look in the Materials repository for workshops presentations papers and Web pages developed and written by the ITSO technical professionals click the Additional Materials button Employees may access MyNews at http w3 ibm com for redbook residency and workshop announcements Copyright IBM Corp 2000 185 61090rd fm Draft Document for Review April 18 2000 9 35 am IBM Redbooks fax order form Please send me the following Title Order Number Quantity First name Last name Company Address City Postal code Country Telephone number Telefax number VAT number Invoice to customer number Credit card number Credit card expiration date Card issued to Signature We accept American Express Diners Eurocard Master Card and Visa Payment by credit card not available in all countries Signature mandatory for credit card payment 186 Tivoli Storage Manager Reporting Draft Document for Revi
35. the Tivoli Discover Interface In the above example the report How much time is spent daily waiting for media access the related views reports are How does the time of day affect server session activity What is the average daily elapsed time for server operations and What is the average daily throughput for server operations 102 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm Tivoli Storage Management E vent Analysis Daily Exception Reports How might improve my storage health Trends in Client Operations Trends in Server Operations What does my environment look like What messages should be concerned with When do find the most problems Tivoli Storage Management Performance Analysis How are my clients performing SS How are my servers performing ual How much time is spent daily waiting for media access oil What is the average daily elapsed time for server operations gall What is the average daily throughput for server operations How does file size affect my performance How does time of day and day of week affect my performance The currently viewed report is highlighted Do o2 8o o 8 8 iam Topic Map Guides Role Related Views for How much time is spent daily waiting for media access te id Be BS Yen ft Enoe Candie fat Jt Wr Heb aua 4 ofa Fe GIES ial Tinie ctr H
36. time is spent daily waiting for media access Draft Document for Review April 17 2000 11 38 pm File nane to uderstand the tades z How does time of day affect server session act Trends in Server Operations i What is the average daily elapsed time for serv How are my servers performing m What is the average daily throughput for server How are my servers performing Tivoli Storage Management Event TSM_srvb002 ppr Tivoli Storage Management Perfor TSM_stv004 ppr Tivoli Storage Management Perfor TSM_stv003 ppr Figure 74 Show how to read the related views and the file names for location in the tables below Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm Related Views 6109ax01 fm Table 1 View Title Filename View Description Hint Text Related Views What are the TSM_clmsg001 ppr This view provides a summary of the TSM_clmsg002 ppr top 10 clients with the most problems Tivoli Storage Manager clients that have issued the most messages during the last 7 days Use this report to determine clients generating the most messages and needing attention Messages include the following Severe S Error E Warning W and Diagnostic D A layer is provided to select a specific server or an aggregate of all servers can be displayed Drill down on a client is provided to view the specific message counts Drill through is provided
37. to view the specific message text associated with the selected messages Note CN signifies client name TSM_clmsg003 ppr TSM_clmsg004 ppr TSM_clmsg005 ppr TSM_clmsg006 ppr Appendix A Relate views for the table analysis 133 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What are the TSM_clmsg002 ppr This view provides a summary of the TSM_clmsg001 ppr top 10 client most common Tivoli Storage Manager TSM_clmsg003 ppr messages client messages that were issued TSM_clmsg004 ppr during the last 7 days TSM_clmsg005 ppr TSM_clmsg006 ppr Use this information to identify the most common problems that are occurring with clients Messages include the following Severe S Error E Warning W and Diagnostic D A layer is provided to select a specific server or an aggregate of all servers can be displayed Drill down on a message number is provided to determine clients that issued the selected message Drill through is provided to view the specific message text associated with the selected messages Note CN signifies client name 134 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Summarize TSM_clmsg003 ppr This view provides a summary of the TSM_clmsg001 ppr client most common
38. w How does platfom affect client throughput rates Period Rolling 7 Days Measure Total Throughout KBis Row Wind8 Column twoson on pranres Layer sNones Trends in Server Operation a What does my environment What messages should be When do find the most pre li Storage Management Perf How are my clients perform tal How does platfom aff ti How does Topp ade ti How much time do ch ti What are client throug til Which are my 10 fast til Which are my 10 slon fl Which cients have th OW are my Servers perfor k B P Topic Map Guides Role Total Throughput KB s By Server Fe tucson on pranres2 Hints for How does platform affect client throughput rates Show hints for This view provides a summary of Tivoli Storage Manager client throughput by platform Selected topic map item Information is based on the last 7 days activity lt Curent view window Related Views History Bookmarks Ready 50topic map views Manual Profle Figure 23 Example of a Generated Cognos Report from the Tivoli Discovery Interface Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Tivoli Decision Support for Storage Management Analysis includes a collection of cubes as seen in Figure 24 on page 67 Powerplay reports Crystal reports queries models and topic mappings Tivoli Discovery Admi
39. with multiple viewing options e Cube s reporting This component sets up reporting from Cognos 3D graphics reporting 2 4 3 Using fm20 dll This is used to support the Discovery Administrator Refer to Chapter 4 2 3 Error 339 fm20 dll MS module access on page 54 for more detail 2 5 Scheduler You will want to schedule the loading of new data into the reporting database at a pace consistent with reporting frequency In this way the most recent data will be added for reporting Normally this will be done on a daily basis We recommend use of the Tivoli Storage Management scheduler for this purpose You will also want to schedule the re building of the Storage Management Analysis cubes following each data loader run This is most easily accomplished by using the scheduler in the Discovery Administrator See the section on scheduling in Chapter 4 1 1 What scheduler to use on page 39 for more information Chapter 2 Tivoli Decision Support for Storage Management Analysis Component Overview 31 6109ch02 fm Draft Document for Review April 18 2000 1 48 pm 32 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch03 fm Chapter 3 Tivoli Decision Support for Storage Management Analysis Architectural Issues In this section we discuss some considerations for a beginning configuration in support of Storage Management Analysis and Tivoli Storage Management reporting We will expand o
40. 09spec fm Draft Document for Review April 18 2000 1 48 pm them into the customer s operational environment While each item may have been reviewed by IBM for accuracy in a specific situation there is no guarantee that the same or similar results will be obtained elsewhere Customers attempting to adapt these techniques to their own environments do so at their own risk Any pointers in this publication to external Web sites are provided for convenience only and do not in any manner serve as an endorsement of these Web sites Any performance data contained in this document was determined in a controlled environment and therefore the results that may be obtained in other operating environments may vary significantly Users of this document should verify the applicable data for their specific environment This document contains examples of data and reports used in daily business operations To illustrate them as completely as possible the examples contain the names of individuals companies brands and products All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental Reference to PTF numbers that have not been released through the normal distribution process does not imply general availability The purpose of including these reference numbers is to alert IBM customers to specific information relative to the implementation of the PTF when it becomes av
41. 2 What size machines and why is this important 37 3 3 Choosing a relational database for SMA 0000 0 eee 37 3 4 Considerations for merging companies departments and IIS groups 37 Chapter 4 Configuration and Implementation 39 4 1 Configuration and installation alternatives 39 4 1 1 What scheduler to use 0 00 ee 39 4 1 2 Choosing a database technology 2 00005 41 4 1 3 Multiple Tivoli Storage Management servers 42 4 1 4 Multiple data source configurations 0005 45 4 2 Installation gotchas 2 0 ce eee 50 4 2 1 Tivoli Decision Support 2 1 patch 00005 50 4 2 2 Tivoli Storage Management client as an ODBC data source 52 4 2 3 Error 339 fm20 dll MS module access 4 54 4 2 4 Running out of hard drive space during install 55 4 2 5 Security Rights 0 0 00 cee eee 55 4 2 6 Connection to DB failures 0 000000 eee eee 55 4 2 7 MDAC levels 0 0 0 0 ete kean 57 4 2 8 No Data problems 0 0 0 eee ee 58 4 3 Crystal and Cognos participation 0 0 eee 63 4 4 Relational Database considerations 00000 eee 67 4 4 1 What size DB to start DB Growth 4 68 4 4 2 SQL example 0 000s 68 4 4 3 DBA CxaMple is ctu wace a ted eeepdnee wend Bee ee pele he Pek eee 69 4 4 4 Setup
42. 33 am time are those which are subject to or related to growth A typical list might be Size of database Size of transaction log Size of storage pools The time it takes to do expirations reclamations and copy pools The time to perform a scheduled backup The number of failed objects The number of clients and filespace sizes Scratch tape usage You may want to look at two major areas in regard to Tivoli Storage Management server performance The Tivoli Storage Management server itself and then the Tivoli Storage Management storage that is on that server 6 5 1 TSM server performance Data saved over a period of time of this subject matter would lend itself to comparison and ultimately a means to predict what a change in load would do to your system Secondarily a picture of before and after a system change would measure the effect of the change on the Tivoli Storage Management load You may first want to examine the status of the work being performed on the server Figure 68 is an example report on non scheduled administrative operations A similar report is available for scheduled administrative operations as well 122 Tivoli Storage Manager Reporting What is the status of non scheduled administrative operations SERVER NAME START TIME AMG 9 15 46 Imaz 94719 amaz 1050 15 IMa 103124 maz Ire IMAZ 145425 MaA 10 42 11 maA 120 maza Ie maza GBE mmaa 16 17 mmaa 167 3 mma 1637 2 AM 16 4834 AMG 17 18 16
43. 52 and Figure 53 list the possible reports available in the current release of Storage Management Analysis Each report can be shown in a variety of formats to best represent or other Tivoli Decision Support features emphasize a particular facet Use of such as sorting explain drill down layering and others Refer to the Tivoli Decision Support Users Guide for a discussion on these features Chapter 5 Operational Procedures for Storage Management Analysis 103 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm Tivoli Discovery Interface File Edit View Navigate Window Help Ble 4 E Gl x Tivoli Storage Management Event Analysis Daily Exception Reports fill Classify outcome for client sessions ve E Summarize the messages issued in my environment E What are the results of all operations that occurred for a client vn E What is the status of non scheduled administrative operations wal What is the status of non scheduled client sessions E What is the status of scheduled administrative operations fene Jl What is the status of scheduled client sessions E What potential problems exist in my server environment 5 mend How might improve my storage health dg How are client schedules affected by day of week lglg How current are client backups sn E Show me my server database backup record fF What administrators and clients have been locked out of the system wal When did clie
44. 57 These illustrate the kind of the errors that you may see For further information regarding connection failures you should consult with the Microsoft SQL Guide and the Tivoli Decision Support 2 1 Guide SOn prepared SUL statements BISBEE WME POU are My Briefcase Figure 16 No Microsoft SQL database connection 56 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Tivoli Discovery Administrator lol x File View Cubes DataSources Decision Support Guides Scheduled Tasks Help Jeja alla 9 ie Administ Popes Datso FM TSM Client Activity Hf TSM Client Bytes Processed sa 4 TSM Client Filespaces Ei pranresd on ptant sa TSM Client Into aif TSM Cent Messages TSM Server Activity TSM Server Bytes Processed A Error connecting to Data Source TSM Server Messages pranres4 on pranres 2 LA Data Sources a Decision Support Guides CA Scheduled Tasks A r Detai Error 40002 Error connecting to data source Source ckDataSource TestConnection MicrosoftR DO AdoConnection Reg A A A Figure 17 Example of another database failure 4 2 7 MDAC levels You should check the MDAC levels regardless of what error appears on your monitor Should you have errors and you suspect that it is a Windows NT error check the operating system MDAC level You can find this in control Pa
45. 6109LOF fm Figures 1 2 3 Summarizing client error messageS 00200 eee eee eee eee 22 Data processed by server operations by day of the week 23 Minimum Tivoli Decision Support and Storage Management Analysis report ing system34 4 Storage Management Analysis reporting system with file server and multiple SMA clients35 5 TSMDSL scheduled and running the desktop interface 40 6 TSMDSL processing multiple TSM servers 000 eee eae 42 7 TSMDSL log extract showing multiple ODBC s and TSM servers 44 8 TSM ODBC driver communications setup 0000e eee eee 45 9 Tivoli Decision Support Loader 00000 e eee eee 46 10 DSL server list setup 0 2 0 eee 47 11 Tables to be loaded inthe DSL 0 0 00 cee eee 48 12 Data source setup in the DSL 0 000 c eee eee 49 13 Saving the TSMDSL INI 0 0 0 00 eee 50 14 Setting up of anew TSM Data Source 000 c eee eee 53 15 The FM20 DLL error which will appear if you do not have the required DLL files54 16 No Microsoft SQL database connection 00000e eee 56 17 Example of another database failure 20000 00 eee 57 18 Correct version of MDAC with all items being at the same level 58 19 Applications can be removed via Control Panel 0055 60 20 Applications can be removed here 0000 eee eee eee ee 61 21 Example o
46. 7 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Classify TSM_cl003 ppr This view provides a summary of Tivoli TSM_clmsg rpt outcome for Storage Manager client operations TSM_cl001 ppr client based on whether or not the session TSM_cl002 ppr sessions had failed objects Information is included from the last reporting period and is summarized for each Tivoli Storage Manager server The results are categorized in the Legend as follows OK Operation completed with all objects successfully processed Warning Operation completed with some successfully processed objects and some failed objects Severe Operation completed and all objects failed processing Not Executed Operation completed without processing any objects Use this categorization to help determine which client operations are failing and prioritize work related to which activities need investigation A layer is provided to select a specific client operation or the aggregate of all client operations can be displayed Drill down is provided for each server The drill down levels are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name Clients associated with specific policy domains A client is identified by appending the string CN
47. 9 ppr This view provides a list of Tivoli Storage TSM_cl005 ppr have the highest Manager clients that have the highest average TSM_cl006 ppr average failed number of failed object over the last 4 weeks TSM_clmsg007 ppr object count Use this to determine clients that have histori cally had the most problems A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly throughput of all client operations or a specific client operation can be selected Appendix A Relate views for the table analysis 173 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm 174 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109addm fm Appendix B Using the additional material This redbook also contains additional material in CD ROM or diskette format and or Web material See the appropriate section below for instructions on using or downloading each type of material B 1 Using the CD ROM or diskette The CD ROM or diskette that accompanies this redbook contains the following File name Description 22222222 cpp Code Samples 22222222 html 2 2 22 HTML Documents 22222222 prz 2 2 Presentations B 1 1 System requirements for using the CD ROM or diskette The following system configuration is recommended for optimal use of the CD ROM or diskette Hard disk space
48. Add Database SmartGuide Will appear Add Database SmartGuide Done _Carcel _Heb Figure 40 Manual configuration for DB2 Chapter 4 Configuration and Implementation 83 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Select the third radio button to manually configure your ODBC setup Figure 40 above You can also use a prediefined access profile to automate the setup porcess Click Help for more inrormation about automated setup Click Next to open the Protocol page Four addition configuration tabs will also appear Add Database SmartGuide Figure 41 Protocol for system configuration Select the communications protocol required by your system configuration Click Next to open the parameters page for the protocol you have selected The example above show the TCP IP parameter page Figure 41 You will see a different page if you select a different protocol 84 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Add Database S martGuide Figure 42 Server host name or IP address Enter the DB2 server host name IP address or system name and port number Click Next to open the Target Database page as per Figure 42 Chapter 4 Configuration and Implementation 85 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Add Database SmartG uide Figure 43 Target database name Enter the name of the database as in the Figure 43 that y
49. Client Column STANDARD ON Layer lt None gt lt How are my clients performing ul How does platform affect client throughput rates ji How does Top Ip address affect throughput Total Media Wait Time m By Client ia How much time do clients spend waiting for media access iia What are client throughput rates fal Which are my 10 fastest clients 40 fa Which are my 10 slowest clients Which clients have the longest elapsed process times 35 How are my servers performing How does file size affect my performance 30 How does time of day and day of week affect my performance 25 20 15 10 5 0 CODE TEAN CH TRITCH CN YUNEICH NZANDE CN TSMDRIVER CH JAGUARI CN STORMAN_WIN32BUILO H MARKHAYE CN i Hints for How much time do clients spend waiting for media access Show hints for This view provides a summary of the amount of time that Tivoli Storage Manager clients spent waiting for access to Tivoli Storage Selected topic map item Manager server media ee g C Current view window This view can be used to highlight tape mount problems Figure 55 Client media waits Referencing another useful report in Figure 56 we can look at wait times for server activity This can be an indicator of scheduling conflicts forced data migrations during backups or even database backup triggers set at an inappropriate level Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 109 6109ch06 fm Draft Doc
50. DE Node GSUN is already registered MSGNO 2147 0313 2000 09 25 56 2022 ANR2022E COPY MGMTCLASS One or more parameters are missing 0343 2000 09 26 49 1582 ANR1582E UPDATE COPYGROUP The RETVER option is valid only for archive copy groups 0343 2000 09 27 31 1612 ANR1612E ACTIVATE POLICYSET Management class LONG_ARCHIVE in policy set STANDARD domain STANDARD specifies MIGREQUIRESBKUP YES but contains no backup copy group 0343 2000 09 51 31 944 ANROS44E QUERY PROCESS No active processes found 0313 2000 09 51 36 2034 ANR2034E QUERY VOLUME No match found using this criteria 0313 2000 09 55 57 2034 ANR2034E QUERY MOUNT No match found using this criteria 0343 2000 13 09 17 2034 ANR2034E QUERY EVENT No match found using this criteria Server messages by severity ERROR Severity WARNING SERVER MESSAGES ANR1229VV Yolume 000067 cannot be backed up volume is offline or access mode is unavailable or destroyed MSGNO 1229 DATE TIME 0342 2000 05 15 05 0343 2000 13 25 59 482 ANR0482 Session 6295 for node ADMIN CAINNT terminated idle for more than 15 minutes 0342 2000 09 51 59 482 ANRO482VV Session 6096 for node AXE AIX terminated idle for more than 15 TE Ee Ea er Nate Mion Hor Savery Hre Reet eas Han Sosa Faroe Figure 1 Summarizing client error messages Again selecting from the abov
51. Software Redbooks Collection SK2T 8046 RS 6000 Redbooks Collection BkMgr SK2T 8040 RS 6000 Redbooks Collection PDF Format SK2T 8043 Application Development Redbooks Collection SK2T 8037 IBM Enterprise Storage and Systems Management Solutions SK3T 3694 D 3 Tivoli Storage Management publications These publications are also relevant as further information sources Book Title Publication Number Tivoli Storage Manager for AIX Version 3 7 Quick Start GC35 0367 Tivoli Storage Manager for AIX Version 3 7 Administrator s Guide GC35 0368 Tivoli Storage Manager for AIX Version 3 7 Administrator s Reference GC35 0369 Tivoli Storage Manager for HP UX Version 3 7 Quick Start GC35 0370 Tivoli Storage Manager for HP UX Version 3 7 Administrator s Guide GC35 0371 Tivoli Storage Manager for HP UX Version 3 7 Administrator s Reference GC35 0372 Tivoli Storage Manager for Sun Solaris Version 3 7 Quick Start GC35 0373 Tivoli Storage Manager for Sun Solaris Version 3 7 Administrator s Guide GC35 0374 Tivoli Storage Manager for Sun Solaris Version 3 7 Administrator s Reference GC35 0375 Tivoli Storage Manager for MVS and OS 390 Version 3 7 Quick Start GC35 0276 Tivoli Storage Manager for MVS and OS 390 Version 3 7 Administrator s Guide GC35 0277 Tivoli Storage Manager for MVS and OS 390 Version 3 7 Administrator s Reference GC35 0278 Tivoli Storage Manager for Windows NT Version 3 7 Quick Start GC35 0379 Tivoli Storage Manager for Windows NT Version 3 7 Admini
52. TES KB 3 552 00 am 54 204 00 418500 197 261 60 ono O00 0 00 O00 SiS DO 34 136 00 54 088 00 54 088 00 3605000 54 392 00 54 392 00 37 720 00 3431600 53 832 00 6 868 00 37 260 00 54 656 00 102 240 00 34 556 00 37 264 00 53 048 00 30 44 00 32 564 00 37 408 00 32 856 00 55 788 00 34 680 00 32 794 00 35 648 00 31 748 00 SUCCES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES YES 6109ch06 fm SFUL 123 6109ch06 fm Draft Document for Review April 18 2000 9 33 am To look at data movement by operation on the server refer to Figure 69 You would want to look for unusual spikes in reported data and try to explain them as they occur How much data is processed by daily server operations Period Rolling 4 Weeks Measure Average MEytes Processed Row By Operation Column Tuesday Layer By Server By Server Layer 2 of 2 Average MBytes Processed By Operation By Weekday Name STGPOOL BACKUP MIGRATION Wednesday FULL_DBBACKUP EXPIRATION Tuesday Figure 69 How much data is processed by daily server operations What is the average for daily elapsed time for server operations is another facet of the above put into terms of time Refer to Figure 70 124 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm Wha
53. They are the SUMMARY and EVENTS tables Therefore this version is required to provide support for Storage Management Analysis information gathering You will have at least one Tivoli Storage Management database source but you may have many of them They can be on multiple processing platforms These will be known to Tivoli Decision Support and Storage Management Analysis as source data servers That will become important when setting up the parameters for the loader program which we will discuss in the next section 2 2 Tivoli Storage Manager RDBMS interface The major portion of this interface is the Decision Support Loader program It s purpose is to move data from the Tivoli Storage Management source database to the Tivoli Decision Support reporting database We recommend that you install the Decision Support Loader on a dedicated NT machine Running the decision Support Loader and the Storage Management Analysis product on the same processor can adversely impact performance You can concurrently transfer data from multiple Tivoli Storage Management servers to a shared RDBMS database server by installing the Decision Support Loader on multiple machines To use this configuration you must set up each Tivoli Storage Management server as an ODBC data source and configure each Decision Support Loader to access the appropriate Tivoli Storage Management server and shared RDBMS database server See the Tivoli Storage Management Decisio
54. Tivoli Storage Manager Reporting Bill Helms Grant McDonald Patrick Randall International Technical Support Organization www redbooks ibm com SG24 6109 00 Draft Document for Review April 18 2000 1 50 pm International Technical Support Organization Tivoli Storage Manager Reporting March 2000 Draft Document for Review April 18 2000 1 48 pm SG24 6109 00 6109edno fm Draft Document for Review April 18 2000 1 48 pm Take Note Before using this information and the product it supports be sure to read the general information in Appendix C Special notices on page 177 First Edition March 2000 This edition applies to Version 1 Release Number 1 1 of Tivoli Decision Support for Storage Management Analysis Version 3 Release 7 of the Tivoli Storage Manager for AIX Program Number 5697 TSM Version 3 Release 7 of the Tivoli Storage Manager for HP UX Program Number 5697 TSM Version 3 Release 7 of the Tivoli Storage Manager for Sun Solaris Program Number 5697 TSM Version 3 Release 7 of the Tivoli Storage Manager for Windows NT Program Number 5697 TSM Version 3 Release 7 of the Tivoli Storage Manager S 390 Edition Program Number 5697 TSO This document created or updated on April 18 2000 Comments may be addressed to IBM Corporation International Technical Support Organization Dept QXXE Building 80 E2 Copyright International Business Machines Corporation 2000 All rights reserved Note t
55. Tivoli Storage Manager Reporting EE o 7070 YE 1or2e1 ORA SOL Draft Document for Review April 18 2000 9 33 am 6109ch06 fm Other facets of these tasks can be explored with multiple reports For example the question How much data did back up incrementally can be answered as in Figure 65 where filesize for different operations and total throughput is shown or as in Figure 66 where the report looks at client data throughput as it may be related to operating system platform of clients How does filesize affect client operation throughput Period Rolling 7 Days Measure Total Throughput Kis Row By Operation Column Small Layer By Server Domain and Client By Server Domain and Client Layer 6 of 6 Total Throughput KB s Legend E BACKUP 350 E RESTORE I ARCHIVE 300 E RETRIEVE 250 200 150 100 50 Medium Figure 65 Data movement by filesize and total throughput Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 119 6109ch06 fm Draft Document for Review April 18 2000 9 33 am How does piatform affect client throughput rates Period Rolling 7 Days Measure Tofa Throughput MEI Row lt Noere gt Column Tucson on pranres4 layer lt Nore gt Total Throughput MB h By Platform WinNT ucson on pranres i STANDARD DN Figure 66 Client data throughput by platform Another client activity you may want to look at is posed
56. ader should execute automatically via the scheduler and contacts all the Tivoli Storage Management servers then extract the data storing it on the RDBMS server Figure 6 shows multiple Tivoli Storage Management servers have been contacted in the right hand window It also shows the Tivoli Storage Management ODBC drivers and the correct version y Tivoli Storage Management Decision Support Loader Setup Verifying database connection to all the servers listed in the Server List server list Table List Tucson on pranres4 uses ODBC driver version 03 07 0001 neptune on pranres4 uses ODBC driver version 03 07 0001 Data Source palana on pranres4 uses ODBC driver version 03 07 0001 Post Processing Server Tucson on pranres4 DataSource local on pranres4 Server values DSN Tucson on pranres4 erie Save Thread ID 254 Server operations for Tucson on pranres4 successfully Load completed H Processing Complete Help Go Exit 3 24 00 11 46 AM 3 3 00 01 03 Figure 6 TSMDSL processing multiple TSM servers Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm The listing shown in Figure 7 userid s and passords have been greyed out which is an extract of the tsmdsl loader log file illustrates to the Tivoli Storage Management administrators that the loader has communicated successfully and pulled the data to the RDBMS server The data wil
57. ailable to each customer according to the normal IBM PTF distribution process The following terms are trademarks of the International Business Machines Corporation in the United States and or other countries IBM The following terms are trademarks of other companies Tivoli Manage Anything Anywhere The Power To Manage Anything Anywhere TME NetView Cross Site Tivoli Ready Tivoli Certified Planet Tivoli and Tivoli Enterprise are trademarks or registered trademarks of Tivoli Systems Inc an IBM company in the United States other countries or both In Denmark Tivoli is a trademark licensed from Kj benhavns Sommer Tivoli A S 178 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109spec fm C bus is a trademark of Corollary Inc in the United States and or other countries Java and all Java based trademarks and logos are trademarks or registered trademarks of Sun Microsystems Inc in the United States and or other countries Microsoft Windows Windows NT and the Windows logo are trademarks of Microsoft Corporation in the United States and or other countries PC Direct is a trademark of Ziff Communications Company in the United States and or other countries and is used by IBM Corporation under license ActionMedia LANDesk MMX Pentium and ProShare are trademarks of Intel Corporation in the United States and or other countries UNIX is a registered trademark in the Un
58. ard OK Cancel Apply Help Figure 18 Correct version of MDAC with all items being at the same level 4 2 8 No Data problems Error number 53 Cube will not build returns No Data may appear when you build a cube from the Tivoli Discovery Administrator by transforming or exporting The reason for this is the table that should contain the data has not received data from the Tivoli Storage Management servers In order to fix this problem refer to the following manual Tivoli Decision Support Administrators Guide version 2 1 58 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm 4 2 8 1 SQL reply NO to uninstall of the dll s Reply no to uninstalling the dll files is to prevent the corruption of the other applications that use dll files Testing has indicated that if you say no to uninstalling the dll s files all applications still work However keeping the dil files in place for SQL should not present a problem When you re intall SQL it will not ask you if you want to update any dll files When installing SQL there are a number of dll files that are updated throughout the operating system Should you say yes to uninstalling the dll files you stand a chance of dll file corruption on the server applications This would require a re install of the operating system or applications that you may be running on the your windows NT4 ser
59. ate Fomat Tools Window Help 18 x Gia aj Gla 1 Ja 2E BIS alel w Tivoli Storage Management Event Analysis Daly Exception Reports How might improve my storage health Trends in Cient Operations amp Trends in Server Operations G What does my environment look Ike Q What messages should be concemed with Q When do find the most problems How much time is spent daily waiting for media access Layer20f2 By Server A A A tdd Mata al raimh By Operation Es 120 amp Tivol Storage Management Perfomance Analysis How are my clients performing How are my servers performing m How much time is spent daly waiting for media access il What is the average dally elapsed time for server operations Wednesday Show related views for Selected topic map item El How does time of day alfect server session act Trends in Server Operations Tivoli Storage Management Evert TSM_srvb02 il What is the average dally elapsed time for serv How ate my servers performing Tivoli Storage Management Perfor TSM_srw004 Bll Whats the average daly throughput for server How are my servers perfoming Tivol Storage Management Perfor TSM s1v003y y C Curent view window His Rell Hitoy Books Ready SD topic map views Manual Profle Figure 50 Related views in the lower box windows from
60. by the question How many restores have been done in the past week Figure 67 shows total objects restored successfully in a calculated average by day over the last four rolling weeks 120 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm What is the average daily failed object count Period Rolling 4 Weeks Measure Total Successu Objects Row RESTORE Column lt Nore gt Layer By Server Domain and Client By Server Domain and Client Layer 3 of 3 Total Successful Objects Friday Thursday Wednesday Tuesday Monday Sunday By Activity Start Day Saturday Figure 67 Total objects restored for clients There are more possible ways to answer these questions and even more exercising the Tivoli Decision Support features You may want to develop a Storage Management Analysis list of favorites to report on client activity and execute them on a regular basis to help identify trends in your environment 6 5 Reporting on Server operations Approaching the subject of Tivoli Storage Management you first might ask What are my key performance indicators and how do monitor them The answer again can be largely based on your environment and what elements you think are most important However the items selected the majority of the Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 121 6109ch06 fm Draft Document for Review April 18 2000 9
61. c days of the week A layer is provided to allow selection of a specific Tivoli Storage Manager server or an aggregate of all servers can be displayed Drill down is provided to view successful object counts for the last 4 weeks associated with the selected day TSM_cl004 ppr TSM_cl005 ppr TSM_clmsg007 ppr Appendix A Relate views for the table analysis 155 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views Summarize TSM_clmsg007 ppr This view lets you look at message TSM_cl004 ppr client counts that occurred for each Tivoli TSM_cl005 ppr messages Storage Manager client software level TSM_cl006 ppr issued by during the last 7 days software level Use this to help determine whether error activity is related to a specific Tivoli Storage Manager client software level For example there may be a fix in the latest Tivoli Storage Manager client software that you need to install on all systems Messages include the following Severe S Error E Warning W and Diagnostic D A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down on a platform is provided to view message counts for the selected platform Drill through is provided to view the specific message text associated with the selected messages 156 Tivoli Storage Manager Reporting D
62. communications to the RDBMS on page 73 If you choose not to do this or can not do this MSSQL is the recommended alternative The install for a desktop environment has a minimum of considerations and works well with Tivoli Decision Support and Storage Management Analysis Refer to Web site www microsoft com for more information regarding this product and the installation procedure 3 4 Considerations for merging companies departments and IIS groups The dynamic nature of today s business environment demands that reporting be flexible enough to change add or delete reported processors as organizations change In order to accomplish this Tivoli Decision Support uses OLAP Information can be stored for multiple source servers and be added or deleted from consolidated reports via filtering criteria invoked before each report or eliminated via layered views of data Chapter 3 Tivoli Decision Support for Storage Management Analysis Architectural Issues 37 6109ch03 fm Draft Document for Review April 18 2000 1 48 pm Also multiple Tivoli Decision Support and Storage Management Analysis servers can be brought on line as needed simply by pointing them to the correct source and RDBMS servers See the Tivoli Decision Support Installation Guide for more details 38 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Chapter 4 Configuration and Implementation 4 1 Configuration
63. cution When executing the scheduler from the install directory you may have to add additional parameters to get the Tivoli Storage Management scheduler to function correctly If you have the Tivoli Storage Management scheduler installed as a NT service make sure the ID has rights to the programs including tsmdsl and the data it must access If you have installed the scheduler as a System account make sure you have checked the allow desktop interface box See Figure 5 greyed out userid s and passwords for an illustration of the desktop interface invoked during execution This is to allow the TSMDSL program to extract the data from the Tivoli Storage Management servers and allow tsmdsl to execute Copyright IBM Corp 2000 39 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Tivoli Storage Management Decision Support Loader OE x Setup Verifying database connection to all the servers listed in the server list Server List Table List Tucson on pranres4 uses ODBC driver version 03 07 0001 Server Tucson on pranres4 DataSource local on pranres4 Server values DSN Tucson on pranres4 UID PWD Thread ID 248 Date Source Post Processing Collecting Storage Data Help Working Sancel Tucson on pranres4 PETE veo MSM OA Figure 5 TSMDSL scheduled and running the desktop interface l password and userids The userid s and passwords are shown when the init
64. d from raw data to reflect the real dimensionality of the enterprise as understood by the user OLAP functionality is characterized by dynamic multi dimensional analysis of consolidated enterprise data supporting end user analytical and navigational activities including Calculations and modeling applied across dimensions through hierarchies and or across members Trend analysis over sequential time periods Slicing subsets for on screen viewing Drill down to deeper levels of consolidation Reach through to underlying detail data Rotation to new dimensional comparisons in the viewing area Running H F i 6109ch01 fm Draft Document for Review March 10 2000 3 51 pm OLAP is implemented in a multi user client server mode and offers consistently rapid response to queries regardless of database size and complexity OLAP helps the user synthesize enterprise information through comparative personalized viewing as well as through analysis of historical and projected data in various what if data model scenarios This is achieved through use of an OLAP Server 1 3 2 OLAP implementation An OLAP server is a high capacity multi user data manipulation engine specifically designed to support and operate on multi dimensional data structures A multi dimensional structure is arranged so that every data item is located and accessed based on the intersection of the dimension members which define that item The design of the server and
65. e sample question lists an example of answering questions via Storage Management Analysis To answer the question How much data did copy during the last four weeks to my copy pools invoke the Tivoli Discovery Interface An appropriate chart to reference in the Storage Management Analysis Guide is entitled Tivoli Storage Manager Reporting Draft Document for Review March 10 2000 3 51 pm 6109ch01 fm How much data is processed by daily server operations as shown in the Figure on page 22 This report draws a three dimensional graphical representation of data moved during administrative processes STGPOOL BACKUP is the category we are interested in By looking at this report you get the average amount of data by day of week This is only one of many graphical format options for display In addition there are options for Drill Down exploration For a complete discussion of these options refer to the Tivoli Decision Support Users Guide M How much data is processed by daily server operations mof How much data is processed by daily server operations Period Rolling 4 Weeks Measure Average MEyiesPronessey Row Gy Coerafion Cowman Sunday Layer By Server By Server Laverdof3 Average MBytes Processed 10000 aii 6000 dii 2000 i Ls Ey Ommam TTCPOOL MEF FEUMAN HERL AN FILL CROP Hos DIPRIUTOM any ip Wikia Fue Akril Figure 2 Data processed by server operations by day
66. e amounts of data being generated in support of the Information Systems environment as is the case of Tivoli Storage Management To put this data into a usable format and relate it to actual business needs of the company involves programmers analysts and other IS agents in the typical organization Further this is usually done on a group or department level to report specific interests to specific parties Seldom is it a continuing requirement so it becomes a throw away solution for an immediate Copyright IBM Corp 2000 6109ch01 fm Draft Document for Review March 10 2000 3 51 pm need It the need comes up again it must be re invented again Many different people can be involved on many different levels of functionality This situation in turn ultimately drives up the cost of Information Systems and has a negative impact on company profit margin and overhead costs Tivoli Decision Support and Storage Management Analysis allows the TSM Administrator to perform more efficiently and effectively by limiting the number of personnel needed to report on Tivoli Storage Management storage resources network traffic for Tivoli Storage Management data and Tivoli Storage Management events By utilizing Storage Management Analysis the functional responsibility of transforming raw data into reports can be limited to the Tivoli Storage Management administrator The Tivoli Storage Management administrator is able to do more than Tivoli Stora
67. e chapter 4 4 1 2 Choosing a database technology There were three databases that were used in the development of Tivoli Decision Support for Storage Management Analysis e Microsoft SQL Server version 7 IBM DB2 version 5 2 Oracle version 8 1 5 The type of database that you will use may be dependent on your organization s current infrastructure and the database servers that are in operational use One of the skills required for Tivoli Decision Support for Storage Management Analysis is someone who can support the database Usually this is a database administrator This situation will be especially true for larger enterprises where dedicated servers hold databases These databases should also be backed up regularly in case there is corruption in the physical database or a physical hardware occurs on the server We assume the recovery of such errors to be the responsibility of the database administrator Chapter 4 Configuration and Implementation 41 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm 4 1 3 Multiple Tivoli Storage Management servers 42 An environment may have more than one Tivoli Storage Management Server in a Local Area Network or even over a Wide Area Network These Tivoli Storage Management servers can report to a common server that contains the RDBMS Microsoft SQL DB2 Oracle with the communications setup in the ODBC and the Tivoli Decision Support Loader The Tivoli Decision Support Lo
68. e lg What day of week do peak server error rates occur _ What time of day do peak client error rates occur Lic j What time of day do peak server error rates occur Tivoli Storage Management Performance Analysis Be How are my clients performing Beseen ui How does platform affect client throughput rates oo ui How does Tcp Ip address affect throughput fever ui How much time do clients spend waiting for media access bas ll What are client throughput rates iid Which are my 10 fastest clients iid Which are my 10 slowest clients Le Ju Which clients have the longest elapsed process times 2 How are my servers performing al How much time is spent daily waiting for media access i What is the average daily elapsed time for server operations gall What is the average daily throughput for server operations How does file size affect my performance oa Classify sessions by file size and performance thresholds aT How does file size affect client operation throughput a 7 How does time of day and day of week affect my performance Ed How does time of day affect client session activity ui What is the average daily throughput for client operations g What is the average hourly throughput for client operations g What is the average hourly throughput rate for server operations Figure 53 More reports from the Storage Management Analysis guide continued Chapter 5 Operational Procedures for Storage Manag
69. ea you may provide invaluable assistance to them as well as improving your Tivoli Storage Management system The questions What impact does Tivoli Storage Management data movement have on the network and What was my throughput rate over the LAN WAN for sent and received data can provide indicators of correctable network problems The reports listed in the Storage Management Analysis Guide in Figure 57 are an excellent place to start looking for network problems gt Tivoli Storage Management Performance Analysis sel How are my clents performing aaa ul How does platform affect chent throughput rates sete ul How does Tcprlp address affect throughput bial How much time do clients spend waiting for media access cool What are client throughput rates oobi Which are my 10 fastest clients coool Which are my 10 slowest clients gT gll Which clients have the longest Alapsed process times Figure 57 Reports that are helpful in identifying network problems From the above lists one interesting exercise is to see if you can draw a correlation between client platform and throughput rates An example of one of the listed reports is in Figure 58 Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 111 6109ch06 fm Draft Document for Review April 18 2000 9 33 am How does Tcp ip address affect throughput Period Rolling 7 Days Measure Tofa Throughout KBs Row By Teotlo C
70. ead or overwritten The Tivoli Storage Management administrator should also have sufficient rights to perform duties like scheduling the reports The administrator can implement security by using the operating system permissions The NT Administrator will need to set this up in two parts e Granting permission to access the entire shared source path e Granting permission to access certain but possibly not all cubes 4 2 6 Connection to DB failures Database connection failures can be the result of ODBC being setup incorrectly It is advisable to get the relevant informatation connection to the database from your Database Administrator After setting up the database you will require the correct information for establishing a connection from the Tivoli Storage Managers servers to the Windows NT4 Server It must have a database that is supported by Tivoli Storage Management Analysis In order for this to happen you will require Chapter 4 Configuration and Implementation 55 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm the connection information for the ODBC drivers From your Microsoft NT4 Server which has the database on it you will want to extract the relevant information from you Microsoft NT4 Workstations This once again will require the correct ODBC drivers On receiving errors there are a number of places that you will have to look to find the problem as can be seen in Figure 16 on page 56 and Figure 17 on page
71. eeding and care of the RDBMS loading data to other servers possible loader failures and high CPU utilization during loader execution 5 2 1 Loader issues and ODBC loss of connection You should be aware that CPU utilization during loader runs can be affected by the use of the PC mouse When the Tivoli Storage Management Decision Support Loader is being executed and the Tivoli Storage Manager Decision Support Loader graphical user interface appears on the screen do not use your mouse or click on the decision support loader This will stop the loader operation for a short while until the utilization decreases The CPU utilization can run at a 100 as in Figure 49 not allowing any operation on the current screens or on the windows NT4 desktop until the decision support loader has completed the data load to the RDBMS 96 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm E Windows NT Task Manager File Options View Help 6109ch05 fm 0 xi Applications Processes Performance r CPU Usage gt MEM Usage CPU Usage History Memory Usage History 397x440 Totals Physical Memory K Handles 2628 Total 589224 Threads 209 Available 480984 Processes 33 File Cache 18632 m Commit Charge K m Kernel Memory K 5 Total 113204 Total 28012 Limit 700968 Paged 23088 _ Peak 125956 Nonpaged 4924 Processes 33 CPU U sage 100 Mem Usage
72. em reporting These are intended to serve as examples of product and report usage A more in depth look at these questions are discussed in reference chapter 6 of this redbook 1 5 1 Typical question sampling This list is representative of the kinds of questions that are likely to be asked in a Tivoli Storage Management environment What is the resource impact on my server when I run my client schedules What is the best way to change my backups and archive schedules to allow efficient scheduling What are my problem clients and which clients are not getting backed up regularly What errors am getting most and which ones should I work on correcting first Running HF1 6109ch01 fm Draft Document for Review March 10 2000 3 51 pm What impact does TSM data movement have on the network How many restores have been done in the past week How much storage was reclaimed this week How much data did back up incrementally How much data did copy the last four weeks to my copy pools What was my throughput rate over the LAN WAN for sent and received data What are my failure rates by server and operating system Is my tape volume full or partially full and when will it be available to migrate What are my key performance indicators and how do monitor them How will know when I need to upgrade system components Can report on event processing in a form which will mean something to my boss want to sho
73. ement Analysis 105 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm Table 1 on page 133 shows how the report names relate to other reports via file names Cross reference Related Views column to Filename column The table is built in Filename sequence Also helpful in that section is the View Description hint text which can be a helpful reference when looking for specific elements to report on From these tables the administrator can see how the related views are linked to each other and generated throughout the whole of the Tivoli Discovery Interface giving a detailed explanation of processing facets 106 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting In this chapter we show how Tivoli Decision Support for Storage Management Analysis can be used to provide answers to the problems highlighted in Part 1 5 What kinds of problems can be solved using Storage Management Analysis on page 19 This is representative of the kinds of questions that are likely to be asked ina Tivoli Storage Management environment We will provide the Storage Management Analysis alternative that we think is most appropriate to answer the given question However this is not the only correct answer and may not be the best answer for your given situation You may want to use other tools to help you
74. eporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the TSM_srvnosch rpt This view provides a Summary of Tivoli TSM_msg rpt status of Storage Manager server operations TSM_srvsch rpt non schedule d administrative operations that were not scheduled using the Tivoli Storage Manager scheduler Use this view to determine the results of administrative operations and determine failures that need to be corrected Report parameters are provided to specify e Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server Appendix A Relate views for the table analysis 143 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What TSM_srvprb rpt This view provides a report of potential TSM_msg rpt potential problems that may exist in your Tivoli problems Storage Manager server env
75. equired with the UID Qualifier is to be put in e Select ox and continue to Post Processing which will have no changes to be made and is should stay as default 48 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Data Source Setup local on pranres4 Figure 12 Data source setup in the DSL e Upon completing the setup you will need to save the configuration in the TSMDSL INI as shown in Figure 13 below Chapter 4 Configuration and Implementation 49 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm a Tivoli Storage Managen Save As 21x Save in E decision ical c r Setup Server List schemas TSMDSL ini Table List 3 TSMDSLI ini TSMDSL3iini Data Source E TSMDSLAini Post Processing Save File name TSMDSL ini Save Load Save as type o Files ini Cancel I Open as read only odida 3 24 00 10 40 AM Figure 13 Saving the TSMDSL INI e After saving the TSMDSL INI file you will need to load the TSMDSL INI from the load tab on the DSL Select go and the DSL will execute pull the data and store it in the RDBSM 4 2 Installation gotchas This section covers problems that may be encountered when setting up Tivoli Decision Support for Storage Management Analysis and what can be done to solve them 4 2 1 Tivoli Decision Support 2 1 patch The Tivoli Decision Support vers
76. ew April 18 2000 9 35 am 6109glos fm Glossary Your glossary term acronym or abbreviation Term definition Copyright IBM Corp 2000 187 6109glos fm Draft Document for Review April 18 2000 9 35 am 188 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 50 pm Index Symbols out of box reporting solution 18 query 15 A analytical 17 B Business data as an asset 15 C Cognos PowerPlay Reporting 18 Configuration and installation alternatives 39 cubes 39 D data 15 dynamic environment 18 E errors Error 78886 51 Error 80911 51 Error 81616 51 H hierarchies and or across members 17 information 18 M macros 15 multi dimensional data 18 multi user data manipulation engine 18 N navigational 17 network traffic 16 Copyright IBM Corp 2000 61091X fm O OLAP 17 OLAP implementation 18 On Line Analytical Processing or OLAP 17 P Path Manager Utility 51 performance 15 performance problems 15 Q query 15 R requirements 16 resources 16 S scheduler which to use 39 scripts 15 Seagate Crystal Reporting 18 sequential time periods 17 shared source directory 51 SQL queries 15 SQL query reporting 16 Storage Management Analysis 15 Storage Management Analysis 16 storage pool usage 16 system health 16 T Tivoli Decision Support for Storage Management Analysis 16 Tivoli Storage Management 15 Tivoli Storage Management Adminis
77. f wanting to remove Tivoli Decision Support 2 1 63 22 Example of a Seagate Crystal Report 000020 0 eee eeee 65 23 Example of a Generated Cognos Report from the Tivoli Discovery Interface 66 24 Cube view from the Tivoli Discovery Administrator 67 25 Microsoft SQL server query 00 0c eee eee eee 69 26 Logon connection to database 0 000 eee ees 70 27 Connection succesful 0 0 000 eens 71 28 Simple command for DB2 query 0 020 c eee eee 72 29 Results of the command issued 0 000 eee eee ees 73 30 Creating a new data SOUICe 2 6 eens 74 31 symbolic name and a specified IPP addressr 75 32 SQL login and password authentication 00a eee eee 76 33 Library configuration for protocol to be used 205 77 34 Specify the database for storage management 0005 78 35 Process options to be applied 1 2 2 02 eee 79 36 Test data source for connection saaara aeaaea 80 Copyright IBM Corp 2000 ix 6109LOF fm Draft Document for Review April 18 2000 1 50 pm x 37 Data source test complete 2 0 es 81 38 Creating a DB2 data source using the ODBC drver 82 39 ODBC IBM DB2 driver 2 0 0 0 cc eens 83 40 Manual configuration for DB2 0 ee 83 41 Protocol for system configuration 0 00 eee ee eee 84 42 Ser
78. fic messages associated with a severity Drill through is provided to view the specific message text associated with the selected messages Appendix A Relate views for the table analysis 137 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What is the TSM_cl001 ppr This view provides a summary of TSM_clmsg rpt status of scheduled operations that occurred for TSM_cl003 ppr scheduled Tivoli Storage Manager clients during client the last reporting period Information sessions is summarized for each Tivoli Storage Manager server This information applies to operations that use the Tivoli Storage Manager scheduler Use this information to identify the overall results of scheduled operations and identify clients that had schedule failures The Legend contains the results of the scheduled operations For schedules that failed to initiate an operation the results are obtained from the Tivoli Storage Manager server event status For operations that were successfully initiated e The result is set to Completed if the session results indicated success The result is set to Failed is the session results indicated failure Drill down is provided for each server The drill down levels are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain na
79. for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views When did TSM_cli002 ppr This view provides a summary of when TSM_clfs001 ppr clients last Tivoli Storage Manager clients last contact the contacted a Tivoli Storage Manager server Information is based on the most recent data extracted from Tivoli Storage Manager servers Clients are categorized as follows OK Client contacted server within the last 7 days e Warning Client last contacted server between 8 and 21 days e Critical Client last contacted the server more than 21 days ago e Never Accessed Server Client has never contacted the server Use this information to identify inactive clients Drill down is provided to view specific clients in a category or all clients associated with a specific server The drill down levels for a server are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name 150 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Show me my TSM_srvdb ppr This view provides a sum
80. frequently received errors You would probably want to concentrate on the E type messages first since they usually indicate a failing task If clients are not getting backed up as you intended then some error should be evident In addition the following Figure 62 shows the circumstances of backup currency Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 115 6109ch06 fm Draft Document for Review April 18 2000 9 33 am How current are client backups Period None gt Measure Total Filespace Count Row Sy Las Filesozce Sackuo Threshold Column Tucson on pranres4 Layer Nore gt Total Filespace Count By Last Flkspace Backip Thres told Wanna By Server OK Newer Backed Up Tucson on pranres4 Figure 62 How current are client backups Eliminating error conditions within Tivoli Storage Management is critical to having a successful and reliable system Storage Management Analysis can help the Administrator to be responsive and proactive in identifying and correcting problems 6 4 Reporting on Client Activity Looking at the Storage Management Analysis Guide there are some obvious choices when you want to report on client activity In the Tivoli Storage Management Event Analysis section the subsections of Daily Exception Reports and Trends in Client Operations have several reports on client activity In the section Tivoli Storage Management Performance Analysis t
81. g file It is highly recommended that you see your Database Administrator for information about the size of your transaction log and data cleanup processes 5 2 3 Near real time reporting The reports that are generated are not in a real time or live mode The Storage Management Analysis mode used is known as near real time When you pull the data from the RDBMS the reports will reflect data up to the point in time of the last data load 5 2 4 Duplicating to other file servers Tivoli Decision Support can be installed and configured in two ways Tivoli Decision Support and its various components can be installed on one server The TDS components however are not shared across other machines The user that will be using the stand alone mode will have access to the Discovery Interface and to the Discovery Administrator Refer to this discussion in Chapter 3 If the end user runs Tivoli Decision Support in stand alone mode the Discovery Administrator the Discovery Interface and the Shared Data must be installed to same machine and serve that machine only The correct specifications of the machine are required With network mode only the Discovery Client component which includes Cognos Powerplay is installed on the client machine It is recommended that you install the Shared Data components and the Discovery Administrator on 98 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 p
82. ge Management Analysis Reporting 113 6109ch06 fm Draft Document for Review April 18 2000 9 33 am Looking further for reports on errors in Storage Management Analysis we can refer to Figure 60 to see another excerts from the Guide Running and analyzing this set of reports is another good place to begin identifying problems in Tivoli Storage Management Try to eliminate the more severe errors first FF What messages should be concemed with 3 msn ul Summarize chent messages by severity sn ul Summarize server error messages by severity mun ul What are the top 10 chent messages 3 sen ul What are the top 10 cents with the most problems pa ul What are the top 10 server messages Figure 60 Some Storage Management Analysis reports on errors Selecting from the above reports list Figure 61 illustrates a report on the top 10 server messages 114 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm What are the top 10 server messages Period Rolling 7 Days Measure Number of Server Messages Row Server Messges Column Nornes Layer By Server By Server Layer30f3 Number of Server Messages 40 35 30 25 20 ANRO48 2 ANR1229V ANRO423vV ANRO480V ANRO418V ANR21 21 ANR2481E ANRO424V ANRO422VV ANR2579E Figure 61 Top 10 server messages This is an indicator as to which problems should get priority attention as well as listing your most
83. ge Management query commands and SQL query reporting immediately Accountability and reporting are highly visible understandable and accessible to all those granted security rights to display Storage Management Analysis reports 1 2 Reporting on system health and justifying requirements The need to report on Tivoli Storage Manager processing and resource usage is never more apparent than when identifying and justifying a need A data collection programming and report presentation scramble usually ensues The degree of complexity and responsiveness depends on how prepared the Tivoli Storage Management Administrator is to answer that facet of need The Tivoli Storage Management Administrator when provided with Tivoli Decision Support for Storage Management Analysis has a means to monitor the health of the Tivoli Storage Management system including storage pool usage event scheduling in terms of resource availability and error reporting They have a means to report on developing trends as well as single occurring anomalies and allows report users to make decisions based on historical data Through trending we can predict when and if resources will be adversely impacted and when new equipment or resources are warranted The supporting documentation will be predisposed for such usage The format and reports will be available in meaningful format to those who approve company expenditures and to the Tivoli Storage Management Ad
84. guide for ODBC communications to the RDBMS 73 Chapter 5 Operational Procedures for Storage Management Analysis 91 5A Sched ling reres saa ia aia te nedltetas dadeee eb ees sade aad 91 5 1 1 Daily reporting 1 0 2 ee 91 5 1 2 Weekly reporting 0 0 0 es 93 5 1 3 Weekend reporting 0 0 ee 94 5 1 4 Monthly reporting 0 0 eee 94 5 1 5 The window of opportunity ssaa uaaa 0 0 0 0 eee eee 95 5 2 Care andfeeding 0000 cee eee 96 5 2 1 Loader issues and ODBC loss of connection 96 5 2 2 Cleanup of RDBMS records 0000e eee ee eee 97 5 2 3 Near real time reporting 0 0 eee 98 5 2 4 Duplicating to other file servers 202 0005 98 5 2 5 Exercising relationships within reports 100 Chapter 6 Tivoli Decision Support for Storage Management Analysis Re POMING ke ees cee ea ke eee oe a A ee ee eae A 107 6 1 Scheduling for efficiency 0 00 ee 107 vi Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109TOC fm 6 2 Looking at Tivoli Storage Management network traffic 111 6 3 Correcting errors 2 ee 113 6 4 Reporting on Client Activity 00 000 eee 116 6 5 Reporting on Server operations 0 000 121 6 5 1 TSM server performance 00 0c cece eee 122 6 5 2 Storage health 0 00 ee 125 6 6 System visibility
85. he subsection How are my clients performing which we had previously referred to under the network topic see Figure 57 on page 111 is also an obvious choice 116 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm The primary activities of client nodes revolve around backups archives and data restoration Refer to Figure 62 on page 116 which tells you how recently backups have been performed Another similar report in Figure 63 shows when client nodes last contacted the server While this same information is available by executing a query node command from the Tivoli Storage Management Command Line Interface these reports are the type that Management would want to see because they illustrate in a presentation format how well their investment in Tivoli Storage Management is doing When did clients last contact the server Period lt Noxe gt Measure Totai Node Count Row Critical Cofinnn Tucson on pranresd Layer lt Nowe gt Total Node Count y Last Client Access Threshold By Server Waming Critical Tucson on pranres4 Figure 63 Identifying when clients last contacted the TSM server These reports might also help identify discontinued nodes which need to be cleaned up in some fashion appropriate to your storage policies Once you have identified the legitimate client nodes that are being backed up on a regular basis you may then be concerned about the actual
86. i Storage Manager server A domain name is identified by appending the string DN to the domain name Clients associated with specific policy domains A client is identified by appending the string CN to the client name e Sessions associated with specific clients If an operation was not initiated the session name is set to None Appendix A Relate views for the table analysis 139 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What are the TSM_clmsg rpt This view provides a summary of all TSM_cl001 ppr results of all operations that occurred for a Tivoli operations Storage Manager client during the last that occurred reporting period This includes for a client scheduled and non scheduled operations Use this view to look at a summary of session activity and the specific messages that were issued for a Tivoli Storage Manager client A report parameter is provided to select e Tivoli Storage Manager server name e Tivoli Storage Manager client node name Date range for information To determine a list of server names and client node names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server 140 Tivoli Storage Manager Reporting Draft Document for Review April 1
87. ial setup is performed The screen captures do not have the userid s and passwords shown Schedule the tasks and the server will be contacted and the TSMDSL will retrieve the data to the database that you have specified allowing the NT4 client to pull the required data 40 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm See also the section in Chapter 5 2 1 Loader issues and ODBC loss of connection on page 96 4 1 1 2 Cognos Scheduler Cognos scheduler can be setup to build the cubes Be sure to schedule this at a time when the tsmdsl job has completed execution See the discussion on scheduling in Chapter 5 1 5 The window of opportunity on page 95 Further information can be found in redbook SG24 5506 00 Using Tivoli Decision Support Guide chapter 4 4 1 1 3 TDS Scheduler Tivoli Decision Support scheduler is configured for the Tivoli Discovery Administrator interface and can be used to add a schedule for cube building Choose the name of the cube you want to build Select daily weekly monthly hourly or minutes and or how often in days you want the execution to take place Tivoli Decision Support will not execute until the service has started in Control Panel gt Services gt TDS Scheduler Upon execution of the scheduler the cubes will be re built Further information can be found in redbook SG24 5506 00 Using Tivoli Decision Support Guid
88. ice Information in this book was developed in conjunction with use of the equipment specified and is limited in application to those specific hardware and software products and levels IBM may have patents or pending patent applications covering subject matter in this document The furnishing of this document does not give you any license to these patents You can send license inquiries in writing to the IBM Director of Licensing IBM Corporation North Castle Drive Armonk NY 10504 1785 Licensees of this program who wish to have information about it for the purpose of enabling i the exchange of information between independently created programs and other programs including this one and ii the mutual use of the information which has been exchanged should contact IBM Corporation Dept 600A Mail Drop 1329 Somers NY 10589 USA Such information may be available subject to appropriate terms and conditions including in some cases payment of a fee The information contained in this document has not been submitted to any formal IBM test and is distributed AS IS The information about non IBM vendor products in this manual has been supplied by the vendor and IBM assumes no responsibility for its accuracy or completeness The use of this information or the implementation of any of these techniques is a customer responsibility and depends on the customer s ability to evaluate and integrate Copyright IBM Corp 2000 177 61
89. ient message activity is related to a specific hour of the day Messages include the following Severe S Error E Warning W and Diagnostic D A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided on an hour of the day as follows e View message counts for each day of the week that had activity associated with the selected hour View message counts for each message that occurred for the selected hour and day Drill through is provided to view the specific message text associated with the selected messages TSM_clmsg004 ppr TSM_clmsg005 ppr Appendix A Relate views for the table analysis 153 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What time of TSM_srvmsg004 ppr This view lets you look at Tivoli TSM_srvmsg001 ppr day do peak Storage Manager server message TSM_srvmsg002 ppr server error volume for each hour of the day TSM_srvmsg003 ppr rates occur Information is included from the last 7 days Use this to help you determine whether error activity is tied to a specific hour of the day A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided on an hour of the day as follows e View message counts for each day of the week that had activity associated with the se
90. iently if they are interpreted and presented accordingly That was one way of approaching this problem prior to Storage Management Analysis Copyright IBM Corp 2000 107 6109ch06 fm Draft Document for Review April 18 2000 9 33 am Now we can select Storage Management Analysis reports which will tell us how we are using resources and indicate scheduling changes that improve overall resource allocation One place to start this analysis is to find a status of clients to determine which clients are failing or have a high rate of failure An appropriate report is in Figure 54 What is the status of scheduled client sessions Period 2006 03 14 Measure Tota Sesser Count Row By Sesson Results Column tucson on pranres2 Layer lt Nore gt Total Session Count By Session Res att C By Schedule Tucson on pranres4 Figure 54 What is the status of scheduled client sessions You would also want to look at media waits for client schedules as a beginning report One of the more common problems in backup and archive job scheduling is to run out of available tape drives Refer to Figure 55 108 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm i ji ity j 7 Tivoli Storage Management Event Analysis How muen ume do eens P ena oe for media access ae eriod Rolling 7 Days Measure Tofa Media Wait Time m Tivoli Storage Management Performance Analysis Row By
91. ies not correctly registered a file is missing or invalid ox Figure 15 The FM20 DLL error which will appear if you do not have the required DLL files 54 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm 4 2 4 Running out of hard drive space during install During Tivoli Decision Support installation there are no warnings provided when the available hard drive space is exceeded The installation will apppear to go smoothly but infact some of the application files needed to execute TDS my not be present Therefoe it is important to ensure there is enough hard drive space available before installing TDS The down fall to this is that there will be no error alerting you that there is not enough hard drive space or alert notifying you that your installation has aborted abnormally In order to fix this the Administrator will need to uninstall Tivoli Decision Support via the unistall option that is provided with the application The NT4 Administrators will have to add another harddrive or free up space on the existing hard drive and re install Tivoli Decision Support This error will be corrected in the future 4 2 5 Security Rights Security rights play a vital role in the functioning of Windows NT4 server and Microsoft SQL version 7 Should you not obtain the correct rights the administrator will not be able to write to the SQL database Therefore not allowing the reports to be r
92. int Text Related Views Summarize TSM_msg rpt This view provides a report of the Tivoli TSM_cl001 ppr the messages Storage Manager client and server TSM_cl002 ppr issued in my messages Messages are classified TSM_clmsg rpt environment according to severity i e Severe Error Warning and Diagnostic Use this report to get a view of client and server messages issued for the requested date This can be used to view message activity for specific dates determine what errors occurred in your environment and prioritize what problems should be worked on first Report parameters are provided to specify e Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server TSM_cl003 ppr Appendix A Relate views for the table analysis 145 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views Show me my TSM_srvdb rpt This view provides a history of the TSM_msg rpt server data backup of
93. ion 2 1 patch will update the current version of Tivoli Decision Support Process Scheduler the path Manager Utility and the relevant readme txt files up to and including Admin gd pdf document files Should the patch not have been installed the Scheduler may have some 50 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm discrepancies There are two parts to applying this patch the client as well as the administrator and they can be located in the following paths Client C Program Files TIDS 2 1 default Administrator C Program Files TDS 2 1 default The files that the Tivoli Decison Support patch updates looks as follows lt AdminN gt 2 1 TDS 0001 Readme txt lt Admin gt TDSScheduler exe lt Admin gt PatherManager exe lt Admin gt tds_cubebuilder exe lt Admin gt readme txt lt Admin gt Docs Pdf Admin gd txt lt Client gt 2 1 TDS 0001 Readme txt lt Client gt Pathmanager exe The Tivoli Decison Support patch fixes the following problems Path Manager Utility Error 78886 User can only apply changes once per session If the shared source directory exist in two separate location the user can not change between the two location using the same instance of the Path Manager Utility Error 80911 user can not set path to a mapped network drive Error 81616 Chapter 4 Configuration and Implementation 51 6109ch04 fm Draft Document for Review April 18
94. ironment exist in my Use this report to identify problem server areas and take appropriate actions to environment correct This view provides information related to 3 areas of a Tivoli Storage Manager server environment 1 Database and Recovery Log e Occupancy information e List of the copy status of database volumes e List of the copy status of recovery log volumes 2 Storage Pool Volume Information e List of disk volumes that are offline e List of storage pool tapes with potential problems A volume is included if has had read errors write errors status destroyed status unavailable or status readonly 3 Offline tape drive information e List of tape drives that are offline Report parameters are provided to specify e Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server 144 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description H
95. ited States and other countries licensed exclusively through The Open Group SET SET Secure Electronic Transaction and the SET Logo are trademarks owned by SET Secure Electronic Transaction LLC Other company product and service names may be trademarks or service marks of others Appendix C Special notices 179 6109spec fm Draft Document for Review April 18 2000 1 48 pm 180 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm Appendix D Related publications 6109bibl fm The publications listed in this section are considered particularly suitable for a more detailed discussion of the topics covered in this redbook D 1 IBM Redbooks publications For information on ordering these publications see How to get IBM Redbooks on page 185 Book Title General Topics Getting Started with ADSM A Practical Implementation Guide ADSM Version 3 7 Technical Guide Using ADSM Hierarchical Storage Management Client Disaster Recovery Bare Metal Restore Planning for IBM Remote Copy P DAS and Enhancement to the IBM 3990 6 and RAMAC Array Family TME 10 Cookbook for AIX Systems Management and Networking Applications Specific Server Books A Practical Guide to Implementing ADSM on AS 400 Windows NT Backup and Recovery with ADSM Using TSM in a Clustered NT Environment ADSM Server to Server Implementation and Operation ADSM Server for Windows NT Configuration and Recovery Examples ADSM 6000
96. ivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Create New Data Source X Select a driver for which you want to set up a data source Microsoft Access Driver mdb Microsoft dBase Driver dbf Microsoft Excel Driver xls Microsoft ODBC for Oracle Microsoft Paradox Driver db Microsoft Text Driver txt csv Microsoft Visual FoxPro Driver SQL Server TSM ODBC Driver lt Back Finish Cancel Figure 14 Setting up of a new TSM Data Source You may also find the older version of the ODBC driver that is listed as 32bit ADSM ODBC driver version 3 01 0007 This ODBC driver should be upgraded to the version as mentioned above To set this up you will find it under Control Panel gt ODBC gt System and then add Scroll down to the bottom to select the TSM ODBC driver Before you configure your Decision Support Loader you will be required to setup your Tivoli Storage Management servers and RDBMS reporting database server as ODBC data sources The ODBC is a interface that lets various programs access data in the relational databases The information will be required to setup the ODBC drivers may vary depending on your database types and system configurations It is advisable that you see your Chapter 4 Configuration and Implementation 53 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm database administrator for specific connection i
97. l now be ready to be viewed by the Tivoli Discovery Interface except for those views which report from cubes After the cubes are rebuilt these will be ready as well Chapter 4 Configuration and Implementation 43 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm 44 tsmlog htm WordPad File Edit View Insert Format Help pela Si al elel l lt PRE gt Database Type MS SQL Log for DSN Tucson on pranres4 3 31 00 2 45 59 PM Log for DSN neptune on pranres4 UID PUD 3 31 00 2 47 20 PM Log for DSN palana on pranres4 UID PUD 3 31 00 2 46 17 PM Average time per server was 00 00 46 Total number of servers processed was 3 Verifying database connection to all the servers listed in the server list Tucson on pranres4 uses ODBC driver version 03 07 0001 neptune on pranres4 uses ODBC driver version 03 07 0001 palana on pranres4 uses ODBC driver version 03 07 0001 Server Tucson on pranres4 DataSource local on pranres4 Server values DSN Tucson on pranres4 Thread ID 265 Server operations for Tucson on pranres4 successfully completed Server neptune on pranres4 DataSource local on pranres4 Server values DSN neptune on pranres4 Thread ID 267 Server operations for neptune on pranres4 successfully completed Server palana on pranres4 DataSource local on pranres4 Server values DSN palana on pranres4 Thread ID 269 Server operations for palana on pranres4 successf
98. l012 ppr TSM_clb005 ppr TSM_cl010 ppr Appendix A Relate views for the table analysis 165 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What is the TSM_srv003 ppr This view provides a summary of the TSM_srv004 ppr average daily average throughput of Tivoli Storage TSM_srv005 ppr throughput for Manager server operations Tivoli server Storage Manager server operations operations included database backup storage pool backup migration expiration reclamation and move data Information is presented by day of week Use this report to determine how throughput varies for Tivoli Storage Manager server operations by day of the week This can be used to highlight potential scheduling problems A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Drill down is provided for a specific day of the week as follows e View the last 4 weeks activity associated with a specific day of the week e View the specific session activity associated with a specific date 166 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the TSM_srv004
99. lected hour View message counts for each message that occurred for the selected hour and day Drill through is provided to view the specific message text associated with the selected messages 154 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the average daily failed object count TSM_cl005 ppr This view lets you look at the average number of object failures that occurred for each Tivoli Storage Manager client operation Information is presented by day of week and is the average of the last 4 weeks of activity Use this to help you determine whether error activity is related to specific days of the week A layer is provided to allow selection of a specific Tivoli Storage Manager server or an aggregate of all servers can be displayed Drill down is provided to view failed object counts for the last 4 weeks associated with the selected day TSM_cl004 ppr TSM_cl006 ppr TSM_clmsg007 ppr What is the average daily successful object count TSM_cl006 ppr This report gives you an overview of the number of objects successfully processed by each Tivoli Storage Manager client operation Information is presented by day of week and is the average of the last 4 weeks of activity Use this to help you determine processing activity for specifi
100. m e Disk Space 100MB for the software Tivoli Storage Manager The use of a file server in the Tivoli Decision Support is recommended If the Tivoli Decision Support client software resides on the file server as a shared resource and each client loads the application from the file server a highly fault tolerant configuration is recommended Chapter 5 Operational Procedures for Storage Management Analysis 99 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm However if the Tivoli Decision Support client software resides on each client workstation configuration of the file server is not required The connection between the file server and the client software must support long file names Low end file server and the various Data Components e 300Mhz or faster processor e 128MB RAM Support long file names e Sufficient hard drive space High end file server and the various Shared Data components e Latest high speed processor e Microsoft Windows 98 or Windows NT4 256MB RAM improve performance 512MB RAM is recommended if you are building cube with large volumes e Support long file names e Sufficient hard drive space 5 2 5 Exercising relationships within reports After opening Tivoli Discovery Interface and selecting a option from Tivoli Storage Management Event Analysis or Tivoli Storage Management Performance Analysis it is possible to exercise reports within reports by clicking on the related views tab as in
101. m 6109ch05 fm separate machines The user of the client machine can only use the Discovery Interface If the environment requires that Tivoli Decision Support Discovery Interface client be installed in the network mode then the Discovery Administrator should be installed on separate machine usually the system administrator s machine and the Shared Data component should be installed on a file server The Discovery Administrator must be installed on at least one machine when installed in network mode In order to use Tivoli Decision Support online documentation install Adobe Acrobat reader The correct specifications for the machine is required Hardware Requirements for Storage Management Analysis Tivoli Decision Support must be installed on a IBM PC compatible machine Tivoli does not support platforms such as the NEC PC98xx series that are not 100 compatible with the IBM PC Hardware requirements depend on the software configurations If Tivoli Decision Support is intended as a server installation the requirements are e Processor Intel based Pentium 450MHZ minimum e Memory 256MB minimum e Disk Space 200MB for the software 400MB minimum for the cubes depending on the Tivoli Storage Manager network size If the Tivoli Discovery Interface and Storage Management Analysis are intended as a client installation the requirements are as follows e Processor Intel based Pentium 300MHZ minimum e Memory 128MB minimu
102. mary of the TSM_msg rpt database Tivoli Storage Manager server backup database backup function for the last record 14 days It is very important to have a current backup of your Tivoli Storage Manager server database Use this report to look at a history of your Tivoli Storage Manager server database backup record If the database is not being successfully backed up every day determine why and take the appropriate corrective actions What day of TSM_clmsg005 ppr This view lets you look at Tivoli TSM_clmsg001 ppr week do peak Storage Manager client message TSM_clmsg002 ppr client error activity for each day of the week TSM_clmsg003 ppr rates occur TSM_clmsg004 ppr Use this view to determine whether TSM_clmsg006 ppr client error activity is related to a specific day of the week Messages include the following Severe S Error E Warning W and Diagnostic D A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided on a day of the week as follows e View message counts for the specific date that is associated with the selected day of the week e View message counts for each hour associated with the selected day e View message counts for the messages that were issued for the selected day and hour Drill through is provided to view the specific message text associated with the selected messages Appendix A Relate views fo
103. me is identified by appending the string DN to the domain name e Client schedules defined to the policy domain A schedule name is identified by appending the string SN to the schedule name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name e Sessions associated with specific clients If an operation was not initiated the session name is set to None 138 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the TSM_cl002 ppr This view provides a summary of TSM_clmsg rpt status of non scheduled operations for Tivoli non schedule Storage Manager clients that occurred d client during the last reporting period sessions Information is summarized for each Tivoli Storage Manager server The results are categorized as follows Completed Operation was considered successful e Failed Operation considered a failure based on client session results Use this information to identify the overall results of non scheduled client sessions Drill down is provided to view a category e g FAILED operations by client Drill down is provided for each TSM server The drill down levels are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivol
104. me of day do peak client data transfers occur e Which clients have the highest average failed objects count Trends in Server Operations e How does time affect server session activity e How much data is processed by daily server operations e What is the daily failed object count for server operations What does my environment look like How many clients are registered with each server What messages should I be concerned with e Summarize client messages by severity e What are the top 10 clients with the most problems Tivoli Storage Management Performance Analysis How are my clients performing e How does platform affect client throughput rates e How does Tcp Ip address affect throughput How does file size affect my performance e Classify sessions by file size and performance thresholds How does file size affect client operation throughput These reports are geared with the proper date filters yield an analysis of performance and events within the month They will give a picture of what has transpired during the month as well as show storage trends in the enterprise These may be good candidates to be stored for further reference or year end summary reporting 5 1 5 The window of opportunity We describe the window of opportunity as the time in which the Tivoli Storage Manager Decision Support Loader may execute allowing the extraction of data from the Tivoli Storage Management servers to the RDBMS Chapter 5 O
105. ment Administrator should setup a regularly executed schedule for dataloads tsmdsl and cube building Keep in mind that you should try to avoid running the dataloads at a time when the Tivoli Storage Management database is being heavily used Avoiding times when client backups and archives are running is preferred Avoid running dataloads during Tivoli Storage Management administrative jobs Expect degraded performance if this is not possible Reporting from System Management Analysis should be done on a regularly scheduled basis as well This will make trends and anomalies more apparent to the viewer and increase the value of the product to your organization Specific reports to be drawn on a weekly monthly daily or weekend basis are dependent on your preference and relevance to your operation The bold print in this section indicates headings within the Storage Management Analysis Guide The following is a recommended guide for a Storage Management Analysis report schedule 5 1 1 Daily reporting Having completed scheduling the Tivoli Storage Manager Decision Support Loader and the cube builds the reports can be viewed in the Tivoli Discover Interface These reports can show you possible server or client errors that should be checked on a daily bases Use the following reports from the Tivoli Discovery Interface for daily reporting Tivoli Storage Management Event Analysis Copyright IBM Corp 2000 91 6109ch05 fm Draft Docu
106. ment for Review April 18 2000 1 49 pm Daily exception reports e Classify outcome for client sessions e Summarize the messages issued in my environment e What are the results of all operations that occurred for a client e What is the status of non scheduled administrative operations e What is the status of scheduled administrative operations What is the status of scheduled client sessions How might I improve my storage health e How current are client backups e Show me my server database backup record When did clients last contact the server Trends in Server Operations e What is the average daily failed object count e What is the average daily successful object count What messages should I be concerned with e Summarize client messages by severity e Summarize server error messages by severity e What are the top 10 server messages Tivoli Storage Management Performance Analysis How are my clients performing e Which are my 10 fastest clients e Which are my 10 slowest clients How does time of day and day of week affect my performance e What is the average daily throughput for client operations e What is the average hourly throughput for client operations e What is the average hourly throughput take for server operations 92 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm This set of reports should point to immediate problems which need attention Look for unexplained
107. ministrator to assure they are using Tivoli Storage Management resources efficiently Tivoli Storage Manager Reporting Draft Document for Review March 10 2000 3 51 pm 6109ch01 fm 1 3 Dynamic business requirements The business environment has been subject to change and will continue to be as long as markets and economy are the drivers As organizations downsize buy out reorganize dissolve and go through the changes that enables business to progress information systems must remain flexible and responsive to these changes This Tivoli Decision Support and Storage Management Analysis is intended to conform to a dynamic business environment It is adaptable to changing computing responsibilities As additional processors and servers some of them possibly with identical names are added to the IS department they are easily integrated into currently reported processors This situation is common as companies are merged bought or reorganized The technology utilized to obtain its flexibility can be described as On Line Analytical Processing or OLAP 1 3 1 What is OLAP Definition for OLAP is from web site http www moulton com olap olap glossary html1l On Line Analytical Processing OLAP is a category of software technology that enables analysts managers and executives to gain insight into data through fast consistent interactive access to a wide variety of possible views of information that has been transforme
108. mmended for downloading the additional Web material Hard disk space 2222MB minimum Operating System 2222Windows UNIX S390 Processor 222 or higher Memory 2222MB B 3 2 How to use the Web material Create a subdirectory folder on your workstation and copy the contents of the Web material into this folder 176 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109spec fm Appendix C Special notices This publication is intended to help network storage administrators to use Tivoli Decision Support for Storage Management Analysis to report on their Tivoli Storage Manager usage The information in this publication is not intended as the specification of any programming interfaces that are provided by Tivoli Decsion Support or Tivoli Storage Manager See the PUBLICATIONS section of the IBM Programming Announcement for Tivoli Decision Support for more information about what publications are considered to be product documentation References in this publication to IBM products programs or services do not imply that IBM intends to make these available in all countries in which IBM operates Any reference to an IBM product program or service is not intended to state or imply that only IBM s product program or service may be used Any functionally equivalent program that does not infringe any of IBM s intellectual property rights may be used instead of the IBM product program or serv
109. mponents to install and on which machines based on how you plan to run the application You will chose to run in stand alone mode or network mode Refer to the Tivoli Decision Support 2 1 Installation Guide for more information on configurations and hardware requirements You must also install PTF2 for Tivoli Decision Support to have Storage Management Analysis function properly The Tivoli Decision Support components necessary to run Storage Management Analysis are e Tivoli Decision Support administrative interface The Tivoli Discovery Administrator Module is a component of Tivoli Decision Support that is used to control the following Scheduling the data collection process to build the Tivoli Storage Manager Reporting Database Building the cubes associated with the Tivoli Decision Support Storage Management Analysis Guide Functional Definition Tivoli Decision Support Discovery Interface The Discovery Interface is a component of Tivoli Decision Support that is used to present information to users This interface is located on one or more PC clients and normally will be pointing to the server content located on a network file server where the Tivoli Decision Support Administrator has created the multi dimensional cube This interface uses a topic map as the primary means of navigating the discovery interface The topic map divides viewable data into a hierarchy of distinct categories topics and views Each Tivoli Storage Manager
110. n Management Information Systems Master of Science from Bowie State University His areas of expertise include systems software support and storage systems support Grant McDonald is a Advisory IT Specialist in South Africa Johannesburg He has 6 years of experience in server operations and support field He has worked at IBM for 6 years His areas of expertise include server operations on OS 2 Novell Winodws NT AIX and enterpirse networking He has written extensively on system software and storage systems support Copyright IBM Corp 2000 xiii 6109pref fm Draft Document for Review April 18 2000 9 35 am Thanks to the following people for their invaluable contributions to this project Don Brancato Tivoli Systems Andy Ruhl Tivoli Systems Dominic Pruitt Tivoli Systems Andy Wharton IBM UK Richard Harrison Tivoli Systems Steve Strutt Tivoli Systems Comments welcome Your comments are important to us We want our Redbooks to be as helpful as possible Please send us your comments about this or other Redbooks in one of the following ways e Fax the evaluation form found in IBM Redbooks review on page 191 to the fax number shown on the form Use the online evaluation form found at http www redbooks ibm com e Send your comments in an Internet note to redbook us ibm com xiv Tivoli Storage Manager Reporting Draft Document for Review March 10 2000 3 51 pm 6109ch01 fm Chapter 1 Real world TSM
111. n Support Loader Release notes Version 1 1 1 for more detail 2 2 1 TSM Decision Support Loader A new utility program called tsmdsl Tivoli Storage Management Decision Support Loader Version 1 1 is provided on the install CD to manage data collection This program uses the Tivoli Storage Manager ODBC interface to read data from the Tivoli Storage Manager server and uses the RDBMS ODBC interface to save data into the Tivoli Storage Manager Reporting Chapter 2 Tivoli Decision Support for Storage Management Analysis Component Overview 27 6109ch02 fm Draft Document for Review April 18 2000 1 48 pm Database The basic steps performed by the program tsmdsl during the data collection process are e Extract data from the Tivoli Storage Manager server using the Tivoli Storage Manager ODBC driver e Transform data into the format required by the Tivoli Storage Manager Reporting database This includes processing such as providing a unique date time key for the information extracted from the Tivoli Storage Manager server e Write data to the Tivoli Storage Manager Reporting database using the RDBMS ODBC driver The program tsmdsl also controls the expiration of old records from the RDBMS There is a GUI interface to control configuration and execution This will appear at loader execution time There is also a log to contain a record of execution results in the Tivoli Decision Support directory The configuration parameters for tm
112. n aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Drill down is provided for a specific day of the week as follows e View the last 4 weeks activity associated with a specific day of the week e View the specific session activity associated with a specific date 168 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views How does file TSM_cl015 ppr This view illustrates how file size TSM_cl016 ppr size affect affects Tivoli Storage Manager client client operations Information is based on operation the last 7 days of activity throughput File size is categorized as follows e SMALL average file size lt 10 KB e MEDIUM average file size between 10 KB and 256 MB e LARGE average file size gt 256 Use this information to help understand what the average client performance is for various file sizes and client operations A layer is provided to select a specific server or an aggregate of all servers can be displayed Appendix A Relate views for the table analysis 169 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views Classify TSM_cl016 ppr This view allows
113. n be solved using Storage Management Anal VSIS a nec ei nee eee oe oe eee ete eg hee aah Dee ane 19 1 5 1 Typical question sampling 00 0 eee eee eee 19 Chapter 2 Tivoli Decision Support for Storage Management Analysis Component Overview 000 cee eee 25 2 1 Tivoli Storage Manager servers 00000 0 cece eee eee 27 2 2 Tivoli Storage Manager RDBMS interface 27 2 2 1 TSM Decision Support Loader 222002000 00s 27 2 2 2 Tivoli Storage Manager ODBC driver 4 28 2 2 3 RDBMS ODBC interface 00002 eee 28 2 3 RDBMS o i sa 253 sea eed See eee won ae eG a ad 29 2 3 1 Tivoli Storage Manager reporting database 29 2 3 2 RDBMS schemas 00000 cece eee eee 29 2 4 Tivoli Decision Support 0 00000 cee 29 2 4 1 Tivoli Decision Support 0 000 e ee eee 30 2 4 2 Storage Management Analysis Guide 31 2 4 3 Using fm20 dll ssr resrerdssi nesepi EE EEA a 31 2 5 Scheduler 0 0 0 es 31 Chapter 3 Tivoli Decision Support for Storage Management Analysis Ar chitectural Issues 0 0 0 0 eee ee 33 3 1 How many machines why is this important 33 3 1 1 Access frequency and the network 2 36 3 1 2 Network Configuration 000 cee eee 36 Copyright IBM Corp 2000 Vv 6109TOC fm Draft Document for Review April 18 2000 1 49 pm 3
114. n the component overview presented in Chapter 2 and identify issues of tailoring Storage Management Analysis reporting to your organization There are multiple configurations related to the tsmdsl program the RDBMS and the Tivoli Storage Manager servers For example tsmds can run on the same machine as the RDBMS or on a different machine Also there can be multiple tsmdsl programs running on separate machines extracting data from different Tivoli Storage Manager servers and loading data into the same RDBMS These different configurations can affect performance Also see the discussion for hardware minimum requirements in Chapter 4 1 4 Multiple data source configurations on page 45 of this redbook 3 1 How many machines why is this important One of the first things to plan for is how many workstations need access to reports and how often If there are multiple reporting workstations you may want to consider a dedicated file server for reports as described in the Tivoli Decision Support Installation Guide See also the discussion in Chapter 5 2 4 Duplicating to other file servers on page 98 on stand alone mode versus network mode If you have a relatively small Tivoli Storage Management system or a system which is accessed by a single Tivoli Storage Management Administrator you may need only the minimum number of machines configured for Tivoli Decision Support and Storage Management Analysis as shown in Figure 3
115. n use the Tivoli Discovery Interface to view these reports You can also use Crystal Reports to generate text based views Chapter 4 Configuration and Implementation 63 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm A Crystal report view is in Figure 22 Once you have generated a full Crystal report you will notice that it s all inclusive You may want to specify a limit on the information that you see in your reports Upon opening Crystal reports for the first time through the Tivoli Discovery Interface you will be prompted to enter one or more parameters Entering parameters allows you to limit the size of the report If you choose to enter the date parameter do so as a string in one of the following format For a type of Date Time the format varies for each different database MICROSOFT SQL pp yyyy ORACLE pp mm vy DB2 yyyy mm DD A small note to be taken is that Crystal Reports will not necessarily display the date in the same format in which you have entered them 64 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Server Name Severity DATE TIME BAAN 12 137 BAAN 141032 BAN 140632 BAAN 11032 RAAN 140632 BAAN 1410632 RA 14 22 16 WAAN 14 22 16 WAAN 14 22 16 WAAN 14 22 16 RAAD 14 22 16 RA 14 27 33 BRA 14 27 39 RAI 14 27 39 RA 14 27 39 BA 14 27 33 BAN 14 20 41 BAN 14 20 41 KA 14 20 41 Server Nane TOCINO praESd B S
116. nd Implementation 67 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm 4 4 1 What size DB to start DB Growth The database that is corrolationg the data from the TSM servers should start growing immediately from day one The database growth can not be defined as this could be dependent on the how many TSM servers are on the network Also how much of the data is coming down the network to the RDBMS The database should be set to prune therfore allowing the RDBMS to remain at a minimum amount of megs The option of pruning should be set by the administrators The defined size before the TSM administratros can start drawing the reports for management could start at any size There is no defined size on how much data that your RDBMS should contain Obviously the more data that is in the RDBMS the more information your graphical graphs will produce Allowing management to see more information of the various intstances that is happening between the TSM servers and the RDBMS As for the database growth it would be difficult to say for instance if you have no set the pruning and left it as default the database will grown Re writing data all the time for 366 days Growth with the default setting of pruning will utilize the hard disk drive space 4 4 2 SQL example Using the Microsoft SQL Analyzer refer to the Figure 25 on page 69 you can perform a simple query such as SELECT FROM DB From the drop down on the toolbar you
117. nderlying purpose of the Storage Management Analysis product outlines the components comprising a Storage Management Analysis reporting environment and explains how to cope with some common problems which may be encountered in implementing that environment We conclude by presenting examples of how you may want to integrate Storage Management Analysis reporting into day to day operations and how to use it to answer some typical adhoc questions asked in a Tivoli Storage Management environment The book is intended for Tivoli Storage Management Administrators and information systems executives who have an interest in the performance and reliability of Tivoli Storage Management The team that wrote this redbook This redbook was produced by a team of specialists from around the world working at the International Technical Support Organization San Jose Center Pat Randall is a Distributed Storage Software Specialist at the International Technical Support Organization San Jose California He has written ten redbooks on ADSM and Tivoli Storage Manager teaches IBM classes worldwide on all areas of distributed storage and is a consultant in disaster and business recovery Before joining the ITSO in July 1996 Patrick worked in IBM UK s Business Recovery Services as a Solutions Architect Bill Helms is a Information Systems Engineer in Baltimore Maryland U S A He has 25 years of experience in the information systems field He holds a degree i
118. nel gt 0DBC driver as referenced in the figure below Verify the correct version of MDAC which should be 3 510 3711 0 If you do not have the correct version it is advisable to upgrade to the correct level to prevent operating system errors or other functional failures that could cause a fatal system error Chapter 4 Configuration and Implementation 57 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm A more general point that should be noted is that any third party software that is installed or downloaded from the internet may downgrade your MDAC levels Refer to Figure 18 on page 58 For a further insight to MDAC refer to the following web site http www microsoft com I ODBC Data Source Administrator 2 x User DSN System DSN File DSN Drivers Tracing Connection Pooling About About the ODBC core components Administrator 3 510 3711 0 CAWINNTSSystem32 odbecp32 dll Control Panel Device 3 510 3711 0 CAWINNTSystem32 odbecp32 cpl Control Panel Startup 3 510 3711 0 CAWINNTSSystem32 odbcad32 exe Cursor Library 3 510 3711 0 CAWINNTSSystem32 odbeer32 dll Driver Manager 3 510 3711 0 CAWINNTSSystem32 odbe32 dll Localized Resource DLL 3 510 3711 0 C WINNTSSystem32 odbcint dll Unicode Cursor Library 3 510 37117 0 CAWINNTSystem32 odbecu32 dll data in database management systems that use Structured Query ODBC is a programming interface that enables applications to access Language SQL as a data access stand
119. nformation before you setup your Tivoli Storage Management data source connection After you have installed the Tivoli Storage Management Decision Support Loader the database schema scripts are manually loaded and then are run on the database The Tivoli Storage management Decision Support Loader task aggregates and stores the data in the relational database Note The ODBC drivers shipped on the Tivoli Decision Support CD ROM will not work with Storage Management Analysis Install the OEM ODBC drivers provided by the RDBMS vendors To ensure the latest drivers are installed you may have to download these drivers from the vendor s website 4 2 3 Error 339 fm20 dlIl MS module access This error 839 FM 20 dll occurs when you install Tivoli Decision Support Loader in support of the Tivoli Discovery Interface and the Tivoli Discovery Admin The error will appear if no Microsoft Office product is installed on the server Some methods of obtaining the FM20 dll files are to install the suite of Microsoft Office or a portion thereof like Microsoft Power Point Another other way of fixing this is by going to the Microsoft web site and downloading Microsoft Active X control Pad from the following web site http www microsoft com Once this patch has been applied the error will no longer appear referring to the error in Figure 15 TSM Decision Support Loader x AN Run time error 339 Component FM20 DLL or one of its dependenc
120. ninstall TDS 2 1 from start gt Programs gt TDS 2 1 gt Unistall Upon completion of the proceeding shutdown your Windows NT4 server or workstation and restart it 62 Tivoli Storage Manager Reporting q Control Panel Ioj xi File Edit View Help Add Remove Programs Properties _ x Install Uninstall windows NT Setup E2 To install a new program from a floppy disk or CD ROM ed drive click Install Install E The following software can be automatically removed by ed Windows To remove a program or to modify its installed components select it from the list and click Add Remove Microsoft SQL Server 7 0 Microsoft Windows Media Player 6 4 Netscape Communicator 4 61 Norton Antivirus 5 0 for Windows NT Paint Shop Pro 5 01 RealPlayer G2 Tivoli Decision Support 2 1 Tivoli Decision Support 2 1 TDS 0001 Patch Tivoli Storage Management Decision Support Loader 1 1 1 zi Confirm File Deletion x C re you sure you want to completely remove Tivoli Decision Support 2 1 and all of its components Yes No Figure 21 Example of wanting to remove Tivoli Decision Support 2 1 4 3 Crystal and Cognos participation Tivoli Discovery Administrator is used to define queries that extract data from the TDS database into a delimited file or a file with comma separated values csv Cognos transformer builds a cube from the file and Cognos PowerPlay generates reports from the cube You ca
121. nistrator O x File View Cubes Data Sources Decision Support Guides Scheduled Tasks Help Efe slala elle Administrator Propetes Cubes M Mem 3 14 00 10 31 37AM Tivoli Storage Manager The cube contains the status f TSM Client Activity amp AB TSM Server Bytes Processed TSM Server Messages 8 Data Sources Decision Support Guides C Scheduled Tasks 06 51PM Tivoli Storage Manager The cube contains an hourly 06 31PM Tivoli Storage Manager The cube contains the mess TSM Serve 3 8 00 TSM Serve 3 8 00 E 1h Clent Bytes Processed Arsh Client 3 8 00 1 08 35 PM Tivoli Storage Manager The cube contains an hourly 15M Client Fiespaces AB TSH Cient 3 9 001 0317 PM Tivoli Storage Manager The cube contains flespace i af 15H Cle Ifo AB TSH Cient 3 9 001 05 00PM Tivoli Storage Manager The cube contains cient nod a 1M Clerk Messages AB TSH Client 3 9 001 08 48 PM Tivoli Storage Manager The cube contains messages Bf TSM Sever Acti TSM Serve 3 8 00 1 08 22 PM Tivoli Storage Manager The cube contains the result 6 1 6 1 D Ready 3 15 00 257 PM I Figure 24 Cube view from the Tivoli Discovery Administrator 4 4 Relational Database considerations In this section we look at a few simple examples of a Microsoft SQL DB2 and Oracle databases and what the requirements are to perform a healthy report from the database Chapter 4 Configuration a
122. nts last contact the server Trends in Client Operations sn ul Summarize client messages issued by platform fa tial Summarize client messages issued by software level svn ul What is the average daily failed object count Jl What is the average daily successful object count sree What time of day do peak client data transfers occur La fgg Which clients have the highest average failed objects count d pe Trends in Server Operations Ed How does time of day affect server session activity B How much data is processed by daily server operations baaa F What is the average daily failed object count for server operations 5 pe S What does my environment look like fv a How many clients are registered with each server lglg Which platforms do clients use ofl Which software levels do clients use Figure 52 Reports from the Storage Management Analysis Guide 104 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm Tivoli Discovery Interface File Edit View Navigate Window Help Hle 44 aloo ae ESS What messages should be concerned with buna ll Summarize client messages by severity fal Summarize server error messages by severity W What are the top 10 client messages i What are the top 10 clients with the most problems ll What are the top 10 server messages When do find the most problems i What day of week do peak client error rates occur b
123. o U S Government Users Documentation related to restricted rights Use duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corp Draft Document for Review April 18 2000 1 48 pm 6109edno fm 650 Harry Road San Jose California 95120 6099 When you send information to IBM you grant IBM a non exclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you 6109edno fm Draft Document for Review April 18 2000 1 48 pm 4 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109TOC fm Contents BIQUICS 2 i dae ria eee cagee dg beri d oe eee bbe bases bow dies ix WANS ee oa ee ee eee ees in ee A xi PTAC Oise sects eis erence tena ai ese ents ee at ae A eae ath eter alll Waele Bs Be xiii The team that wrote this redbook 0 0 2 0000000 c eee eee xiii Comments welcome 0 00000 e eee ee eee eee xiv Chapter 1 Real world TSM event business and performance problems 15 1 1 Defining function within the IS infrastructure 15 1 2 Reporting on system health and justifying requirements 16 1 3 Dynamic business requirements 000 anaa 17 1 3 1 Whatis OLAP cio pocia taadaa aioa a aaa a eee 17 1 3 2 OLAP implementation naana aaaea 18 1 4 An out of box reporting solution 0 0 00 eee eee ee 18 1 5 What kinds of problems ca
124. ocument for Review April 18 2000 1 49 pm Create a New Data Source to SQL Server Figure 32 SQL login and password authentication Select the second radio button to use SQL Server login authentication enter a Login ID and Password for SQL server authentication Figure 32 click client Configuration to open the Edit Network Lfbrary Configuration dialog box 76 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Edit Network Library Configuration k e 9 s 9 Fr s Figure 33 Library configuration for protocol to be used Change the Network libraries communication protocol or connection parameters as required by your system configuration Figure 33 Click ox to return to the Create a New Data Source to SQL server Setup wizard Click Next Chapter 4 Configuration and Implementation 77 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Create a New Data Source to SQL Server fely SIGTEd DIGREd UTES Tor prepara SUL statenrents tole d proved fe Gri ihen pau disconrect sanes and las ap piapriate wm evonet Figure 34 Specify the database for storage management Select any processing option you want to apply or use the default settings You must specify the reporting database you plan to use for Storage management Analysisas the default database Figure 34 Click Next 78 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000
125. olumna sNore gt Layer Sy Server Domain and Client By Server Domain and Client Layer 3 of 3 Total Throughput KB s By Tcpilp 32 4 Figure 58 TCP IP address and throughput Another good report which may be show the effect of network parameters within the operating system Tivoli Storage Management or other network components is presented in Figure 59 112 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm Classify sessions by filesize and perfomance thresholds Period Rolling 7 Days Measure Tofa Session Count Row By Performance Threshold KB s Column Small Layer Tucson on pranres4 Tucson on pranres4 Layer4of5 2 Total Session Count Legend 140 60 40 20 Small Medium Large Figure 59 Examining filesize as related to performance Refer to the Hints tab when running this report to see how response was classified good slow or average 6 3 Correcting errors The questions What are my problem clients and which clients are not getting backed up on a regularly and What are the errors am getting most and which ones should work on correcting first are also closely related We discussed these questions as an example in Figure 1 on page 20 and the discussion proceeding it That is a good starting point in cleaning up problems within your system Chapter 6 Tivoli Decision Support for Stora
126. ou want to set up as an ODBC data source You must enter the unique name specified for the database when it was created See your database administrator for this database name Cick Next to open the Alias page 86 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Add Database SmartGuide Figure 44 Alias database name Enter an alias name and description if you want to create a symbolic name for the target database in Figure 44 If you do not specify an alias the unique name specified for the database when it was created will be used as the default local alias Click Next to open the opsBc page Chapter 4 Configuration and Implementation 87 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Add Database SmartGuide IV Heoister this datavase for UBL Figure 45 Microsoft Visual Basic application Make sure the check box next to Register thes database for ODBC is checked Select Microsoft Visual Basic in Figure 45 from the Application dropdown list Click Done to open the Connect to DB2 Database dialog box 88 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm Connect To DB Databaze Figure 46 User id and password for Database connection Enter the User ID and Password required to access the DB2 database Click oK to pen the confirmation dialog box above in Figure 46 ee Confirmation DB2 TEST Figure 47 Te
127. ow much tine is spent daily B Diy Eeten terate waiting for media access Hoel ramen bashed ini nd nts TELE i Tern et eatre serr inert E Tertr Seeler Gee Bertin Wha ee ve he E3 What nesses ll becemene nt i mate 4 Tit Sirgelirapnet Peon te a Howse mp censeloig 3 9 How aen ne lori si Hush inet ert ingest fg rte avenge ce eaainela sn pln F Tec at Fe O oea Vet ed aia Honmchine gent dawg io nefa aroan Show ed iae ha Ye Tp Tay Fene Sebiedtiragten Hon des mecl dy ec sense ac TardsnSeverlpedim Trai Sioage Hanagenert Evert TSH anole 7 Crete ivtainhecrmezedab davetne tose tov aroseexpafomig ThiStogeHenpenePef TSH ny ld tabteceapds iragputiona Haereses panig TalSuaxdengenfata TH sl E Brka Piles Hy ian Sach Doere Med Pole Related views tab points to other relevant reports and graphics kd How does time of day affect server session act Trends in Server Operations ul What is the average daily elapsed time for serv How are my servers performing ul What is the average daily throughput for server How are my servers performing Figure 51 Related views shown from Tivoli Discovery Interface Tivoli Storage Management Event Tivoli Storage Management Perfor Tivoli Storage Management Perfor TSM_srvb002 ppr TSM_srv004 ppr TSM_srv003 ppr Figure
128. perational Procedures for Storage Management Analysis 95 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm where the data will be stored while encountering the least amount of competing data traffic or processing resistance After dataloads have been completed and the cubes have been built the stored data can then be reviewed by managers of a business or the Tivoli Storage Management Administrators Before you build the cubes in the Tivoli Discovery Administrator it is important the database has stored the data that will allow the cubes to build with the most current data Then the reports can then be viewed from the Tivoli Discovery Interface The process of performing cube builds can be done in two different ways We recommend that the cubes be scheduled to build automatically at a time of day or days specified by the administrator Pick a time when the network will not be a limiting factor The other way the cubes can be built is to manually have the administrator do it through the Tivoli Decision Support Administrative Interface which can become a time consuming task The importance of the time chosen to do this is that you do not want the Tivoli Decision Support Loader to execute at the same time the cubes are scheduled to build The interference will decrease the system performance on the processors particularly when data is been correlated into the RDBMS 5 2 Care and feeding Here we discuss the data cleanup f
129. ppr This view provides a summary of the TSM_srv003 ppr average daily elapsed time of Tivoli Storage TSM_srv005 ppr elapsed time Manager server operations by day of TSM_srvb002 ppr for server week for the last four weeks operations Use this report to determine how elapsed time varies for Tivoli Storage Manager server operations by day of the week This can be used to highlight potential scheduling problems A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Drill down is provided for a specific day of the week as follows e View the last 4 weeks activity associated with a specific day of the week e View the specific session activity associated with a specific date Appendix A Relate views for the table analysis 167 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views How much TSM_srv005 ppr This view provides a daily summary of TSM_srv003 ppr time is spent the amount of time server operations TSM_srv004 ppr daily waiting spend wait for media access during the TSM_srvb002 ppr for media last 7 days access This view can be used to highlight tape mount problems that are occurring during server operations A layer is provided to select a specific server or a
130. pt PRANRES3 T 2666 64 63 68 58 24 53 661 66666663 6668 6668 66666668 666666F FFFFFFF 00000000006000 SOGGG6FFFFFFFF 65 6666666085354475 G4F 4F4CSF43I4F554E54O00000 669666666666666666666666666666666666666669 6666666A 666666 PSESESESESisEsEsisEsistsisisisistsisisisistsisisisistsisisisistsisisisisisisisisisisisisisisisisisisistsisists PSESESESESisEsEsisEsisisisisisistsisisisistsisisisistsisisisistsisisisisisisisisisisisisisisisisisisistsisists FILESPACES PRANRES3 T 2666 64 63 68 58 24 83 661 66666663 6668 6668 66666668 666666F FFFFFFF 0606000000660008 GOGFFFFFFFF1AG 666664 646494045535 B41 43455F54595 645 666666 FFFFFFFFFFFFFFFFFFFFF 63 6614662 6666463 685824887 661666666 LOG PRANRES3 T 2666 64 63 68 58 25 66 661 66666663 6668 6668 66666668 6666606F FFFFFFF 0606000000060908 66667 666666601 6618 6664666666064 56660666F FFFFFFF8 686666666666 G4F SF SC5F5 641474553 6660660660 6666666611 00000606E 66666663 66 666666666660 66660666606656066660665606656066056565560656 ADMINS PRANRES3 T 2666 64 63 68 58 25 33 661 66666663 6668 6668 66666668 666606F FFFFFFF 0606000000000900 45F54494D45 66606606660 6066660666 66060660 606606056060560666 Figure 29 Results of the command issued The results that can be seen are from the DB2 tables for any futher DB2 command and administration please consult with the IBM DB2 manuals either Administration or support 4 4 4 Setup guide for ODBC communications to the RDBMS As mentioned earlier the
131. pts to the Tivoli Storage Manager server or identify users that may not know their password Report parameters are provided to specify Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server Appendix A Relate views for the table analysis 147 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views How current TSM_clfs001 ppr This view provides a summary of the TSM_cli002 ppr are client backup currency for Tivoli Storage backups Manager client filespaces Information is based on the most recent data extracted from Tivoli Storage Manager servers Filespaces are categorized as follows OK Filespace was backed up within the last day e Warning Filespace backup occurred in the last 2 to 14 days Critical Filespace has not been backed up for more than 14 days Never Backed Up Filespace has never been backed up Use this information to identify client file
132. r the administrator will be required to launch the Tivoli Decison Support Loader and complete the setup by doing the following e Launch the Tivoli Decision support loader as in Figure 9 userid s and passwords have been greyed out and clicking on cancel to prevent the execution of TSMDSL Chapter 4 Configuration and Implementation 45 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Tivoli Storage Management Decision Support Loader lei ks r Setup l Verifying database connection to all the servers listed in the server Sever List list Table List Tucson on pranres4 uses ODBC driver version 03 07 0001 Server Tucson on pranres4 DataSource local on pranres4 Server values DSN Tucson on pranres4 Thread ID 248 Data Source Post Processing Collecting Storage Data Help Working ance Tucson on pranres4 TTT TTT TTT TT 3 9 00 11 55 AM 0 1 Figure 9 Tivoli Decision Support Loader e From the Tivoli Decison Support Loader graphical user interface select the server list tab on the left and click on the arrow to drop down a list The Tivoli Storage Management ODBC driver that you have setup will show in the server list drop down Select the server name that you have entered and click on it The administrator then will have to enter a userid and password that is the same on the Tivoli Storage Management server as shown in Figure 10 userid s and password greyed out Select
133. r 4 61 Norton AntiVirus 5 0 for Windows NT Paint Shop Pro 5 01 RealPlayer G2 Tivoli Decision Support 2 1 Tivoli Decision Support 2 1 TDS 0001 Patch Tivoli Storage Management Decision Support Loader 1 1 1 Add Remove OK Cancel Apply Figure 20 Applications can be removed here e Cognos PowerPlay 6 5 for Windows Cognos PowerPlay 6 5 Personal Server e Microsoft SQL Server Tivoli Decision support 2 1 e Tivoli Decision Support 2 1 TDS 0001 Patch To remove these applications there is a specific order in doing so This to prevent unwanted errors A condition where the application has never fully Tivoli Storage Management Decision Support Loader 1 1 1 6109ch04 fm been removed from the operating system and will not allow you to delete the Chapter 4 Configuration and Implementation 61 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm rest of the application files may occur You then will be required to use the Windows NT4 Registry to remove parts of the application that you wish to uninstall refer to figure 8 on page 37 The preferred way to remove the applications is as follows Uninstall the Guide from with in the Tivoli Discovery Administrator Uninstall the patch from settings gt Control Panel gt Add Remov programs Uninstall Cognos from Settings gt Control Panel gt Add Remove programs Cognos has two parts to it Personal Server and a Windows Product U
134. r db2admin m Cancel Figure 26 Logon connection to database once the above command is run you will be required to enter a passwora as in Figure 27 userid s and passwords greyed out a confirmation screen will appear showing you connection to the database server and the user id 70 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm tj Command Center ioj xi Results Edit Help Script Results Access Plan Command entered connect to db2itso user db2admin Database Connection Information Database server DB2 NT 5 2 86 SQL authorization ID Local database alias Figure 27 Connection succesful On having connection to the DB2 database the command as mentioned above Select from sysibm systables Can be run as demonstrated in Figure 28 below Chapter 4 Configuration and Implementation 71 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm ij Command Center OF x Script Edit Help i area w SBA lsa Ei i Results Access Plan Interactive Script select from sysibm systables aad select from sysibm systables Figure 28 Simple command for DB2 query On completion of running the command a the information will show what you have requested Figure 29 72 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm cn Command Center ioj xi Results Edit Help ne Me Hle Scri
135. r the table analysis 151 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views What day of TSM_srvmsg003 ppr This view lets you look at Tivoli TSM_srvmsg001 ppr week do peak Storage Manager server message TSM_srvmsg002 ppr server error activity for each day of the week TSM_srvmsg004 ppr rates occur Information is included from the last 7 days Use this to determine whether server error activity is related to a specific day of the week A status bar is provided to select a specific server or an aggregate of all servers can be displayed Drill down is provided on a day of the week as follows e View message counts for the specific date that is associated with the selected day of the week e View message counts for each hour associated with the selected day View messages that were issued for a selected day and hour Drill through is provided to view the specific message text associated with the selected messages 152 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What time of TSM_clmsg006 ppr This view lets you look at hourly client TSM_clmsg001 ppr day do peak message activity for the last 7 days TSM_clmsg002 ppr client error TSM_clmsg003 ppr rates occur Use this to determine whether cl
136. raft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What is the average daily failed object count for server operations TSM_srv001 ppr This view lets you look at the average number of object failures that occurred during the last four weeks of Tivoli Storage Manager server operations Tivoli Storage Manager server operations included database backup storage pool backup migration expiration reclamation and move data Information is presented by day of week Use this report to view weekly error activity and determine whether error activity is related to specific days of the week A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar is provided to select a specific server operation or an aggregate of all server operations can be displayed Drill down is provided for a specific day of the week as follows e View the last 4 weeks activity associated with a specific day of the week e View the specific session activity associated with a specific date TSM_srv002 ppr Appendix A Relate views for the table analysis 157 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views How much TSM_srv002 ppr This view lets you look at the average TSM_srv001 ppr data is amount of data
137. re for future marketing or promotional contacts or other communications beyond the scope of this transaction Questions about IBM s privacy policy The following link explains how we protect your personal information http www ibm com privacy yourprivacy Copyright IBM Corp 2000 191 Tivoli Storage Manager Reporting SG24 6109 00 Printed in the U S A SG24 6109 00
138. rver Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name e Sessions associated with the selected client TSM_cl018 ppr TSM_cl011 ppr TSM_cl012 ppr TSM_cl010 ppr TSM_cl014 ppr 164 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views How much time is spent waiting for media access TSM_cl014 ppr This view provides a summary of the amount of time that Tivoli Storage Manager clients spent waiting for access to Tivoli Storage Manager server media This view can be used to highlight tape mount problems Drill down is provided to view media wait activity by individual client and session for a specific day of the week The drill down levels are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name e Sessions associated with the selected client TSM_cl018 ppr TSM_cl011 ppr TSM_c
139. sdsl are e Tivoli Storage Manager administrative ID and Password for each Tivoli Storage Manager server e Message level I E W S D Control what type of messages are included in the RDBMS e Expiration value used for pruning old entries from RDBMS e Include extract time qualification for EXTRACT_DATE field RDBMS key 2 2 2 Tivoli Storage Manager ODBC driver Used to read data from the Tivoli Storage Manager server Tivoli Storage Manager ODBC configuration parameters e Tcp ip address of Tivoli Storage Manager servers to query e Port number of Tivoli Storage Manager servers to query 2 2 3 RDBMS ODBC interface Used to save data into the Tivoli Storage Manager Reporting Database This will be relational database specific such as SQL ODBC or ORACLE ODBC RDBMS ODBC configuration parameters 28 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm 6109ch02 fm e Tcp ip address of Tivoli Storage Manager servers to query e Port number of Tivoli Storage Manager servers to query 2 3 RDBMS This must be on a platform and supported by the relational database technology chosen You may have multiple RDBMS servers but ordinarily you will only have one This is because multiple source servers can share the same database 2 3 1 Tivoli Storage Manager reporting database The source information is saved in a relational database called the Tivoli Storage Manager reporting database One
140. se this information to determine hourly server session activity A layer is provided to select a specific server or an aggregate of all servers can be displayed A status bar provides the ability to view an aggregate hourly session activity of all server operations or a specific server operation can be selected How many TSM_cli003 ppr This view presents asummary of the TSM_cli004 ppr clients are number of Tivoli Storage Manager TSM_cli005 ppr registered clients registered with each Tivoli with each Storage Manager server Information server is based on the most recent data extracted from Tivoli Storage Manager servers Use this information to see a summary of clients registered to each server Drill down is provided for each server The drill down levels are as follows Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name Appendix A Relate views for the table analysis 159 6109ax01 fm Draft Document for Review April 17 2000 11 38 pm View Title Filename View Description Hint Text Related Views Which TSM_cli004 ppr This view presents a summary of what TSM_cli003 ppr software Tivoli Storage Manager client software TSM_cli005 ppr
141. should select the database that you have created That will return the query information in a sub window in the SQL Analyzer The information that will be supplied is from the query you entered regarding the information that was pulled from the Tivoli Storage Manager server to the Microsoft SQL database 68 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm i Query local itsotest sa untitled select from BoaeWx M B ivp n o ElB DB fitsotest select from db 10 10 10 D oO 10 Ooorr J J J n 1p n Ip Oo n lo Query batch completed Exec time 0 00 00 17 rows Ibn Figure 25 Microsoft SQL server query For further command information consult your Microsoft SQL User manual or consult the Administrators manual 4 4 3 DB2 example Using a very simple DB2 command such as select from sysibm systables Chapter 4 Configuration and Implementation 69 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm In order to perform a commad as the one above you will be required to logon and connect to the DB2 database with the following command as in Figure 26 below userid and password greyed out connect to db2itso user db2admin once tj Command Center Iof x Results Edit Help Seba Script Results Access Plan Command entered connect to db2itso user db2admin 3 Command Center Enter current password fo
142. sion Support Storage Management Analysis Cognos PowerPlay and Seagate Crystal Reporting Tivoli Storage Manager Reporting Draft Document for Review March 10 2000 3 51 pm 6109ch01 fm allows little room for custom reporting and introduces a great deal of risk if attempted The product will continue to be attuned to the needs of Tivoli Storage Management reporting and will be modified as new versions of TSM are available 1 5 What kinds of problems can be solved using Storage Management Analysis A wide variety of reporting elements are included in the current release The current release has concentration in the Tivoli Storage Management event analysis and Tivoli Storage Management performance analysis The goal of the Tivoli Storage Manager Event and performance Category is to gain insight into the health of a Tivoli Storage Manager environment This includes information related to how well a Tivoli Storage Manager environment is operating and highlight areas needing improvement Reporting is performed for both Tivoli Storage Manager server and Tivoli Storage Manager client processing For Tivoli Storage Manager client processing the Tivoli Storage Manager client event logging function is required to forward messages to the Tivoli Storage Manager server Reporting is performed for both Tivoli Storage Manager server and Tivoli Storage Manager client processing In this section we will look at some typical instances of probl
143. spaces that are not being backed up or need to be backed up more frequently Drill down is provided to view specific clients in a category or all clients associated with a specific server The drill down levels for a server are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name Filespace associated with a specific client 148 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views How are client schedules affected by day of week TSM_cl004 ppr This view provides a daily summary of the results of Tivoli Storage Manager client sessions Use this information to identify scheduling problems A layer is provided to select information for a specific Tivoli Storage Manager server or a summary of all servers can be displayed This information applies to client sessions that use the Tivoli Storage Manager scheduler TSM_cl001 ppr TSM_cl002 ppr TSM_cl003 ppr TSM_cl005 ppr TSM_cl006 ppr TSM_clmsg007 ppr Appendix A Relate views for the table analysis 149 6109ax01 fm Draft Document
144. spikes in the performance and object failure Also error messages indicating severe and critical errors 5 1 2 Weekly reporting Use the following reports from theTivoli Discovery Interface for weekly reporting Tivoli Storage Management Event Analysis How might I improve my storage health e How are clients schedules affected by the day of the week e How current are client backups e What administrators and clients have been locked out of the system Trend in Client Operations e What is the average daily failed object count e What time of day do peak client data transfers occur Trends in Server Operations How does time affect server session activity e What is the daily failed object count for server operations What messages should I be concerned with e Summarize client messages by severity e What are the top 10 client messages with the most problems When do find the most problems e What day of week do peak client error rates occur e What day of week do peak server error rates occur e What time of day do peak clients error rates occur e What time of day do peak server error rates occur Tivoli Storage Management Performance Analysis How are my clients performing e How does Tcp Ip address affect throughput Chapter 5 Operational Procedures for Storage Management Analysis 93 6109ch05 fm Draft Document for Review April 18 2000 1 49 pm These reports should alert you to potential problems unusual growth which co
145. st connection to database Click Test Connection to the database connection Figure 47 Chapter 4 Configuration and Implementation 89 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm DB Message The connection test was successful Database product DB2 SUN 5 2 0 SOL authorization ID userid Database alias DB2_TEST Figure 48 Db2 message confirmation Click ox to exit the setup wizard and return to the Data Source Administrator If the data source test failed or you will get a message The connection test was successful Figure 48 You can repeat the DB2 ODBC setup procedure to adjust option settings From the Data Source Administrator you can setup more ODBC data source connections or exit the ODBC data source setup 90 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm Chapter 5 Operational Procedures for Storage Management Analysis In this chapter we review scheduling and routine operations of Tivoli Decision Support for Storage Management Analysis The problems that Tivoli Storage Management administrators face in making sure that the database has data reported to it on a daily bases loader issues and the care and feeding of the various Storage Management Analysis components are covered 5 1 Scheduling In this section we describe our recommendations on what Storage Management Analysis reports should be viewed and when The Tivoli Storage Manage
146. stall the Decision Support Loader on a dedicated workstation How often you run this program will have a impact on the amount of data transferred and the time of day may have an impact on data traffic Some Administrators may want to run on this on an hourly basis but more often it will be run on a daily basis See the discussion on Window of Opportunity in Chapter 5 Avoid running this program when other activity such as backups and archives may be accessing the Tivoli Storage Management database Also avoid running building cubes during tsmdsl execution Both of these activities can adversely affect performance 3 1 2 Network Configuration If you plan to report from multiple Tivoli Storage Management machines to a common RDBMS machine you probably want to install tsmds on multiple machines as well In this way you may do concurrent downloads of data from Tivoli Storage Management with a minimum of impact on a given tsmdsl processor However keep in mind the impact on the RDBMS server itself and the network paths to it Once you decide on a desired configuration you may want to consult your network specialist to discuss the configuration with them As the case is with other shared applications poor configuration planning or timing for the network can be a barrier to full acceptance and exploitation of Tivoli Decision Support for Storage Management Analysis 36 Tivoli Storage Manager Reporting Draft Document for Review April 18
147. stomers we re doing a good job 6 7 Comprehensive Tivoli Storage Management reporting Tivoli Decision Support for Storage Management Analysis has been written expressly for Tivoli Storage Management reporting Event and performance reporting can give us insight into the elements that determine the health and reliability of your system Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 129 6109ch06 fm Draft Document for Review April 18 2000 9 33 am There is no programming or development effort as reports are ready to run as soon as the product is installed and the data is loaded The product utilizes the already developed power of Tivoli Decision Support Cognos PowerPlay Seagate s Crystal Reporting an RDBMS and Storage Management Analysis all in one uniform execution Future releases of Storage Management Analysis are being developed to expand on the reporting in the area of capacity planning This will further extend the reporting capability of the product We expect this trend to continue and in fact we expect Storage Management Analysis to be ultimately in step with development of Tivoli Storage Management itself As new features are added so too will Storage Management Analysis reporting on those features will be added So if the question is want a comprehensive Out of the box solution to TSM reporting Is this it the answer is yes for the immediate and long term future
148. strator s Guide GC35 0380 Tivoli Storage Manager for Windows NT Version 3 7 Administrator s Reference GC35 0381 Tivoli Storage Manager Version 3 7 Messages GC35 0382 Tivoli Storage Manager for AS 400 Version 3 1 2 Quick Start GC35 0317 182 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 48 pm Book Title Tivoli Storage Manager for AS 400 Version 3 1 2 Administrator s Guide Tivoli Storage Manager for AS 400 Version 3 1 2 Administrator s Reference Tivoli Storage Manager for VM Version 3 1 Quick Start Tivoli Storage Manager for VM Version 3 1 Administrator s Guide Tivoli Storage Manager for VM Version 3 1 Administrator s Reference Tivoli Storage Manager for VM Version 3 1 Messages Tivoli Storage Manager for OS 2 Version 3 1 Quick Start Tivoli Storage Manager for OS 2 Version 3 1 Administrator s Guide Tivoli Storage Manager for OS 2 Version 3 1 Administrator s Reference Tivoli Storage Manager for OS 2 Version 3 1 Messages Tivoli Storage Manager Version 3 7 Using the Backup Archive Client for UNIX Tivoli Storage Manager Version 3 7 Using the Backup Archive Client for Windows Tivoli Storage Manager Version 3 7 Using the Backup Archive Client for NetWare Tivoli Storage Manager Version 3 7 Installing the Clients Tivoli Storage Manager Version 3 7 Using the Application Programming Interface Tivoli Storage Manager Version 3 7 AFS DFS Backup Clients Tivoli Storage Manager Version 3 7 Trace Facility Guide Ti
149. t is the average hourly throughput rate for server operations By Server Layer 2 of 2 Total Throughput KB s By Activity 4000 3500 3000 2500 2000 1500 1000 500 Figure 70 What is the average hourly throughput rate for server operations 6 5 2 Storage health In the Storage Management Analysis Guide under Tivoli Storage Management Event Analysis there is a section with five reports The report section is called How might I improve my storage health Refer to Figure 71 Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 125 6109ch06 fm Draft Document for Review April 18 2000 9 33 am El How might improve my storage health How are chent schedules affected by day of week ae vil How curent are client backups a Show me my server database backup record _ What administrators and chents have Deen locked out of the system ul When did clents last contact the server Figure 71 Reports available on storage health These are quite useful in exposing any problems with storage pools as well as creating an overall picture of how space is being used within Tivoli Storage Management Filespace reporting would be useful feedback to the clients to free storage resources Clients tend to forget that removing a filesystem from an incremental does not mean that the data already backed up to that filesystem is deleted Inactive filesystems reported back to clien
150. the Tivoli Storage Manager base backup server database record Use this view to determine if the server database is being backed up every day It is critical to always have a current database backup Report parameters are provided to specify Tivoli Storage Manager server name If this parameter is not specified information for all Tivoli Storage Manager servers is included Date for reporting information The date specified is related to when information was extracted from Tivoli Storage Manager Servers using the data collection program tsmdsl To determine a list of server names refer to the report TSM_cli003 This is under the topic What does my environment look like and is the view How many clients are registered with each server 146 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views What TSM_lock rpt This view provides a list of Tivoli TSM_msg rpt administrator Storage Manager administrators and s and clients clients that have been locked out of the have been system A node is locked from the locked out of system when too many invalid sign on the system attempts have been made The administrative command SET INVALIDPWLIMIT controls the number of invalid logon attempts allowed before a node is locked Use this view to identify potential invalid access attem
151. the structure of the data are optimized for rapid ad hoc information retrieval in any orientation as well as for fast flexible calculation and transformation of raw data based on formulaic relationships The OLAP Server may either physically stage the processed multi dimensional information to deliver consistent and rapid response times to end users or it may populate its data structures in real time from relational or other databases or offer a choice of both Given the current state of technology and the end user requirement for consistent and rapid response times staging the multi dimensional data in the OLAP Server is often the preferred method Thus the technology utilized by Tivoli Storage Manager and Storage Management Analysis and its associated components is OLAP and the OLAP Server to meet the requirement of a dynamic environment In the next chapter we will discuss all of the components necessary to create this reporting power 1 4 An out of box reporting solution Information needs to gathered and put to work quickly and effectively Tivoli Decision Support and Storage Management Analysis does this by supplying comprehensive pre coded reports available upon install There is no need for program or report development In fact Storage Management Analysis as a Tivoli Decision Support Guide is designed to not be a custom solution The complexity of a six product solution Tivoli Storage Management Tivoli Deci
152. this report you can tell which messages are prevalent which messages should be prioritized to work on first how often you re getting errors and what the Tivoli Storage Management message numbers are for further reference In the example we can see that we have received eight severity messages Three of them are message ANR2034E However since these messages relate only to QUERY commands these may not be as critical to correct as for example the UPDATE COPYGROUP message ANR1582E issued 03 13 2000 09 26 49 Failure of this command may mean data is not being retained with the proper Tivoli Storage Management criteria Other information is available upon generating this report including Hints as shown on the bottom tabs which tells you what the report data is comprised of and how you may want to use this data There is also a tab entitled Related Views which will reference other Storage Management Analysis reports which can give further insight and relevant data See the Tivoli Decision Support for Storage Management Analysis Users Guide for details concerning these and other features Running H F i 6109ch01 fm Hints Related Views Draft Document for Review March 10 2000 3 51 pm Summarize the messages issued in my environment Server Name tucson on pranres2 Severity DATE TIME 0343 2000 09 24 12 ERROR SERVER MESSAGES ANR2147E REGISTER NO
153. trators 15 Tivoli Storage Manager accounting file 15 TSM 16 189 61091X fm Draft Document for Review April 18 2000 1 50 pm 190 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 35 am 6109eva fm IBM Redbooks review Your feedback is valued by the Redbook authors In particular we are interested in situations where a Redbook made the difference in a task or problem you encountered Using one of the following methods please review the Redbook addressing value subject matter structure depth and quality as appropriate Use the online Contact us review redbook form found at http www redbooks ibm com e Fax this form to USA International Access Code 1 914 432 8264 Send your comments in an Internet note to redbook us ibm com Document Number Redbook Title SG24 6109 00 Tivoli Storage Manager Reporting Review What other subjects would you like to see IBM Redbooks address Please rate your overall O Very Good OGood O Average O Poor satisfaction Please identify yourself as O Customer O Business Partner O Solution Developer belonging to one of the following groups O IBM Lotus or Tivoli Employee O None of the above Your email address The data you provide here may be used to provide you with information from IBM or our business partners about our products services or activities O Please do not use the information collected he
154. ts might prompt them to actually delete the data Tape full or partially full When will it be available to migrate or to be able to restore some of the information can be derived This would help answer the what if change the reclamation percentage question but is not something we would need to ask very often More likely to ask this if you are constrained by ATL size and hence tape usage For example I need more scratch tapes can use reclamation to get some more How much data did copy the last four weeks to my copy pools How much storage was reclaimed this week How much data did copy the last four weeks to my copy pools Is my tape volume full or partially full and when will it be available to migrate 126 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm 6 6 System visibility The administrator who is interested in a proactive approach to problems may want to look at the report entitled What potential problems exist in my server environment It would be nice to be able to provide a statistics sheet which summarized a days weeks or months activity in terms of total incoming data tapes total outgoing restores throughput total stored data full etc This could be used as an indication of the overall use of the server One of the things we re trying to implement is Usage Based Charging Therefore a rolling say 30 day average of total occupanc
155. uld lead to problems or beginning trends 5 1 3 Weekend reporting The following reports from the Tivoli Discovery Interface are recommended for weekend reporting Tivoli Storage Management Event Analysis When do find the most problems e What day of week do peak client error rates occur e What day of week do peak server error rates occur Tivoli Storage Management Performance Analysis How are my servers performing e How much time is spent daily waiting for media access How does file size affect my performance How does file size affect client operation throughput How does time of day and day of week affect my performance e What is the average daily throughput for client operations e What is the average hourly throughput for client operations e What is the average hourly throughput take for server operations Weekend reporting is much like weekly in purpose Some organizations prefer to look at data as it corresponds to the calendar week You may find that this is appropriate If not run these along with the weekly reports 5 1 4 Monthly reporting The following from the Tivoli Discovery Interface are recommended for monthly reporting Tivoli Storage Management Event Analysis Trend in Client Operations e Summarize client messages issued by platform 94 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch05 fm e Summarize client messages issued by software level e What ti
156. ully completed Figure 7 TSMDSL log extract showing multiple ODBC s and TSM servers Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm 4 1 4 Multiple data source configurations Multiple data sources in this case is having more than one Tivoli Storage Management servers reporting to a common RDBMS The configuration for this is in the setup of the Tivoli Storage Management Decision Support loader and the setup of the Tivoli Storage Management ODBC driver In order for another data source to function you have to register it in the ODBC setup as another Tivoli Storage Management server as in Figure 8 below This is for communications to the server that will be pulling the data to the RDBMS ODBC Data Source Administrator UserDSN System DSN File DSN Drivers Tracing Connection Pooling About System Data Sources Add Name Driver o local on pranres4 SQL Server Remove MOIS SOL Server neptune on pranres2 TSM ODBC Driver Configure AA AlE TSM ODBC Driver pranres4 on pranres 2 TSM ODBC Driver sql on pranres4 SOL Server tucson on pranres2 TSM ODBC Driver the indicated data provider A System data source is visible to all users An ODBC System data source stores information about how to connect to on this machine including NT services Cancel Apply Help Figure 8 TSM ODBC driver communications setup After setting up the ODBC drive
157. ument for Review April 18 2000 9 33 am How much time is spent daily waiting for media access Period Rolling 7 Days Measure Tofa Media Wait Tine pm Row By Operation Column Tuesday Layer By Server By Server Layer 2 of 2 Total Media Wait Time m By Operation By Weekday Name STGPOOL BACKUP MIGRATION Wednesday FULL_DBBACKUP EXPIRATION Tuesday Figure 56 How much time is spent daily waiting for media access We can see on the above report that there may be an unusual amount of time spent waiting for tape access during migration activity Controlling when migrations happen can be key to keeping client schedules moving efficiently Closely related to this topic because it can effect the performance of client schedules is the next topic on networking 110 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm 6 2 Looking at Tivoli Storage Management network traffic Tivoli Storage Management implemented into the enterprise can help identify problems with your network because it is highly reliant on network connections to accomplish its tasks Implemented across a network it usually reaches many paths which can be diagnosed from a single Tivoli Storage Management server source If some paths to the server perform meet expectations and others do not a comparison of divergent paths can usually identify problem components By working with your network technicians in this ar
158. ummarize the messages issued in my environment Summarize the messages issued in my environment Tucson on pranresd DIAGNOSTIC 9993 9393 393 393 393 9393 393 Ese 9393 9399 9393 9393 393 9893 9393 9393 9393 393 393 NSGNO SERVER MESSAGES ANRSGSSD aamsqlc 1952 S0L Rh hoop canceled ANRSGSOD serons 02212 hualdmaghe vimber bud h tame header ANRSGSOD sero 02219 Wrong seqmentgroup Kd found h tame header ANRSSISD ss recons 6 2225 Wrong sequence rumber trad h tame header ANRIA ssrecons C2731 Achal Magka TCD ttt Suke s05495171 29G opk 3257 SDS D2 Seq Nime ETE ANRSSEAD ss econs 0223 Epected Mag 53154552 SUHD Seg ropke 2190855 Seqnim 2 ANR serons 2212 hualdmagke mter bnd h tame header ANRSGEID ss recons CRAJ Wrong segmeitgrop id brd h tame kadr ANR9G390 ss recons 0 2225 Wrong sequence Lumber brnd h tame header ANRSSSD ssrecons C2731 Achal Mag lo O2F FF FCO Suk 18530 Seg rope 64517 HT 1675160 Sq Nime 117 H0510 ANRQS290 sE toons ORZI Expected Mag lo 53454652 SUD S2gG ronpi 21897692 Seqnim 1 ANRSGRID ss recons 2212 hualldmagke wumber bnd ih tame header ANRSBSID ss eoo 02219 rong seqmentgroup Kd found h tame header ANRSQ9D se recors 672225 Wrong sequence Lumber turd h tame beader ANRSEOD se RONE COZ Actal Magh D5TBA35E Smukl 61 1615499 SJG opi DOEY Y Seq ume SISS ANRSSOD se toons ORZI Bpectd Mag ke S3i5t652 SUHD HJG Oph 2180715 Nim 1
159. urce Administrator you can setup more ODBC data source connections or exit the ODBC data source setup Chapter 4 Configuration and Implementation 81 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Install of IBM DB2 From the create new Data Source dialog box select IBM DB2 ODBC Driver Figure 38 Create New Data Source Select a driver for which you want ta set up a data source 32bit ADSM ODBC Driver 3 07 00 00 IBM DB2 ODBC DRIVER Not marked Ne Microsoft Access Driver mdb 4 00 3711 08 Mir Microsoft dB ase Driver dbf 400 3711 08 Mir Microsoft Excel Driver xIs 400 3711 08 Mir Microsoft FoxPro Driver dbf 4 00 3711 08 Mir Microsoft ODBC for Oracle 2 573 3711 00 Mir Microsoft Paradox Driver db 4 00 3711 08 Mi Microsoft Text Driver txt csv 4 00 3711 08 Mi Microsoft Visual FaxPro Driver Ann a47A nn E lt Back Cancel Figure 38 Creating a DB2 data source using the ODBC drver click Finish to open the ODBC IBM DB2 Driver Add dialog box Figure 39 note during your initial DB2 product installation you may already set up and ODBC data source connection The following steps apply for a new database configuration 82 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm 6109ch04 fm ODBC IBM DBZ Driver Add IND _T Sah Figure 39 ODBC IBM DB2 driver Click Add Database to set up a new database as and ODBC data source The
160. ut Drill down is provided for each TSM server The drill down levels are as follows e Tivoli Storage Manager server e Policy domains defined to specific Tivoli Storage Manager server A domain name is identified by appending the string DN to the domain name e Clients associated with specific policy domains A client is identified by appending the string CN to the client name e Sessions associated with the selected client TSM_cl010 ppr TSM_cl011 ppr TSM_cl012 ppr TSM_clb005 ppr TSM_cl014 ppr Which are my 10 slowest clients TSM_cl018 ppr This view provides a list of the ten Tivoli Storage Manager clients that have the lowest aggregate throughput KB s over the last 7 days Use this view to identify clients that have potential performance problems A layer is provided to select a specific server or an aggregate of all servers can be displayed TSM_cl010 ppr TSM_cl011 ppr TSM_cl012 ppr TSM_clb005 ppr TSM_cl014 ppr 162 Tivoli Storage Manager Reporting Draft Document for Review April 17 2000 11 38 pm 6109ax01 fm View Title Filename View Description Hint Text Related Views Which clients have the longest elapsed processing times TSM_cl011 ppr This view provides the elapsed time Tivoli Storage Manager clients have spent performing client operations over the last 7 days A ranked list is presented Use this view to determine which
161. ver 4 2 8 2 Removing programs via Control Panel This is done by selecting start gt Settings gt Control Panel gt Add Remov Programs icon and on the first tab Install Uninstall You will be required to scroll down using the scroll bar to the applications that you want to uninstall This can be referred to as in the Figure 19 on page 60 and Figure 20 on page 61 Note that there are more applications that can be removed Chapter 4 Configuration and Implementation 59 6109ch04 fm Draft Document for Review April 18 2000 1 49 pm Add Remove Programs Properties We Cognos PowerPlay 6 5 for Windows Cognos PowerPlay 6 5 Personal Server Diskeeper Lite IBM Personal Communications ITSO FrameMaker Toolkit LiveUpdate Lotus Notes Lotus SmartSuite Release 9 Microsoft Activex Control Pad Figure 19 Applications can be removed via Control Panel 60 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 1 49 pm The following applications can be removed via the control Panel Add Remove Programs Properties Install Uninstall windows NT Setup e To install a new program from a floppy disk or CD ROM perd drive click Install Install ZA The following software can be automatically removed by Windows To remove a program or to modify its installed components select it from the list and click Add Remove Microsoft SOL Server 7 0 Microsoft Windows Media Player 6 4 Netscape Communicato
162. ver host name or IP address 0 00 000 c eee eee eee 85 43 Target database name cece eee 86 44 Alias database name 0 cee eee 87 45 Microsoft Visual Basic application 0 000 eee eee 88 46 User id and password for Database connection 89 47 Test connection to database 0 eee 89 48 Db2 message confirmation 0 00 cece ee 90 49 CPU utilization 100 while TSMDSL is running 97 50 Related views in the lower box windows from the Tivoli Discover Interface 102 51 Related views shown from Tivoli Discovery Interface 103 52 Reports from the Storage Management Analysis Guide 104 53 More reports from the Storage Management Analysis guide continued 105 54 What is the status of scheduled client sessions 108 55 Client media waitS 0 0 0 0 teens 109 56 How much time is spent daily waiting for media access 110 57 Reports that are helpful in identifying network problems 114 58 TCP IP address and throughput 0 00 eee eee eee 112 59 Examining filesize as related to performance 05 113 60 Some Storage Management Analysis reports on errors 114 61 Top 10 server MessageS 20 eee 115 62 How current are client backupS 0 000 e eee eee 116 63 Identifying when clients last contacted the TSM server
163. voli Decision Support After that you are ready to look at the remaining issues Once the network or stand alone decision made for Tivoli Decision Support Tivoli Storage Management database size network configuration and reporting database size may be the major determinates in deciding how many machines should be configured Chapter 3 Tivoli Decision Support for Storage Management Analysis Architectural Issues 35 6109ch03 fm Draft Document for Review April 18 2000 1 48 pm We recommend that you install the Decision Support Loader tsmdsl on a dedicated workstation Running the decision Support Loader and the Storage Management Analysis product on the same processor can adversely impact performance It is evident the number of machines to configure and what to install on them is largely dependent on use network configuration and data volume 3 1 1 Access frequency and the network Consider the approximate number of reports a given user of the system is likely to build or download from the file server or reporting database Each report varies in the amount of data depending on the content and the volume of elements included Nevertheless response will be poor if data traffic or bandwidth precludes rapid transfer You may want to run some initial benchmarks to see exactly what impact your particular reporting needs have on your network Consider also the impact of tsmdsl executions on the network Again we recommend that you in
164. voli Storage Manager Version 3 7 Reference Cards for the Backup Archive Clients Tivoli Data Protection for Informix V3R7 Installation and User s Guide Tivoli Data Protection for Lotus Domino for UNIX V1R1 Installation and User s Guide 6109bibl fm Publication Number GC35 0315 GC35 0316 GC35 0351 GC35 0352 GC35 0353 GC35 0271 GC35 0231 GC35 0232 GC35 0233 SH35 0133 SH26 4105 SH26 4101 SH26 4100 SH26 4102 SH26 4107 SH26 4106 SH26 4104 SX26 6021 SH26 4095 SH26 4088 Tivoli Data Protection for Lotus Domino for Windows NT V1R1 Installation and User s GuideGC26 7320 Tivoli Data Protection for Lotus Notes on Windows NT Installation and User s Guide Tivoli Data Protection for Lotus Notes on AIX Installation and User s Guide Tivoli Data Protection for Microsoft Exchange Server Installation and User s Guide Tivoli Data Protection for Microsoft SQL Server Installation and User s Guide Tivoli Data Protection for Oracle Backup on AIX Installation and User s Guide Tivoli Data Protection for Oracle Backup on Sun Solaris Installation and User s Guide Tivoli Data Protection for Oracle Backup on HP UX Installation and User s Guide Tivoli Data Protection for Oracle Backup on Windows NT Installation and User s Guide SH26 4065 SH26 4067 SH26 4071 SH26 4069 SH26 4061 SH26 4063 SH26 4073 SH26 4086 Appendix D Related publications 183 6109bibl fm Draft Document for Review April 18 2000 1 48 pm 184 Tivoli
165. w my boss we re doing a good job with the resources have How can do that want a comprehensive Out of the box solution to Tivoli Storage Management reporting Is this it Future Storage Management Analysis Guide releases will address other questions particularly in the area of Tivoli Storage Management capacity planning Some of the additional questions which will benefit from reporting currently planned for the next release How much client data do we protect over the entire enterprise Can know how much active and inactive data is in my storage pools How much of the data is being kept onsite and offsite What does collocation cost me in terms of volumes Can track and predict storage growth by tape slots and by MB by client Can predict what an increased client load would do to the system An example selected from the above lists of answering questions via Storage Management Analysis reporting follows To answer the question What errors am getting most and which ones should work on correcting first we can invoke the Tivoli Discovery Tivoli Storage Manager Reporting Draft Document for Review March 10 2000 3 51 pm 6109ch01 fm Interface An appropriate chart to reference in the Storage Management Analysis Guide is entitled Summarize the messages issued in my environment as shown in the Figure on page 20 This report draws a composite picture of error messages by severity By looking at
166. y for each node would be useful Since we can work out the cost of delivering the TSM server and what based on tapes and average capacity the total capacity of the server is we can calculate a cost per GB per month How will know when I need to upgrade system components Chapter 6 Tivoli Decision Support for Storage Management Analysis Reporting 127 6109ch06 fm Draft Document for Review April 18 2000 9 33 am How does piatform affect client throughput rates Period Rolling 7 Days Measure Tofa Throughout KSis Row Sy Platfform Column Tucson on pranres4 Layer lt Nore gt Total Throughput KB s By Platform WinNT By Server Tucson on pranres4 Figure 72 How does platform affect client throughput rates 128 Tivoli Storage Manager Reporting Draft Document for Review April 18 2000 9 33 am 6109ch06 fm Summarize client messages issued by software level Period Rolling 7 Days Measure Number of Client Messages Row By Server Column VER 3 4 0 6 Layer sNone gt Number of Client Messages By Server 320 280 240 200 160 120 VER 3 7 0 0 VER 3 1 0 1 VER 3 7 1 0 Figure 73 Summary of client messages by TSM software level Can report on event processing in a form which will mean something to my boss want to show my boss we re doing a good job with the resources have How can do that want to show my boss we re doing a good job Absolutely also want to show cu

Tivoli Storage Manager Reporting - e

Contents

Download Pdf Manuals

Related Search

Related Contents