How to batch executing SQL statements on db2

来源：互联网发布：传奇霸业轮回数据库编辑：程序博客网时间：2024/06/04 18:57

1）Use UltraEdit tool to prepare the sql file. For example:bssmock.sql

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, '7NUAiKrSQuyC9bixn97tSA', 1, 'ba3bcb81-76f7-40fb-be6e-8653e5a1c218', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, '@6S6QlFDSeWlr3u2R_YTTw', 3, '6c12190a-146e-4156-9231-4141034fe678', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, '@6S6QlFDSeWlr3u2R_YTTw', 3, '7ebd9aac-9d21-4399-9852-b7e6b2195256', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'wBGeqPw3R3q87d95yo6jEg', 1, 'e0e0921a-1d9c-4123-b3c3-ecdd96e57af5', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'wBGeqPw3R3q87d95yo6jEg', 1, '8be2a483-faf2-4ab5-b3a2-703c4f06b318', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'sGoH64CAQtCGi8Rq6YeS6g', 1, 'ddb42ea7-2b59-462b-a7d3-e9f4b11892d2', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'sGoH64CAQtCGi8Rq6YeS6g', 1, '8ee157ef-ba2e-4bc5-a4e2-21fe5816f75d', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'T9WxP2iSQlOirjKlKqFZrA', 4, '83cda3cf-c3ef-449b-a976-7dc9cd6e08ea', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'A8NvjFn8S0mPyTYDxIJlaw', 4, '563cd86f-b9cf-40fc-90e7-e03367413745', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'eweYr3CTSuSCE5@VdoDnIA', 4, '2e4d4475-efa8-4f7f-b455-90c548ae8e11', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'LaNKXd_fQwyXYoIBI1JtBQ', 3, 'dd69843d-4010-4d68-8b78-bf058f31ca1d', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'MMYBXIRfT0a7KxmLv6cOzw', 3, '89bea364-9612-4b16-a088-198316e64cf4', null, 'DTCVS', null, null);

INSERT INTO OPENSTK.DEPLOYMENTINSTANCE(DEPLOYMENTID, RESOURCEUUID, DEPLOYMENTSTATE, OPENSTACKID, CREATETIMESTAMP, INSTANCETYPE, MODE, CURRENTTIMESTAMP) VALUES (null, 'stTPKxR1QtO_Nr10hUw2zw', 3, '43ade785-4922-4972-8bc1-026b901d617e', null, 'DTCVS', null, null);

2) connect to db2

Use command ：db2 connect to db_name user user_name using password

For example: db2 connect to db2inst1 user db2inst1 using passw0rd

3) execute the import command

Use command: db2 –tvf

For example: db2 –tvf /home/db2inst1/bssmock.sql >> /home/db2inst1/bssmock.log