When DB2 Database is used for the Domain creation the following SQL error is reported : Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;TIBCTEST, DRIVER=3.64.82
Article ID: KB0085017
Updated On:
| Products | Versions |
|---|---|
| TIBCO Runtime Agent (TRA) | - |
| Not Applicable | - |
Description
Resolution:
The error is specific to DB2 and the page size of DB created.
The error is specific to DB2 and the page size of DB created.
*****************************************************************
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;TIBCTEST, DRIVER=3.64.82
*****************************************************************
Cause
=====
The database mapping file defines a table with more columns than it can be contained in the current database table that created.
Resolution
=======
Delete the database and recreate it with a larger page size.
Example command: CREATE DB database_name PAGESIZE size.
Used the page size 32 k for DB2 as the database for domain creation. Note: Consult your DB2 DBA/Administrator prior to making changes.
Issue/Introduction
When DB2 Database is used for the Domain creation the following SQL error is reported : Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384;TIBCTEST, DRIVER=3.64.82
Additional Information
IBM docs
Feedback
Yes
No
Powered by
