Do you know how your TSM environment is evolving?

2

2

Do you know how your TSM environment is evolving?

Healthy?

_{Well integrated?}

Data Growth?

Historical Reporting and Business Intelligence are

needed to be prepared for future challenges

Recognize and quanitfy data growth

Support financial investmens in additional or new hardware
Avoid operational problems by timely adjustments

4

4

Tivoli Decision Support (TDS)

1. Allows users to make business decisions based on historical data

2. Unlocks hidden IT data

3. Consolidates and transforms enterprise management data into text and

graphical formats

4. Turns raw statistics into useful business information

6

6

Tivoli Data Warehouse

Follow-on product to Tivoli Decision Support.
Builds a “Central Data Warehouse” (DB)

containing data from entire IT infrastructure. (including TSM environment).

A subset of the CDW (or Data Mart as it is

called) can be then used to analyze IT costs, infrastructure, performance and do historical trending.

Vendors can write their own packages to

interface with TDW for their software

applications, or customers can also develop their own). These are referred to as

Enablement Packages.

Tivoli has developed V1 of its WEP for TSM.
TDW contains several software components

8

8

Operational Reporting Collaboration Model

Managers TSM Admins TSM Server TSM Server Node Owners App Owners

Help Desk Tape Operators

TEC Web

Commercial tools

Commercial tools offer out of the box

solutions

Sometimes mixture between admin and

reporting tool

Limited report customization

Integration into enterprise BI strategy

questionable

10

10

Open Source Business Intelligence tools

Cacti (monitoring tool with reporting capabilities)

Pentaho

Jaspersoft

OpenI

BIRT

Cacti serves between monitoring and reporting

“Cacti is a complete frontend to RRDTool, it stores all of

the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG.”

Cacti uses
MySQL

PHP

12

12

Principles of Operation for Cacti

Data Retrival by utilizing scheduled poller run

Data Storage by utilizing RRDTool

Example Output for Diskpool Utilization

Nightly backups fill

14

14

Example Output for Drive Utilization

How to get from a script to a Cacti graph

The minimal steps to create a graph from a script are simply:

1. Create a Data Input Method to tell Cacti how to call the script and

what to expect from it.

2. Create a Data Template to tell cacti how and where the data will

be stored.

3. Create a Graph Template to tell cacti how the data will be

presented in graph form.

4. Associate Template with device

16

16

Cacti Links

Home of Cacti http://www.cacti.net

Home of CactiEZ http://www.cactiusers.org

18

18

What‘s BIRT?

BIRT Project = Business Intelligence and Report Tools Project
Open source initiative as part of the Eclipse Foundation

Project launched in October, 2004
Goals:

Next generation reporting technology
Eclipse-based Report Designer

Web-centric design metaphor
Open Source with rapid adoption
Standards based & highly extensible
Open XML design format

High Level BIRT Architecture

Report Designer

Report Design Engine

20 6-May-09

BIRT Views

Navigator

Navigates through Eclipse projects and files under those projects

Allows user to run report inside of BIRTOutline
Provides hierarchy of current report

Allows for easy navigation of report elements to change properties in the property pane

When selecting libraries, use the outline to copy non-visual components such as data sources and sets

Palette

Contains a number of visual elements used in BIRT report designs

Similar to Toolboxes in MS Visual Studio and other visual IDE

Data Explorer

22 6-May-09

BIRT Report Designer

Area where report layout is

designed, previews of the report are seen, scripts and events are coded, and XML source for report can be viewed.

Properties for BIRT

objects can be modified, such as Data Set

Binding, Font

information, formatting for Data Set returns such as Row

24

24

Some preparations

Database needed to store

TSM data points

Extract mechanism to

regularly extract data

Here we „mirrored“ the TSM

BIRT Links

Home of BIRT Project http://www.eclipse.org/birt
BIRT World http://birtworld.blogspot.com/

26

26

Meanwhile...

TSM Real-Time Monitoring and Reporting

Integrated, common-reporting engine that integrates to IBM Tivoli

Monitoring (ITM) and Tivoli Data Warehouse (TDW)

Uses an agent to communicate with the TSM server and extract

data from the TSM database and return this data to the ITM server to be stored in the TDW database

ITM will act as a monitoring application while the Tivoli Common

Reporting (TCR) portion of ITM will report on the retrieved data

TCR uses the Eclipse/BIRT (open-source) engine to report on the

28

Tivoli solution – Tivoli Common Reporting (TCR)

