Link to home
Start Free TrialLog in
Avatar of Santiago videla
Santiago videla

asked on

How to get the daily amount of data backuped on TSM.?

Hi everyone.
                        since  I need to analize some network traffic,  i want to know if there is a way to have the daily amount size of data saved by tsm and the top 5 servers with more traffic/data volume backuped.


Thanks in advance.
Avatar of David Favor
David Favor
Flag of United States of America image

Clarify what you mean by "top 5 servers with more traffic/data volume backuped", maybe in terms of what you're trying to learn from this data.
TSM - Tivoli... Shudder... I worked on this product years ago, when the company first started.

The best way to answer your question about daily data size, it to open a Tivoli service ticket + ask the exact location of the oid or oid list where this data is stored.

Then you can query this data. You may have to keep track of the above data each night at midnight + do your own calculations, as this will likely be faster then trying to lookup all packet data across a date range of one day, which would generate a massive amount of system thrash (CPU usage + Disk I/O), due to home brewed database used with TSM.

A much lighter weight solution is to use tshark to capture desired data + restart each hour logging to a new file.

This way you end up with 24 log files each day, which will be far smaller than Tivoli's version + much faster to access + require far less CPU/Disk resource usage.
Avatar of Santiago videla
Santiago videla

ASKER

David, i just need to know how much of data is being backuped daily and  the 5 servers with more data saved
Best way to do this is to open a Tivoli support ticket.

The only way to know this for sure is to actually introspect into your data, based on how Tivoli tells you do this for your TSM version.

I still don't understand what you're asking about "backuped daily and  the 5 servers with more data saved".

Maybe you're asking how much additional data will be backed up daily if you add 5 servers. If this is what you're asking, then once you answer your first question (about data size of one server), you can guess at size for adding any number of other servers... like 5 in your case.
ASKER CERTIFIED SOLUTION
Avatar of max_the_king
max_the_king

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have the following report on my Spectrum Protect v8.1.3:

SERVER1> select Entity as NODE_NAME, (CAST(FLOAT(SUM(s.bytes_protected))/1024/1024 AS DECIMAL(12,2))) AS PROTECTED_MB, (CAST(FLOAT(SUM(s.bytes_written))/1024/1024 AS DECIMAL(12,2))) AS WRITTEN_MB, (CAST(FLOAT(SUM(s.dedup_savings))/1024/1024 AS DECIMAL(12,2))) AS DEDUPSAVINGS_MB, (CAST(FLOAT(SUM(s.comp_savings))/1024/1024 AS DECIMAL(12,2))) AS COMPSAVINGS_MB, (CAST(FLOAT(SUM(s.dedup_savings))/FLOAT(SUM(s.bytes_protected))*100 AS DECIMAL(5,2))) AS DEDUP_PCT from summary s WHERE s.bytes_protected<>0 AND (activity='BACKUP' OR activity='ARCHIVE') AND s.START_TIME>=(current_date - 1 days) GROUP BY ENTITY order by COMPSAVINGS_MB DESC

And generates "Summarized node backups in the last 24 hours, sorted by Compressed Savings":

NODE_NAME	PROTECTED_MB	WRITTEN_MB	DEDUPSAVINGS_MB	COMPSAVINGS_MB	DEDUP_PCT
-----------------------------------------------------------------------------------------
1_NEPTUNO_TDPORA	569,997.5	150,416.51	21,916.36	397,664.62	3.84
1_SCHEMBRI_TDPORA	574,946.75	173,511.3	185,813	215,622.44	32.31
2_SCHEMBRI_TDPORA	179,070.75	34,992.05	49,285.04	94,793.65	27.52
3_NEPTUNO_TDPORA	101,592.75	34,619.15	22.97	66,950.61	0.02
4_SCHEMBRI_TDPORA	66,065.75	13,373.49	21,667.42	31,024.82	32.79
5_TDPORA	82,468.25	5,684.68	48,949.59	27,833.96	59.35
6_NEPTUNO_TDPORA	65,679.5	4,405.32	36,562.75	24,711.42	55.66
7_NEPTUNO_TDPORA	22,175	7,000.17	14.68	15,160.13	0.06
8_NEPTUNO_SP	307,344.72	1,376.66	299,333.65	6,634.27	97.39
9_NEPTUNO_SP	132,572.93	1,257.54	127,722.07	3,593.06	96.34
A_SCHEMBRI_SP	17,960.15	1,036.48	14,212.84	2,710.72	79.13
B_SCHEMBRI_SP	45,358.74	1,016.35	41,762.21	2,580.1	92.07
C_SP	21,594.41	104.18	20,294.17	1,195.94	93.97
D_STATION	132,410.01	24,949.28	104,219.16	864.65	78.7
E_SP	109,454.35	226.54	108,417.63	810.04	99.05
F_NEPTUNO_SP	10,107.93	39.17	9,766.46	301.2	96.62
G_SP	3,831.52	52.28	3,499.32	279.81	91.32
SPECTRE	1,889.01	27.11	1,746.26	115.59	92.44
H_NEPTUNO_SP	1,466.32	10.62	1,410.45	45.19	96.18
I_FS	4,248.45	1,114.26	3,110.62	23.27	73.21
J_CORREO_SP	1,450,305.82	21,998.51	1,428,305.38	0	98.48

Open in new window

Hi Max,
              This command is exactly what im looking for!. Thanks a lot as usual.