IBM Support

IJ03599: MAXIMO IS EXECUTING THE SAME SQL STATEMENT MULTIPLE TIMES , PERFORMANCE ISSUE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Issue :- While fetching data through CLASSIFICATION JSON api
    service system is taking 9.5 seconds and monitoring through
    Perfmon tool it shows 1412 statements running in backend. Issue
    is  related to the NUMERIC  domains. The same issue can be
    reproduce by steps
    1. Go to Incident app
    2. Bring up an existing record
    3. Look up the Reported Priority field
    4. You'll see MAXDOMAIN is fetched 4 times with the same sql
    statement
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Maximo repeatedly performs the same fetch against the        *
    * MaxDomain table when looking up domain values.               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is included in the following package:
                             | Release 7.6.1.0 of Base Services.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ03599

  • Reported component name

    INTEGRATION

  • Reported component ID

    5724R46I1

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-24

  • Closed date

    2018-03-28

  • Last modified date

    2018-03-28

  • 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

    INTEGRATION

  • Fixed component ID

    5724R46I1

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management

Software version: 760

Reference #: IJ03599

Modified date: 28 March 2018