IV44194: INACTIVE AGENTS ARE NOT REMOVING

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-IF0011
IBM License Metric Tool Interim Fix 7.5.0-TIV-ILMT-IF0026

APAR status

• Closed as program error.

Error description

• IBM Tivoli Asset Discovery for Distributed
  Product version:
    7.5.0.14
  Build number:
    20121128-2250
  
  Old inactive (not_connecting) agents are not being cleaned up
  automatically based on the maxagentinactivity and
  maxagentinactivitytodelete system parms. Our parms are set as
  follows:
  
  Name: maxAgentInactivity
  Value: 2880
  
  Name: maxAgentInactivityToDelete
  Value: 43200
  
  Based on these settings an inactive agent should be
  automatically
  deleted after 32 days of inactivity. We have several hundred
  inactive
  agents with a Last Agent Activity date older than 90 days that
  are not
  being deleted. Are there any known TAD 7.5 issues with
  maxagentinactivitytodelete?
  

Local fix

• It seems that the problem occurred because ACTIVE field in
  ADM.AGENT
  table was not updated. Please open an apar for that problem.
  
  To fix your database the ACTIVE fields need to be set manually.
  
  I have prepared the example query for setting ACTIVE fields to 0
  for
  agents with last activity before 30 days:
  
  ----------------------------------------------
  CONNECT TO TLMA;
  
  UPDATE ADM.AGENT SET ACTIVE = 0
  WHERE ID IN (
   SELECT AGENT_ID
   FROM ADM.AGENT_ALIVE
   WHERE ALIVE_TIME / 1000 < (DAYS(CURRENT TIMESTAMP - 30 DAYS) -
  DAYS('1970-01-01 00:00:00.0')) * 86400 +
  (MIDNIGHT_SECONDS(CURRENT
  TIMESTAMP - 30 DAYS) - MIDNIGHT_SECONDS('1970-01-01
  00:00:00.0'))
  );
  
  DISCONNECT TLMA;
  ----------------------------------------------
  
  The query needs to be run from the user with DBADM privilates
  (for
  example instance owner).
  

Problem summary

• ****************************************************************
  * Inactive agents are not deleted after the period that is set
  * in the maxAgentInactivityToDelete parameter is exceeded.
  ****************************************************************
  * RECOMMENDATION: Apply appropriate interim fix when available.
  ****************************************************************
  

Problem conclusion

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

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