The following command runs successfully create a DEPARTMENT table and
liquibase --driver=com.ibm.db2.jcc.DB2Driver --classpath=“D:\DB2Jars\dbjars\db2jcc.jar;D:\DB2Jars\dbjars\db2jcc_license_cu.jar” --changeLogFile=D:\eclipse-workspace\src\main\java\com\dst\hps\pmab\liquibase\basic-Changeset.xml --url=“jdbc:db2://localhost:50000/PMAB1:currentSchema=PMAB_DEMO;retrieveMessagesFromServerOnGetMessage=true;driverType=4;” --username=username --password=password migrate
The following command fails
liquibase --driver=com.ibm.db2.jcc.DB2Driver --classpath=“D:\DB2Jars\dbjars\db2jcc.jar;D:\DB2Jars\dbjars\db2jcc_license_cu.jar” --changeLogFile=D:\eclipse-workspace\src\main\java\com\dst\hps\pmab\liquibase\basic-Changeset1.xml --url=“jdbc:db2://localhost:50000/SAMPLE1:currentSchema=SAMPLE;retrieveMessagesFromServerOnGetMessage=true;driverType=4;” --username=username --password=password migrate
at liquibase.integration.commandline.Main.main(Main.java:116)
Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED SMALLINT NOT NU
LL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGE PRIMARY KEY (ID)); on jdbc:db2://DTHP0310:50000/PMAB1INSERT INTO D
ATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0): The name of the object to be created is identical to the existing name “PMAB_DEMO.DATABASECHANGE
LOGLOCK” of type “TABLE”.
The DATABASECHANGELOGLOCK…LOCKED=1 after the first command.
Please help to resolve this