PM64964: BATCH SQLACTIVITY REPORT TRACE JOB ABENDEDS0CC-C IN FPECFUD2+55F7C

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLACTIVITY REPORT & TRACE BATCH JOB ABENDEDS0CC-C.
  
  IEA995I SYMPTOM DUMP OUTPUT  080
  SYSTEM COMPLETION CODE=0CC  REASON CODE=0000000C
   TIME=11.59.11  SEQ=15641  CPU=0000  ASID=006D
   PSW AT TIME OF ERROR  078D2000   8005D504  ILC 4  INTC 0C
     ACTIVE LOAD MODULE           ADDRESS=00007588
  OFFSET=00055F7C
     NAME=FPEUFUD2
     DATA AT PSW  0005D4FE - C1FA6D20  C2026020  C20A5870
     AR/GR 0: 975A447A/00000000_D5000000   1:
  00000000/00000000_17C63638
           2: 00000000/00000000_1812A000   3:
  00000000/00000000_001A03D0
           4: 00000000/00000000_00007588   5:
  00000000/00000000_17C63A98
           6: 00000000/00000000_17C63AA0   7:
  00000000/00000000_00000369
           8: 00000000/00000200_0019F578   9:
  00000000/00000000_000001AC
           A: 00000000/00000000_17C6369C   B:
  00000000/00000000_17C6269D
           C: 00000000/00000000_8005D486   D:
  00000000/00000000_0005D610
           E: 00000000/00000000_0005D610   F:
  00000000/00000000_0005D4E2
   END OF SYMPTOM DUMP
  IEA993I SYSMDUMP TAKEN TO ONTOP.GS7TD.P65062.C000.SYSMDUMP
  IEF450I SJCHANGI PM - ABEND=S0CC U0000 REASON=0005D4E2  083
  
  ICE185A 0 AN S0CC  ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM
  OR AN EXIT (PHASE S 3)
  
  SYNCSORT ALSO increased CPU and memory consumption.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  *                 -   ATF - Application Trace Facility         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Batch SQLACTIVITY Report Trace job      *
  *                      encountered ABNDS0CC-C in FPECFUD2 or   *
  *                      it may show high CPU consumption.       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: All OMPE V510 customers using DB2 V10 with   *
  *                 PTF UK64815 applied recommended to apply     *
  *                 also this PTF.                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Batch SQLACTIVITY Report Ttrace job may encounter ABNDS0CC-C in
  FPECFUD2 or it may show loop / high CPU consumption.
  That caused by the new key field QW00xxCB introduced instead of
  QW00xxAC in DB2 V10 PTF UK64815 for IFCIDs 15,16,17 and 18.
  
  PROBLEM CONCLUSION:
  Code changed to fix ABNDS0CC and accommodate changes introduced
  with DB2 V10 PTF UK64815.
  

Problem conclusion

• Code changed to fix ABNDS0CC and accommodate changes introduced
  with DB2 V10 PTF UK64815.
  
  KEYWORDS : BATCH SQLACTIVITY REPORT TRACE ABNDS0CC HIGH CPU LOOP
             UK64815
  

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:

  UK80991

Modules/Macros

•    BPOQAPVA BPOQCREC BPOQINEX BPOQRIOA BPOQSRGB
  DGOAACUM DGOABLOG DGOACREC DGOAIREC DGOARCAL DGOBGENL DGOFECAL
  DGOFEDAT DGOFPDAT DGOFPE35 DGOFSDST DGOFSSST DGOFUCAL DGOFUCA1
  DGOFUFAC DGOFUFDI DGOIPAIR DGOIPEDM DGOLADLK DGOLAREQ DGOLARES
  DGOLASUM DGOLASUS DGOLATIM DGOLCREC DGOLFILE DGOLIREC DGOLREDC
  DGOLTRAC DGOLXRES DGOMLEXD DGOMSDST DGONCREC DGONFIFA DGONFILE
  DGONFTXA DGONF012 DGONF023 DGONF030 DGONF040 DGONF050 DGONF060
  DGONF210 DGONF220 DGONF230 DGONF240 DGONF250 DGONF8ST DGONTRAC
  DGORASCN DGORCREC DGORCREP DGORCRE2 DGORDIST DGORINEX DGORIREC
  DGORIREP DGORPCAP DGORPEXI DGORPHIL DGORPHVA DGORPIOA DGORPMIN
  DGORPPAG DGORPPAR DGORPRID DGORPSCA DGORPSOR DGORPSUM DGORPSUS
  DGORPUDF DGORRCAP DGORRCOM DGORRDAT DGORRDDF DGORREXI DGORRHIL
  DGORRHVA DGORRIOA DGORRLOC DGORRMIS DGORRSOR DGORRSQL DGORRTHR
  DGORSRBY DGORUSUM DGORUWRK DGORZREP DGOSAPAW DGOSBLKX DGOSBORD
  DGOSBORE DGOSFMTQ DGOSFMTR DGOSGENC DGOSGENS DGOSI225 DGOSSPSH
  DGOSTRAC DGOTAEXT DGOTAPVA DGOTAUTY DGOTBWKL DGOTCCHK DGOTCCOP
  DGOTCDIV DGOTCLOD DGOTCRCO DGOTCREB DGOTCREC DGOTCREO DGOTCREP
  DGOTIREC DGOTIREP DGOVDMSG DGOVPIG1 DGOVSUTL DGOVS700 DGOVUELD
  DGOWFILE DGOWF201 DGOXF000 DGOXF006 DGOXF007 DGOXR000 DGOXS006
  DGOXS007 DGOXT006 DGOXT007 FPECHASY FPECHATS FPECHE35 FPECHTRN
  FPECMDAT FPEUCBPR FPEUCXPX FPEUCXSX FPEUFTDS FPEUFTS2 FPEUIFCI
  FPEUIFC2 FPEUNIDT KO2ARSBA KO2ARSBK KO2ARSB2 KO2ARS6A KO2ARS6K
  KO2ARS62 KO2ASUDA KO2ASUDK KO2ASUD2 KO2ASU8A KO2ASU8K KO2ASU82
  TDK$LNCK
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK80991

     UP12/08/14 P F208

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.