PM86947: PANEL ZHTSOCS SHOWING ZERO ON SORT ELAPSED TIME AND SORT CPU TIME

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The values for the Sort Elapsed Time and Sort CPU Time fields on
    panel ZHTSOCS are always zero.
    
    
     ________________ ZHTSOCS  VTM     O2       V510./C SSID
    > Help PF1               Back PF3               Up
    PF7                 Down PF8
    
    
    >          THREAD HISTORY:  Enter a selection letter on the top
    line.
    
    
    > A-THREAD DETAIL   B-LOCK COUNTS  C-LOCK WAITS     D-GLOBAL
    LOCKS  *-SORT/SCAN
    > F-DYNAMIC SQL     G-SQL COUNTS   H-DISTRIBUTED    I-BUFFER
    POOL   J-GROUP BP
    > K-PACKAGE SUMMARY L-RES LIMIT    M-PARALLEL
    TASKS
    ================================================================
    ===============
    >                     THREAD HISTORY SORT AND SCAN
    ACTIVITY
     HPLN
    
    + Thread:  Plan=DSNESPCS  Connid=TSO      Corrid=HIFRGIL
    Authid=HIFRGIL
    + Attach:  TSO            DB2=DV12
    MVS=USYS
    + Time  :  Start=04/05/2013 11:42:13.130710     End=04/05/2013
    11:42:17.804850
    +
    Luwid=ADP.SSID.CB2AF370C989
    
     socs
    
    +                               Sort
    Statistics
    +
    
    + Number of Sorts      =            1     Number of Work Files
    =           0
    + Records Sorted       =         1356     Work File Inserts
    =           0
    + Sort Elapsed Time    = 00:00:00.000     Work File Reads
    =           0
    + Sort CPU Time        =
    00:00:00.000
    +
    
    
    NOTE:
    This dynamic SQL statement will generate a sort.
    SELECT NAME FROM SYSIBM.SYSTABLES ORDER BY NAME DESC;
    
    
    Additional symptom:
    The SQL numbers have problem too (not-SQL numbers are added to
    SQL count
    
    
    >                            Thread History Summary
    
    HATH
    
    + Report Interval:    5 mins                     Start: 02/25
    00.000000
    
    + Report Filtered:      YES                        End: 02/25
    59.999999
    
    act
    
    +
    
    +                                  Elapsed
    CPU                          Term
    
    + End Time       Plan     Authid   Time     Time   SQL   Commit
    Abrt
    Pkg Status
    
    + ------------   -------- -------- -------  ------ ----- ------
    ----
    --- ------
    
    + 14:15:27.373   DSNESPCS HIILKUR     1.98    .449 35353     1
    1
    2 DEALLO
    
      <- Number of  SQLs on this screen doubles the previous
    screen's number.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Classic Interface                        *
    *                 -   CUA Interface                            *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1.PANEL ZHTSOCS SHOWING ZERO ON SORT    *
    *                        ELAPSED TIME AND SORT CPU TIME.       *
    *                      2.PANEL ZHATACT SHOWS WRONG NUMBER OF   *
    *                        SQLS.                                 *
    *                      3.RECORD SORTED NUMBER IS INCORRECT     *
    *                        ON PANEL ZHATLOC.                     *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    Calculation of Sort Elapsed Time, Sort CPU Time and Record
    Sorted fields was incorrect.
    Number SQLs on panel ZHATACT was incorrect.
    
    PROBLEM CONCLUSION:
    Change the calculation of Sort Elapsed Time, Sort CPU Time and
    Record Sorted fields and Number SQLs to display correct values.
    

Problem conclusion

  • Change the calculation of Sort Elapsed Time, Sort CPU Time and
    Record Sorted fields and Number SQLs to display correct values.
    
    KEYWORDS : ELAPSED TIME CALCULATION
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM86947

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-12

  • Closed date

    2013-04-30

  • Last modified date

    2013-06-04

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

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

    UK93945

Modules/Macros

  •    KO2APC5A KO2APC5K KO2APC52 KO2APC6A KO2APC6K
    KO2APC62 KO2APC7A KO2APC7K KO2APC72 KO2APC8A KO2APC8K KO2APC82
    KO2CNASB KO2DTH1A KO2DTH1K KO2DTH12 KO2ONASB KO2OTHAB KO2OTHDB
    KO2OTHFB KO2OTH3B KO2OTH8B KO2OZM2B
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R510 PSY UK93945

       UP13/05/03 P F305

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 Buffer Pool Analyzer for z/OS

Software version:

5.1.0

Reference #:

PM86947

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation