The following error is encountered when Installing CA Workload Automation DE using IBM's DB2 database:
FATAL ERROR - com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;CAWA, DRIVER=3.50.152
Workload Automation DE-High Availability
AIX
IBM DB2
According to IBM's website, "Your database mapping file defines a table with more columns than can be contained in the current database table that you created."
Delete the database that you created and recreate it with a larger page size. For example, enter the command CREATE DB database_name PAGESIZE size.
To determine the page size to specify, check the value of the SQLERRMC parameter in the error message that appears in the export audit log in the ES_NODE_ROOT/logs/audit directory. For example, if the following message appears in the audit log, create a database with a page size of 8192 or higher:
com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192 ;DB2ADMIN, DRIVER=3.50.152
The content of this article is taken directly from the following IBM URL.
https://www-304.ibm.com/support/docview.wss?uid=swg21414318
Please contact IBM for further assistance as needed on this specific issue.