ÕâÊÇÔÚIBM RS6000 ²Ù×÷ϵͳΪAIX°²×°µÄ,HP9000ÉÏÀ×ͬ
1. ×¢²áΪ¾ßÓг¬¼¶Óû§È¨ÏÞµÄÓû§(root)
2. ½« ±êÓС°DB2ͨÓÃÊý¾Ý¿âÆóÒµ°æ¡±µÄÈí¼þ¹âÅ̲åÈëÇý¶¯Æ÷
3. ÊäÈëÈçÏÂÃüÁÒÔ´´½¨Ò»¸öĿ¼À´°²×°¸Ã CD-ROM£º
# mkdir -p /cdrom ÆäÖÐ cdrom ±íʾ CD-ROM °²×°Ä¿Â¼¡£
ÊäÈëÈçÏÂÃüÁÀ´·ÖÅä CD-ROM Îļþϵͳ£º
# smitty storage
4. Ñ¡ÔñÎļþϵͳ
5. Ñ¡ÔñÌí¼Ó£¯¸ü¸Ä£¯ÏÔʾ£¯É¾³ýÎļþϵͳ
6. Ñ¡Ôñ CDROM Îļþϵͳ
7. Ñ¡ÔñÌí¼Ó CDROM Îļþϵͳ
8. ÔÚµ¯³ö´°¿ÚÖУ¬ÊäÈëÈçÏÂÏî×÷Ϊ°²×°µã£º
/cdrom
9. ͨ¹ýÊäÈëÒÔÏÂÃüÁîÀ´°²×° CD-ROM Îļþϵͳ£º smit mountf
10. ÔÚÎļþϵͳÃû³Æ×Ö¶ÎÖÐÊäÈëÖµ¡£ÀýÈ磬¸ÃÃû³Æ¿ÉÄÜÊÇ /dev/cd0¡£
11. ÔÚ°²×°Ä¿Â¼×Ö¶ÎÖÐÊäÈëÖµ¡£ÀýÈ磬´ËÖµ¿ÉÄÜÊÇ /cdrom¡£
12. ½«°²×°ÎªÖ»¶ÁϵͳÉèÖÃΪ Yes¡£
13. µ¥»÷È·¶¨¡£
14. cd /cdrom
15. ÊäÈë ./db2setup ÃüÁîÒÔÆô¶¯ DB2 °²×°³ÌÐò¡£ °²×° DB2 V6 ´°¿Ú´ò¿ª¡£
16. °´ Tab ¼ü¸ü¸ÄÍ»³öÏÔʾµÄÑ¡Ï°´ Enter ¼üÑ¡Ôñ»òÈ¡ÏûÑ¡ÔñÑ¡Ïî¡£
£¨1£© ÔÚ·þÎñÆ÷Éϰ²×°£¬Ò»°ãÑ¡Ôñ°²×°ÒÔÏÂÈý¸ö²úÆ·£º
×¢Ò⣺ҪÏÔʾÏëÒª°²×°µÄ DB2 ²úÆ·µÄ²¿¼þ£¬Ñ¡Ôñ¶¨ÖÆ¡£ÒªÔÚÈκÎʱºò·µ»ØÖÁÏÈǰ´°¿Ú£¬Ñ¡ÔñÈ¡Ïû¡£
Ø DB2 Administration Client
Ñ¡Ôñ¶¨Öư²×°Õâ¸ö²úÆ·£¬
Ø DB2 UDB enterprise edition
Ñ¡Ôñ¶¨Öư²×°Õâ¸ö²úÆ·£¬
Ø DB2 Software Developer Kit
Èç¹ûͬʱ×ö¿ª·¢£¬ÐèÒª¶¨Öư²×°´Ë²úÆ·¡£
£¨2£© ÔÚ¡°DB2²úÆ·ÐÅÏ¢¡±ºÍ¡°DB2²úÆ·¿â¡±Ö»Ñ¡ÔñÖйúÓïÑÔZH_CNÖ§³Ö¡£
17. ÔÚ16²½È·ÈϺ󣬽«¿ªÊ¼°²×°Êý¾Ý¿â³ÌÐò¡£ÔÚ°²×°¹ý³ÌÖУ¬»¹ÐèÈ·ÈÏÒÔÏÂÎÊÌ⣺
£¨1£© ÊÇ·ñ½¨Á¢DB2¹ÜÀíÕÊ»§, Ò»°ãÑ¡Ôñ½¨Á¢:
°´È±Ê¡½¨Á¢db2¹ÜÀíÓû§db2as£¨Ê¹ÓÃȱʡµÄUID£¬Group Id£¬°²×°home·¾¶£©£¬ÔÚÓïÑÔÖ§³ÖÉÏ£¬
ֻѡÔñÖйúÓïÑÔZH_CNÖ§³Ö¡£
£¨2£© ÊÇ·ñ½¨Á¢DB2µÄʵÀý, Ò»°ãÑ¡Ôñ½¨Á¢:
Ø °´È±Ê¡½¨Á¢db2¹ÜÀíÓû§db2inst1:db2iadm1£¨Ê¹ÓÃȱʡµÄUID£¬Group Id£¬°²×°home·¾¶£©£¬
ÔÚÓïÑÔÖ§³ÖÉÏ£¬Ö»Ñ¡ÔñÖйúÓïÑÔZH_CNÖ§³Ö¡£
Ø °´È±Ê¡½¨Á¢db2Óû§db2fenc1:db2fenc1£¨Ê¹ÓÃȱʡµÄUID£¬Group Id£¬°²×°home·¾¶£©£¬
ÔÚÓïÑÔÖ§³ÖÉÏ£¬Ö»Ñ¡ÔñÖйúÓïÑÔZH_CNÖ§³Ö¡£
Ø ÊÇ·ñ½¨Á¢sampleÊý¾Ý¿â£¨ÎªÁ˼ì²éÊý¾Ý¿âµÄ°²×°ÊÇ·ñÕýÈ·£¬Ò»°ãÑ¡Ôñ½¨Á¢sampleÊý¾Ý¿â£©
Ø ÊÇ·ñÑ¡ÔñDB2µÄʵÀý½ø³ÌÔÚ²Ù×÷ϵͳÆô¶¯Ê±£¬×Ô¶¯Ö´Ðгõʼ»¯
Èç¹ûÔÚ¶ÀÁ¢·þÎñÆ÷Éϰ²×°Ê¹Ó㬿ÉÑ¡Ôñautostart£¬µ«ÔÚaix+hacmp+db2µÄË«»ú¹²Ïí»·¾³ÖУ¬²»ÒªÑ¡Ôñ
autostart£¬DB2ʵÀý½ø³ÌµÄÆô¶¯£¬ÓÉhacmpÀ´¿ØÖÆ¡£
18. °²×°½á¹û£º
Êý¾Ý¿â³ÌÐò°²×°Íê³Éºó£¬DB2µÄÈí¼þ³ÌÐò°²×°ÔÚ/usr/lppĿ¼ÖУ¬
DB2DIR = /usr/lpp/DB2_06_01
×¢Ò⣺Èç¹û°²×°¹ý³ÌÖÐûÓÐÖ¸¶¨½¨Á¢ÊµÀýºÍ¹ÜÀíÕÊ»§£¬ÔÚ°²×°Íê³Éºó¿ÉÒÔʹÓÃÃüÁî´´½¨ÊµÀý(db2icrt)¡£
»òÕßÒª´´½¨»òÌí¼ÓеÄʵÀý¡¢¡°¹ÜÀí·þÎñÆ÷¡±»òÆäËû DB2 ²úÆ·ºÍ²¿¼þ£¬ÊäÈëÈçÏÂÃüÁ
/usr/lpp/DB2_06_01/install/DB2setup
19. ÑéÖ¤°²×°
ÔÚ°²×°Ê±ÈôûÓÐÑ¡Ôñ½¨Á¢sampleÊý¾Ý¿â£¬ÔÚ°²×°Íê³Éºó¿ÉÒÔͨ¹ýÃüÁdb2sampl£©´´½¨ SAMPLE Êý¾Ý¿â£¬
²¢Í¨¹ýʹÓÃÃüÁîÐд¦ÀíÆ÷Óë¸ÃÊý¾Ý¿âÏàÁ¬À´ÑéÖ¤°²×°:
£¨1£© ×÷Ϊ¾ßÓÐϵͳ¹ÜÀí (SYSADM) ȨÏÞµÄÓû§Ïòϵͳע²á¡£È磺db2inst1
£¨2£© ÊäÈë DB2sampl ÃüÁîÒԱ㴴½¨ SAMPLE Êý¾Ý¿â¡£
£¨3£© ´´½¨ SAMPLE Êý¾Ý¿âʱ£¬ÓÃÊý¾Ý¿â±ðÃû SAMPLE ½«Ëü×Ô¶¯±àÄ¿¡£
£¨4£© ÊäÈë DB2start ÃüÁîÒÔÆô¶¯Êý¾Ý¿â¹ÜÀí³ÌÐò¡£
£¨5£© ÊäÈëÏÂÁÐÃüÁîÀ´Óë SAMPLE Êý¾Ý¿âÏàÁ¬£¬¼ìË÷ÔÚ²¿ÃÅ 20 Öй¤×÷µÄËùÓйÍÔ±µÄÁÐ±í£¬²¢ÖØÉèÊý¾Ý¿âÁ¬½Ó£º
DB2 connect to sample
DB2 "select * from staff where dept = 20"
DB2 connect reset
×¢Ò⣺ÔÚÑéÖ¤°²×°ºó£¬¿É³ýÈ¥ SAMPLE Êý¾Ý¿âÒÔÊÍ·Å´ÅÅ̿ռ䡣ÊäÈë DB2 drop database sample ÃüÁî
À´Ð¶Ï SAMPLE Êý¾Ý¿â¡£
ÈôÉÐδδ°²×° DB2 ¹¤¾ß£¬ÔòÄú¿ÉÒÔͨ¹ý´´½¨ SAMPLE Êý¾Ý¿â£¬ ²¢Í¨¹ýʹÓÃÃüÁîÐд¦ÀíÆ÷Óë¸ÃÊý¾Ý¿â
ÏàÁ¬À´ÑéÖ¤°²×°£¬ÈçÏÂËùʾ£º
²½Öè 1.
×÷Ϊ¾ßÓÐϵͳ¹ÜÀí (SYSADM) ȨÏÞµÄÓû§Ïòϵͳע²á¡£
²½Öè 2.
ÊäÈë db2sampl ÃüÁîÒԱ㴴½¨ SAMPLE Êý¾Ý¿â¡£
´´½¨ SAMPLE Êý¾Ý¿âʱ£¬ ÓÃÊý¾Ý¿â±ðÃû SAMPLE ½«Ëü×Ô¶¯±àÄ¿¡£
²½Öè 3.
ÊäÈë db2start ÃüÁîÒÔÆô¶¯Êý¾Ý¿â¹ÜÀí³ÌÐò¡£
²½Öè 4.
ÊäÈëÏÂÁÐÃüÁîÀ´Óë SAMPLE Êý¾Ý¿âÏàÁ¬£¬ ¼ìË÷ÔÚ²¿ÃÅ 20 Öй¤×÷µÄËùÓйÍÔ±µÄÁÐ±í£¬²¢ÖØÉèÊý¾Ý¿âÁ¬½Ó£º
db2 connect to sample
db2 "select * from staff where dept = 20"
db2 connect reset
ÈçÒÔÉÏÃüÁî¾ùÕýÈ·Ö´ÐÐ, ÔòÖ¤Ã÷DB2 UDB Êý¾Ý¿â·þÎñÆ÷µÄ°²×°ÒѾ³É¹¦Íê³É.

