Db2 error during WCM 7 Syndication

  • 31 Aug, 2012

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

Next

Related Posts

Proud to be an HCL Ambassador 2021

  • 15 Dec, 2020

​If you have a problem, and no-one else can help, and if you can find them, maybe you can ask an HCL Ambassador… !(http://www.mysphere.com.br/wp-content/uploads/2020/12/HCLAmbassaborlight4x.png) See

Proud to be an HCL Ambassador 2021Read More

WebSphere Application Server Configuration Comparison Tool

  • 06 Sep, 2019

The Configuration Comparison Tool (CCT) is a lightweight wsadmin script and Python report generation script which will produce HTML reports on configuration settings for the following types of resourc

WebSphere Application Server Configuration Comparison ToolRead More

IBM Support Community for Digital Experience Products

  • 07 Nov, 2017

In the next week Digital Experience products: • WebSphere Portal • Web Content Manager • Digital Experience Patterns • Digital Experience on Cloud • Forms Experience Builder • Forms Experience Builde

IBM Support Community for Digital Experience ProductsRead More