IAM is not starting when configured with DB2

Article Id: 141723

Status: Published

Updated On: 12-12-2019 09:05

Products:

CLOUDTEST , CA Application Test , CA Cloud Test Mobile , MOBILECLOUD , Service Virtualization

Issue/Introduction:

When starting IAM service after DB2 configuration is failing with the below error

ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 56) Change Set META-INF/jpa-changelog-1.1.0.Beta1.xml::1.1.0.Beta1::[email protected] failed. Error: DB2 SQL Error: SQLCODE=-670, SQLSTATE=54010, SQLERRMC=8101;USERSPACE1;8116, DRIVER=4.18.60 [Failed SQL: ALTER TABLE CASVUDB1.REALM ADD CERTIFICATE VARCHAR(2048)]: liquibase.exception.DatabaseException: DB2 SQL Error: SQLCODE=-670, SQLSTATE=54010, SQLERRMC=8101;USERSPACE1;8116, DRIVER=4.18.60 [Failed SQL: ALTER TABLE CASVUDB1.REALM ADD CERTIFICATE VARCHAR(2048)]

Cause:

This is causing due to DB2 database configured for IAM is allocated with default USERSPACE of 8k. Recommended page size is 16k

Environment:

Release : 10.5

Component : CA Service Virtualization

Database: DB2

Resolution:

We recommend to use 16k page size for DB2 database which you will use it for IAM. So that, Alter statements with more column size spaces are arranged by DB2 database