Can someone provide a detailed explanation of the "tdpsqlc backup" command output? I did not find this information in the "tdpsqlc" command reference page or in the "TDP-MSSQL Installation and User's Guide".
To illustrate: We have a MS-SQL database called "secretsvrdb". It consists of two files:
Logical Name File Type File Name File Size on disk (bytes)
secretsvrdb Rows Data secretsvrdb.mdf 144,703,488
secretsvrdb_log Log secretsvrdb_1.ldf 13,646,168,064
When we backup this database using command "tdpsqlc backup", the output is:
Beginning full backup for database secretsvrdb, 6 of 11.
Full: 3 Read: 8388608 Written: 5242880 Rate: 5,114.89 Kb/Sec
Full: 3 Read: 22020096 Written: 18874368 Rate: 9,193.02 Kb/Sec
Full: 3 Read: 42991616 Written: 39845888 Rate: 12,944.78 Kb/Sec
Full: 3 Read: 63963136 Written: 60817408 Rate: 14,825.76 Kb/Sec
Full: 1 Read: 72843776 Written: 72843776 Rate: 14,207.41 Kb/Sec
Full: 0 Read: 72846080 Written: 72846080 Rate: 12,250.52 Kb/Sec
Backup of secretsvrdb completed successfully.
I do not see a correlation between the file size on disk and the "Read" and "Written" values.
Can someone tell me: What are the units of the "read" and "Written" values? They appear to be cumulative - is that right? And why does the output say "Full: 3" for the first several lines, followed by "Full: 1" and "Full: 0" ? If there is a IBM TSM document that explains this output in detail, please refer me to that document.
Sincere Thanks,
Janet
To illustrate: We have a MS-SQL database called "secretsvrdb". It consists of two files:
Logical Name File Type File Name File Size on disk (bytes)
secretsvrdb Rows Data secretsvrdb.mdf 144,703,488
secretsvrdb_log Log secretsvrdb_1.ldf 13,646,168,064
When we backup this database using command "tdpsqlc backup", the output is:
Beginning full backup for database secretsvrdb, 6 of 11.
Full: 3 Read: 8388608 Written: 5242880 Rate: 5,114.89 Kb/Sec
Full: 3 Read: 22020096 Written: 18874368 Rate: 9,193.02 Kb/Sec
Full: 3 Read: 42991616 Written: 39845888 Rate: 12,944.78 Kb/Sec
Full: 3 Read: 63963136 Written: 60817408 Rate: 14,825.76 Kb/Sec
Full: 1 Read: 72843776 Written: 72843776 Rate: 14,207.41 Kb/Sec
Full: 0 Read: 72846080 Written: 72846080 Rate: 12,250.52 Kb/Sec
Backup of secretsvrdb completed successfully.
I do not see a correlation between the file size on disk and the "Read" and "Written" values.
Can someone tell me: What are the units of the "read" and "Written" values? They appear to be cumulative - is that right? And why does the output say "Full: 3" for the first several lines, followed by "Full: 1" and "Full: 0" ? If there is a IBM TSM document that explains this output in detail, please refer me to that document.
Sincere Thanks,
Janet
