Product documentation

Abstract

This document assists customers who want to use the Tivoli® Storage Manager V5.5 Operational Reporting feature with Tivoli Storage Manager V6 and V7 servers, before making the transition to the reporting and monitoring feature that was introduced in V6. The instructions for configuring V5.5 Operational Reporting to work with V6 and V7 servers are provided as is, and no additional support will be provided by IBM. See the full document for restrictions and instructions.

Also introduced with Tivoli Storage Manager V6 is the change from a proprietary Tivoli Storage Manager database to a DB2® database. Because the DB2 program is the database manager, Tivoli Storage Manager V6 introduces fundamental changes to the database and recovery log architecture. The Tivoli Storage Manager database schema and the SELECT syntax also changed, both of which are used by Tivoli Storage Manager Operational Reporting. For information about the V6 changes, see Server database updates overview and Changes to the SELECT command.

Tivoli Storage Manager V5.5 Operational Reporting is part of the Tivoli Storage Manager Management Console for V5.5 servers, which runs only on Windows® systems. V5.5 Operational Reporting is not supported and not included with Tivoli Storage Manager V6. If a Tivoli Storage Manager V5.5 server on a Windows system is upgraded to Tivoli Storage Manager V6, the Tivoli Storage Manager V6 Management Console is installed without the Operational Reporting feature.

Without modification, the V5.5 Operational Reporting feature does not work with V6 or V7 servers. The default Custom Summary report sections in reports and monitors fail for a Tivoli Storage Manager V6 server, typically with error messages that cite syntax errors or references to columns that do not exist in the V6 server database. Customized reports might also fail.

Preparation

To modify Tivoli Storage Manager V5.5 Operational Reporting to work with a Tivoli Storage Manager V6 or V7 server, the Tivoli Storage Manager V5.5 Management Console, which includes Operational Reporting, must be installed on a separate physical or virtual Windows device.

Important: After you make the changes that are described in this document, the reports and monitors that you modify will not work with a V5 server.

If you do not already have the Tivoli Storage Manager V5.5 Management Console installed on a separate physical or virtual Windows device, download the program and install it.

The PCT_UTILIZED variable has no direct equivalent in Tivoli Storage Manager V6 or V7 servers. To monitor the usage of database space, the ratio of FREE_SPACE_MB to TOT_FILE_SYSTEM_MB can be used to give similar results. The suggested select statement gives the percent utilized of the space available to the database.

To be automatically warned when the space available to the database is nearly full, activate a notification rule to receive a message if this value reaches a high percentage, for example 85%.

CACHE_PCT (Database Cache Hit Ratio)

Original select statement:

select CACHE_HIT_PCT as CACHE_PCT from DB

Modified select statement:

select BUFF_HIT_RATIO as CACHE_PCT from DB

MAX_PCT_UTILIZED (% Maximum Recovery Log Utilization)

Original select statement:

select max_pct_utilized from log

You can either delete this Select Variable, or change it to report on the file system where the active log is located. A suggested modified select statement:

The suggested select statement reports the percent utilized of the file system where the active log resides. The number is important because problems occur if the file system where the active log resides fills up.

RESET_BUFFPOOL

Original select statement:

reset bufpool

Delete this Select Variable. Tivoli Storage Manager servers at V6.1 and later do not reset the buffer pool.

TMS (Number of tape mounts)

Original select statement:

select count(*) as TMS from summary
where activity='TAPE MOUNT' and cast((current_timestamp-start_time)hours
as decimal)<%s

Modified select statement:

select count(*) as TMS from summary where activity='TAPE MOUNT'
and TIMESTAMPDIFF (8,CHAR(current_timestamp-start_time ))<%s

MTM (Total number of minutes tape were mounted)

Original select statement:

select (sum(end_time-start_time))minutes as MTM from summary
where activity='TAPE MOUNT' and
cast((current_timestamp-start_time)hours as decimal)<%s

The PCT_UTILIZED variable has no direct equivalent in Tivoli Storage Manager V6 servers. To monitor the usage of database space, the ratio of FREE_SPACE_MB to TOT_FILE_SYSTEM_MB can be used to give similar results. The suggested select statement gives the percent utilized of the space available to the database.

MAX_PCT_UTILIZED (% Maximum Recovery Log Utilization)

Original select statement:

select max_pct_utilized from log

You can either delete this Select Variable, or change it to report on the file system where the active log is located. A suggested modified select statement:

The suggested select statement reports the percent utilized of the file system where the active log resides. The number is important because problems occur if the file system where the active log resides fills up.

Modifying custom reports

If custom reports have been created in the Operational Reporting feature, verify that the syntax of custom select statements is correct for V6 or V7 servers. Review the information in the following document to learn about the changes that were made to the Tivoli Storage Manager server SELECT command between V5.5 and V6: Changes to the SELECT command.