ããå级ååå¤
ããå级ä¹åï¼SAP 客æ·éè¦èèä¸æ¹é¢çå
容ï¼å级æ¡ä»¶æ¯å¦å
·å¤ï¼æ£æ¥éè¦å级çç»ä»¶ï¼ä¿åå级å SAP ç¯å¢ãæåå¶å®å级计åã
ããæ£æ¥å级æ¡ä»¶
ãã主è¦ä»ä¸æ¹é¢æ¥æ£æ¥ SAP ç³»ç»æ¯å¦æ¯æå级 DB2 å° V9.7 çæ¬ãå¨æä½ç³»ç»æ¹é¢ï¼DB2 V9.7 ä¸åæ¯æä»»ä½ 32 ä½ç³»ç»ï¼ä¹ä¸æ¯æ PA-RISC ä¸ç HP-UXï¼ä¸æ¯æ IA64 ä¸ç Linux å Windowsï¼ä¸æ¯æ row devicesãå¨ DB2 çæ¬æ¹é¢ï¼åªæ¯æç´æ¥ä» DB2 V8 FP9 以åççæ¬å级ï¼å¦ææ¯æ´ä½ççæ¬ï¼éè¦å
åçº§å° V8FP9 以åççæ¬ãå¨ SAP æ¹é¢ï¼DB2 V9.7 åªæ¯æé«äº SAP ç³»ç» 4.6X ççæ¬ãå½å®¢æ·çSAP ç³»ç»åªæ满足以ä¸æ¡ä»¶åï¼æå¯ä»¥èèå级 DB2ã
ãã满足ä¸è¿°æ¡ä»¶åï¼å®è£
DB2 V9.7 ç³»ç»è¿éè¦ç¡®å®éæ©çç³»ç»æ»¡è¶³å¿
éçæä½ç³»ç»ã硬件ã软件ãéä¿¡ãç£çåå
åè¦æ±ã对äºä¸åçæä½ç³»ç»ï¼è¿äºè¦æ±ä¹ä¸ä¸æ ·ãæ¬æä¸è¯¦ç»ä»ç»å®è£
V9.7 çææè¦æ±ãå¯¹äº SAP 客æ·æ¥è®²ï¼éè¦å级ç SAP ç³»ç»çå®è£
è¦æ±æ¯ç¹å®çãDB2å¨ DVD ä¸æä¾äºä¸ä¸ªå¾å¥½çå·¥å
· db2prereqcheck æ¥åå®è£
æ¡ä»¶çæ£æ¥ã
ããSAP 客æ·é¦å
mount å®è£
å
çå° <DB2_DVD>ãæ¬æä¸ç¨ <DB2_DVD> æ¥ä»£æ¿ mount çè·¯å¾ãdb2prereqcheck å·¥å
·å¨ç¸åºçå¦ <DB2_DVD>/RDBMS/DVD_2/LINUXX86_64/ESE/disk1 è¿æ ·çç®å½ä¸ãå¦ææ¯ Windowsï¼é£ç¸åºçç®å½æ¯ <DB2_DVD>\RDBMS\DVD_3\WINDOWS_AMD64\ESE\imageï¼å·¥å
·æ¯ db2prereqcheck.exeã
ãã
ããå¦æ db2prereqcheck æ§è¡æåï¼å°ä¸ä¼è¿åä»»ä½ä¿¡æ¯ï¼è¯´ææ¤ç³»ç»æ¯æææçå®è£
æ¡ä»¶ãå¦æåç°é»åæ¡ä»¶ä¸æ¯æï¼é£ä¹å°ä¼è¿åå¦æ¸
å 1 æ示çé误信æ¯ï¼ååºææå®è£
çå
å³æ¡ä»¶ã客æ·å°±éè¦æ ¹æ®é误信æ¯ï¼éä¸æ»¡è¶³ãä¸ç´å°è¿è¡æ¤å·¥å
·ä¸ååºç°é误信æ¯ä¸ºæ¢ãè¿ééè¦ç¹å«æ³¨æï¼å¨æ´æ¹ç³»ç»é
ç½®çæ¶åï¼ä¸å®è¦å好 SAPç³»ç»çå¤ä»½ï¼ç¡®å®æä½æ´æ¹ä¸ä¼å½±åå½å SAPè¿è¡ï¼æå¯ä»¥å级系ç»çé
ç½®ãå¨æ¸
å 1 çæåä¸è¡ï¼æ¤å·¥å
·åè¯ç¨æ·å¯ä»¥ä» IBM ç½ç«å¾å°æ´è¯¦ç»çå
å³æ¡ä»¶å表ã
ããdb2prereqcheck å¯ä»¥æ£æ¥ DB2 å®è£
çç³»ç»æ¡ä»¶ï¼ä¹å°±æ¯å
æ¬äºå¤§é¨åçå级æ¡ä»¶ãä½æ¯å¹¶ä¸ä¼æ£æµ DB2 æå¡å¨å级çç£ç空é´è¦æ±ã建议å°ç³»ç»ç®å½è¡¨ç©ºé´å临æ¶è¡¨ç©ºé´é½å¢å¤§ä¸ºå·²ä½¿ç¨è¡¨ç©ºé´æ»å¤§å°ç两åãå¯ä»¥è°æ´ logprimary å logsecond æ¥ç¡®ä¿æ足å¤çæ¥å¿æ件空é´å¯ç¨ã
ããæ£æ¥å级ç»ä»¶
ããå¯¹äº SAP 客æ·ï¼å级æ°æ®åºç¯å¢æ主è¦çç»ä»¶æ¯ DB2 æå¡å¨å DB2 客æ·æºãSAP å¨ä¸åççæ¬ä¸ä¼ä½¿ç¨ä¸åç DB2 客æ·æºãæ以 SAP客æ·éè¦æ£æ¥ SAP æ使ç¨ç DB2 客æ·æºæ¯åªä¸ç§ï¼å¹¶ä¸å³å®å级ç¸åºç客æ·æºãæ¬æä¸å¯è½ä¼ä½¿ç¨å° <sid> è¿æ ·ç代è¯ãçæ SAP çç¨æ·åºè¯¥ç¥éï¼è¿æ¯ SAP ç³»ç»çå¯ä¸æ è¯ãä¸æä¸ææ <sid>ï¼<sapsid>ï¼<dbsid> é½ç¨ä»¥ä»£æ¿ SAP ç³»ç»æ è¯ãç°å¨éè¿ä»¥ä¸æ¥éª¤å¯ä»¥æ£æµSAP 使ç¨äºåªç§å®¢æ·æºï¼
ãã以 <sapsid>adm 身份ç»å½å°æä½ç³»ç»ä¸ï¼è¿è¡â R3trans â d âå½ä»¤ãå½ä»¤æ§è¡æååä¼çæä¸ä¸ª trans.log æ件ãå¨æ¤æ件ä¸æ¥æ¾å è½½çDB2 libraryã
ããå¶å®å级计å
ãã解å³çå级çå¿
è¦æ¡ä»¶ï¼ç¥éäºéè¦å级çæ°æ®åºç»ä»¶ï¼å¹¶ä¸å¤ä»½äº SAP ç¯å¢ï¼ä¸äºä¿±å¤ï¼åªæ¬ ä¸é£ãå¶å®ä¸ä»½å级计åé常éè¦ï¼SAPçåºç¨ä¸è¬é½å¾å¤§ï¼å¯¹ç³»ç»å½æºçè¦æ±ä¹å¾é«ãä¸è¬å级 DB2 éè¦è±è´¹å¾é¿çæ¶é´ï¼èä¸å
·æä¸å®çé£é©ãä¸ä»½å¨è¯¦ç计åä¼æå©äºéä½å级çé£é©ãå级计åææ¡£ä¾äººèå®ï¼å¯ä»¥å
æ¬è®¡åå¶å®äººï¼å®¡æ ¸äººï¼å®¡æ¹äººï¼å级æ§è¡æ¶é´ï¼å级èå¾ï¼å级å
·ä½æ¥éª¤ï¼ç¸åºæµè¯è®¡åççãå级æ¯ä¸ä¸ªé«é£é©çè¿ç¨ï¼ä¸å®è¦å好å
åçåå¤åæµè¯ã
ããå级
ããå®è£
DB2 V9.7
ããèªä» DB2 V9 å¼å§ï¼DB2 æ¯æå¨æä½ç³»ç»ä¸å®è£
å¤ä¸ªå¯æ¬ãå级æ°æ®åºæ两ç§å®è£
DB2 çéæ©ï¼ä¸ç§æ¯ç´æ¥å级èçæ¬æ°æ®åºå¯æ¬å°æ°ççæ¬ï¼å¦å¤ä¸ç§æ¯å®è£
æ°çæ°æ®åºå¯æ¬å°æ°çä½ç½®ãè¿ä¸ªå
·ä½è¦çç¨æ·çç¯å¢è§åãä½è
æ¨èå®è£
æ°çå¯æ¬å°æ°çä½ç½®ï¼è¿æ ·å¯ä»¥ä¸å½±åèçå¯æ¬ï¼å¦æå级è¿ç¨ä¸åºç°é®é¢ï¼å®¢æ·å¯ä»¥æ¢å¤å°èççæ¬ç´æ¥è¿è¡ã
ããå级åæ´»å¨
ããå¨ SAP è¿æ ·ä¸ä¸ªç¹å®ç¯å¢å
ï¼å级å®æ°æ®åºåï¼è¿æåç»ä»»å¡éè¦å®æãç¸æ¯äºå
¶ä»æ°æ®åºåºç¨ï¼SAP 为äºæ¹ä¾¿æ°æ®åºçå级ï¼æä¾äºä¸ç§åç»å级工å
· db6_update_dbãæ¤å·¥å
·ä¼è®¾ç½®ä¸äº SAP ç¸å
³ç DB2 é
ç½®ï¼éç»ç³»ç»ç¼ç®è¡¨çãå¨å¦ <DB2_DVD>/RDBMS/DVD_2/LINUXX86_64/ è¿æ ·çç®å½ä¸å¯ä»¥æ¾å°æ¤å·¥å
·ï¼Windows æ¯ db6_update_db.batï¼Linux æè
Unix æ¯ db6_update_db.shã
ãã以 db2<dbsid> ç¨æ·ç»å½å°ç³»ç»è¿è¡ db6_update_db.bat
ããæ¸
å 13. è¿è¡ db6_update_db
ãã# db6_update_db.sh -d <dbsid>
**************************************************
* db6_update_db.sh script version 0008 *
**************************************************
Database Connection Information
Database server = DB2/HPUX-IA64 9.7.0
SQL authorization ID = DB2LR1
Local database alias = LR1
The script db6_update_db_out.sh was created. Please verify the generated
script Then run it in the following way:
db6_update_db_out.sh > db6_update_db_out.sh.log.
Finally check the logfile db6_update_db_out.sh.log for errors !!!
# ./db6_update_db_out.sh > db6_update_db_out.sh.log
# db2stop force
# db2start
ããæ¥ç db6_update_db_out æ¯å¦æé误信æ¯ãå级å®æåï¼SAP 客æ·è¿éè¦ä¿ååéªè¯å级åçç¯å¢é
ç½®ã
ããä¿åå级å SAP ç¯å¢
ããå¦åä¿åå级å SAP ç¯å¢ä¸è¬ï¼ä¿åå级åçç¯å¢ï¼
ãã1. 以 db2<dbsid> ç¨æ·ç»å½å°æä½ç³»ç»ï¼å¯å¨ DB2 å®ä¾ã
ãã# db2startï¼
ãã2. è¿å
¥å¤ä»½è·¯å¾
ãã# cd /db2/db2<dbsid>/db_backup
ãã3 ï¼å¤ä»½æ°æ®åºæå¡å¨é
ç½®
ãã# env > env_after_upgrade.txt
# db2set -all > reg_after_upgrade.txt
# db2 get dbm cfg > dbm_after_upgrade.txt
# db2 get db cfg for <SAPSID> > db_after_upgrade.txt
ããæ¯è¾å级åä¿åçé
ç½®æ件åå级åçé
ç½®æ件ï¼å¯ä»¥èªå®ä¹éæ©ä¿®æ¹éå½çåæ°ã
ããå®è£
DB2 许å¯
ããSAP ç¨æ·ç DB2 许å¯ä¸è¬é½æ¯è´ä¹°èª SAP å
¬å¸ï¼æç
§ SAP çææ¡£å®è£
DB2 ç许å¯ã
ããä½¿ç¨ V9.7 æ°ç¹æ§
ããDB2 åçº§å° V9.7 åå°±å¯ä»¥ä½¿ç¨æ°åè½æ¥å¢å¼ºåè½åæé«æ°æ®åºåºç¨ç¨åºçæ§è½ãå¦å¤§ RIDï¼ç´¢å¼å缩ççãå
·ä½çå
容å¯ä»¥åç
§ IBM developerworks ä¸å
¶ä»ä»ç» V9.7 æ°ç¹æ§çæç« ã
ããå¤ä»½æ°æ®åº
ããå级æåï¼å¨ SAP å次ä¸çº¿ä¹åï¼åä¸ä¸ªå®æ´ç离线å¤ä»½ã
温馨提示:答案为网友推荐,仅供参考