Capacity value in TAMIT PVU report does not match the values in TAD4d report
On comparing the PVU report from TAMIT vs TAD4d, mismatching values are seen
Resolving the problem
Customer needs to verify the following
1. ITIC transfers PVU data from the last SIGNED report from TAD4d. Customer needs to compare the last signed report data with TAMIT after checking that ITIC has been run after signing the report in TAD4d.
2. It is possible that TAMIT still has old left over PVUs from the agents that do
not exist anymore. The fix to remove old PVUs has been put in ITIC in
18.104.22.168 HF 8 . But fix is only working going forward and does not wipe out PVU
data for the agents deleted long time ago.
Customer has to delete all the records from TLOAMDPAHWM table and re-run
the import. At that point TAMIT will only contain PVU data from last
report. And if imports and report signing are performed regularly, ITIC
will maintain accurate PVU numbers and will not include outdated PVUs.
3. For sub capacity PVU Values, please run the following queries and provide to support
for further investigation
select SUM(p.CORES_SUB_CAP), SUM(p.PVU_SUB_CAP),,
min(p.AGGREGATION_START_DATE), max(p.AGGREGATION_END_DATE), s.NAME
from NODE_PRODUCT_AGGREGATION_V p , LAST_SIGNED_PVU_MAX l ,SWPRODUCT s
where l.SUBCAP_PEAK_DATE>= p.AGGREGATION_START_DATE AND
l.PRODUCT_ID=p.PRODUCT_ID and l.PRODUCT_ID=s.ID and v.ID=s.VENDOR_ID
and s.name='<replace with your software name>'
group by s.NAME
select distinct sum (hwmvusub) as hwmvusub,min(startdate), max(enddate)
from maximo.tloamdpahwm , maximo.tloamsoftware , maximo.deployedasset
where tloamdpahwm.nodeid = deployedasset.nodeid and
and tloamsoftware.swname=''<replace with your software name>'
group by tloamsoftware.swname
Tivoli Asset Management for IT
More support for:
Tivoli Integration Composer
Software version: 7.2, 7.2.1
Operating system(s): AIX, Linux, Windows
Software edition: All Editions
Reference #: 1625118
Modified date: 2016-01-07