IZ94729: MANAGEDSYSTEM TABLE FOR OS AGENTS TCR REPORTS SOMETIMES CONTAINS"LOOPBACK" AS FULLYQUALIFIEDHOSTNAME

IBM Tivoli Monitoring 6.2.2 Fix Pack 8 (6.2.2-TIV-ITM-FP0008)
IBM Tivoli Monitoring 6.2.2 Fix Pack 9 (6.2.2-TIV-ITM-FP0009)
IBM Tivoli Monitoring 6.2.2 Fix Pack 6 (6.2.2-TIV-ITM-FP0006)

APAR status

• Closed as program error.

Error description

• Severity: 3
  Approver: gdc
  Compid: 5724C040U
  Release: 6.2.2
  Abstract: ManagedSystem table for OS Agents TCR Reports contains
            "loopback" as FullyQualifiedHostname
  
  Environment: The Cognos TCR Reports for IBM Tivoli Monitoring OS
  Agents 6.2.2 FP2
  
  Problem Description: Procedures for DB2, Oracle and MSSQL used
  to populate the ManagedSystem table in the Warehouse schema for
  TCR Cognos Reports for ITM OS Agents can generate entries with
  "loopback" for the FullyQualifiedHostname.  The procedures
  should filter-out
  the 'loopback%' entries, similar to what is done to filter-out
  the 'localhost%' entries.
  

Local fix

• Rewrite the SQL script that creates the database stored
  procedure, to include a "NOT LIKE" clause to eliminate the
  'loopback%' entries.  For example, for the Oracle script
  create_procedure.sql, above the lines that have:
  
           || pv_domain
           || '" NOT LIKE ''NO_DNS_ENTRY'''
  
  add two lines to filter-out the "loopback%" entries, so it looks
  like:
  
           || pv_domain
           || '" NOT LIKE ''loopback%'' and "'
           || pv_domain
           || '" NOT LIKE ''NO_DNS_ENTRY'''
  
  That way, it filters-out all three types of entries.  Re-run the
  new create_procedure.sql and confirm populate_osagents() works
  correctly afterwards.
  

Problem summary

• Procedures for DB2, Oracle and MSSQL used to populate the
  ManagedSystem table in the Warehouse schema for TCR Cognos
  Reports for ITM OS Agents can generate entries with "loopback"
  for the FullyQualifiedHostname. The procedures should filter-out
  the 'loopback%' entries, similar to what is done to filter-out
  the 'localhost%' entries.
  

Problem conclusion

• Procedures were added to filter-out the loopback entries
  
  The fix for this APAR is going to be included in the following
  maintenance
  vehicle:
      | fix pack | 6.2.2-TIV-ITM-FP0005
  

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

  ITM AGENT UNIX

• Fixed component ID

  5724C040U

Applicable component levels

• R622 PSY

     UP