Db2 Tools

 View Only
  • 1.  FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Posted Jul 04, 2018 10:18 AM

    IGD103I SMS ALLOCATED TO DDNAME SYS00002
    IGD103I SMS ALLOCATED TO DDNAME SYS00003
    IEC988I KCBUL001,LOAD001,SYSIN-1,037B,S72039,DBAP.GRAB.SYSPUNCH.KCBDBAP
    IEF237I 0720 ALLOCATED TO SYS00004
    IGD103I SMS ALLOCATED TO DDNAME SYS00005
    IGD103I SMS ALLOCATED TO DDNAME SYS00006
    IEA995I SYMPTOM DUMP OUTPUT
    SYSTEM COMPLETION CODE=0C4 REASON CODE=0000003B
    TIME=12.24.03 SEQ=19599 CPU=0000 ASID=007E
    PSW AT TIME OF ERROR 070C0001 A3920120 ILC 6 INTC 3B
    NO ACTIVE MODULE FOUND - PRIMARY NOT EQUAL TO HOME
    NAME=UNKNOWN
    DATA AT PSW 2392011A - 00024120 0080DA12 B044F002
    AR/GR 0: 0000013F/00000000_27868E38 1: 00000000/00000000_00000002
    2: 00000000/00000000_00000080 3: 00000000/00000000_2312CB30
    4: 00000000/00000000_27A7D3A8 5: 00000000/00000000_2312CB30
    6: 00000000/00000000_23062240 7: 00000000/00000229_75FB4908

     

     

    PFL4002I - DFSORT detected as the SORT program
    PFL0070E - Failure occurred during Object
    TXTAT4.KCBS002ALL status Inquiry

    PFL0072E - Pending flag(s) could not be Determined
    because SQL Error/Rtn Error
    PUT0136I - Primary restart rows deleted
    **************************** Bottom of Data ***********



  • 2.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Broadcom Employee
    Posted Jul 04, 2018 10:58 AM

    Hello Ajay,

     

    I have opend a Case in CA Support Online to research this Abend S0C4.

     

    To fix this Abend S0C4 you can update the SORT-MOSIZE parameter setting in the UTIL member in highlvl.CDBAPARM to SORT-MOSIZE (0) which would be a global change for all Fast Load executions.

    Another option would be to add the following DD to a particular JCL:
    //DFSPARM DD *
    OPTION MOSIZE=0

     

    If this solution does not work please update the Case in CA Support Online and I will research the problem further.

    Thanks.  



  • 3.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Broadcom Employee
    Posted Jul 04, 2018 10:58 AM

    Hi Ajay,

          Problems like this are very difficult to diagnose without job output and dumps etc.

    If you would like to contact me directly at keith.sessions@ca.com  I'll open a case for you for this and i can do some detailed research for you

     

       keith



  • 4.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Broadcom Employee
    Posted Jul 05, 2018 07:05 AM

    Hello Ajay,
     
    I have realized the solution I gave you was to fix the Abend SDC2 in DFSORT, you already updated the
    Case in CA Support Online and the Case is pending of verification.
     
    For the Abend S0C4 and PFL0070E - PFL0072E error messages we have already provided you a solution in the
    opened Cases in CA Support Online.
     
    Please update the Cases accordingly if you have any further question.
     
    Thanks. 
    Josep Raull



  • 5.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B
    Best Answer

    Posted Jul 05, 2018 09:44 AM
      |   view attached

    Hi Josep/Keith - Thanks for your quick & promt responce !!

    You can close all related cases, which is related with 0C4 or DC2.

     

    Thanks again !!

     

    Thanks & Regards,

    Ajay Sharma

    DB2 & IMS SysProg and DBA Support on zOS/SAP

    GTS, Solutions, Del & Transf

    +91-9860-2525-99 Mobile

    Ajay_Sharma@in.ibm.com

     

    IBM Services



  • 6.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Broadcom Employee
    Posted Jul 05, 2018 09:48 AM

    Thanks Ajay



  • 7.  Re: FAST LOAD is failing with CODE=0C4  REASON CODE=0000003B

    Broadcom Employee
    Posted Jul 05, 2018 09:52 AM

    Thank you Ajay, closing Cases as requested.

     

    Josep Raull.