db2move迁移数据遇到锁
来源:互联网 发布:天池大数据竞赛 案例 编辑:程序博客网 时间:2024/06/10 05:31
环境说明
Linux DB2 V10.1
- [db2inst2@kvm101 migrate_repdb01]$ db2level
- DB21085I This instance or install (instance name, where applicable:
- "db2inst2") uses "64" bits and DB2 code release "SQL10014" with level
- identifier "0205010E".
- Informational tokens are "DB2 v10.1.0.4", "s140509", "IP23584", and Fix Pack
- "4".
- Product is installed at "/opt/ibm/db2/V10.1.0.5".
数据库有一个capture在运行.
新建目录 migrate_repdb01
cd migrate_repdb01
开始使用db2move导出数据
点击(此处)折叠或打开
- [db2inst2@kvm101 migrate_repdb01]$ db2move repdb01 export
- Application code page not determined, using ANSI codepage 1208
- ***** DB2MOVE *****
- Action: EXPORT
- Start time: Wed Jun 8 13:46:39 2016
- Connecting to database REPDB01 ... Server : DB2 Common Server V10.1.4
- Binding package automatically ... /home/db2inst2/sqllib/bnd/db2common.bnd ...
- Binding package automatically ... /home/db2inst2/sqllib/bnd/db2move.bnd ...
- EXPORT: 2004 rows from table "ASN "."ASNTDIFF"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT0"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT1"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT2"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT3"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT4"
- EXPORT: 0 rows from table "DB2CAE2 "."CDT5"
- EXPORT: 0 rows from table "DB2CAE2 "."CDTEST01"
- EXPORT: 178 rows from table "SYSTOOLS"."HMON_ATM_INFO"
- EXPORT: 0 rows from table "SYSTOOLS"."HMON_COLLECTION"
- EXPORT: 14 rows from table "ASN "."IBMQREP_COLVERSION"
- EXPORT: 0 rows from table "ASN "."IBMQREP_IGNTRAN"
- EXPORT: 0 rows from table "ASN "."IBMQREP_IGNTRANTRC"
- EXPORT: 0 rows from table "ASN "."IBMQREP_PART_HIST"
- EXPORT: 7 rows from table "ASN "."IBMQREP_TABVERSION"
问题来了,就一直卡在这里没有进展.....卡住
使用db2top快速查看session情况
发现db2move处于Lock waiting状态
进一步查看Lock Chain:
发现db2move会话被865号会话阻塞
是capture数据复制,暂停capture
随后db2move立刻继续数据导出:
恢复正常,继续导出数据后,进行数据库的迁移。
使用db2top快速查看session情况
发现db2move处于Lock waiting状态
进一步查看Lock Chain:
发现db2move会话被865号会话阻塞
是capture数据复制,暂停capture
- nohup asnccmd capture_server=repdb01 capture_schema=asn stop &
随后db2move立刻继续数据导出:
- EXPORT: 0 rows from table "ASN "."IBMSNAP_CAPENQ"
- EXPORT: 2012 rows from table "ASN "."IBMSNAP_CAPMON"
- EXPORT: 1 rows from table "ASN "."IBMSNAP_CAPPARMS"
- EXPORT: 1 rows from table "ASN "."IBMSNAP_CAPSCHEMAS"
- EXPORT: 8103 rows from table "ASN "."IBMSNAP_CAPTRACE"
- EXPORT: 7 rows from table "ASN "."IBMSNAP_PRUNCNTL"
- EXPORT: 0 rows from table "ASN "."IBMSNAP_PRUNE_LOCK"
- EXPORT: 3 rows from table "ASN "."IBMSNAP_PRUNE_SET"
- EXPORT: 8 rows from table "ASN "."IBMSNAP_REGISTER"
- EXPORT: 1 rows from table "ASN "."IBMSNAP_RESTART"
- EXPORT: 0 rows from table "ASN "."IBMSNAP_SIGNAL"
- EXPORT: 0 rows from table "ASN "."IBMSNAP_UOW"
- EXPORT: 5 rows from table "SYSTOOLS"."POLICY"
- EXPORT: 3986 rows from table "DB2CAE2 "."T0"
- EXPORT: 3999999 rows from table "DB2CAE2 "."T1"
- EXPORT: 3999999 rows from table "DB2CAE2 "."T2"
- EXPORT: 3 rows from table "DB2CAE2 "."T3"
- EXPORT: 3 rows from table "DB2CAE2 "."T4"
- EXPORT: 3 rows from table "DB2CAE2 "."T5"
- EXPORT: 20 rows from table "DB2CAE2 "."TEST01"
- Disconnecting from database ...
- End time: Wed Jun 8 14:23:01 2016
1 0
- db2move迁移数据遇到锁
- DB2迁移(db2look+db2move)
- db2move 数据导出整理
- db2move 数据导出整理
- DB2MOVE
- db2move
- DB2MOVE 命令导出导入数据
- db2 导出数据 db2move &dbname export
- 数据迁移中遇到的问题
- SVN迁移数据遇到的问题
- db2move,db2look使用及所遇到问题详解
- db2move用法
- 数据迁移
- 数据迁移
- 数据迁移
- 数据迁移
- 数据迁移
- 数据迁移
- Undefined symbols for architecture arm64: "std::string::push_back(char)", referenced from:
- QtCreator2.8.0+QtOpenSource4.8.5环境配置(初学者必看)
- 工厂方法模式
- jquery添加元素
- Git分支管理
- db2move迁移数据遇到锁
- 浅析移动云计算服务端技术
- Android开发百度地图显示不出来-签名文件
- nodejs中tcp服务器和http服务器实现的异同
- 实现PHP服务器+Android客户端(Retrofit+RxJava)第三天Retrofit的配置以及缓存的实现
- 散列表的基本概念
- post提交数据
- c++删除文件夹内指定批量txt文件的前n行
- 第1章:Introduction