TSM console v5.5 for Windows (only) can be adapted for TSM server v6
http://www-01.ibm.com/support/docview.wss?uid=swg27019794
Preparation To modify Tivoli Storage Manager V5.5 Operational Reporting to work with a Tivoli Storage Manager V6 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. Go to the FTP site for V5.5 downloads for Windows systems: ftp://public.dhe.ibm.com/storage/tivoli-storage-management/maintenance/server/v5r5/WIN/LATEST Download the file for the Tivoli Storage Manager V5.5 Management Console, which has a name like 5.5.x.x-TIV-TSMCON-Windows.exe, where the x.x are numbers that indicate the fix level. Run the file that you downloaded to install the Tivoli Storage Manager V5.5 Management Console. Configure Tivoli Storage Manager V5.5 Operational Reporting according to the instructions at this link: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/com.ibm.itsmcw.doc/anrwgd55668.htm Back up the default XML template files for reports and monitors:
C:\Program Files\Tivoli\TSM\console\default_rep_eng.xml C:\Program Files\Tivoli\TSM\console\default_mon_eng.xml
Create a report XML template file to use for modification of reports by copying this file:
C:\Program Files\Tivoli\TSM\console\default_rep_eng.xml
Rename the copy of the file:
C:\Program Files\Tivoli\TSM\console\default_rep_eng_TSM6.xml
Create a monitor XML template file to use for modification of monitors by copying this file:
C:\Program Files\Tivoli\TSM\console\default_mon_eng.xml
Rename the copy of the file:
C:\Program Files\Tivoli\TSM\console\default_mon_eng_TSM6.xml
Back to top Modifying reports
When first installed, Tivoli Storage Manager Operational Reporting contains a model template for a Daily Report. You must modify the Custom Summary report section of this Daily Report.
Start the Tivoli Storage Manager 5.5 Management Console: Start > All Programs > Tivoli Storage Manager > Management Console Click Operational Reports and create a new report or update the properties of an existing report. On the Report Details tab, select Custom Summary and click Settings. Click Browse and select the report template file that you created in a previous step: C:\Program Files\Tivoli\TSM\console\default_rep_eng_TSM6.xml Edit each of the following Select Variables, and modify the select statements.
LDBB (Last Database Backup) Original select statement:
select substr(char(last_backup_date), 1, 16) as LDBB from db where cast((current_timestamp-last_backup_date)hours as decimal)<%s
Modified select statement:
select substr(char(last_backup_date), 1, 16) as LDBB from db where TIMESTAMPDIFF (8,CHAR(current_timestamp-last_backup_date ))<%s
PCTUTILIZED (%Database Utilization) Original select statement:
select pct_utilized from db
Suggested modified select statement:
select sum(100-(free_space_mb*100) / tot_file_system_mb) as PCT_UTILIZED from db
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.
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:
select cast(sum(used_space_mb *100 / total_space_MB) as decimal(3,1)) as MAX_PCT_UTILIZED from log
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
Modified select statement:
select (sum(TIMESTAMPDIFF(4,end_time-start_time))) as MTM from summary where activity='TAPE MOUNT' and TIMESTAMPDIFF (8,CHAR(current_timestamp-start_time )) <%s
Click OK, then click Yes to save the changes.
Back to top Modifying monitors
When first installed, Tivoli Storage Manager Operational Reporting contains a model template for an Hourly Monitor. You must modify the Custom Summary report section of the Hourly Monitor.
Start the Tivoli Storage Manager V5.5 Management Console: Start > All Programs > Tivoli Storage Manager > Management Console Click Operational Monitors and create a new Hourly Monitor, or update the properties of an existing monitor. On the Monitor Details tab, select Custom Summary, then click Settings. Click Browse and select the monitor template file that you created in a previous step: C:\Program Files\Tivoli\TSM\console\default_mon_eng_TSM6.xml Edit the following Select Variables, and modify the select statements.
PCTUTILIZED (%Database Utilization) Original select statement:
select pct_utilized from db
Suggested modified select statement:
select sum(100-(free_space_mb*100) / tot_file_system_mb) as PCT_UTILIZED from db
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:
select cast(sum(used_space_mb *100 / total_space_MB) as decimal(3,1)) as MAX_PCT_UTILIZED from log
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.
Click OK, then click Yes to save the changes.