--SQL1047N 应用程序已经与另一个数据库相连
db2 connect reset
https://www.cnblogs.com/simon6623/p/8663719.html
--创建数据库
db2 CREATE DATABASE qhysjh AUTOMATIC STORAGE YES ON 'C:\work\database\db2_data' DBPATH ON 'C:' USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM PAGESIZE 4096--备份数据库
CONNECT TO QHYSJH;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE QHYSJH TO "C:\" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO QHYSJH;
UNQUIESCE DATABASE;
CONNECT RESET;
--还原数据库
db2 RESTORE DATABASE qhysjh FROM C:\QHYSJH.0.DB2.NODE0000.CATN0000.20220208084148.001 TAKEN AT 20220208084148 TO C: INTO QHYSJH WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。