Guest User

Untitled

a guest
Jul 7th, 2018
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. [PEM@db db2-updater]$ bin/tool/liquibase/liquibase --changeLogFile=`pwd`/bin/tool/liquibase/masterchangelog.xml --username=usernameXYZ --password=XYZPASS --url=jdbc:db2:DBP changelogSyncSQL
  2. Liquibase Home: /home/myhomedir/db2-updater/bin/tool/liquibase
  3. -- *********************************************************************
  4. -- SQL to add all changesets to database history table
  5. -- *********************************************************************
  6. -- Change Log: /home/myhomedir/db2-updater/bin/tool/liquibase/masterchangelog.xml
  7. -- Ran at: 7/6/18 3:43 PM
  8. -- Against: XYZ@jdbc:db2:DBP
  9. -- Liquibase version: 3.5.3
  10. -- *********************************************************************
  11.  
  12. -- Lock Database
  13. 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;
  14.  
  15. 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');
  16.  
  17. -- Release Database Lock
  18. UPDATE XYZ.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
Add Comment
Please, Sign In to add comment