在配置两个数据库之间表复制时出现SQLSTATE=42997错误

huajieaixue

在配置两个数据库之间表复制时出现SQLSTATE=42997错误


在配置两个数据库复制的过程中，对多表（100多个表）注册CAPTURE的CD TABLE时出现错误
请求高人指明原因~~

错误日志如下：
IBM][CLI Driver][DB2/NT64] SQL0270N  Function not supported
(Reason code = "83".  SQLSTATE=42997
Capability is not supported by this version of the DB2 application requester, DB2 application server, or the combination of the two.
（此版本的DB2应用程序请求器、DB2应用程序服务器或两者的组合不支持该功能）

Explanation:
The statement cannot be processed because it violates a
restriction as indicated by the following reason code:
1 The primary key, each unique constraint, and each unique index
must contain all distribution columns of the table (columns may   
appear in any order).  
2 Update of the distribution key column value is not         
supported.  
3 A foreign key cannot include any nullable distribution key     
columns when defined with ON DELETE SET NULL.  This is a special  
case of reason code 2 since defining such a constraint would      
result in attempting to update a distribution key column.  
4 A table defined using a multipartition nodegroup or a         
single-partition nodegroup on other than the catalog partition   
does not support DATA CAPTURE CHANGES.  
5 Views created with the WITH CHECK OPTION clause should not use
functions (or reference views that use functions) that:
o   are non-deterministic
o   have side effects
o   are related to the placement of data (for example nodenumber  
    or partition functions).  
These functions must also not be present within referenced views  
if the new view is created with the CASCADED check option.  
6 A transform cannot be defined for a user-defined distinct      
type.  
7 Long fields can only be defined using a table space with a     
page size that is 4K.  A LARGE TABLESPACE can only be created     
using a 4K page size.  
8 Structured types are not supported as columns of a table or   
structured type attribute data types prior to DB2 Version 7.1.  
9 Triggers are not supported on typed tables.  
10 A single default table space cannot be selected since the     
table has one or more LOB columns which must be placed in a table
space with a 4K page size and the rowsize or number of columns in
the table requires a table space with an 8K page size.  
。。。。。。
83 The statement cannot be processed because DATA CAPTURE        
CHANGES and COMPRESS YES are not compatible.  
。。。。。。