IAM is not starting when configured with DB2

book

Article ID: 141723

calendar_today

Updated On:

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