How to use the TSM parameter, @tsmestimatedsize?
What TSM API parameter is this mapped to?
Does this parameter requiure user input for it at all times?
What value gets passed to TSM if I leave it blank?
Can it the value be specified in MB or GB instead of just bytes?
TSM parameter, @tsmestimatedsize
Example:
declare @rc int
Declare @filenumber int
exec @rc = master.dbo.xp_backup_database
@database = N'AdventureWorksDW'
, @GUID = N'BF3A157F-28B7-42A1-BA43-5E7A4548096C'
, @tsmclientnode = N'block'
, @tsmclientownerpwd = N'block'
, @tsmobject = N'SLS_Russel-April\Northwind\AdventureWorksD2.sls'
, @tsmconfigfile = N'C:\Program Files\Tivoli\TSM\baclient\dsm.opt'
, @backupname = N'AdventureWorksDW ???????'
, @desc = N'AdventureWorksDW ?2007-10-10 05:31:12 ???????'
, @init = 1
, @with = N'SKIP'
, @with = N'STATS = 10'
, @filenumber = @filenumber output
, @tsmestimatedsize = 107374182400
if @rc = 0
begin
exec master.dbo.xp_restore_verifyonly
@tsmclientnode = N'block'
, @tsmclientownerpwd = N'block'
, @tsmobject = N'SLS_Russel-April\Northwind\AdventureWorksDW.sls'
, @tsmconfigfile = N'C:\Program Files\Tivoli\TSM\baclient\dsm.opt'
, @filenumber = @filenumber
end
What TSM API parameter is this mapped to?
There is a sizeEstimate parameter we pass in the ObjAttr parameter of the dsmSendObj method.
Must the user provide a value for it at all times?
If no @tsmestimatedsize parameter is passed in for a given backup then SQLLiteSpeed engine estimates the size as:
if (Operator.Compare(_T("LOG")) == 0)
EstSize = (((m_DatabaseSize*2)/3)/4) / m_SLSFiles.GetCount(); // estimate two thirds compression of 1/4th log changes
else
EstSize = ((m_DatabaseSize*2)/3) / m_SLSFiles.GetCount(); // estimate two thirds compression
Previous estimated sizes are not remembered by the engine. Each time, if the @tsmestimatedsize is not passed in the engine uses the above equation.
What value gets passed to TSM if user does not enter a value? The calculation above is used.
Can it the value be specified in MB or GB instead of just bytes?
The @tsmestimatedsize parameter must be specified in bytes
In versions 4.6x and 4.7x of LiteSpeed, the @OLRMAP parameter was added to TSM backups. Object Level Recovery does not function with TSM backups so this parameter should not be passed into the backup script. This issue was resolved in Version 4.8.4.00086 (CR0227382)
