IBM Support

IT18364: SQL QUERIES RUN BY THE ITM AGENT TO RETRIEVE ALERT DATA WERE NOTUPDATED TO HANDLE THE ALERT SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR addresses the following issues:
    1. The sql queries are not able to identify the top level entity
    type stored in T_ALERT_LOG.TOPLEVEL_TYPE..
    2. The sql queries return the T_ALERT_LOG.MSG column. Previously
    this column contained the alert message, but now this is not the
    case.
    3. The sql queries assume that each row in T_ALERT_LOG
    corresponds to a single alert.
    The SQL queries will be fixed/improved to handle the Alert
    server enhancements.
    

Local fix

  • upgrade to fixing release.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Control 5.2.10, 5.2.11, 5.2.12, and 5.2.13      *
    * customers using IBM Spectrum Control Monitoring Agent.       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After the Monitoring Agent is installed, Alert data was not  *
    * displayed in the TPC Server Overview workspace in the Tivoli *
    * Enterprise Portal Navigator window.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply Fix Maintenance when available.                        *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is targeted for the following maintenance
    package:
    
    | refresh pack  |  5.2-TIV-TPC-RP0015  |  August 2017
    
    Fixed in IBM Spectrum Control 5.2.15
    
    http://www.ibm.com/support/docview.wss?&uid=swg21320822
    
    The target dates for future refresh packs do not represent a
    formal commitment by IBM. The dates are subject to change
    without notice.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT18364

  • Reported component name

    TPC ADVANCED

  • Reported component ID

    5608TPCA0

  • Reported release

    52A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-12-12

  • Closed date

    2017-02-28

  • Last modified date

    2018-02-19

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

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

Modules/Macros

  • ITMagent
    

Fix information

  • Fixed component name

    TPC ADVANCED

  • Fixed component ID

    5608TPCA0

Applicable component levels

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSNECY","label":"Tivoli Storage Productivity Center Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"52A"}]

Document Information

Modified date:
24 June 2022