User Tools

Site Tools


tsm:tsmconsole

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.
tsm/tsmconsole.txt · Last modified: 2021/01/01 21:25 (external edit)