DB2 Spatial Extender¸¦ ¼³Ä¡ÇÑ ÈÄ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇÏ°í ¼³Ä¡ È®ÀÎ ÇÁ·Î±×·¥À» ½ÇÇà½ÃÄÑ DB2 Spatial Extender°¡ Á¦´ë·Î ¼³Ä¡ ¹× ±¸¼ºµÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
DB2 Spatial Extender »ùÇà ÇÁ·Î±×·¥(runGseDemo)À» »ç¿ëÇÏ¿© ¼³Ä¡¸¦ °ËÁõÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸í·ÉÇà¿¡¼ DB2 µµ±¸ ¶Ç´Â DB2 Á¦¾î ¼¾ÅÍ¿¡ ÀÖ´Â »ç¿ëÀÚ ÀÎÅÍÆäÀ̽º¸¦ ÀÌ¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ±¸¼º ¸Å°³º¯¼ö¸¦ º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ Áö½Ã»çÇ×Àº AIX, Windows NT ¹× Windows 2000¿¡ Àû¿ëµË´Ï´Ù.
¼³Ä¡¸¦ È®ÀÎÇÏ·Á¸é,
·Î±× ÆÄÀÏ Å©±â¸¦ ´Ã¸®·Á¸é,
AIXÀÇ °æ¿ì cd $HOME/sqllib/samples/spatialÀ» ÀÔ·ÂÇϽʽÿÀ. ¿©±â¼ $HOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.
Windows NT ¹× Windows 2000ÀÇ °æ¿ì, cd c:\sqllib\samples\spatialÀ» ÀÔ·ÂÇϽʽÿÀ. ¿©±â¼ c:\sqllib´Â DB2 Spatial Extender¸¦ ¼³Ä¡ÇÑ µð·ºÅ丮ÀÔ´Ï´Ù.
runGseDemo mydb userID password
mydb ¸Å°³º¯¼ö´Â µ¥ÀÌÅͺ£À̽º À̸§ÀÔ´Ï´Ù.
DB2 »ùÇà ÇÁ·Î±×·¥Àº »ç¿ëÀÚ ¼³Ä¡½Ã ¹®Á¦Á¡À» Ç¥¸éÈÇϵµ·Ï ¼³°èµÇ¾ú½À´Ï´Ù. ¼³Ä¡ °ËÁõ Áß¿¡ ±¸Ã¼ÀûÀÎ ½Ã½ºÅÛ ¹®Á¦Á¡À» Áø´ÜÇÏ´Â µ¥ µµ¿òÀÌ µÇ´Â ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù. ´ëºÎºÐÀÇ ¿À·ù ¸Þ½ÃÁö´Â ÀϹÝÀûÀ¸·Î ¼Ò¼öÀÇ »ç¿ëÀÚ ½Ç¼ö¿¡ ÀÇÇØ ¹ß»ýÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ¿À·ù¸¦ ÇÇÇϱâ À§Çؼ´Â ¼³Ä¡ È®ÀÎ ÇÁ·Î±×·¥À» ½ÇÇàÇÒ ¶§¸¶´Ù ´ÙÀ½À» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
DB2 Spatial Extender¸¦ ¼³Ä¡ÇÒ ¶§ (NT ¼³Ä¡ÀÇ °æ¿ì) DB2 Administration Client ¿É¼ÇÀ» ¼±ÅÃÇÏÁö ¾Ê¾Ò°Å³ª (AIX ¼³Ä¡ÀÇ °æ¿ì) Spatial Extender Ŭ¶óÀÌ¾ðÆ® ¿É¼ÇÀ» ¼±ÅÃÇÏÁö ¾ÊÀº °æ¿ì, "ÁöÁ¤µÈ À̸§ÀÌ ³»ºÎ ¹× ¿ÜºÎ ¸í·É, ÀÛµ¿ ÇÁ·Î±×·¥ ¶Ç´Â Àϰýó¸® ÆÄÀÏ·Î ÀνĵÇÁö ¾Ê½À´Ï´Ù."¶ó´Â ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
ÀÌ ¿À·ù´Â ½Ã½ºÅÛ¿¡ »ùÇà ÇÁ·Î±×·¥ÀÌ »ç¿ë °¡´ÉÇÏÁö ¾Ê±â ¶§¹®¿¡ ¹ß»ýÇÕ´Ï´Ù. »ùÇà ÇÁ·Î±×·¥Àº DB2 Administration Client ¹× Spatial Extender Ŭ¶óÀÌ¾ðÆ®¿Í ÇÔ²² ÆÐŰÁö·Î Á¦°øµË´Ï´Ù. DB2 Administration Client ¶Ç´Â Spatial Extender Ŭ¶óÀÌ¾ðÆ®°¡ ½Ã½ºÅÛ¿¡ ¼³Ä¡µÇ¾î ÀÖÁö ¾Ê´Ù¸é ½Ã½ºÅÛ¿¡¼ »ùÇà ÇÁ·Î±×·¥µµ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
ÀÌ ¹®Á¦Á¡À» ¼öÁ¤ÇÏ·Á¸é,
»ùÇà ÇÁ·Î±×·¥À» ½ÇÇà ÁßÀÎ µ¥ÀÌÅͺ£À̽º°¡ ÀÌ¹Ì °ø°£ÀûÀ¸·Î »ç¿ë °¡´ÉÇÑ °æ¿ì ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
Enabling database logtst... Returning from ENABLE_DB: Return code = -14 Return message text = GSE0014E µ¥ÀÌÅͺ£À̽º°¡ °ø°£ µ¥ÀÌÅÍ °ü·Ã ÀÛ¾÷¿ëÀ¸·Î ÀÌ¹Ì »ç¿ë °¡´ÉÇÕ´Ï´Ù.
ÀÌ ¹®Á¦Á¡À» Á¤Á¤ÇÏ·Á¸é µ¥ÀÌÅͺ£À̽º¸¦ Á¦°ÅÇÏ°í ¼³Ä¡ °ËÁõÀÇ ´Ü°è¸¦ ¹Ýº¹ÇϽʽÿÀ.
µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º¿¡¼ UDF ¸Þ¸ð¸® »ç¿ë Å©±â¸¦ Áõ°¡½ÃŰ´Â µ¥ ½ÇÆÐÇÑ °æ¿ì ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
An unexpected SQL error ("SQL0973N Not enough storage is available in the "UDF_MEM" heap to process the statement. ") has occurred. SQLSTATE=57011
µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º Å©±â¸¦ Áõ°¡½ÃŰ´Â ¹æ¹ý¿¡ ´ëÇØ¼´Â ¼³Ä¡ °ËÁõÀÇ 2 ´Ü°è¸¦ ÂüÁ¶ÇϽʽÿÀ.
·Î±× ÆÄÀÏ Å©±â¸¦ Áõ°¡½ÃŰ´Â µ¥ ½ÇÆÐÇÑ °æ¿ì ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
Enabling database logtst... Returning from EN ABLE_DB: Return code = -8 Return message text = GSE0008E An unexpected SQL error ("SQL3306N An SQL error "-964" occurred while inserting a row into ") has occurred.
·Î±× ÆÄÀÏ Å©±â¸¦ Áõ°¡½ÃŰ´Â ¹æ¹ý¿¡ ´ëÇØ¼´Â ¼³Ä¡ °ËÁõÀÇ 4 ´Ü°è¸¦ ÂüÁ¶ÇϽʽÿÀ.