°ü¸® ¾È³»¼­


Ãʱâ Å×ÀÌºí °ø°£ÀÇ Á¤ÀÇ

µ¥ÀÌÅͺ£À̽º°¡ ÀÛ¼ºµÇ¸é, ¼¼ °³ÀÇ Å×ÀÌºí °ø°£ÀÌ Á¤Àǵ˴ϴÙ.

ÁÖ:óÀ½ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ ¶§ »ç¿ëÀÚ Àӽà Å×ÀÌºí °ø°£ÀÌ ÀÛ¼ºµÇÁö ¾Ê½À´Ï´Ù.

CREATE DATABASE ¸í·ÉÀ» »ç¿ëÇÏ¿© ´Ù¸¥ Å×ÀÌºí °ø°£ ¸Å°³º¯¼ö¸¦ ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é, µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥Àº ½Ã½ºÅÛ °ü¸® ÀúÀ念¿ª(SMS) µð·ºÅ丮 ÄÁÅ×À̳ʸ¦ »ç¿ëÇÏ¿© ÀÌ Å×ÀÌºí °ø°£À» ÀÛ¼ºÇÕ´Ï´Ù. ÀÌ·¯ÇÑ µð·ºÅ丮 ÄÁÅ×À̳ʴ µ¥ÀÌÅͺ£À̽º¿ëÀ¸·Î ÀÛ¼ºµÈ ¼­ºêµð·ºÅ丮¿¡ ÀÛ¼ºµË´Ï´Ù(µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 ÂüÁ¶). ÀÌ·¯ÇÑ Å×ÀÌºí °ø°£¿¡ extent Å©±â´Â ±âº»°ªÀ¸·Î ¼³Á¤µË´Ï´Ù.

Á¦¾î ¼¾Å͸¦ »ç¿ëÇÏ¿© Ãʱâ Å×ÀÌºí °ø°£À» Á¤ÀÇÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
  1. µ¥ÀÌÅͺ£À̽º Æú´õ¸¦ ãÀ» ¶§±îÁö ¿ÀºêÁ§Æ® Æ®¸®¸¦ È®ÀåÇϽʽÿÀ.
  2. µ¥ÀÌÅͺ£À̽º Æú´õ¸¦ ¿À¸¥ÂÊ ¸¶¿ì½º ¹öưÀ¸·Î Ŭ¸¯ÇÏ°í ÆË¾÷ ¸Þ´º¿¡¼­ ÀÛ¼º --> ¸¶¹ý»ç¸¦ »ç¿ëÇÑ µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇϽʽÿÀ.
  3. ÀÌ Å¸½ºÅ©¸¦ ¿Ï·áÇÏ·Á¸é ´Ü°è¸¦ µû¸£½Ê½Ã¿À.

¸í·ÉÇàÀ» »ç¿ëÇÏ¿© Ãʱâ Å×ÀÌºí °ø°£À» Á¤ÀÇÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

   CREATE DATABASE <name>
     CATALOG TABLESPACE
       MANAGED BY SYSTEM USING ('<path>')
       EXTENTSIZE <value> PREFETCHSIZE <value>
     USER TABLESPACE
       MANAGED BY DATABASE USING (FILE'<path>' 5000,
                                  FILE'<path>' 5000)
       EXTENTSIZE <value> PREFETCHSIZE <value>
     TEMPORARY TABLESPACE
       MANAGED BY SYSTEM USING ('<path>')
     WITH "<comment>"

ÀÌ·¯ÇÑ Å×ÀÌºí °ø°£¿¡ ´ëÇØ ±âº» Á¤ÀǸ¦ »ç¿ëÇÏÁö ¾ÊÀ¸·Á¸é, CREATE DATABASE ¸í·É¿¡ Ư¼ºÀ» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ ¸í·ÉÀº OS/2¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ ¶§ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.

   CREATE DATABASE PERSONL
     CATALOG TABLESPACE
       MANAGED BY SYSTEM USING ('d:\pcatalog','e:\pcatalog')
       EXTENTSIZE 16 PREFETCHSIZE 32
     USER TABLESPACE
       MANAGED BY DATABASE USING (FILE'd:\db2data\personl' 5000,
                                  FILE'd:\db2data\personl' 5000)
       EXTENTSIZE 32 PREFETCHSIZE 64
     TEMPORARY TABLESPACE
       MANAGED BY SYSTEM USING ('f:\db2temp\personl')
     WITH "Personnel DB for BSchiefer Co"

ÀÌ ¿¹¿¡¼­, °¢°¢ÀÇ Ãʱâ Å×ÀÌºí °ø°£¿¡ ´ëÇÑ Á¤ÀÇ´Â ¸í½ÃÀûÀ¸·Î Á¦°øµË´Ï´Ù. ±âº» Á¤ÀǸ¦ »ç¿ëÇÏÁö ¾ÊÀ¸·Á´Â °æ¿ì¿¡´Â Å×ÀÌºí °ø°£¿¡ ´ëÇØ »ç¿ëÀÚ°¡ Å×ÀÌºí °ø°£ Á¤ÀǸ¦ ÁöÁ¤Çϱ⸸ ÇÏ¸é µË´Ï´Ù.

CREATE DATABASE ¸í·ÉÀÇ MANAGED BYÀýÀ» ÄÚµåÈ­ÇÏ´Â Çü½ÄÀº CREATE TABLESPACE ¸í·ÉÀÇ MANAGED BYÀýÀÇ Çü½Ä°ú µ¿ÀÏÇÕ´Ï´Ù. Ãß°¡ ¿¹´Â Å×ÀÌºí °ø°£ ÀÛ¼º¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

»ç¿ëÀÚÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϱâ Àü¿¡, Å×ÀÌºí °ø°£ ¼³°è ¹× ¼±Åÿ¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]