IBM Support

PI53211: DATABASE QUERIES TO DEVICES TABLE TIMEOUT WHEN TABLES INCLUDES LARGE AMOUNT OF DATA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • It has been observed that database quesries to DEVICES table
    timeout and fail with Reason code "68".. SQLCODE=-911 when the
    table includes large amount of data.
    

Local fix

  • To workaround the issue an index can be created against DEVICES
    table that improves data retrieval from the table to avoid
    timing out of queries.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MobileFirst servers which have License Tracking enabled.     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * License tracking feature's device decommissioning task runs  *
    * at server start up slowing down the server startup.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * -                                                            *
    ****************************************************************
    

Problem conclusion

  • Added indexing to the Devices Table and, only set the
    decommissioning interval at start up, but not run the
    decommissioning task. The first decommissioning task will run
    only after one set interval.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI53211

  • Reported component name

    MFPF/WORKLIGHT

  • Reported component ID

    5725I4301

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-11-26

  • Closed date

    2016-11-16

  • Last modified date

    2016-11-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

    MFPF/WORKLIGHT

  • Fixed component ID

    5725I4301

Applicable component levels

  • R700 PSY

       UP

  • R710 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZH4A","label":"IBM Worklight"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"700","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 October 2021