IBM Support

PI12727: OPTIM ABEND S0C7 BROWSING EXTRACT FILE WITH INVALIDDECIMAL DATA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • User performs BROWSE of an Optim EXTRACT FILE which may contain
    invalid DECIMAL DATA. The following ABEND S0C7 ABEND0C7 may
    occur:
    Traceback:
      DSA   Entry       E  Offset  Statement   Load Mod
    Program Unit                   Service  Status
      1     CEEHDSP     +0000422C              CEEPLPKA
    CEEHDSP                        UK80866  Call
      2     DECTOMEM    +000000C0              FOP1OSFN
    DECTOMEM                                Exception
      3     XFMPrint    +00013836  1754        FOPZFMMN
    FOPZPRNT                       UI12916  Call
      4     BrowseReport+00023EF4  4657        FOPMARCN
    FOPABROW                       UK96649  Call
      5     ArcBrowse   +0000D5A6  1074        FOPMARCN
    FOPABROW                       UK96649  Call
      6     ArcHighLevel+00000DEE  378         FOPMARCN
    FOPAMAIN                       UI14675  Call
      7     dmjsmain    +00001B50  485         FOPMMJBS
    FOPJINI                        UK98260  Call
      8     mngojsb     +000010A8  1718        FOPMMUNU
    FOPMCALL                       UK96649  Call
      9     PromptDM    +00002508  1739        FOPMMUNU
    FOPMMENU                       UK96649  Call
      10    mnprmpt     +00004C9A  830         FOPMMUNU
    FOPMMENU                       UK96649  Call
      11    main        +000031C2  598         FOPMAIN
    FOPMMAIN                       UI15078  Call
      12    EDCZMINV    +000000C2              CEEEV003
    Call
      13    CEEBBEXT    +000001C4              CEEPLPKA
    CEEBBEXT                       HLE7780  Call
    Condition Information for Active Routines
      Condition Information for DECTOMEM (DSA address 1F862C10)
        CIB Address: 1F8635D0
        Current Condition:
          CEE0198S The termination of a thread was signaled due to
    an unhandled condition.
        Original Condition:
          CEE3207S The system detected a data exception (System
    Completion Code=0C7).
        Location:
          Program Unit: DECTOMEM Entry: DECTOMEM Statement:  Offset:
    +000000C0
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Optim/z users performing BROWSE or PRINT of, possibly    *
    * converted, EXTRACT or ARCHIVE files.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * o When performing BROWSE or PRINT of EXTRACT or ARCHIVE      *
    * files which contain DECIMAL data Optim assumes that all      *
    * values in such files are valid PACKED DECIMAL numbers.       *
    * When the data originated from source other than a DB2 table  *
    * additional checks are performed to validate the data before  *
    * processing. No such checks are being performed for DB2 data  *
    * which is assumed to be always valid.                         *
    * However the user may perform CONVERT processing of the       *
    * original EXTRACT or  ARCHIVE file containing DB2 data and    *
    * inadvertently cause decimal data corruption. Such corruption *
    * may then lead to an ABEND S0C7 ABEND0C7 while performing     *
    * BROWSE of converted XF or AF.                                *
    * Traceback:                                                   *
    *   DSA   Entry       E  Offset  Statement   Load Mod          *
    * Program Unit                                                 *
    *   1     CEEHDSP     +0000422C              CEEPLPKA          *
    * CEEHDSP                                                      *
    *   2     DECTOMEM    +000000C0              FOP1OSFN          *
    * DECTOMEM                                                     *
    *   3     XFMPrint    +00013836  1754        FOPZFMMN          *
    * FOPZPRNT                                                     *
    *   4     BrowseReport+00023EF4  4657        FOPMARCN          *
    * FOPABROW                                                     *
    *   5     ArcBrowse   +0000D5A6  1074        FOPMARCN          *
    * FOPABROW                                                     *
    *   6     ArcHighLevel+00000DEE  378         FOPMARCN          *
    * FOPAMAIN                                                     *
    *   7     dmjsmain    +00001B50  485         FOPMMJBS          *
    * FOPJINI                                                      *
    *   8     mngojsb     +000010A8  1718        FOPMMUNU          *
    * FOPMCALL                                                     *
    *   9     PromptDM    +00002508  1739        FOPMMUNU          *
    * FOPMMENU                                                     *
    *   10    mnprmpt     +00004C9A  830         FOPMMUNU          *
    * FOPMMENU                                                     *
    *   11    main        +000031C2  598         FOPMAIN           *
    * FOPMMAIN                                                     *
    *   12    EDCZMINV    +000000C2              CEEEV003          *
    *   13    CEEBBEXT    +000001C4              CEEPLPKA          *
    * CEEBBEXT                                                     *
    *                                                              *
    * o In addition the following System Error may be reported by  *
    * Optim when attempting to perform a BROWSE in mode A (AD) of  *
    * a converted EXTRACT file which does not contain an Access    *
    * Definition:                                                  *
    *            An Internal System Error has Occurred on          *
    * 2014/02/27 23:15                                             *
    *                                                              *
    * I/O ERROR ON OUTPUT FILE.  MAKE SURE RECORD FORMAT IS V      *
    * DB2Rel=915(NFM), Rel=7.1.0                                   *
    * Code=-1, AuxInfo=                                            *
    * 01  FOPZPRNT 20140227 GC12727D (002147) XFMPrint             *
    * 02  FOPABROW 20130815 UK96649D (004659) BrowseReport         *
    * 03  FOPABROW 20130815 UK96649D (001075) ArcBrowse            *
    * 04  FOPAMAIN 20140204 UI14675D (000379) ArcHighLevel         *
    * 05  FOPJINI  20131007 UK98260D (000486) StartJobSubmission   *
    * 06  FOPMCALL 20130815 UK96649D (001720) CallJSub             *
    * 07  FOPMMENU 20130815 UK96649D (001740) PromptDM             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply the provided fix.                                      *
    ****************************************************************
    o The assumption that DECIMAL values which originated from DB2
    tables are always valid may not be safe since the user may
    change the original values during a CONVERT process and possibly
    introduce values which are no longer valid packed DECIMAL.
    o The System Error is caused by a missing check for the REPORT
    file being previously opened which is causing the close attempt
    to fail.
    

Problem conclusion

  • o Optim/z code will be changed to validate any DECIMAL values
    before processing them for the purpose of producing a REPORT
    output of an XF or AF.
    Note that the reported invalid decimal value may only partially
    reflect the column's content, as long as it can be interpreted
    as valid decimal digits, and it will be followed by an
    exclamation point (!) to indicate that the (decimal) value is in
    error.
    o The REPORT file will only be closed after it has been
    previously opened.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI12727

  • Reported component name

    OPTIM MOVE FOR

  • Reported component ID

    5655V0700

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-28

  • Closed date

    2014-03-12

  • Last modified date

    2014-04-02

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

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

    PI12728

Modules/Macros

  • FOPZFMMN
    

Fix information

  • Fixed component name

    OPTIM MOVE FOR

  • Fixed component ID

    5655V0700

Applicable component levels

  • R710 PSY UI15938

       UP14/03/19 P F403

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 April 2014