Capacity value in TAMIT PVU report does not match the values in TAD4d report

Technote (troubleshooting)


Problem(Abstract)

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
7.2.2.2 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
On TAD4D:

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
,VENDOR v
where l.SUBCAP_PEAK_DATE>= p.AGGREGATION_START_DATE AND
p.AGGREGATION_END_DATE>=l.SUBCAP_PEAK_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

TAMIT:

select distinct sum (hwmvusub) as hwmvusub,min(startdate), max(enddate)
from maximo.tloamdpahwm , maximo.tloamsoftware , maximo.deployedasset
where tloamdpahwm.nodeid = deployedasset.nodeid and
tloamsoftware.tloamsoftwareid=tloamdpahwm .tloamsoftwareid
and tloamsoftware.swname=''<replace with your software name>'
group by tloamsoftware.swname

Product Alias/Synonym

Integration Composer
Tivoli Asset Management for IT

Rate this page:

(0 users)Average rating

Add comments

Document information


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:

2014-01-27

Translate my page

Machine Translation

Content navigation