Skip to main content

SQL0614N Error When Creating DB2 Workspace in Enterprise Analyzer

  • April 1, 2015
  • 0 replies
  • 0 views

Michael Tong

Problem:

When user attempts to create Workspace using DB2, receives error DBERR : [IBM][CLI Driver][DB2/NT64] SQL0614N  The index or index extension "CONTEXT_1" cannot be created or altered because the combined length of the specified columns is too long.  SQLSTATE=54008.

Resolution:

During setup of the DB2 server, the tablespace page size should be 32K.  This will allow for a key that is larger than 4K, which is the index being referenced in the error message.  The installation guide for Enterprise Analyzer specifically lists this requirement for a 32K tablespace page size.


#EnterpriseAnalyzer
#DB2
#SupportTip

0 replies

Be the first to reply!