IBM Support

IT21255: IBM STERLING FILE GATEWAY TABLE FG_EVENTS SHOWS DIFFERENT COUNT THAN ICC TABLE FG_STATS_LOG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IBM Sterling File Gateway table FG_EVENTS shows different count
    than ICC table FG_STATS_LOG
    
    It was discovered 1,000 DataflowIDs (DFID) were missing 1 or
    more events ,usually between 3 and 5 events for each of the
    1,000 DFIDs on a given day.
    

Local fix

  • RTC ID:- 571564
    LR / SF
    Circumvention: No
    

Problem summary

  • Users Affected:
    ICC Users Monitoring Filegateway
    
    Problem Description:
    Missing some FG EVENTS in ICC.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    Enhancement that allows the timestamp for MODIFYTS and CREATETS
    in FG_EVENTS table records to be set closer to the time that
    database commits the event record versus when the event is added
    to the event queue. In some cases where the database is a little
    slow and visibility queues get backed up, there may be some
    "missing" events in ICC because of ICC's moving query window.
    Changing the filegateway.useDatabaseTS property in
    customer_overrides.properties to true will allow the time for
    the MODIFYTS and CREATETS to be closer to the actual commit time
    and it is seen that customers miss far lesser events.
    By default this property in filegateway.properties.in is set to
    false:
    #useDatabaseTS if set to true allows the MODIFYTS and CREATETS
    for FG event records to be set close to database commit time
    # can sometimes help if ICC seems to be missing some FG events.
    Default is false.
    Other ways to alleviate missing event records on ICC side (not
    relating to this particular fix) are outlined in this article as
    well:
    http://www-01.ibm.com/support/docview.wss?uid=swg22017410
    
    Delivered in:
    5020603_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21255

  • Reported component name

    STR FILE GATEWA

  • Reported component ID

    5725D0700

  • Reported release

    226

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-29

  • Closed date

    2018-10-03

  • Last modified date

    2018-10-16

  • 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

    STR FILE GATEWA

  • Fixed component ID

    5725D0700

Applicable component levels

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4TGX","label":"IBM Sterling File Gateway"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.2"}]

Document Information

Modified date:
03 March 2021