This document provides an explanation of each slide within the IBM TSM PowerPoint project output.
Once the project is uploaded to the Live Optics portal, download the PowerPoint by clicking the Download PPT button while viewing a completed project.
NOTE: This release is associated with a new version of Live Optics Collector and associated IBM Spectrum Protect (TSM) assessment scripts, which create a new Node tab in the XLSX. It is strongly recommended that you download the latest Collector prior to running an assessment: Download the Live Optics Collector
Title Slide (Slide 1)
Among other standard Live Optics info, this slide contains the version of IBM Spectrum Protect under assessment.
Summary Slide (Slide 2)
This Summary slide conveys an overall picture of the backup environment. TSM specific categories/terminology are used and each category is calculated as follows:
- Step 1
- Referencing the FileSpace tab, (for each row in Column E [Capacity] multiply by the adjacent cell in Column F [Pct_Util]) (which is a %, so convert to decimal first) then sum all results.
- Calculation: Col E * Col F (%) = Result
- Example: 214936.99 * 56.03% = 120429.1955
- Step 2
- Add the following to the total from step 1:
- For each Node_name (Column A) which has a Filespace_type (Column D) starting with API:, look up that Node_name in the Summary tab's Column E (Entity). There will be dupes, you want to take the largest backup Bytes (Column L) from each grouping. (Please note that Column E is in MB and needs to be converted)
- Number of Nodes: From the (new for this release) Node tab
- Number of Files: Sum of Column E, Occupancy tab. Please note that this is inclusive of offsite (Copypool) and is derived from Column E in Occupancy Tab (Copypool is Offsite, Tapepool is Onsite) - Please note that the number of Jobs can be deduced from (Number of Rows in Summary tab - 1)
- Add the following to the total from step 1:
Environmental Topology Slide (Slide 3)
This slide provides an overall picture of how OS’s are distributed in the environment and breakdown by the capacity of specific TSM Domains (limited to 28 entries)
The "Capacity per Domain Name" table shows the distribution of capacity across the environment. This is based on the Domain Names and is presented in GB's, not percentages in descending order (capping at 14 table rows on the slide). Leveraging information from the Nodes tab, we find the total capacity for each Domain Name (which is in the Occupancy tab listed by Node_Name).
Here is how this is calculated:
- We group all the nodes together by “Domain_Name” (there can be, and usually are, multiple Node_Names in each domain name).
- We look the Node_Names up in the Occupancy tab and sum up Column H [Reporting_Mb] and convert to GB. That sum is what is listed in the table for each Domain_Name.
OS Distribution Chart:
Similar process as above, however, we are looking, to sum up, capacity based on OS types, where capacity is taken from Column H [Reporting_Mb] in the Occupancy tab. From the Nodes tab, we group based on Column C (Platform_Name) which reflects the OS for the nodes. Grouping is done by flavors of Unix, Windows, and Other (for example DB2 might be listed with no OS, or it's blank). Architectures are not delineated (i.e., 64-bit or other), this information will show in the table on the right or you can look this up in the XLSX for this project. The bars reflect total capacity (converted from MB to GB).
It is important to note, if this slide is blank, it's likely that Node information is missing. There is a tab in the XLSX called “Node” which is populated via a new select statement in the assessment script. Please check the XLSX for this project and if the Node tab is missing then please ensure you are running the latest version of the TSM Live Optics script. If you are unsure, or you are already running the latest version, please speak to Live Optics Support by Creating A Ticket. You must be logged in to send a ticket to Support.
Backup Overview Slide (Slide 4)
The goal of this slide is to present an overview of backups that may be of interest.
The chart (to the left) presents an overall picture of backup time frames, to help show the number of jobs running 8+ hours (which may be of interest to the backup admin). To determine this, we reference the Summary Tab and calculate Column B - Column A (time delta), given Column C (Activity) is set to BACKUP only. All types of backups are considered for this chart.
The table (on the right of the slide) lists (in descending order) the Top 10 largest Entity backups. With Column C (Activity) set to BACKUP only, we take the largest backup in Column L [Bytes] for each unique Entity name and convert it to GB.
Please note, A common issue in discussions with TSM backup admins is about them backing up their TSM server (i.e., they added a client to the TSM server because they want to back up their system hosting TSM). In some environments, this can be the largest backup and isn't a Best Practice. Refer to the project's XLSX and check the Summary Tab, Column C (Activity) for DBBackup, which is the TSM catalog.
Top 5 Domain-Class Retention (Slide 5)
This slide depicts the Top 5 Domain-Class pairings with regards to retention, with preference given to VerExists. This is determined by filtering Set_Name on Active only and sorting the VerExists, VerDeleted, RetExtra, and RetOnly columns (Columns E thru H) in the Bu_Copygroup tab in the XLSX for this project.
The Y-axis is the [Domain Name-Class Name] pairs from (Column A-Column C) in the Bu_Copygroup tab. To get the Top 5, we sort Column E in descending order, then F, then G, then H and we do not include rows where any of these columns = NOLIMIT (forever). It's not that NOLIMITs aren't important to review, but they are easily found in the XLSX and this chart will help show the other more interesting retention from a business perspective.
Top Ten Longest Running Backups Slide (Slide 6)
To calculate the longest-running backups, we reference the Summary tab in the XLSX for this project and populate the chart in descending order as follows:
- Entity: [Entity], Column E
- Duration: ([End_Time] - [Start_Time]) (Column B - Column A)
- Data Transferred: [Bytes] Column L (converted to Gigabytes)
- Throughput: [Bytes] Column L (converted from Bytes to Megabytes) / Duration (from above, converted to seconds)
This is the listing of the backups which are in the Top 10 for the duration.
NOTE: that the capacity is taken from Column AI (Bjs Backed Up Size, Raw Data tab) and converted to GB from Bytes (please note that Bjs Backed Up Size may be zero in some cases and you may want to reference Columns AF, AG and AH to determine read, stored and processed sizes respectively).
Duration is derived from Raw Data Tab’s Column M (Ts End Time) – Column L (Ts Creation Time) while throughput is from Column T (Ts Average Speed, Raw Data tab) converted to MB/Sec.
Top Ten Largest Nodes (Slide 7)
To determine the Top 10 Largest Nodes, we reference the Occupancy tab to get the following and take the largest from each unique Node_Name set:
- Node name: Column A, [Node_Name]
- Number of files: Column E, [Num_Files]
- Data Stored: Column H, [Reporting_Mb] (converted from Megabytes to Gigabytes)
The table is sorted by descending by Data_Stored.
Total Daily Data Transfer Slide (Slide 8)
An often-overlooked aspect of a backup environment assessment is the bigger picture of the amount of data being transferred each day. This slide helps paint a picture of a backup admin’s practices along with the environment.
Total backup jobs are broken down into types based on referencing the Summary Tab and with Activity set to Backup only:
- Number of Backup Jobs: To determine this, we sort the Summary tab by Start_Time. Then we count the number of rows per day.
- Capacity: The sum of the amount of data Column L [Bytes] (converted to GB) per day Column A [Start Time]
The peak of the bar shows the Total Capacity initiated for backup on that day. Jobs can cover more than one day. So, a job would be identified by starting on a day, completing successfully, and then using the capacity backed up at completion. Ts End Time is not evaluated for a specific date/time.
Average Daily Transfer is the amount of data transferred, not the transfer rate, and is an average of the bar chart total values (in red): Sum(each day’s total capacity backed up) / number of days (where 30 days is the most recent 30 days of backups, starting at the most recent backup (i.e., not calendar day) and correlates with the left vertical axis.
Backup Jobs (purple line) are the number of jobs that were initiated on each day. These values align with those on the right-hand vertical axis.
Backup Summary: Average Backup Rate by Number of Jobs / Top 5 Slowest Node Backups (Slide 9)
How it is calculated:
- Referencing the Summary tab in the XLSX for this project the Top Chart is populated as follows:
- We calculate the Throughput in MB/s for each job, (Column L), in MB (Column B [End Time] – Column A [Start_Time]), in Seconds
- We “bucketize” the range of throughput by rounding up to the nearest 10's value (using a Ceiling function), with MB/s shown as a whole number. So, for example:
>0 and <=10, are in 10MB/s
>10 and <=20, are in 20MB/s, and so on.
- We ignore 0's and truncate the chart at 300MB/s. The general idea for this chart is to give an overview of the transfer rates across the environment. The highest throughput jobs (perhaps fast Tape/VTL) aren’t factored in the chart. It's probably known, and expected, that these fast jobs exist. You can always reference the spreadsheet and create a throughput column and sort to look at more detailed information.
Referencing the Summary tab in the XLSX for this project the Bottom Table is populated as follows:
- The average throughput (using the formula above) and capacity for each unique grouping of Entity is calculated and the 5 slowest of these averages are listed in the table with the slowest at the top.
- Empty Entities in Column E are not factored in.
NOTE: the NODE is equivalent to ENTITY (Column E in Summary tab), IBM has a naming inconsistency here. Also. each Excel row in the Summary tab is a backup job.
PowerPoint Sample Reports
To view an IBM TSM PowerPoint Sample see the knowledge base article IBM TSM Project Samples