Hi, All
I've been using data queried from TSM summary tables for capacity planning to track how much data my instances are backing up. I've recently discovered some duplicate entries in my query output. I assumed that start time, stop time and activity were a unique key but not quite so.
See these as an example (also attached):
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45135,X,Tcp/Ip,10.241.140.16:13869,,0,2,0,22294,2,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45134,X,Tcp/Ip,10.241.140.16:13871,,0,2,0,22294,2,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45147,X,Tcp/Ip,10.241.140.16:13876,,0,2,0,22294,1,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:15.000000,BACKUP,45148,X,Tcp/Ip,10.241.140.16:13877,,0,2,0,22294,4,0,1,YES,,,,,0,
This looks like a backup of the same size, at the same time, from the same client (obscured as X here). The only difference I can see here is the TCP/IP port number.
Can somebody explain this data for me? How much data is being backed up? Is it 22294 bytes, or 4 times 22294 bytes?
TIA
-Jim Lane
I've been using data queried from TSM summary tables for capacity planning to track how much data my instances are backing up. I've recently discovered some duplicate entries in my query output. I assumed that start time, stop time and activity were a unique key but not quite so.
See these as an example (also attached):
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45135,X,Tcp/Ip,10.241.140.16:13869,,0,2,0,22294,2,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45134,X,Tcp/Ip,10.241.140.16:13871,,0,2,0,22294,2,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:12.000000,BACKUP,45147,X,Tcp/Ip,10.241.140.16:13876,,0,2,0,22294,1,0,1,YES,,,,,0,
2010-01-25 07:00:10.000000,2010-01-25 07:00:15.000000,BACKUP,45148,X,Tcp/Ip,10.241.140.16:13877,,0,2,0,22294,4,0,1,YES,,,,,0,
This looks like a backup of the same size, at the same time, from the same client (obscured as X here). The only difference I can see here is the TCP/IP port number.
Can somebody explain this data for me? How much data is being backed up? Is it 22294 bytes, or 4 times 22294 bytes?
TIA
-Jim Lane