µ¥ÀÌÅͺ£À̽º°¡ ÀÛ¼ºµÇ¸é, ¼¼ °³ÀÇ Å×ÀÌºí °ø°£ÀÌ Á¤Àǵ˴ϴÙ.
ÁÖ: | óÀ½ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÒ ¶§ »ç¿ëÀÚ Àӽà Å×ÀÌºí °ø°£ÀÌ ÀÛ¼ºµÇÁö ¾Ê½À´Ï´Ù. |
CREATE DATABASE ¸í·ÉÀ» »ç¿ëÇÏ¿© ´Ù¸¥ Å×ÀÌºí °ø°£ ¸Å°³º¯¼ö¸¦ ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é, µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥Àº ½Ã½ºÅÛ °ü¸® ÀúÀ念¿ª(SMS) µð·ºÅ丮 ÄÁÅ×À̳ʸ¦ »ç¿ëÇÏ¿© ÀÌ Å×ÀÌºí °ø°£À» ÀÛ¼ºÇÕ´Ï´Ù. ÀÌ·¯ÇÑ µð·ºÅ丮 ÄÁÅ×À̳ʴ µ¥ÀÌÅͺ£À̽º¿ëÀ¸·Î ÀÛ¼ºµÈ ¼ºêµð·ºÅ丮¿¡ ÀÛ¼ºµË´Ï´Ù(µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 ÂüÁ¶). ÀÌ·¯ÇÑ Å×ÀÌºí °ø°£¿¡ extent Å©±â´Â ±âº»°ªÀ¸·Î ¼³Á¤µË´Ï´Ù.
Á¦¾î ¼¾Å͸¦ »ç¿ëÇÏ¿© Ãʱâ Å×ÀÌºí °ø°£À» Á¤ÀÇÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
|
¸í·ÉÇàÀ» »ç¿ëÇÏ¿© Ãʱâ Å×ÀÌºí °ø°£À» Á¤ÀÇÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
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ÀýÀÇ Çü½Ä°ú µ¿ÀÏÇÕ´Ï´Ù. Ãß°¡ ¿¹´Â Å×ÀÌºí °ø°£ ÀÛ¼º¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
»ç¿ëÀÚÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϱâ Àü¿¡, Å×ÀÌºí °ø°£ ¼³°è ¹× ¼±Åÿ¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.