PK28923: NEGATIVE NUMBER (ROWS EXAMINED) DISPLAYED ON PANEL ZEDD3

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• NEGATIVE NUMBER (ROWS EXAMINED) DISPLAYED ON PANEL ZEDD3
  
  Rows Examined is displayed as negative.  Numbers larger than a
  signed full word.
  
  FYI.
  
  ________________ ZEDD3 VTM O2 V520./I DB25 02/14/06 14:46:54 2
  > Help PF1 Back PF3 Up PF7 Down PF8
  >
  ================================================================
  > EDM SNAPSHOT DYNAMIC SQL CACHE STATISTICS
  > statistics require that monitor class 1 and ifcid 318 be
  started
  EDD3
  + Authorization Id: WWPRXPD
  +
  + SELECT Z.MPN002_PART_BASE_R baseNumber, Z.MPN036_BASE_TYPE_R
  type,
  Z.MP
  + N002_PART_BASE_X description, Z.MPN002_BASE_STRP_R
  BASE_STRIP_R ,
  Z.MPN0
  + 02_BASE_STRP_C BASE_STRIP_C, Z.MPN033_BASE_CATG_R category,
  Z.MPN002_ACT
  + IVE_F activeFlag, Z.MPN002_ACTIVE_Y activeDate,
  Z.MPN002_LAST_UPDT_C
  upd
  + ateBy, Z.MPN002_LAST_UPDT_S updatedDate, Z.MPN002_TYP_SRVCD_F
  servicedFl
  + ag, Z.MPN002_TYP_SRVCD_Y servicedDate, Z.MPN002_EMISSIONS_F
  emissionFlag
  + , Z.MPN002_SUGG_BASE_R suggestedBase, Z.MPN002_EMISSIONS_Y
  emissionDate
  + FROM PDU@DBA.PMPN002_PART_BASE Z , PDU@DBA.PMPN019_BASE_ABRV A
  , PDU@D
  
  + BA.PMPN019_BASE_ABRV B , PDU@DBA.PMPN019_BASE_ABRV C WHERE
  (Z.MPN002_P
  
  + ART_BASE_R = A.MPN002_PART_BASE_R AND Z.MPN036_BASE_TYPE_R =
  A.MPN036_BA
  + SE_TYPE_R AND A.MPN019_KEYWORD_X = ? ) AND
  (Z.MPN002_PART_BASE_R =
  B.MP
  + N002_PART_BASE_R AND Z.MPN036_BASE_TYPE_R =
  B.MPN036_BASE_TYPE_R AND
  B.M
  + PN019_KEYWORD_X = ? ) AND (Z.MPN002_PART_BASE_R =
  C.MPN002_PART_BASE_R
  
  + AND Z.MPN036_BASE_TYPE_R = C.MPN036_BASE_TYPE_R AND
  C.MPN019_KEYWORD_X
  =
  + ? ) AND Z.MPN033_BASE_CATG_R = ? ORDER BY basenumber OPTIMIZE
  FOR 20
  + 00 ROWS WITH UR FOR FETCH ONLY
  +
  + Times Executed 21 Synchronous Buffer Reads 440
  + Getpages 39830032 Rows Examined -2099728K
  + Rows Processed 962 Sorts Performed 42
  + Index Scans 381656 Tablespace Scans 21
  + Parallel Groups Created 0 Synchronous Writes 0
  + Elapsed Time 01:31:04.301 CPU Time 00:48:51.830
  + Wait for Synch I/O 00:00:00.636 Wait for Lock/Latch
  00:05:11.969
  + Synch Exec Switch 00:00:00.000 Wait for Global Locks
  00:00:00.000
  + Wait Othr Thread Read 00:00:00.013 Wait Othr Thread Write
  00:00:00.000
  
  + Isolation Bind RS Currentdata Bind N
  + Dynamic rules Bind R Current Degree 1
  + Current Rules D Current Precision N
  + Cursor Hold Y
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM V310            *
  *                 users of component:                          *
  *                 -   Classic Interface                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: NEGATIVE NUMBER (ROWS EXAMINED)         *
  *                      DISPLAYED ON PANEL ZEDD3.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• PROGRAM LOGIC IS CHANGED TO DISPLAY CORRECT NUMBER EXAMINED
  ROWS.
  -------------------
  SYSMOD TITLE: NEGATIVE NUMBER (ROWS EXAMINED) DISPLAYED ON ZEDD3
  KEYWORDS:     INCORROUT NEGATIVE NUMBER ROWS EXAMINED ZEDD3
  

Temporary fix

Comments

APAR Information

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

  OA15929

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

  UK17705

Modules/Macros

•    KO2OEDSB
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK17705

     UP06/09/07 P F609

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.