If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > UDB Replication (V8 FP5) with UDT's...?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-05-04, 14:53
sphelical sphelical is offline
Registered User
 
Join Date: Aug 2004
Posts: 6
Thumbs down UDB Replication (V8 FP5) with UDT's...?

Anyone have any luck getting UDB Replication going on ANY platform for that matter with UDT's?

IBM Doc states the following:
Replication of UDT's is possible...
1. The CD Tables need to be change to base "sysibm" datatypes (done).
2. If the GUI (rep center) generates the target table DDL, it will create with base datatypes as well.

#2 Above cannot be done in my case. We replicate to failover DB, which is a backup / restore copy from prod, so the UDT's must stay in place (also for the app to function in a failover scenario).

SQL -432 when run with just CD tables set to base datatypes when apply tries to modify the targets.

SQL -151 when i repoint apply to a view I created with the CAST'ing already done. Unfortunately, it looks like CAST is a one way deal...select from the view no problem, but update generates the above...

Any suggestions? success stories?

Thanks...
Reply With Quote
  #2 (permalink)  
Old 08-05-04, 17:39
sphelical sphelical is offline
Registered User
 
Join Date: Aug 2004
Posts: 6
just got word from IBM as per PMR 94441...

no. the target tables must be set to base datatypes...UDT's on the target will fail at V8 FP5 repl.

thanks anyway.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On