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)]
This is causing due to DB2 database configured for IAM is allocated with default USERSPACE of 8k. Recommended page size is 16k
Release : 10.5
Component : CA Service Virtualization
Database: DB2
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