PH64087: ABEND S0C9 EDITING OR BROWSING LARGE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing BROWSE of a DB2 table with large number
  of rows. He receives ABEND S0C9:
  
  CEE3209S The system detected a fixed-point divide exception (
  System Completion Code=0C9).
  From entry point Initialize at statement 3004 at compile unit
  offset +0000A046 at entry offset +0000A046 at
  address 21AB008E.
  
  Traceback:
    DSA   Entry       E  Offset  Statement   Load Mod  ProgramUnit
    1     CEEHDSP     +00004B12              CEEPLPKA  CEEHDSP
    2     Initialize  +000206CA  3004        FOPMEMAI  FOPEDRIV
    3     ededitad    +00001DEA  442         FOPMEMAI  FOPEDRIV
    4     mngorun     +00000A70  1126        FOPMMUNU  FOPMCALL
    5     LC_SelTbl   +000005C6  609         FOPMMUNU  FOPMTLST
    6     ExecLineCmds+0000150C  818         FOPMECMN  FOPEISPL
    7     cmispfl     +000028B2  365         FOPMECMN  FOPEISPL
    8     mntbsls     +00004432  516         FOPMMUNU  FOPMTLST
    9     PromptEditTable
                      +00002310  1147        FOPMMUNU  FOPMMENU
    10    mnprmpt     +00004934  823         FOPMMUNU  FOPMMENU
    11    main        +000040A2  909         FOPMAIN   FOPMMAIN
  

Local fix

• Reduce the Editor Fetch Rows limit to a smaller value or
  increase the REGION size.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing BROWSE or EDIT of     *
  *                 tables with very large number of rows or     *
  *                 working with REGIONs of limited size.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  Optim detects an out-of-storage condition due to large
  number of rows, or limited REGION size, and attempts
  recovery. An incorrectly coded test causes the abend in
  such scenarios.
  

Problem conclusion

• Optim code will be corrected.
  

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:

  UI99443

Modules/Macros

• FOP2RRSQ FOP9APIM FOPCFPMN FOPHSTM  FOPK00   FOPMADDE FOPMAIN
  FOPMAMAI FOPMCMAI FOPMCOLP FOPMDBMN FOPMDPRC FOPMDXTR FOPMECMN
  FOPMEMAI FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM FOPOMN
  FOPRS10  FOPRS9   FOPT02T  FOPT29K  FOPTLPRA FOPUMCBT FOPZFMMN
  FOPZSUB
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI99443

     UP24/12/17 P F412

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.