Db2 error during WCM 7 Syndication

Share

When the syndication happens i see this error DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=4096 on the SystemOut.log.

This problem can be solved tunning the JCRDB and running a reorg on the tables.

I use the following commands:

db2 CONNECT TO JCRDB USER db2inst1
db2 update db cfg for JCRDB using DBHEAP 4800
db2 reorgchk current statistics on table all > “reorg.txt”
db2 -x “select ‘reorg table’,substr(rtrim(tabschema)||’.’||rtrim(tabname),1,50),’;’from syscat.tables where type = ‘T’ ” > reorg.out
db2 -tvf reorg.out