本篇文章主要介绍了"DB2搭建SQL复制环境",主要涉及到表空间方面的内容,对于DB2感兴趣的同学可以参考一下:
摘要: 本文在同一个数据下,搭建了一个SQL复制的环境,并做了相关的测试~[背景知识]在搭建环境之前,您需要了解SQL复制中基本的概念,比如capture, a...
employee表一定要有primary key或者unique index,否则会失败。
第一次试验的时候,创建表定义如下
$ db2 "create table employee(id int, FIRSTNAME char(20), GIVENNAME char(20))"
结果在启动apply的时候,报出以下错误
$ asnapply c apply_qual=MYQUAL1
2015-12-06-10.48.25.284625 ASN0600I "Apply" : "" : "Initial" : Program "apply 9.7.6" is starting.
2015-12-06-10.48.25.943151 ASN1045I APPLY "MYQUAL1" : "Initial" : The Apply version "9.7.6" program was started using database "SAMPLE".
2015-12-06-10.48.26.080955 ASN1008E APPLY "MYQUAL1" : "WorkerThread". The subscription set with Apply qualifier "MYQUAL1" and set name "SET00" is not defined correctly. ERRCODE is "43080D".
[参考资料]
https://www.ibm.com/developerworks/community/files/basic/anonymous/api/library/87742721-7cfd-4134-bba6-c23dc23fd5b1/document/cd1a8685-22f8-490c-8bc3-d3b87a292036/media
以上就介绍了DB2搭建SQL复制环境,包括了表空间方面的内容,希望对DB2有兴趣的朋友有所帮助。
本文网址链接:http://www.codes51.com/article/detail_240526_2.html