OS/390¿ë DB2 Universal DatabaseÀÇ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö Áö¿øÀº OS/390¿ë DB2 Universal Database°¡ DRDA ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ¿¡ ´ëÇØ ¼¹ö·Î ÀÛ¿ëÇÒ ¼ö ÀÖµµ·Ï ÇØÁÝ´Ï´Ù. OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ ¿¬°áµÈ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ´Â ´ÙÀ½À¸·Î ÀÛ¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ ¿¬°áµÈ ¸ðµç ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ¿¡ ´ëÇØ OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â ´ÙÀ½°ú °°ÀÌ µ¥ÀÌÅͺ£À̽º ¾×¼¼½º¸¦ Á¦°øÇÕ´Ï´Ù.
OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ ºÐ»ê µ¥ÀÌÅͺ£À̽º ¿äûÀ» Á¦´ë·Î ó¸®ÇÏ°Ô ÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ ºÐ»ê µ¥ÀÌÅͺ£À̽º ¿äûÀ» ¼ö½ÅÇÏ·Á¸é Áö¿ª Åë½Å °ü¸® ÇÁ·Î±×·¥¿¡ ¸Â°Ô Á¤ÀǵǾî¾ß ÇÏ¸ç °íÀ¯ÇÑ RDB_NAMEÀ» °¡Á®¾ß ÇÕ´Ï´Ù. ´ÙÀ½ ³íÀÇ´Â SNA ¿¬°á°ú °ü·ÃµË´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¸¦ Á¦´ë·Î Á¤ÀÇÇÏ·Á¸é ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
VTAM ³×Æ®¿öÅ© È®ÀÎ ¹æ¹ý¿¡ ´ëÇØ¼´Â RU Å©±â ¹× ÆäÀÌ½Ì ¼³Á¤¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
¿¹¸¦ µé¾î, DALLAS ½Ã½ºÅÛ(¶Ç ´Ù¸¥ OS/390¿ë DB2 Universal Database ½Ã½ºÅÛ)ÀÌ »çÀü °ËÁõµÈ ºÐ»ê µ¥ÀÌÅͺ£À̽º ¿äû(LU 6.2 SECURITY=SAME)À» Àü¼ÛÇÒ ¼ö ÀÖ´Â ¹Ý¸é, µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ½Ã½ºÅÛÀº ¾ÏÈ£¸¦ Àü¼ÛÇϵµ·Ï ¿ä±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ, ÀÌ·¯ÇÑ ½Ã½ºÅÛÀÌ ¸¹Àº °æ¿ì °¢°¢ÀÇ µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ½Ã½ºÅÛ¿¡ ´ëÇØ CDB¿¡ Ç׸ñÀ» ±â·ÏÇÏÁö ¾ÊÀ¸·Á°í ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ±×¸² 25¿¡¼´Â CDB¸¦ »ç¿ëÇÏ¿© DALLAS ½Ã½ºÅÛ¿¡ ´ëÇØ SECURITY=SAMEÀ» ÁöÁ¤ÇÏ°í ´Ù¸¥ ¸ðµç ¸®Äù½ºÅÍ¿¡ ´ëÇØ¼´Â SECURITY=PGMÀ» Àû¿ëÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.
±×¸² 25. ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ ¿¬°á¿¡ ´ëÇØ ±âº»°ª ¼³Á¤(SNA)
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUDALLAS', ' ', 'A', 'N', 'N', ' '); INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES (' ', ' ', 'C', 'N', 'N', ' '); |
±×¸² 26¿¡¼, ¾î¶² Ç൵ LUNAME Ä÷³¿¡ °ø¹éÀ» Æ÷ÇÔÇϰí ÀÖÁö ¾ÊÀ¸¹Ç·Î, OS/390¿ë DB2 Universal Database´Â LUDALLAS ¶Ç´Â LUNYC ÀÌ¿ÜÀÇ ´Ù¸¥ ¸ðµç LU¿¡ ´ëÇÑ ¾×¼¼½º¸¦ °ÅºÎÇÕ´Ï´Ù.
±×¸² 26. °³º° ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ ¿¬°á ½Äº°(SNA)
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUDALLAS', ' ', 'A', 'N', 'N', ' '); INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUNYC', ' ', 'A', 'N', 'N', ' '); |
ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ TCP/IP ¿¬°áÀ» ÅëÇØ ºÐ»ê µ¥ÀÌÅͺ£À̽º ¿äûÀ» ¼ö½ÅÇÏ·Á¸é, Áö¿ª TCP/IP¿¡ ¸Â°Ô Á¤ÀǵǾî¾ß ÇÏ¸ç °íÀ¯ÇÑ RDB_NAMEÀ» °¡Á®¾ß ÇÕ´Ï´Ù. ¶ÇÇÑ, OS/390¿ë DB2 Universal Database ºÎÆ®½ºÆ®·¦ µ¥ÀÌÅÍ ¼¼Æ®¿¡´Â ÇÊ¿äÇÑ ¸Å°³º¯¼ö°¡ Æ÷ÇԵǾî¾ß Çϸç OS/390¿ë DB2 Universal Database Åë½Å µ¥ÀÌÅͺ£À̽º(CDB)¸¦ °»½ÅÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
TCP/IP ³ëµå¿¡ ´ëÇØ Àιٿîµå µ¥ÀÌÅͺ£À̽º ¿¬°á ¿äûÀ» Çã¿ëÇÏ·Á°í ÇÒ °æ¿ì, ´ÙÀ½°ú °°Àº SQL ¸í·ÉÀ» »ç¿ëÇÏ¿© ÀÌ Å×À̺íÀ» °»½ÅÇϽʽÿÀ.
INSERT INTO SYSIBM.IPNAMES (LINKNAME) VALUES(' ')
ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͰ¡ ºÐ»ê µ¥ÀÌÅͺ£À̽º ¿äûÀ» OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ °æ·Î¸¦ ÁöÁ¤ÇÒ ¶§ ´ÙÀ½°ú °°Àº º¸¾È °ü·Ã»çÇ×ÀÌ ¿¬°üµÉ ¼ö ÀÖ½À´Ï´Ù.
OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͷκÎÅÍ ÀÏ¹Ý »ç¿ëÀÚ À̸§À» ¼ö½ÅÇÒ ¶§, ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â ÁÖ¾îÁø ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͷκÎÅÍ ¼ö½ÅµÇ´Â ÀÏ¹Ý »ç¿ëÀÚ À̸§À» Á¦ÇÑÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â ¹ß½ÅÁö(come-from) Á¡°ËÀ» ÅëÇØ ¼öÇàµË´Ï´Ù. ¹ß½ÅÁö(come-from) Á¡°ËÀ» ÅëÇØ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â ƯÁ¤ »ó´ë¹æ¸¸ÀÌ ÁÖ¾îÁø »ç¿ëÀÚ ID¸¦ »ç¿ëÇÒ ¼ö ÀÖµµ·Ï ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â JONES°¡ DALLAS¿¡¼ "¹ß½ÅµÇµµ·Ï" Á¦ÇÑÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶Ç ´Ù¸¥ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ(DALLAS°¡ ¾Æ´Ñ)°¡ À̸§ JONES¸¦ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ Àü¼ÛÇÏ·Á°í Çϸé, À̸§ÀÌ Á¤È®ÇÑ ³×Æ®¿öÅ© À§Ä¡¿¡¼ ¹ß½ÅµÈ °ÍÀÌ ¾Æ´Ï±â ¶§¹®¿¡ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â ¿äûÀ» °ÅºÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
OS/390¿ë DB2 Universal Database´Â Àιٿîµå ÀÏ¹Ý »ç¿ëÀÚ À̸§ º¯È¯ÀÇ ÇÑ ºÎºÐÀ¸·Î ¹ß½ÅÁö(come-from) Á¡°ËÀ» ¼öÇàÇϴµ¥ ÀÌ¿¡ ´ëÇØ¼´Â ´ÙÀ½ Àý¿¡¼ ¼³¸íµË´Ï´Ù.
ÁÖ: | TCP/IP Àιٿîµå ¿äû¿¡ ´ëÇØ¼´Â Àιٿîµå ¹× ¹ß½ÅÁö(come-from) Á¡°ËÀÌ ¼öÇàµÇÁö ¾Ê½À´Ï´Ù. |
ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͰ¡ Àü´ÞÇÑ »ç¿ëÀÚ ID´Â Àüü SNA ³×Æ®¿öÅ©¿¡¼ °íÀ¯ÇÏÁö ¾ÊÀ» ¼ö ÀÖ½À´Ï´Ù. SNA ³×Æ®¿öÅ© Àü¹Ý¿¡ °ÉÃÄ °íÀ¯ÇÑ ÀÏ¹Ý »ç¿ëÀÚ À̸§À» ÀÛ¼ºÇϱâ À§ÇØ OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ Àιٿîµå À̸§ º¯È¯À» ¼öÇàÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸¶Âù°¡Áö·Î, OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ ¾Æ¿ô¹Ù¿îµå À̸§ º¯È¯À» ¼öÇàÇÏ¿© ÀÀ¿ëÇÁ·Î±×·¥¿¡ ¿¬°üµÈ 2Â÷ ¼¹ö¿¡ ¸Â´Â °íÀ¯ÇÑ ÀÏ¹Ý »ç¿ëÀÚ À̸§À» Á¦°øÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù(¾Æ¿ô¹Ù¿îµå ÀÏ¹Ý »ç¿ëÀÚ À̸§ º¯È¯¿¡ ´ëÇØ¼´Â º¸¾È Á¦°ø¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.).
Àιٿîµå À̸§ º¯È¯Àº SYSIBM.LUNAMES Å×À̺íÀÇ USERNAMES Ä÷³À» 'I'(Àιٿîµå º¯È¯) ¶Ç´Â 'B'(Àιٿîµå ¹× ¾Æ¿ô¹Ù¿îµå º¯È¯)À¸·Î ¼³Á¤Çϸé ÀÛµ¿ °¡´ÉÇÏ°Ô µË´Ï´Ù. Àιٿîµå À̸§ º¯È¯ÀÌ È¿·ÂÀ» °®°Ô µÇ¸é, OS/390¿ë DB2 Universal Database´Â ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͰ¡ Àü¼ÛÇÑ »ç¿ëÀÚ ID¿Í OS/390¿ë DB2 Universal Database Ç÷£ ¼ÒÀ¯ÀÚÀÇ À̸§(ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͰ¡ ¶Ç ´Ù¸¥ OS/390¿ë DB2 Universal Database ½Ã½ºÅÛÀÏ °æ¿ì)À» º¯È¯ÇÕ´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͰ¡ »ç¿ëÀÚ APPC ALLOCATE ¸í·É¾î¸¦ ÅëÇØ »ç¿ëÀÚ ID¿Í ¾ÏÈ£¸¦ ¸ðµÎ Àü¼ÛÇϸé, »ç¿ëÀÚ ID°¡ º¯È¯µÇ±â Àü¿¡ »ç¿ëÀÚ ID¿Í ¾ÏÈ£ÀÇ À¯È¿¼ºÀÌ °ËÁõµË´Ï´Ù. SYSIBM.USERNAMESÀÇ PASSWORD Ä÷³Àº ¾ÏÈ£ °ËÁõ¿¡ »ç¿ëµÇÁö ¾Ê½À´Ï´Ù. ´ë½Å, »ç¿ëÀÚ ID¿Í ¾ÏÈ£´Â °ËÁõÀ» À§ÇØ ¿ÜºÎ º¸¾È ½Ã½ºÅÛ(RACF ¶Ç´Â RACF ȣȯ Á¦Ç°)¿¡ Á¦½ÃµË´Ï´Ù.
ALLOCATE ¸í·É¾î»óÀÇ ¼ö½Å »ç¿ëÀÚ ID°¡ °ËÁõµÇ¸é, OS/390¿ë DB2 Universal Database´Â 2Â÷ AUTHID ¸ñ·ÏÀ» Á¦°øÇϰí Ãß°¡ÀÇ º¸¾È Á¡°ËÀ» ¼öÇàÇÒ ¶§ »ç¿ëÇÒ ¼ö ÀÖ´Â ±ÇÇÑ ºÎ¿© exit¸¦ °®½À´Ï´Ù. OS/390¿ë DB2 Universal Database Administration Guide¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
Àιٿîµå À̸§ º¯È¯ ÇÁ·Î¼¼½º´Â SYSIBM.USERNAMES Å×ÀÌºí¿¡¼ ÇàÀ» °Ë»öÇϴµ¥, ÀÌ ÇàÀº ¾Æ·¡ ¸ñ·ÏÀÇ ÆÐÅÏ Áß Çϳª¿Í ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù(TYPE.AUTHID.LINKNAME).
ÇàÀÌ ¾ø´Â °æ¿ì, ¿ø°Ý ¾×¼¼½º°¡ °ÅºÎµË´Ï´Ù. ÇàÀÌ ÀÖ´Â °æ¿ì, ¿ø°Ý ¾×¼¼½º°¡ Çã¿ëµÇ°í ÀÏ¹Ý »ç¿ëÀÚ À̸§Àº NEWAUTHID Ä÷³¿¡ Á¦°øµÈ °ªÀ¸·Î º¯°æµÇ´Âµ¥, °ø¹éÀÇ NEWAUTHID °ªÀº À̸§ÀÌ º¯°æµÇÁö ¾ÊÀ½À» ³ªÅ¸³À´Ï´Ù. OS/390¿ë DB2 Universal Database¿¡¼ ¼öÇàÇÏ´Â ¸ðµç OS/390¿ë DB2 Universal Database ÀÚ¿ø ±ÇÇÑ Á¡°Ë(¿¹: SQL Å×ÀÌºí Æ¯±Ç)Àº ÃÖÃÊÀÇ »ç¿ëÀÚ À̸§ÀÌ ¾Æ´Ï¶ó º¯È¯µÈ ÀÏ¹Ý »ç¿ëÀÚ À̸§¿¡ ´ëÇØ ¼öÇàµË´Ï´Ù.
OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͷκÎÅÍ ÀÏ¹Ý »ç¿ëÀÚ À̸§À» ¼ö½ÅÇÒ ¶§ OS/390¿ë DB2 Universal Database Àιٿîµå À̸§ º¯È¯ ±â´ÉÀ» »ç¿ëÇÏ¿© ¿©·¯ °³ÀÇ ÀÛ¾÷À» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUNYC', ' ', 'A', 'N', 'N', 'I'); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', 'JONES', 'LUNYC', 'NYJONES', ' ');
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUNYC', ' ', 'A', 'N', 'N', 'I'); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', ' ', 'LUNYC', 'NYUSER', ' ');
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('LUNYC', ' ', 'A', 'N', 'N', 'I'); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', 'SMITH', 'LUNYC', ' ', ' '); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', 'JONES', 'LUNYC', ' ', ' ');
INSERT INTO SYSIBM.LUNAMES (LUNAME, SYSMODENAME, SECURITY_IN, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES (' ', ' ', 'A', 'N', 'N', 'I'); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', ' ', 'LUNYC', ' ', ' '); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('I', ' ', 'LUCHI', ' ', ' ');
SNA ¿¬°á¿¡ ´ëÇØ LU 6.2´Â ´ÙÀ½°ú °°Àº 3°³ÀÇ ÁÖ¿ä ³×Æ®¿öÅ© º¸¾È ±â´ÉÀ» Á¦°øÇÕ´Ï´Ù.
³×Æ®¿öÅ© º¸¾È¿¡´Â OS/390¿ë DB2 Universal Database¿¡¼ ¼¼¼Ç ·¹º§ º¸¾È°ú ¾Ïȣȸ¦ ÁöÁ¤ÇÏ´Â ¹æ¹ýÀÌ ±â¼úµÇ¾î ÀÖ½À´Ï´Ù. OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ¿Í µ¿ÀÏÇÑ ¹æ¹ýÀ¸·Î ¼¼¼Ç ·¹º§ º¸¾È°ú ¾Ïȣȸ¦ »ç¿ëÇÕ´Ï´Ù.
³²¾Æ ÀÖ´Â ÇѰ¡Áö ³×Æ®¿öÅ© º¸¾È °í·Á»çÇ×ÀÌ SNA ´ëÈ ·¹º§ º¸¾ÈÀÔ´Ï´Ù. ´ëÈ ·¹º§ º¸¾ÈÀÇ ¸î¸î »çÇ×Àº OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ °íÀ¯ÇÕ´Ï´Ù. OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â ³×Æ®¿öÅ© º¸¾È¿¡¼ µÎ °¡ÁöÀÇ Æ¯º°ÇÑ ¿ªÇÒÀ» ¼öÇàÇÕ´Ï´Ù.
º¸¾È À§¹ÝÀÌ ¹ß°ßµÇ¸é LU 6.2´Â SNA º¸¾È ½ÇÆÐ °¨Áö ÄÚµå('080F6051'X)¸¦ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅÍ¿¡ ¸®Åϵǵµ·Ï MVS/ESA¿ë DB2 ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ ¿ä±¸ÇÕ´Ï´Ù. ÀÌ·¯ÇÑ °¨Áö Äڵ尡 ½ÇÆÐ ¿øÀÎÀ» ±â¼úÇÏÁö´Â ¾ÊÀ¸¹Ç·Î, OS/390¿ë DB2 Universal Database´Â ºÐ»ê º¸¾È À§¹ÝÀÇ ¿øÀÎÀ» ±â·ÏÇϱâ À§ÇÑ µÎ °¡Áö ¹æ¹ýÀ» Á¦°øÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ÀÚ¿øÀÇ ¼ÒÀ¯Àڷμ OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö´Â OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ »óÁÖÇÏ´Â SQL ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ µ¥ÀÌÅͺ£À̽º º¸¾È ±â´ÉÀ» Á¦¾îÇÕ´Ï´Ù. OS/390¿ë DB2 Universal Database °ü¸® ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ ¾×¼¼½º´Â Ư±Ç¿¡ ÀÇÇØ Á¦¾îµÇ´Âµ¥ ÀÌ·¯ÇÑ Æ¯±ÇÀº OS/390¿ë DB2 Universal Database °ü¸®ÀÚ³ª °³º° ¿ÀºêÁ§Æ®ÀÇ ¼ÒÀ¯ÀÚ¿¡ ÀÇÇØ »ç¿ëÀÚ¿¡°Ô ºÎ¿©µË´Ï´Ù. OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ Á¦¾îÇÏ´Â µÎ °³ÀÇ ±âº»ÀûÀÎ ¿ÀºêÁ§Æ® Ŭ·¡½º´Â ´ÙÀ½°ú °°½À´Ï´Ù.
ÀÏ¹Ý »ç¿ëÀÚ°¡ ÆÐŰÁö¸¦ ¼ÒÀ¯Çϸé, ±× »ç¿ëÀÚ´Â ÆÐŰÁö¸¦ ÀÚµ¿À¸·Î ¼öÇàÇϰųª ¹Ù²Ü ¼ö ÀÖ½À´Ï´Ù. ´Ù¸¥ ÀÏ¹Ý »ç¿ëÀÚ°¡ GRANT ¸í·É¹®À» »ç¿ëÇÏ¿© OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡¼ ÆÐŰÁö¸¦ ½ÇÇàÇÏ·Á¸é Ưº°È÷ ±ÇÇÑÀ» ºÎ¿©¹Þ¾Æ¾ß ÇÕ´Ï´Ù. °¢ ÀÏ¹Ý »ç¿ëÀÚ³ª PUBLIC¿¡ USE ±ÇÇÑÀ» ºÎ¿©ÇÏ¿© ¸ðµç ÀÏ¹Ý »ç¿ëÀÚ°¡ ÆÐŰÁö¸¦ ¼öÇàÇϵµ·Ï ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ÀÌ OS/390¿ë DB2 Universal Database¿¡ ¹ÙÀεåµÉ ¶§ ÆÐŰÁö¿¡´Â ÀÀ¿ëÇÁ·Î±×·¥¿¡ Æ÷ÇÔµÈ SQL¹®ÀÌ µé¾î°©´Ï´Ù. ÀÌ·¯ÇÑ SQL¹®Àº ´ÙÀ½°ú °°ÀÌ ºÐ·ùµË´Ï´Ù.
ÀÏ¹Ý »ç¿ëÀÚ¿¡°Ô ÆÐŰÁö ½ÇÇà ±ÇÇÑÀÌ ºÎ¿©µÇ¸é À̵éÀº ÆÐŰÁö¿¡ µé¾î ÀÖ´Â °¢ Á¤Àû SQL¹®À» ½ÇÇàÇÒ ±ÇÇÑÀ» ÀÚµ¿À¸·Î °®°Ô µË´Ï´Ù. µû¶ó¼, ÀÏ¹Ý »ç¿ëÀÚ°¡ ½ÇÇàÇÏ´Â ÆÐŰÁö¿¡ Á¤Àû SQL¹®¸¸ÀÌ µé¾î ÀÖ´Â °æ¿ì, ÀÏ¹Ý »ç¿ëÀÚ¿¡°Ô´Â OS/390¿ë DB2 Universal Database Å×ÀÌºí Æ¯±ÇÀÌ ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù.
ÆÐŰÁö ÀÛ¼º½Ã DISABLE/ENABLE ¿É¼ÇÀ» »ç¿ëÇÏ¸é ÆÐŰÁö¸¦ ½ÇÇàÇÒ ¼ö ÀÖ´Â OS/390¿ë DB2 Universal Database ¿¬°á À¯ÇüÀ» Á¦¾îÇÒ ¼ö ÀÖ½À´Ï´Ù. RACF¿Í OS/390¿ë DB2 Universal Database º¸¾È exit ·çƾÀ» »ç¿ëÇÏ¿© ÀÏ¹Ý »ç¿ëÀÚÀÇ DDF »ç¿ëÀ» ¼±ÅÃÀûÀ¸·Î Çã¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. RLF¸¦ »ç¿ëÇÏ¿© ¿ø°Ý ¹ÙÀεå¿Í µ¿Àû SQL ½ÇÇàÀÇ Ã³¸® ½Ã°£¿¡ ´ëÇØ ÇѰ踦 ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
JOE°¡ ¼ÒÀ¯ÇÑ MYPKG¶ó´Â À̸§ÀÇ OS/390¿ë DB2 Universal Database ÆÐŰÁö¸¦ °í·ÁÇØ º¸½Ê½Ã¿À. JOE´Â SALÀÌ OS/390¿ë DB2 Universal Database GRANT USE ¸í·É¹®À» ¹ßÇàÇÏ¿© ÆÐŰÁö¸¦ ½ÇÇàÇϵµ·Ï Çã¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. SALÀÌ ÆÐŰÁö¸¦ ½ÇÇàÇÒ ¶§ ´ÙÀ½ÀÌ ¹ß»ýµË´Ï´Ù.
OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö°¡ »ç¿ëÇÏ´Â º¸¾È ¼ºê½Ã½ºÅÛ(RACF ¶Ç´Â RACF ȣȯ Á¦Ç°)Àº SYSIBM.LUNAMES Å×ÀÌºí¿¡ Àιٿîµå À̸§ º¯È¯ ±â´ÉÀ» Á¤ÀÇÇÏ´Â ¹æ½Ä¿¡ µû¶ó ´Þ¶óÁý´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͷκÎÅÍÀÇ ¿äû¿¡ »ç¿ëÀÚ ID¸¸ µé¾î ÀÖ´Â °æ¿ì(SECURITY=SAME), ¿ÜºÎ º¸¾È ½Ã½ºÅÛÀº È£ÃâµÇÁö ¾Ê½À´Ï´Ù. ±× ÀÌÀ¯´Â Àιٿîµå À̸§ º¯È¯ ±ÔÄ¢ÀÌ OS/390¿ë DB2 Universal Database ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¿¡ ¿¬°áÇÒ ¼ö ÀÖ´Â »ç¿ëÀÚ¸¦ Á¤ÀÇÇϱ⠶§¹®ÀÔ´Ï´Ù.
»ç¿ëÁßÀÎ OS/390¿ë DB2 Universal Database ¼ºê½Ã½ºÅÛÀÌ °¢ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹öÀÇ CCSID¸¦ »ç¿ëÀÚ OS/390¿ë DB2 Universal Database ¼ºê½Ã½ºÅÛÀÇ ¼³Ä¡ CCSID·Î º¯È¯ÇÒ ¼ö ÀÖ´Â ´É·ÂÀÌ ÀÖ´ÂÁö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù. µ¥ÀÌÅÍ Ç¥½Ã¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.