IC72024: CDR CHECK AND CDR CHECK --VERBOSE SHOW EVERY ROW AS A MISMATCH WHEN COLUMN NAME OF THE SOURCE AND TARGET TABLE IS NOT THE SAME

APAR status

• Closed as program error.

Error description

• When the column name of the source and target table are
  different the cdr check  reports every row as a mismatch. If the
  data is unloaded and ouptput is compared there is no difference
  in the data. Below are the outputs:
  
  cdr check repl -r agency -m g_cdr1 g_cdr2
  
  Oct 15 2010 12:38:10 ------   Table scan for agency start
  --------
  
  
  Node                  Rows     Extra   Missing  Mismatch
  Processed
  ---------------- --------- --------- --------- ---------
  ---------
  g_cdr1                 100         0         0         0
  0
  g_cdr2                 100         0         0       100
  0
  
  WARNING: replicate is not in sync
  Oct 15 2010 12:38:11 ------   Table scan for agency end
  ---------
  
  command failed -- WARNING: replicate is not in sync (178)
  
  cdr check repl --verbose -r agency -m g_cdr1 g_cdr2
  
  Oct 15 2010 12:38:28 ------   Table scan for agency start
  --------
  
  data mismatch
  key: noclient:00325010
  Error in reportMismatch2
          Can not find target value for notps
  
  command failed -- Data for row or column not found (203)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * any user replicating subscripted columns                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * During the check one server was replicating a subscripted    *
  * column to a non-subscripted column on another server.        *
  * During the check, we were comparing the complete column and  *
  * not just the subscripted value.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50xC8                                          *
  ****************************************************************
  

Problem conclusion

• Code was added to correctly process subscripted columns.
  

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:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP