IAM is not starting when configured with DB2

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