IV37952: OLD AGENTS UPLOAD INCORRECT MEASURES TO ADM.MEASURE

Tivoli Asset Discovery for Distributed Interim Fix 7.5.0-TIV-TAD4D-IF0027
IBM License Metric Tool Interim Fix 7.5.0-TIV-ILMT-IF0027
Tivoli Asset Discovery for Distributed Interim Fix 7.5.0-TIV-TAD4D-IF0026
IBM License Metric Tool Interim Fix 7.5.0-TIV-ILMT-IF0026
IBM License Metric Tool 7.2.2 Interim Fix, 7.2.2-TIV-ILMT-IF0010
IBM License Metric Tool Interim Fix 7.5.0-TIV-ILMT-IF0026

APAR status

• Closed as program error.

Error description

• CODBL0004W - Essential periodic calculations did not occur when
  expected.
  
  we applied
  ILMT 7.5.0 Fixpack1
  and
  ILMT 7.5.0 IterimFix7  but it didnt fix the issue.
  
  According to L3:
  
  Old agents upload incorrect measures to adm.measure
  
  and following work around sent to customer by L3 team:
  Please execute the following commands on TLMA database:
  
  
  db2 "delete from adm.measure where METRIC_id = 1"
  
  db2 "create trigger ADM.MEASURE_TR3 after insert on adm.measure
  referencing  new as NEW for each row mode db2sql  when (
  (NEW.METRIC_ID
  < 6 ) OR (NEW.METRIC_ID > 15) ) delete from adm.measure where id
  =
  new.id"
  

Local fix

• Please execute the following commands on TLMA database:
  
  
  db2 "delete from adm.measure where METRIC_id = 1"
  
  db2 "create trigger ADM.MEASURE_TR3 after insert on adm.measure
  referencing  new as NEW for each row mode db2sql  when (
  (NEW.METRIC_ID
  < 6 ) OR (NEW.METRIC_ID > 15) ) delete from adm.measure where id
  =
  new.id"
  

Problem summary

• ****************************************************************
  * Old agents upload incorrect measures to adm.measure
  ****************************************************************
  * RECOMMENDATION: Apply appropriate interim/fixpack when
  * available.
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
   | Interim Fix | 7.5.0-TIV-ILMT-IF0008
   | Interim Fix | 7.5.0-TIV-TAD4D-IF0008
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TIV ASSET DIS 4

• Fixed component ID

  5724T4D00

Applicable component levels

• R750 PSY

     UP