请åèï¼
http://www.ibm.com/developerworks/cn/data/library/techarticle/dm-1403db2_migration/index.htmlå级ååå¤
å级ä¹åï¼å®¢æ·éè¦èèå级æ¡ä»¶æ¯å¦å
·å¤ï¼ç¶åå¶å®å级计åã
æ£æ¥å级æ¡ä»¶
主è¦ä»ä¸¤æ¹é¢æ¥æ£æ¥æ¯å¦æ¯æ DB2 åçº§å° V10.5 çæ¬ãå¨ DB2 çæ¬æ¹é¢ï¼åªæ¯æç´æ¥ä» DB 9.7 ä¹åï¼å«ï¼ççæ¬å级ï¼å¦ææ¯æ´ä½ççæ¬å¦ DB2 9.5ï¼éè¦å
åçº§å° 9.7 æ 10.1ï¼ç¶åååçº§å° V10.5ã建议å°DB2 åçº§å° V9.7 æ V10.1 ææ°ç FIXPACKãå¨æä½ç³»ç»æ¹é¢ï¼DB2 V10.5 å¨è½¯ä»¶ãéä¿¡ãç£çåå
åæ¹é¢å¯¹ä¸åæä½ç³»ç»æä¸åçæä½è¦æ±ï¼å æ¤åºå½ç¡®ä¿æéæä½ç³»ç»æ»¡è¶³è¿äºè¦æ±ãæ¬æä¸è¯¦ç»ä»ç» ä¸åæä½ç³»ç»å®è£
V10.5 çææè¦æ±ãDB2 å®è£
软件ä¸æä¾äºä¸ä¸ªå¾å¥½çå·¥å
· db2prereqcheck æ¥æ£æ¥ç³»ç»æ¯å¦æ»¡è¶³å®è£
å
å³æ¡ä»¶ï¼èä¸å¿
ç´æ¥å¼å§å®è£
ç¹å®ç DB2 çæ¬ãæ¤å½ä»¤æ£æ¥å
å³æ¡ä»¶ï¼ä¾å¦ï¼æä½ç³»ç»çº§å«ã客æ·æºæç¹å®äº DB2 pureScale ç¹æ§çè¦æ±ççã
æ¸
å 1. æ¸
å 1. Windowns ç³»ç»ä¸ db2prereqcheck å½ä»¤è¾åº
D:\WINDOWNS_AMD64\ESE\image>db2prereqcheck.exe -v 10.5.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version "10.5.0.0" on operating system
"Windows"
Required minimum version : "Windows 2012" SP "0"
Actual version detected: "Windows 2012" SP "0"
OS is Windows "Server"
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites
were met.
å¦æ db2prereqcheck æ§è¡æåï¼è¯´ææ¤ç³»ç»æ»¡è¶³ææçå®è£
æ¡ä»¶ãå¦æåç°æ¡ä»¶ä¸ç¬¦åï¼é£ä¹å°ä¼è¿åå¦æ¸
å 1 æ示çé误信æ¯ï¼ååºææå®è£
çå
å³æ¡ä»¶ã客æ·å°±éè¦æ ¹æ®é误信æ¯ï¼éä¸æ»¡è¶³ãä¸ç´å°è¿è¡æ¤å·¥å
·ä¸ååºç°é误信æ¯ä¸ºæ¢ã
å®é
ä¸ï¼å¦æè¿è¡ä¸å¸¦ä»»ä½åæ°ç db2prereqcheck å½ä»¤ï¼é£ä¹è¯¥å½ä»¤å°æ£æ¥ç³»ç»æ¯å¦æ»¡è¶³ææ DB2 åè¡çå修订å
çå
å³æ¡ä»¶ãè¦æ£æ¥ç³»ç»æ¯å¦æ»¡è¶³ç¹å® DB2 çæ¬çå
å³æ¡ä»¶ï¼è¦è¿è¡å¸¦æ -v åæ°ç db2prereqcheck å½ä»¤ãå¯¹äº DB2 pureScale ç¹æ§å®è£
ï¼éä½¿ç¨ -p é项ã对äºå®¢æ·æºå®è£
ï¼éä½¿ç¨ -c é项ã
æ¸
å 2. æ¸
å 2. AIX ç³»ç»ä¸ db2prereqcheck å½ä»¤è¾åº
bash-4.2# ./db2prereqcheck -p -v 10.5.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version "10.5.0.0" on operating system "AIX"
Validating "kernel level " ...
Required minimum operating system kernel level: "6.1".
Actual operating system kernel level: "7.1".
Requirement matched.
Validating "AIX technology level and service pack " ...
Required minimum technology level: "0" Service pack: "3"
Actual technology level: "2" Service pack: "1"
Requirement matched.
Validating "XL C/C++ Runtime" ...
Required minimum "XL C/C++ Runtime" level: "11.1.0.1"
Actual version: "12.1.0.1"
Requirement matched.
Validating "openssh" ...
Found package "openssh" on host "sapaix8".
Requirement matched.
Validating "IOPORTS" ...
The input/output completion Port (IOCP) is installed on host "sapaix8".
The input/output completion Port (IOCP) is enabled on host "sapaix8".
Requirement matched.
Validating "free space" ...
The directory "/tmp" has enough space on host "sapaix8".
Requirement matched.
Validating "free space" ...
The directory "/var" has enough space on host "sapaix8".
Requirement matched.
Validating "free space" ...
DBT3594W The db2prereqcheck utility found that the directory "/home" does not have the
recommended amount of free space on host "sapaix8". Recommended
amount needed: "5120000 KB". Actual space present: "203792 KB".
WARNING : Requirement not matched.
Validating "free space" ...
The directory "/opt" has enough space on host "sapaix8".
Requirement matched.
Validating "free space" ...
DBT3594W The db2prereqcheck utility found that the directory "/" does not have the
recommended amount of free space on host "sapaix8". Recommended amount
needed: "5120000 KB". Actual space present: "203792 KB".
WARNING : Requirement not matched.
Validating "uDAPL" ...
Required minimum "uDAPL" level: "7.1.0.15"
Actual version: "6.1.6.0"
ERROR : Requirement not matched.
Requirement not matched for DB2 database "Server" with pureScale feature. Version:
"10.5.0.0".
Summary of prerequisites that are not met on the current system:
Required minimum "uDAPL" level: "7.1.0.15"
Actual version: "6.1.6.0"
DBT3594W The db2prereqcheck utility found that the directory "/" does not have the
recommended amount of free space on host "sapaix8". Recommended amount
needed: "5120000 KB". Actual space present: "203792 KB".
DBT3594W The db2prereqcheck utility found that the directory "/home" does not have the
recommended amount of free space on host "sapaix8". Recommended
amount needed: "5120000 KB". Actual space present: "203792 KB".
éè¦æ³¨æçæ¯ï¼db2prereqcheck å¯ä»¥æ£æ¥ DB2 å®è£
ç大é¨åå级æ¡ä»¶ï¼ä½æ¯å¹¶ä¸ä¼æ£æµ DB2 æå¡å¨å级çç£ç空é´è¦æ±ãå¨ Linux å UNIX æä½ç³»ç»ä¸ï¼å»ºè®®å¨ /tmp ç®å½ä¸æ 2 GB çå¯ç¨ç©ºé´ãæ¤å¤ï¼æ¨éè¦äºè§£ç³»ç»ç¯å¢ä¸å
·æå 个ç»ä»¶ï¼å¦ DB2® æå¡å¨ãDB2 客æ·æºãæ°æ®åºåºç¨ç¨åºãèæ¬ãä¾ç¨åå·¥å
·ï¼å¨è§åå级æ¶éè¦å½»åºäºè§£æ¯ä¸ªç»ä»¶çè¿ç§»è¿ç¨ã
å¶å®å级计å
ä¸è¬å级 DB2 éè¦è±è´¹å¾é¿çæ¶é´ï¼èä¸å
·æä¸å®çé£é©ï¼ä¸ä»½å¨è¯¦çå级计åä¼æå©äºéä½å级çé£é©ã
é¦å
ï¼å¶å®ä¸é¡¹å
³äºå¦ä½å¤çç¯å¢å级ççç¥ãä½ å¿
须确å®æ¯ä¸ªç»ä»¶çå级顺åºãç¯å¢çç¹å¾åå级åºæ¬è¦æ±ä¸çä¿¡æ¯å¯ä»¥å¸®å©ä½ ç¡®å®çç¥ã
ä¸é¢æ¯ä¸ä¸ªå¾å¥½çå级çç¥ç¤ºä¾ï¼å¨æ¤ç¤ºä¾ä¸ï¼ä½ å°æµè¯æ°æ®åºåºç¨ç¨åºåä¾ç¨å¹¶ç¡®å®å®ä»¬å¨ DB2 V10.5 ä¸æ¯å¦æåè¿è¡ï¼
æ¥ç DB2 V10.5 以åæ¨è¦å级çåè¡çä¸ DB2 V10.5 ä¹é´çä»»ä½åè¡ççæ°åè½ãä¸æ¨è使ç¨çåè½åå·²åæ¢ä½¿ç¨çåè½ã
计åå¦ä½ä¿®æ¹æ°æ®åºåºç¨ç¨åºåä¾ç¨ãç¡®ä¿å®ä»¬å¨ DB2 V10.5 ä¸æåè¿è¡ã
设置 DB2 V10.5 æå¡å¨å¹¶å建æµè¯æ°æ®åºã
å¨ DB2 V10.5 æµè¯æ°æ®åºä¸æµè¯æ°æ®åºåºç¨ç¨åºåä¾ç¨ï¼ä»¥ç¡®å®å®ä»¬æ¯å¦æåè¿è¡ãå¦æåºç¨ç¨åºéè¦å®¢æ·æºï¼è¯·ä½¿ç¨ DB2 V10.5 客æ·æºã
å¨æµè¯ç¯å¢ä¸å¯¹ DB2 æå¡å¨å客æ·æºè¿è¡å级ãç¡®å®åå¨çé®é¢åå
¶è§£å³æ¹æ¡ã使ç¨æ¤ä¿¡æ¯æ¥è°æ´å级计åã
å¨ç产ç¯å¢ä¸å° DB2 æå¡å¨åçº§å° DB2 V10.5ãç¡®ä¿å®ä»¬æé¢ææä½ã
å¨ç产ç¯å¢ä¸å°å®¢æ·æºåçº§å° DB2 V10.5ãç¡®ä¿å®¢æ·æºæé¢ææä½ã
å¨å级åç DB2 V10.5 ç¯å¢ä¸æµè¯æ°æ®åºåºç¨ç¨åºåä¾ç¨ï¼ä»¥ç¡®å®å®ä»¬æ¯å¦æé¢æè¿è¡ã
使已å级çç¯å¢å¯ä¾ç¨æ·ä½¿ç¨ã
ä¹åï¼ä½ å°±å¯ä»¥ä¸ºç¯å¢ä¸çæ¯ä¸ªç»ä»¶å®ä¹å级计å详ç»ä¿¡æ¯ãå级计ååºè¯¥å
æ¬æ¯ä¸ªç»ä»¶çä¸åä¿¡æ¯ï¼å级å
å³æ¡ä»¶ï¼å级åä»»å¡ï¼å级任å¡åå级åä»»å¡ã
å¦æä½ å
åå·²å¶å®äºå级计åï¼æ¥çå®ä»¬å¹¶å°å®ä»¬ä¸ DB2 V10.5 çå级计åè¿è¡æ¯è¾ãæåï¼å¨å级计åä¸åæ¶ä½¿ç¨ä¸æ¨è使ç¨çåè½å¹¶å并 DB2 V10.5 ä¸çæ°åè½ãå°½ç®¡ä½ åªéè¦åæ¶ä½¿ç¨å·²åæ¢ä½¿ç¨çåè½ï¼ä½è¿æ¯åºè¯¥è®¡åå¨å级ä¹ååæ¶ä½¿ç¨ä¸æ¨è使ç¨çåè½ï¼å 为å¨æªæ¥çåè¡çä¸å°ä¸æ¯æè¿äºåè½ãæ¤å¤ï¼è¿åºè¯¥å©ç¨æ°åè½ä¸ºä½ çæ°æ®åºäº§åãåºç¨ç¨åºåä¾ç¨å¢å¼ºåè½åæé«æ§è½ãå级æ¯ä¸ä¸ªé«é£é©çè¿ç¨ï¼ä¸å®è¦å好å
åçåå¤åæµè¯ã
å级
å®è£
DB2 V10.5
èªä» DB2 V9 å¼å§ï¼DB2 æ¯æå¨æä½ç³»ç»ä¸å®è£
å¤ä¸ªå¯æ¬ãå级æ°æ®åºæ两ç§å®è£
DB2 çéæ©ï¼ä¸ç§æ¯å®è£
æ°çæ°æ®åºå¯æ¬å°æ°çä½ç½®ï¼å¦å¤ä¸ç§æ¯ç´æ¥å级èçæ¬æ°æ®åºå¯æ¬å°æ°ççæ¬ãè¿ä¸ªå
·ä½è¦çç¨æ· çç¯å¢è§åãæ们æ¨èå®è£
æ°çå¯æ¬å°æ°çä½ç½®ï¼è¿æ ·å¯ä»¥ä¸å½±åèçå¯æ¬ï¼å¦æå级è¿ç¨ä¸åºç°é®é¢ï¼å®¢æ·å¯ä»¥æ¢å¤å°èççæ¬ç´æ¥è¿è¡ã
æ们以 DB2 V10.1 å° DB2 V10.5 çå级为ä¾æ¥è®²è§£å
·ä½çå级è¿ç¨ãç³»ç»ä¸å·²å®è£
äº DB2 V10.1 çä¸ä¸ªå¯æ¬ãæ们ä¸è½½ DB2 V10.5 çæ¬ï¼å¯¹äº Windows æä½ç³»ç»ï¼æ§è¡å
¶ä¸ç setup.exeï¼
å¾ 1. å¾ 1. DB2 V10.5 çå®è£
æ件
æ¤æ¶å¼¹åºå¦ä¸çé¢ï¼
å¾ 2. å¾ 2. DB2 V10.5 å®è£
çé¢
ç¹å»æ¥ç大å¾
å¨ DB2 V10.5 ä¸ï¼è¿ä¸ªçé¢è¾ä¹ååäºäºè°æ´ââæç
§æå¡ç±»ååå®è£
端è¿è¡äºåç±»ï¼å° Advanced Enterprise Server EditionãAdvanced Workgroup Server EditionãEnterprise Server Edition å Workgroup Server Edition æ¾å°äºä¸ç»ï¼Express VersionãData Server ClientãData Server Runtime Client å Connect Server åèªä¸ºä¸ç»ï¼è¿éæ们éæ©ç¬¬ä¸ç»çå®è£
å¾ 3. å¾ 3. éæ©ä¸ï¼å®è£
ä¸ä¸ªæ°çå¯æ¬
è¥ç¹å» Work with Existingï¼å表示ç´æ¥å级èçæ¬æ°æ®åºå¯æ¬å°æ°ççæ¬ï¼
å¾ 4. å¾ 4. éæ©äºï¼ç´æ¥å级èçæ¬æ°æ®åºå¯æ¬å°æ°çæ¬
å¯¹äº Linux å Unix æä½ç³»ç»æ¥è¯´ï¼V10.5 å¨è½¯ä»¶å®è£
æ件ç®å½ä¸æ db2_install å db2_setup 两ç§å®è£
å½ä»¤ï¼å¦æ¸
å 3 æ示ï¼å»ºè®®ç¨æ·ä½¿ç¨ db2_setup æ¥å®è£
ï¼å 为 db2_install å¨æªæ¥çæ°çæ¬ä¸å°ä¸å使ç¨ï¼
æ¸
å 3. æ¸
å 3. V10.5 æä¾ä¸¤ç§è½¯ä»¶å®è£
å½ä»¤ï¼Linux/ Unixï¼
bash-3.00# ls
db2 db2_install db2ls db2setup installFixPack
db2_deinstall db2ckupgrade db2prereqcheck ibm_im
é¦å
æä»¬ä½¿ç¨ db2_install æ¥å®è£
DB2 å¯æ¬ï¼å¦æ¸
å 4 æ示ï¼
æ¸
å 4. æ¸
å 4. éæ©ä¸ï¼ä½¿ç¨ db2_install å®è£
æ°å¯æ¬ï¼Linux/Unixï¼
# ./db2_install
DBI1324W Support of the db2_install command is deprecated. For
more information, see the DB2 Information Center.
Default directory for installation of products - /opt/ibm/db2/V10.5
***********************************************************
Install into default directory (/opt/ibm/db2/V10.5) ? [yes/no]
å¨æ¸
å 4 ä¸ï¼æ们çå°è¾å
¥ db2_install åææ示ï¼âSupport of the db2_install command is deprecatedâï¼è¿æå³ç V10.5 以åçæ¬å°ä¸åæä¾è¯¥å½ä»¤ï¼å®é
ä¸æä»¬ä» V10.1 å¼å§å°±ä¸æ¨è使ç¨è¿ä¸ªå½ä»¤ãå æ¤æ们éç¨ä¸ Windows å¹³å°ä¸ç¸åç db2setup å½ä»¤å®è£
软件ï¼å¦æ¸
å 5 ä¸æ示ï¼
æ¸
å 5. æ¸
å 5. éæ©äºï¼ä½¿ç¨ db2setup å®è£
æ°å¯æ¬ï¼Linux Unixï¼
# ./db2setup
DBI1190I db2setup is preparing the DB2 Setup wizard which will guide
you through the program setup process. Please wait.
ä¹åæ们å°çå°äº²åçå¾å½¢çé¢ï¼å¦å¾ 2ãå¾ 3 æ示ï¼æ¥ä¸æ¥æç
§å导å°å¸®å©æ¨å®ææä½ï¼å¦å¾ 5 æ示ï¼
å¾ 5. å¾ 5. ä½¿ç¨ db2setup å®è£
æ°å¯æ¬çé¢ï¼Linux Unixï¼
ç¹å»æ¥ç大å¾
åæ ·çï¼ä½ å¯ä»¥éæ© Install New æè
Work with Exsiting 两ç§æ¹å¼æ¥è¿è¡å®è£
ã