¡¾·±ÌåÖÐÎÄ¡¿
¡¾ÉèΪÊ×Ò³¡¿
¡¾¼ÓÈëÊղء¿
µ±Ç°Î»ÖãºÊý¾Ý¿â¼¼ÊõÊ×Ò³ >> DB2½Ì³Ì >> DB2Êý¾Ý¿âµÄ°²×°

DB2Êý¾Ý¿âµÄ°²×°

2007-03-15 08:00:00  ×÷Õߣº  À´Ô´£º»¥ÁªÍø  ä¯ÀÀ´ÎÊý£º0  ÎÄ×Ö´óС£º¡¾´ó¡¿¡¾ÖС¿¡¾Ð¡¡¿
¼ò½é£ºÕâÊÇÔÚIBM RS6000 ²Ù×÷ϵͳΪAIX°²×°µÄ,HP9000ÉÏÀ×ͬ 1. ×¢²áΪ¾ßÓг¬¼¶Óû§È¨ÏÞµÄÓû§(root) 2. ½« ±êÓС°DB2ͨÓÃÊý¾Ý¿âÆóÒµ°æ¡±µÄÈí¼þ¹âÅ̲åÈëÇý¶¯Æ÷ 3. ÊäÈëÈçÏÂÃüÁÒÔ´´½¨Ò»¸öĿ¼À´°²×°¸Ã CD-ROM£º # mkd...
¹Ø¼ü×Ö£ºÊý¾Ý¿â DB2

ÕâÊÇÔÚ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 Êý¾Ý¿â·þÎñÆ÷µÄ°²×°ÒѾ­³É¹¦Íê³É.

ÔðÈα༭£ºadmin
Ïà¹ØÎÄÕÂ