IBM Support

PH33621: ABEND0C4 SQL ACTIVITY TRACE REPORT

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SYSTEM COMPLETION CODE=0C4  REASON CODE=00000004
TIME=15.56.37  SEQ=23173  CPU=0000  ASID=0252
PSW AT TIME OF ERROR  078D2000   B6DE5D3C  ILC 4  INTC 04
 ACTIVE MODULE ADDRESS=00000000_36D00000 OFFSET=000E5D3C
 NAME=FPECMAIN
 DATA AT PSW  36DE5D36 - B1F19200  B203D213  B081CDF0
 AR/GR 0: 00002001/80007000   1: 00000000/36D007A8


A storage overlay over next module in memory occurs when long
fields are copied to saved_dpm0 structure in DGORINEX due to
improper declaration. Depending on linkage order this can cause
FPECMAIN to abend.


//SYSIN    DD  *
 SQLACTIVITY
    TRACE
    SUMMARIZEBY (ALL)
    WORKLOAD (ALL)
 EXEC


Additional keywords
ABENDS0C4 S0C4 FPECMAIN batch report

Local fix

  • Apply PTF when available

Problem summary

  • ****************************************************************
* USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
*                 users of components:                         *
*                 - Batch SQL Reporting                        *
****************************************************************
* PROBLEM DESCRIPTION: 0C4 abend caused by storage overlay     *
*                      in BSQL processing routine.             *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
Batch SQL trace may terminate with abend 0c4 due to storage
overlay.

Problem conclusion

  • Program logic amended to no longer overlay storage in BSQL
processing.

Keywords:
BATCH DB2PE 0C4 DGORINEX

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH33621
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    540
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2021-01-20
    • 

  • Closed date
    2021-03-02
    • 

  • Last modified date
    2021-04-01
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • DGOBGENL DGOBSRAL DGOBSRBN DGOBSRCM DGOBSRDD DGOBSRLG DGOBSRLK
DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI DGOBSRSH DGOBSRSP
DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN DGOBSTCM DGOBSTDD
DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO DGOBSTQP DGOBSTRI
DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM DGORINEX DGORZREP
DGOSBLKX DGOSBORD DGOSBORE DGOVCRDB DGOVFTAB DGOVFTIN DGOVMSTR
DGOVRA   DGOVS150 DGOVSCLO DGOVSCNI DGOVSCNT DGOVSFLR DGOVSGFT
DGOVSLOC DGOVSORT DGOVSQFM DGOVSTQL DGOVUDAT DGOVUFTL DGOYA020
DGOYA100 DGOYB100 DGOYBLOK DGOYCKPT DGOYCNDX DGOYDB2I DGOYDPC0
DGOYDPM0 DGOYFFML DGOYFIST DGOYFPCK DGOYFRCA DGOYFSQL DGOYGPCK
DGOYGREQ DGOYJOIN DGOYLCEP DGOYLINE DGOYLIST DGOYMAIN DGOYPATH
DGOYPHDR DGOYPLA1 DGOYPLA2 DGOYPLAN DGOYPSUM DGOYR100 DGOYR200
DGOYRNM0 DGOYRNM1 DGOYRPT0 DGOYRPT1 DGOYRTB0 DGOYRTC0 DGOYS000
DGOYSEEE DGOYSERV DGOYSPCK DGOYSQMF DGOYSTAB DGOYSTOT DGOYSUMM
DGOYSVRS DGOYT000 DGOYT100 DGOYTCD0 DGOYTCD2 DGOYTCD3 DGOYTCO0
DGOYTCO1 DGOYTCO2 DGOYTCO3 DGOYTDB0 DGOYTDB1 DGOYTDM0 DGOYTDM1
DGOYTDM3 DGOYTDM4 DGOYTFI0 DGOYTFI1 DGOYTIAR DGOYTIX0 DGOYTIX1
DGOYTIX2 DGOYTIX3 DGOYTKY0 DGOYTKY3 DGOYTNF0 DGOYTNF3 DGOYTNM0
DGOYTNM3 DGOYTPC0 DGOYTPC1 DGOYTPC2 DGOYTPC3 DGOYTPD0 DGOYTPD1
DGOYTPG0 DGOYTPG1 DGOYTPG2 DGOYTPG3 DGOYTPG4 DGOYTPG5 DGOYTPG6
DGOYTPL0 DGOYTPL1 DGOYTPL3 DGOYTPL4 DGOYTPM0 DGOYTPM1 DGOYTPM2
DGOYTPM3 DGOYTPM4 DGOYTPM5 DGOYTPM6 DGOYTPN0 DGOYTPN1 DGOYTPT0
DGOYTPT1 DGOYTPT2 DGOYTPT3 DGOYTPT4 DGOYTPT5 DGOYTPT6 DGOYTPT7
DGOYTPT8 DGOYTPT9 DGOYTQD0 DGOYTQD1 DGOYTQD3 DGOYTQR0 DGOYTQR1
DGOYTSM0 DGOYTSM1 DGOYTSM2 DGOYTSM3 DGOYTSM4 DGOYTSM5 DGOYTSR0
DGOYTSR1 DGOYTSR2 DGOYTSS0 DGOYTSS1 DGOYTTB0 DGOYTTB1 DGOYTTB2
DGOYTTC0 DGOYTTC1 DGOYTXM0 DGOYTXM3 DGOYTXM4 DGOYTXN0 DGOYTXN1
DGOYTXN3 DGOYTXN4 DGOYU100 DGOYU110 DGOYU211 DGOYU212 DGOYU213
DGOYU221 DGOYU232 DGOYUMSG DGOYXPC1 DGOYXPC2 DGOYXPC3 DGOYXPC4
DGOYXPC5 DGOYXPCK DGOYXPLC DGOZCRDC DGOZPRSE FPEFUCAL FPEPSSTG
FPEUCBPR FPEUU120 FPEVFTM  FPEVSFLR FPEVZMAI FPEZCRD  KDPBPDZ
KDPBPRIX KDPGBPO5 KDPHBP   KDPHBPD  KDPHGBP  KDPHGBPD KDPHQISE
KDPNAV4I KDPTHDBD KDPTHDBP KDPTHGBD KDPTHGBP KO2ACAF2 KO2ACAFK
KO2ACAFS KO2ASUB2 KO2ASUBK KO2ASUBS KO2CCAFB KO2OQAL2 KO2OQALK
KO2OQALS

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R540  PSY  UI74215
       UP21/03/06  P  F103
    • 



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.
    








      
              
                            

              

              [{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0"}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 April 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback