Need a script that displays NODE REPLICATION DETAILS in daily report

[jquonce]

I am looking for a script that I can add to the daily report with the details for NODE REPLICATIONs? Does anyone have one?

Thanks in advance.

[moon-buddy]

Replication?? What exactly do you mean by that?

Or, de-duplication?

[jquonce]

We have TSM 6.3 and we are doing a NODE REPLICATION from one server to another server.

[moon-buddy]

Sorry, I don't have a TSM 6.3 environment to come up with the script.

[balkark]

Give this a try....

select node_name,fsname,comp_state,BKBYTES_REPLICATED/1024/1024/1024 as GB_REPLICATED,BKBYTES_TRANSFERRED/1024/1024/1024 as GB_TRANSFERED,date(start_time) as "Date",time(start_time) as "Start",time(end_time) as "End",timestampdiff (4, char(timestamp (end_time) - timestamp (start_time))) as DURATION_MINS from replicationview where start_time>current_timestamp-1 day