Troubleshooting
Problem
A node is replicated from a Tivoli Storage Manager source server to a target server. After the node is replicated, the QUERY OCCUPANCY command reports different values for the node on the source and target servers.
Resolving The Problem
The following needs to be considered when comparing the replication data between the source and target Tivoli Storage Manager servers.
- Data residing in copy storage pools or active-date storage pools is not replicated. When using the QUERY OCCUPANCY command, verify the amount of files/logical MB in primary pools only. The following select command may be used :
select sum(a.NUM_FILES) as "# of files", sum(a.LOGICAL_MB) as "Logical(MB)" from occupancy a, stgpools b where a.stgpool_name=b.stgpool_name and b.pooltype='PRIMARY'
- When the REPLICATE NODE command is run, the "DATATYPE=ALL" is the default value used. If you specify a value other than "DATATYPE=ALL", ensure that the query is adjusted accordingly. For example, in the case where a node has both archive and backup data stored on the source server and the REPLICATE NODE command is run with DATATYPE=BACKUP, then only the backup data is replicated and not the archive. The QUERY OCCUPANCY command would report different values on the source and target servers if the TYPE=ANY (default) is used with the command instead of TYPE=BACKUP. The following select command may be used in this example :
select sum(a.NUM_FILES) as "# of files", sum(a.LOGICAL_MB) as "Logical(MB)" from occupancy a, stgpools b where a.type='Bkup' and a.stgpool_name=b.stgpool_name and b.pooltype='PRIMARY'
Related Information
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Supported Versions","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21694144