[Liquibase-user] REORG function for an addPrimary

[Thanh Nguyen]

Hi all, I am executing this changeset on a DB2 database:     <changeSet id="create-constraints" author="silanis">      <addPrimaryKey tableName="AWS_MERCHANT constraintName="PK_AWS_MERCHANT"     columnNames="MERC_NAME"/>     </changeSet> Strangely, Liquibase generates a "REORG" call instead of the expected add primary key: org.apache.maven.lifecycle.LifecycleExecutionException: Error setting up or running Liquibase: Migration failed for change set target/classes/changelogs/changelog-Z.5-create-constraints.xml::create-constraints-AWS_MERCHANT::silanis:      Reason: liquibase.exception.JDBCException: Error executing SQL CALL SYSPROC.ADMIN_CMD ('REORG TABLE SCHEMA_SOURCE.AWS_MERCHANT'):           Caused By: Error executing SQL CALL SYSPROC.ADMIN_CMD ('REORG TABLE SCHEMA_SOURCE.AWS_MERCHANT'):           Caused By: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: SYSPROC.ADMIN_CMD;PROCEDURE at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:583) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:499) ??? Help please... tom nguyen.

---

Yahoo! Canada Toolbar : Search from anywhere on the web and bookmark your favourite sites. Download it now!

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Liquibase-user mailing list
Liquibase-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/liquibase-user