Liquibase on System i (AS400) - Does it work?

Hello Folks! 


I’m trying to use Liquibase for our AS400 DB2 database. I keep getting…


PK_DATABASECHANGE in PMD1 type *N already exists


I delete it, run again and it gets recreated, and then throws the above exception anyhow. 


       

   


Any ideas?


Thank You!


Gary

It works! 


I needed to create the schema using SQL. A schema created with the AS400 command CRTLIB does not work. However, you can still copy AS400 artifacts into the schema (Library in AS400 terms) created by SQL. 


I also needed to set the following in the ANT updateDatabase task; 


defaultschemaname=“PMD1”

databasechangeloglocktablename=“LIQUIBASE_LOCK”

databasechangelogtablename=“LIQUIBASE_CHANGELOG”


I also needed to set the schema on the connection URL;

jdbc:as400://10.5.0.9/PMD1;prompt=false"

Great to hear. Thanks for the update


Nathan