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

Obtain the fix for this APAR.

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 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.