Unable to create database tables during server install

Document ID : KB000044419
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue 

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 

Environment:  

AIX

IBM DB2

Cause: 

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."

Resolution:

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

Additional Information:

https://www-304.ibm.com/support/docview.wss?uid=swg21414318