IBM Support

PM74284: ISSUES WHEN USING REBUILD_INDEXES KEYWORD ON WRITE_TO_VSAM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following issues are resolved when using EBUILD_INDEXES
    keyword on a WRITE_TO_VSAM job,
    1.ABEND U0012 on GGC#LGAP and job outputs shows the following
    messages
    GGC2028I A Log apply process cancelled by request from task
    manager.
    GGC4998A A Internal error. Contact IBM tech support. Pgm:
    GGC#IKS Stmt: 591
    GGC2027I A Rebuild indexes thread returned error.  GGC4006I
    Rebuild indexes thread error detected. Cancelling in process.
    GGC3601I Log apply task returned an error, RC=X'00000C'
    GGC2802I The writer service returned an error, RC=X'A03000'
    2. ABEND U0012 on GGC#LGAP and job outputs shows the following
    messages:
    GGC4236I A QDS5.DSNDBC.DBCA184C.I184CB1.I0001.A001.
    GGC4227I A A VSAM write failure occurred..
    GGC2027I A Rebuild indexes thread returned error.
    GGC2028I B Log apply process cancelled by request from task
    manager.
    GGC4006I  Rebuild indexes thread error detected. Cancelling in
    process.
    GGC3601I  Log apply task returned an error, RC=X'00000C'
    GGC2802I  The writer service returned an error, RC=X'A03000'
    3. ABEND U0012 on GGC#LGAP and job outputs shows the following
    messages:
    GGC2028I A Log apply process cancelled by request from task
    manager.
    GGC4154I B Pgm: GGC#PSRW Stmt: 00226 Type: SELECT INTO Code:
    -805
    GGC4155I B RS25QDS5..GGCIPSRW.0C7C7C3E06D9D240 GGC31WRK 03
    GGC4146A B SQL request can not be completed.
    GGC2027I B Rebuild indexes thread returned error.
    GGC4006I Rebuild indexes thread error detected. Cancelling in
    process.
    GGC3601I Log apply task returned an error, RC=X'0E0000'
    GGC2802I The writer service returned an error, RC=X'A03000'
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Change Accumulation Tool.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following issues are resolved when  *
    *                      using EBUILD_INDEXES keyword on a       *
    *                      WRITE_TO_VSAM job,                      *
    *                      1.ABEND U0012 on GGC#LGAP and job       *
    *                      outputs shows the following messages    *
    *                      GGC2028I A Log apply process cancelled  *
    *                       by request from task manager.          *
    *                      GGC4998A A Internal error. Contact IBM  *
    *                       tech support. Pgm:GGC#IKS Stmt: 591    *
    *                      GGC2027I A Rebuild indexes thread       *
    *                       returned error.                        *
    *                      GGC4006I Rebuild indexes thread error   *
    *                       detected. Cancelling in process.       *
    *                      GGC3601I Log apply task returned an     *
    *                       error, RC=X'00000C'                    *
    *                      GGC2802I The writer service returned    *
    *                       an error, RC=X'A03000'                 *
    *                      2. ABEND U0012 on GGC#LGAP and job      *
    *                      outputs shows the following messages:   *
    *                      GGC4236I A QDS5.DSNDBC.DBCA184C.        *
    *                      I184CB1.I0001.A001.                     *
    *                      GGC4227I A A VSAM write failure         *
    *                       occurred..                             *
    *                      GGC2027I A Rebuild indexes thread       *
    *                       returned error.                        *
    *                      GGC2028I B Log apply process cancelled  *
    *                       by request from task manager.          *
    *                      GGC4006I  Rebuild indexes thread error  *
    *                       detected. Cancelling in process.       *
    *                      GGC3601I  Log apply task returned an    *
    *                       error, RC=X'00000C'                    *
    *                      GGC2802I  The writer service returned   *
    *                      an error, RC=X'A03000'                  *
    *                      3. ABEND U0012 on GGC#LGAP and job      *
    *                      outputs shows the following messages:   *
    *                      GGC2028I A Log apply process cancelled  *
    *                       by request from task manager.          *
    *                      GGC4154I B Pgm: GGC#PSRW Stmt: 00226    *
    *                       Type: SELECT INTO Code: -805           *
    *                      GGC4155I B RS25QDS5..GGCIPSRW.          *
    *                      0C7C7C3E06D9D240 GGC31WRK 03            *
    *                      GGC4146A B SQL request can not be       *
    *                       completed.                             *
    *                      GGC2027I B Rebuild indexes thread       *
    *                       returned error.                        *
    *                      GGC4006I Rebuild indexes thread error   *
    *                       detected. Cancelling in process.       *
    *                      GGC3601I Log apply task returned an     *
    *                       error, RC=X'0E0000'                    *
    *                      GGC2802I The writer service returned    *
    *                       an error, RC=X'A03000'                 *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM74284

  • Reported component name

    DB2 CHANGE ACCU

  • Reported component ID

    5655F5500

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-03

  • Closed date

    2012-11-01

  • Last modified date

    2012-12-04

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

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

    UK83169

Modules/Macros

  • GGC#RUNT GGC#WRIT GGCIALI  GGCIDB2C GGCIDCAM
    GGCIENQS GGCIEXCP GGCIGIDX GGCIGRS  GGCIHFP  GGCIHLI2 GGCIICW2
    GGCIIDPH GGCIIKS  GGCIIKSA GGCILOCK GGCIMAIN GGCIMSGS GGCIMUTX
    GGCINCRD GGCIPAGE GGCIPROT GGCIPSRW GGCIRBLT GGCIROWK GGCISMPR
    GGCISORT GGCISOR1 GGCISOR2 GGCISOR3 GGCISOR5 GGCISTDB GGCISYSP
    GGCITHRD GGCIUCB  GGCIUTLB GGCIVSAD GGCIVSAM GGCIVSAS GGCIXMLR
    

Fix information

  • Fixed component name

    DB2 CHANGE ACCU

  • Fixed component ID

    5655F5500

Applicable component levels

  • R310 PSY UK83169

       UP12/11/09 P F211

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":"3.1.0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUXZ","label":"IBM Db2 Change Accumulation Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021