DB2 Database Migration

DB2 Database Migration

Environment Introduction:

Original database: DB2 V10.5.3 database under Windows Server 64bit R2

Target database: DB2 V10.5.3 database under RHEL 7.0 64bit

Migration method: Using the Db2move and Db2look tools

2. First, export the table structure and table data from Windows:

   A. Prepare the catalogue D:\yjmhbak for storing the data files;

   B. Use an account with database permissions for database connectivity, export, and more. If you want to add an account to the Db2admns group.

4. Export Data:

   
   

6. D:\yjmhbak>db2stop Force

8. 2017-11-15 14:39:06 0 0 sql1064n db2stop processing succeeded.

10. sql1064n db2stop processing succeeded.

12. 
    

14. D:\yjmhbak>db2start

16. 2017-11-15 14:39:24 0 0 sql1063n db2start processing succeeded.

18. sql1063n Db2start processing succeeded.

20. 
    

22. D:\yjmhbak>db2move YJMH Export-aw

24. 
    

26. Db2move * * * *

28. 
    

30. Action:export

32. 
    

34. Start time:wed Nov 15 14:39:58 2017

36. 
    

38. 
    

40. Connecting to database YJMH ... successful! SERVER:DB2 Common Server V10.5.3

42. 
    

44. export:108 rows from table "SysTools". " Altobj_info "

46. export:0 rows from table "SysTools". " Fed_cache_mqts "

48. export:0 rows from table "SysTools". " Fed_cache_options "

50. export:191 rows from table "SysTools". " Hmon_atm_info "

52. export:0 rows from table "SysTools". " Hmon_collection "

54. Export:5 rows from table "SysTools". " POLICY "

56. export:1 rows from table "SysTools". " Stmg_dbsize_info "

58. export:15085 rows from table "Futurecloud". " T_account "

60. export:325 rows from table "Futurecloud". " T_ACCOUNT_BK "

62. export:3202311 rows from table "Futurecloud". " T_account_function "

64. export:1816 rows from table "Futurecloud". " T_account_messageaddresslist "

66. export:476 rows from table "Futurecloud". " T_account_messagegroup "

68. export:30265 rows from table "Futurecloud". " T_account_messagesearch "

70. export:1371358 rows from table "Futurecloud". " T_account_module "

72. export:17007 rows from table "Futurecloud". " T_account_question "

74. export:49830 rows from table "Futurecloud". " T_account_role "

76. export:20028 rows from table "Futurecloud". " T_addresslist "

78. export:2821 rows from table "Futurecloud". " t_addresslist_0214 "

80. export:2367 rows from table "Futurecloud". " t_addresslist_021416 "

82. export:0 rows from table "Futurecloud". " T_ADDRESSLIST_BK "

84. export:0 rows from table "Futurecloud". " T_addresslist_temp "

86. export:13 rows from table "Futurecloud". " T_adminauthority "

88. Export:11 rows from table "Futurecloud". " T_application "

90. export:14 rows from table "Futurecloud". " T_application_areainfo "

92. export:1966 rows from table "Futurecloud". " T_areagroup "

94. export:4612 rows from table "Futurecloud". " T_areainfo "

96. export:14947 rows from table "Futurecloud". " T_department "

98. export:8640 rows from table "Futurecloud". " t_department_0311 "

100. export:61 rows from table "Futurecloud". " T_dictionary "

102. export:64 rows from table "Futurecloud". " T_duty "

104. export:703 rows from table "Futurecloud". " T_function "

106. export:1413501 rows from table "Futurecloud". " T_log "

108. export:93647 rows from table "Futurecloud". " T_loginrecord "

110. export:72 rows from table "Futurecloud". " T_log_directory "

112. export:1599 rows from table "Futurecloud". " T_mac_areacode "

114. export:23 rows from table "Futurecloud". " T_messagesearch "

116. export:205 rows from table "Futurecloud". " T_module "

118. export:10700 rows from table "Futurecloud". " T_news "

120. export:82000 rows from table "Futurecloud". " T_numbersearch "

122. export:2050 rows from table "Futurecloud". " T_receivemessage "

124. export:7992 rows from table "Futurecloud". " T_role "

126. export:9216 rows from table "Futurecloud". " T_role_function "

128. export:7400 rows from table "Futurecloud". " T_securitycode "

130. export:51823 rows from table "Futurecloud". " T_sendmessage "

132. export:570 rows from table "Futurecloud". " T_sms_number "

134. export:285 rows from table "Futurecloud". " T_timermessage "

136. export:1750985 rows from table "Futurecloud". " T_webservicelog "

138. 
     

140. Disconnecting from Database ... successful!

142. 
     

144. End time:wed Nov 15 14:57:21 2017

146. D:\yjmhbak>

Export Complete!

This article from "Flower of Xu's blog" blog, declined reproduced!

DB2 Database Migration