PH32617: RENAME ENABLED ACCELERATOR TABLE RUN TIME ERRORS ADB5258E TABLE CANNOT BE RECREATED ADB5702I; WRONG TABLE NAME ADB7146I ADB7176I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Rename of a table that is added to an accelerator and enabled
  for replication may result in the following issues:
  
  1)  The following errors may appear at run time:
  
  ADB5258E Table(s) cannot be recreated on the accelerator. An
  error occurred during the call to accelerator stored procedure
  SYSPROC.ACCEL_ADD_TABLES on accelerator IDAAZ59.
  
  ADB5702I The value '>tablename<'is incorrect for an identifier
  of the TABLE type.  The error condition is:  NOT EXISTS.  The
  identifier can take on a maximum length of 128.  The minimum
  length is 1.
  
  ADB5265W Action: Specify a correct identifier value.
  ADB5185E The run is ending due to errors.
  
  2) 2) The compare report may use the wrong table name
  when issuing informational messages ADB7146I and
  ADB7176I:
  
  ADB7146I Table >old_table_name< will be recreated in IBM DB2
  Analytics Accelerator.
  ADB7176I Table >old_table_name< will be loaded to IBM DB2
  Analytics Accelerator.
  
  
  
  
  
  
  
  Keywords: msgadb5258e; msgadb5702I; msgadb5265w; msgadb5185E
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Object Comparison Tool for      *
  *                 z/OS who rename accelerated tables.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1) Renaming an accelerated table        *
  *                      creates a WSL with incorrect            *
  *                      accelerator processing statements. The  *
  *                      WSL is missing the DISABLE, DELETE,     *
  *                      and ADD accelerator statements and      *
  *                      uses the old name of the table instead  *
  *                      of the new one.                         *
  *                                                              *
  *                      2) The Compare report indicates the old *
  *                      table name instead of the new table     *
  *                      name when issuing informational         *
  *                      messages ADB7146I and ADB7176I.         *
  ****************************************************************
  1) Running the WSL that was generated from renaming
  an accelerated table might result in errors, such as the
  following example messages:
  
  ADB5275I Found Distribution key
  'SEQ_NO' for TS5771.IDAA_QRY_HST
  on accelerator IDAAZ59.
  ADB5258E Table(s) cannot be recreated
  on the accelerator. An error occurred
  during the call to accelerator
  stored procedure
  SYSPROC.ACCEL_ADD_TABLES on
  accelerator IDAAZ59.
  ADB5702I The value 'IDAA_QRY_HST' is
  incorrect for an identifier of the
  TABLE type. The error condition
  is: NOT EXISTS. The identifier can
  take on a maximum length of 128.
  The minimum length is 1.
  ADB5265W Action: Specify a correct
  identifier value.
  ADB5185E The run is ending due to errors.
  
  2) The compare report uses the wrong table name
  when issuing informational messages ADB7146I and
  ADB7176I:
  
  ADB7146I Table >old_table_name< will be recreated in IBM DB2
  Analytics Accelerator.
  ADB7176I Table >old_table_name< will be loaded to IBM DB2
  Analytics Accelerator.
  

Problem conclusion

• The problem has been resolved.
  
  Search keywords: MSGADB5258 MSGADB5258E MSGADB2565 MSGADB5256W
  MSGADB5185 MSGADB5185E MSGADB7146I MSGADB7176I
  

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:

  UI74058

Modules/Macros

• ADB2CM3  ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74058

     UP21/02/23 P F102

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.