When creating a domain with DB2 - using DB2 native drivers fail due to DB2 SQL Error: SQLCODE=-286 .

When creating a domain with DB2 - using DB2 native drivers fail due to DB2 SQL Error: SQLCODE=-286 .

book

Article ID: KB0094209

calendar_today

Updated On:

Products Versions
TIBCO Administrator -
Not Applicable -

Description

Resolution:
Description:
============
When creating a domain with DB2 - using DB2 native drivers fail due to DB2 SQL Error: SQLCODE=-286 .

Environment:
===========
TIBCO Runtime Agent(TRA) 5.6.x ,TIBCO Administrator 5.6.x

Details:
=======
When creating a database with DB2, the default bufferpool and tablespace size is 4K. Some tables  cannot be created and fail with a severe error.
========================
DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=16384
========================

  
Resolution:
=========

When creating the database in DB2, make sure that the bufferpool and tablespace size is 16K or 32K.

Issue/Introduction

When creating a domain with DB2 - using DB2 native drivers fail due to DB2 SQL Error: SQLCODE=-286 .