环境说明
-
[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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29023300/viewspace-2117439/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
