PH05801: DB2 ADMIN TOOL - ONCODE 9999 FOR COMPARE OF RENAMED TEMPORAL TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• While comparing renamed temporal tables, RENAMETB masks to
  informs AOC that tables have been renamed. Analyze output ends
  with RC12 and oncode 9999.
  
  ADB9703E Program ADBCCM detected an ONCODE condition 9999 in
  REGISTER_PARTINFO
  
  ERROR condition was raised
  Traceback of user routines:
  Compile Unit   Entry          Statement
                 REGISTER_PARTINFO
                                28778
                 SORTD_IN       5678
                 PREPARE_DELTAS 4051
                 ADBCCMM        2003
                 MERGEVFS_CMM   43530
                 ANALYZE_CHANGE_PROCESS
                                35065
                 ADBCCM         8314
                 GOCCCM         3
  
  ONCODE9999
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS or Db2 Object Comparison Tool for z/OS  *
  *                 who analyze a change.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Analyzing a change terminates with      *
  *                      ONCODE 9999 / ONCODE9999 while          *
  *                      processing a rename of a history table. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Analyzing a change ends with ONCODE as shown in the below
  error message. The error occurs while processing a rename
  of a history table.
  
  ADB9703E Program ADBCCM detected an ONCODE condition 9999
  in REGISTER_PARTINFO
  
  ERROR condition was raised
   Traceback of user routines:
     Compile Unit
     Entry Statement CU offset Entry offset Address
     REGISTER_PARTINFO
                 28778 +00008886 +00008886 21C3F126
     SORTD_IN 5678 +00007870 +00007870 21CED7A0
     PREPARE_DELTAS 4051 +0000083C +0000083C 21CEECB4
     ADBCCMM 2003 +00001A3C +00001A3C 21C0CC6C
     MERGEVFS_CMM 43530 +0000028A +0000028A 2182F97A
     ANALYZE_CHANGE_PROCESS
                 35065 +000028DA +000028DA 2187A7E2
     ADBCCM 8314 +00027D44 +00027D44 21822D8C
     GOCCCM 3 +000000CC +000000CC 2207A204
  
  Note: Statement numbers, offsets and addresses are approximate,
        and may vary somewhat, depending on release, maintenance
        applied and other factors.
  

Problem conclusion

• Problem has been resolved.
  

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:

Modules/Macros

•    ADBCCMM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI61894

     UP19/03/19 P F903

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.