IY86443: PROBLEM W/ PURGE UTILITY BECAUSE OF LARGE FILE SIZE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • New functionality needs to be included in the Manager Server's
    purge
    functionality to include an option to select when to execute the
    purge
    process (current functionality executes the purge at 12:00 pm
    GMT, which
    translates to 6:00 pm CDT - this is still within Discover's
    defined
    business day). Additional new functionality needs to be included
    to
    control how much data gets purged at one time. The current
    functionality
    purges ALL data that meets the defined purge criteria (purging
    an entire
    day's or multiple day's worth of data in one DB2 transaction).
    This is
    very inefficient, and has been blowing up DB2 due to volumes.
    Logic must
    be incorporated into the Manager Server purge criteria to split
    up the
    purge into smaller chunks of rows. Some suggestions - purge by a
    configurable or pre-defined number of rows, purge by hour of day
    as
    opposed to an entire day or multiple days at once.
    

Local fix

  • n/a
    

Problem summary

  • Tivoli Web Segment Analyzer product's purging of database
    function causes to fill the transaction log causing the DB2
    database to crash.
    

Problem conclusion

  • fix delivered to limit each purge to 100,000 rows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IY86443

  • Reported component name

    MGR CLNT SRV ET

  • Reported component ID

    5724K40EG

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-06-28

  • Closed date

    2006-08-10

  • Last modified date

    2006-08-10

  • 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

    MGR CLNT SRV ET

  • Fixed component ID

    5724K40EG

Applicable component levels

  • R350 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli ETEWatch Enterprise Edition

Software version:

350

Reference #:

IY86443

Modified date:

2006-08-10

Translate my page

Machine Translation

Content navigation