Information Catalog Manager(ICM) À¯Æ¿¸®Æ¼·Î, ÀÌÁ¦ ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© SQL¹®À» CREATE TABLE¹®ÀÇ ³¡¿¡ Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
CREATEIC \DBTYPE dbtype \DGNAME dgname \USERID userid \PASSWORD password \KA1 userid \TABOPT "directory:\tabopt.file"
DB2°¡ ¼³Ä¡µÈ µð·ºÅ丮¿¡¼ CREATEIC À¯Æ¿¸®Æ¼ÀÇ TABOPT Å°¿öµå¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. TABOPT Å°¿öµå µÚÀÇ °ªÀº Àüü °æ·Î°¡ ÀÖ´Â
tabopt.file ÆÄÀÏ À̸§ÀÔ´Ï´Ù. µð·ºÅ丮 À̸§¿¡ °ø¹éÀÌ Æ÷ÇԵǾî ÀÖÀ¸¸é, À̸§À» ÀοëºÎÈ£·Î ¹À¸½Ê½Ã¿À. tabopt.file ÆÄÀÏÀÇ ³»¿ë¿¡´Â CREATE TABLE¹®¿¡ Ãß°¡ÇÒ Á¤º¸°¡ µé¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù. ¾Æ·¡ÀÇ SQL¹® Áß Çϳª¸¦ »ç¿ëÇÏ¿© ÀÌ tabopt.file ÆÄÀÏ¿¡ ¾µ ¼ö ÀÖ½À´Ï´Ù ICM À¯Æ¿¸®Æ¼´Â ÀÌ ÆÄÀÏÀ» ÀÐÀº µÚ ±×°ÍÀ» CREATE TABLE¹®¿¡ Ãß°¡ÇÕ´Ï´Ù.
IN MYTABLESPACE | MYTABLESPACEÀÇ µ¥ÀÌÅÍ·Î Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. |
DATA CAPTURE CHANGES | Å×À̺íÀ» ÀÛ¼ºÇÏ°í SQL º¯°æ»çÇ×À» È®ÀåµÈ Çü½ÄÀ¸·Î ·Î±×ÇÕ´Ï´Ù. |
IN ACCOUNTING INDEX IN ACCOUNT_IDX | ACCOUNTINGÀÇ µ¥ÀÌÅÍ¿Í ACCOUNT_IDXÀÇ »öÀÎÀ¸·Î Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. |
³»¿ë ÆÄÀÏÀÇ ÃÖ´ë Å©±â´Â 1000°³ÀÇ 1¹ÙÀÌÆ® ¹®ÀÚÀÔ´Ï´Ù.
ÀÌ »õ·Î¿î ±â´ÉÀº Windows¿Í UNIX ½Ã½ºÅÛ¿¡¼¸¸ »ç¿ë °¡´ÉÇÕ´Ï´Ù.
´ÙÀ½ ¸Þ½ÃÁö°¡ Ç¥½ÃµÉ °æ¿ì,
FLG0083E: IBM Information Catalog Manager ÃʱâÈ À¯Æ¿¸®Æ¼¿¡ ´ëÇØ À¯È¿ÇÑ »ç¿ë±ÇÀ» °¡Áö°í ÀÖÁö ¾Ê½À´Ï´Ù. ÇØ´ç Áö¿ªÀÇ ¼ÒÇÁÆ®¿þ¾î »ç¾÷ºÎ³ª IBM ¿µ¾÷ ´ëÇ¥¿¡°Ô ¹®ÀÇÇϽʽÿÀ.
DB2 Warehouse Manager³ª IBM DB2 OLAP Server¸¦ ±¸ÀÔÇÏ°í Information Catalog Manager ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ±¸¼º¿ä¼Ò¿¡ Information Catalog Manager ÃʱâÈ À¯Æ¿¸®Æ¼°¡ ÀÖ½À´Ï´Ù.
DB2 Warehouse Manager³ª IBM DB2 OLAP Server¸¦ ¼³Ä¡ÇÑ ÈÄ ´Ù¸¥ Information Catalog Manager °ü¸®ÀÚ ±¸¼º¿ä¼Ò¸¦ °°Àº ¿öÅ©½ºÅ×À̼ǿ¡ ¼³Ä¡ÇÑ °æ¿ì(DB2 Universal Database CD-ROMÀ» »ç¿ëÇÏ¿©), Information Catalog ÃʱâÈ À¯Æ¿¸®Æ¼ À§¿¡ °ãÃľ²±â ÇÏ¿´À» ¼öµµ ÀÖ½À´Ï´Ù. ±×·¯ÇÑ °æ¿ì, \sqllib\bin µð·ºÅ丮¿¡¼ createic.bak ¹× flgnmwcr.bak ÆÄÀÏÀ» ã°í À̸§À» °¢°¢ createic.exe ¹× flgnmwcr.exe·Î º¯°æÇϽʽÿÀ.
DB2 Universal Database¿¡¼ Ãß°¡ Information Catalog Manager ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÒ °æ¿ì, ±× ±¸¼º¿ä¼ÒµéÀº Data Warehouse Manager¸¦ ¼³Ä¡ÇÑ °÷°ú ´Ù¸¥ º°µµÀÇ ¿öÅ©½ºÅ×À̼ǿ¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 Warehouse Manager ¼³Ä¡ ¾È³»¼¿¡¼ Á¦ 3 Àå Information Catalog Manager ±¸¼º¿ä¼Ò ¼³Ä¡¸¦ ÂüÁ¶ÇϽʽÿÀ.