PM75727: REBUILD_INDEXES KEYWORD RELATED ISSUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following issues are resolved when using REBUILD_INDEXES
  keyword:
  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: 629...
   GGC2027I A Rebuild indexes thread returned error.
   RC=X'A03000'
   .
  2. CHECK INDEX job fails after a change accumulation tool
     REBUILD_INDEXES job:
   2.1. CHECK INDEX RC = 4 and with the following message,
       DSNU713I !QA1A 291 03:35:10.07 DSNUKIKI - KEYS MISMATCH,
       RID=X'0000000201'.
   2.2. CHECK INDEX ABEND=S04E U0000 REASON=00C90101 and with the
       following message,
      -DSNU017I 291 03:40:09.33 DSNUGBAC - UTILITY DATA BASE
       SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C90101'
  .
  3. REBUILD_INDEXES related messages that refers to Pgm: GGC#
     updated to Pgm: GGCI
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Change Accumulation Tool.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following issues are resolved when  *
  *                      using REBUILD_INDEXES keyword:          *
  *                      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: 629...                           *
  *                      GGC2027I A Rebuild indexes thread       *
  *                       returned error. RC=X'A03000'.          *
  *                      2. CHECK INDEX job fails after a        *
  *                       change accumulation tool               *
  *                       REBUILD_INDEXES job:                   *
  *                      2.1. CHECK INDEX RC = 4 and with the    *
  *                       following message, DSNU713I !QA1A 291  *
  *                       03:35:10.07 DSNUKIKI - KEYS MISMATCH,  *
  *                       RID=X'0000000201'.                     *
  *                      2.2. CHECK INDEX ABEND=S04E U0000       *
  *                       REASON=00C90101 and with the following *
  *                       message, -DSNU017I 291 03:40:09.33     *
  *                       DSNUGBAC - UTILITY DATA BASE SERVICES  *
  *                       MEMORY EXECUTION ABENDED,              *
  *                       REASON=X'00C90101'.                    *
  *                      3. REBUILD_INDEXES related messages     *
  *                       that refers to Pgm: GGC# updated to    *
  *                       Pgm: GGCI.                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK83437

Modules/Macros

• GGC#LGAF GGC#SCPY 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 UK83437

     UP12/11/14 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.