Comes from Tivoli

Monitoring (ITM)

Shared across Tivoli

Portfolio

Web Server based
Agents needed
Leverages BIRT

FAQ’s

How does a user see Reporting and Monitoring?
-Reporting GUI is the TSM Admin Center

-Monitoring GUI is TEP

Can Monitoring be installed without Reporting?
-Yes

Can Reporting be installed without Monitoring?
-No

Is it supported and downloadable for TSM 5.x Servers ?
-Yes

Can it be installed on the TSM Server ?

-For TSM 5.x: Yes, but not recommended, due to resource consumption

-For TSM 6.1: No, not supported, due to conflicting DB2 Versions

-We recommend to install the standard TSM Admin Center and Reporting/Monitoring on the

same server to manage multiple mixed TSM Servers

FAQ’s

30

Do I need extra licenses?
-No, it is part of TSM Base/EE

Do I need to write my own Monitors or Reports?

-No, we deliver pre-configured Monitors and pre-defined Reports
Can I write my own reports?

-Yes, they can be developed with BIRT using Eclipse 3.3.1.1
Can customers write their own reports?

-Yes, but we recommend a service engagement, since BIRT is not trivial
Can customers customize their own Monitors?

-Yes, it’s very easy in TEP

Does it plug-into an existing ITM installation?

-Yes, you can see TSM Monitoring as well as all other ITM Monitors (licensing required)

Does it plug into an existing TSM Admin Center Installation?

-Yes, we recommend to use one server for managing/reporting/monitoring TSM. It plugs into TSM 6.1 Admin Center only.

Can I monitor and report on multiple TSM Servers?

-Yes, you can even monitor and report on different TSM versions

TSM Real-Time Monitoring and Reporting

ITM workspaces are presented on

the Tivoli Enterprise Portal foundation. A number of

workspaces are delivered with the TSM reporting solution. These workspaces are easily selected from a list of workspaces in the

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

To start TCR, the user

will point their browser to a URL in the same way as the user points to the Admin Center URL. ISC will request a userid and password to access the TCR product.

The user will be

presented, after login, a list of reports available to them in the ISC

navigation tree. They will select each report which will then be

displayed to them in the ISC console.

TSM Real-Time Monitoring and Reporting

Reports can be

TSM Real-Time Monitoring and Reporting

Each report presents a

parameter input window. Parameters are specific to the individual report.

Click “Run” to generate

the report

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

TSM Real-Time Monitoring and Reporting

To create your own custom reports using BIRT and Tivoli Common

Reporting from your data that is stored in Tivoli Data Warehouse, complete the following steps:

Download and install BIRT, version 2.2.1, All-In-One software using one of

the following Web sites:

Go to the following IBM Tivoli Open Process Automation Library

(OPAL) Web site for the BIRT software that you need to download and install:

http://www.ibm.com/software/brandcatalog/portal/opal/details?catalog.l abel=1TW10OT02

52

Disclaimer

No part of this document may be reproduced or transmitted in any form without written permission from IBM Corporation.

Product data has been reviewed for accuracy as of the date of initial publication. Product data is subject to change without notice. This information could include technical inaccuracies or typographical errors. IBM may make improvements and/or changes in the product(s) and/or program(s) at any time without notice. Any statements regarding IBM's future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only.

The performance data contained herein was obtained in a controlled, isolated environment. Actual results that may be obtained in other operating environments may vary significantly. While IBM has reviewed each item for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtained elsewhere. Customer experiences described herein are based upon information and opinions provided by the customer. The same results may not be obtained by every user.

Reference in this document to IBM products, programs, or services does not imply that IBM intends to make such products, programs or services available in all countries in which IBM operates or does business. Any reference to an IBM Program Product in this

document is not intended to state or imply that only that program product may be used. Any functionally equivalent program, that does not infringe IBM's intellectual property rights, may be used instead. It is the user's responsibility to evaluate and verify the operation on any non-IBM product, program or service.

THE INFORMATION PROVIDED IN THIS DOCUMENT IS DISTRIBUTED "AS IS" WITHOUT ANY WARRANTY, EITHER EXPRESS OR IMPLIED. IBM EXPRESSLY DISCLAIMS ANY WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR INFRINGEMENT. IBM shall have no responsibility to update this information. IBM products are warranted according to the terms and conditions of the agreements (e.g. IBM Customer Agreement, Statement of Limited Warranty, International Program License