Unable to create database tables during server install

Products

• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

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

Workload Automation DE-High Availability

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

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.