JR32929: REPLICATION CENTER : SOURCE COLUMNS DO NOT SHOW UP DURING COLUMN MAPPING IN CERTAIN SITUATIONS

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Cannot see source column names during column mapping
  using column mapping ellipsis, during Create Q subscription in a
  zOS datasharing environment.
  
  Steps involved:
  
  1.  Define the source table in database A in one datasharing
  group
  2.  Define the target table in database B in a different
  datasharing
  group.
  3.  Be sure that database A does not exist on the target side.
  4.  Go through the process of defining a subscription via the
  Replication Center.  If the problem exists, the mapping panel
  will show column mapping as incomplete and you won't be able to
  get around this.
  
  5.  If the problem does exist, simply define database A on the
  target
  side.  It's not necessary to create any tables in it.  Then do
  step (4)
  again and the problem should go away.
  

Local fix

• Define database  on target side
  

Problem summary

• The problem fixed in V97GA and V95 FP5.
  

Problem conclusion

• The problem fixed in V97GA and V95 FP5.
  

Temporary fix

• The problem fixed in V97GA and V95 FP5.
  

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

  WS Q-REPLIC LUW

• Fixed component ID

  5724N9801

Applicable component levels

• R950 PSY

     UP