Upgrading V8 to V9.5 replication

redwolf · #1 (**permalink**) 03-23-09, 10:55

Did anyone encounter issues with the IBMSNAP_CAPMON table in V9.5. Apparently there are 4 new columns required on this table in V9.5. I added those columns, but now I'm getting this error:

2009-03-23-10.44.16.092178 SQL0104N "Capture" : "ASN" : "AdminThread" : An unexpected token "," was found following "NULL, ?, ?, ?, ?, ?".
Expected tokens may include: ")". SQLSTATE=42601

TIA for your help.

stolze · #2 (**permalink**) 03-23-09, 12:58

I don't know the details, but I would assume that you have to go through a migration process for replication as well. Did you do that?

przytula_guy · #3 (**permalink**) 03-24-09, 10:04

you don't have to modify any table
there are some jobs/executables to export/drop/create load old data in new tables
have a look at replication guide and look for migration
straight forward

Internet Services

Web Development

Digital Marketing

Consumer Tech