Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [PEM@db db2-updater]$ bin/tool/liquibase/liquibase --changeLogFile=`pwd`/bin/tool/liquibase/masterchangelog.xml --username=usernameXYZ --password=XYZPASS --url=jdbc:db2:DBP changelogSyncSQL
- Liquibase Home: /home/myhomedir/db2-updater/bin/tool/liquibase
- -- *********************************************************************
- -- SQL to add all changesets to database history table
- -- *********************************************************************
- -- Change Log: /home/myhomedir/db2-updater/bin/tool/liquibase/masterchangelog.xml
- -- Ran at: 7/6/18 3:43 PM
- -- Against: XYZ@jdbc:db2:DBP
- -- Liquibase version: 3.5.3
- -- *********************************************************************
- -- Lock Database
- UPDATE XYZ.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'db.test.net (192.168.1.1)', LOCKGRANTED = TIMESTAMP('2018-07-06 15:43:32.407') WHERE ID = 1 AND LOCKED = 0;
- INSERT INTO XYZ.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2.1.2-fix', 'DB', 'db/ddlchangelog.xml', CURRENT TIMESTAMP, 1, '7:ef412d3bf251a59cfe9d990085aee090', 'sqlFile', '', 'EXECUTED', NULL, NULL, '3.5.3', '0891813742');
- -- Release Database Lock
- UPDATE XYZ.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
Add Comment
Please, Sign In to add comment