IBM Support

PM97986: ZERO ELAPSED AND CPU TIME FOR ACCELERATED QUERY IN IFCID0003 Q8AC SECTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • For DB2 11 for z/OS, see PI09182.
    Always ZERO ELAPSED AND CPU TIME FOR ACCELERATED QUERY in
    IFCID0003 Q8AC section Q8ACACPU and Q8ACAELA.
    E.g.:
    
    From the Accounting long report it showed the following:
    ACCELERATOR        AVERAGE         TOTAL
    ------------  ------------  ------------
    ELAPSED TIME
     SVCS TCP/IP   3:04.167835   3:04.167835
     ACCUM ACCEL      0.000000      0.000000
    CPU TIME
     SVCS TCP/IP     25.808230     25.808230
     ACCUM ACCEL      0.000000      0.000000
    ========================================================
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All IDAA V3 DB2 10 for z/OS users.           *
    *                 Specifically where IDAA remote query offload *
    *                 is in the workload.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Zero elapsed and cpu times for remote   *
    *                      accelerated query in IFCID0003 Q8AC     *
    *                      section.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During an IDAA remote query offload, the monitorring event
    request was not send to the IDAA server.
    
    Additional Keywords:
    IDAAV3R1/K IDAAV4R1/K
    

Problem conclusion

  • During an IDAA remote query offload, monitorring event request
    is being send to the IDAA server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97986

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2013-09-27

  • Closed date

    2014-01-08

  • Last modified date

    2016-07-14

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

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

    UI14066 PI09182

Modules/Macros

  • DSNLZHC1 DSNLZR00
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI14066

       UP14/01/23 P F401

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PM97986

Modified date: 14 July 2016


Translate this page: