JR21686: Q REPLICATION: VARIOUS PROBLEMS WITH FEDERATED TARGET SUPPORT.

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• Problem 1:
  LONG VARGRAPHIC data type support is not yet supported for
  Oracle target.
  
  Problem 2:
  Q Subscriptions to a Sybase target table are generated partially
  because the generated SQL script fails on the Q Apply database.
  Possible work around: Create target table in Sybase and use this
  existing target when creating the Q subscription.
  
  Problem 3a:
  While creating Q Subscriptions when the source is on z/OS and
  target is federated (Oracle or Sybase), for some data types
  where DEFAULT keyword is present with no value after it, some
  columns in Sybase and Oracle targets get generated without a
  value added, which is invalid syntax for Sybase and Oracle.
  
  Problem 3b:
  While creating Q Subscriptions involving mapping a z/OS LONG
  VARCHAR source column to the Oracle 9 target, an alter column on
  nickname is generated but it should not be and this results in
  SQL failure.
  

Local fix

• none specified
  

Problem summary

• AS DESCRIPED IN THE APAR DESCRIPTION
  

Problem conclusion

• FIXED IN THE API CODE
  

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

• NONW
  

Fix information

• Fixed component name

  WS II REPLICATI

• Fixed component ID

  5724C7415

Applicable component levels

• R820 PSY

     UP