ÀÌ Àý¿¡¼´Â ´ÙÀ½¿¡ °üÇÑ Á¤º¸¸¦ Ç¥½ÃÇÏ´Â ¸í·ÉÀ» ¼³¸íÇÕ´Ï´Ù.
¿ä¾à |
---|
|
´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
db2tx GET STATUS
´ÙÀ½Àº GET STATUS¿¡ ÀÇÇØ Ç¥½ÃµÈ Ãâ·ÂÀÇ ¿¹ÀÔ´Ï´Ù. ÀÌ ¿¹´Â µ¥ÀÌÅͺ£À̽ºÀÇ »ç¿ë °¡´ÉÈ »óÅÂ, ¸ðµç »ç¿ë °¡´ÉÈµÈ Å×ÀÌºí ¹× ÅØ½ºÆ® Ä÷³ÀÇ »óÅ ¶Ç´Â ¿©±â¿¡ Æ÷ÇÔµÈ ÅØ½ºÆ® ÆÄÀÏÀÇ »ç¿ë °¡´ÉÈ »óŸ¦ ³ªÅ¸³À´Ï´Ù.
Database is enabled for Text Extender Table DB2TX.MYTABLE is enabled as a common-index table Table DB2TX.MYTABLE is enabled as a common-index table TextColumnName HandleColumnName -------------- ---------------- COMMENT COMMENTHANDLE Table DB2TX.TEST is enabled as a multi-index table TextColumnName HandleColumnName -------------- ---------------- ABSTRACT1 ABSTRACT1HANDLE ABSTRACT2 ABSTRACT2HANDLE
¿ä¾à |
---|
|
´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
db2tx GET ENVIRONMENT
´ÙÀ½Àº GET ENVIRONMENT¿¡ ÀÇÇØ Ç¥½ÃµÈ Ãâ·ÂÀÇ ¿¹ÀÔ´Ï´Ù. ÀÌ ¿¹¿¡¼ DB2 Text Extender ȯ°æ º¯¼öÀÇ ÇöÀç ¼³Á¤°ªÀ» ³ªÅ¸³À´Ï´Ù.
Current database manager instance (DB2INSTANCE) = db2 Default database name (DB2DBDFT) = my_database Instance name (DB2TX_INSTOWNER) = user1 Instance directory (DB2TX_INSTOWNERHOMEDIR) = /usr/instance1
¿ä¾à |
---|
00½Ã±â 000ÅØ½ºÆ® ¹× »öÀÎ¿ë ±âº»°ª ¼³Á¤°ú ÇÁ·Î¼¼½º Á¤º¸°¡ ÇÊ¿äÇÑ °æ¿ì. 000¸í·É 000GET TEXT CONFIGURATION 000±ÇÇÑ ºÎ¿© 000¾øÀ½ 00 |
ÀÌ ¼³Á¤Àº ÅØ½ºÆ® ±¸¼º ¼³Á¤¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù. ¼³Á¤À» º¯°æÇÏ·Á¸é, ÅØ½ºÆ® ±¸¼º º¯°æÀ» ÂüÁ¶ÇϽʽÿÀ.
ÅØ½ºÆ® ±¸¼ºÀ» º¯°æÇÏ·Á¸é, ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
db2tx GET TEXT CFG
´ÙÀ½Àº GET TEXT CONFIGURATION¿¡ ÀÇÇØ Ç¥½ÃµÈ Ãâ·ÂÀÇ ¿¹ÀÔ´Ï´Ù. ÀÌ ¿¹´Â ÇöÀç ÅØ½ºÆ® ±¸¼º ¼³Á¤À» ³ªÅ¸³À´Ï´Ù.
Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS Index type (INDEXTYPE) = LINGUISTIC Update frequency (UPDATEFREQ) = NONE Index directory (DIRECTORY) = user1/db2tx/indexes Update index option (UPDATEINDEX) = UPDATE Commit count (COMMITCOUNT) = 10 000 Tablespace name (TABLESPACE) = TXLOG
¿ä¾à |
---|
|
¾î¶² »óÅ¿¡¼ »öÀÎÀ» Ž»öÇϰųª °»½ÅÇÒ ¼ö ¾ø´Â »óȲÀÌ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ »óȲ¿¡¼´Â, ¿øÀÎÀ» ÆÇº°ÇÏ´Â µ¥ µµ¿òÀÌ µÉ ¼ö ÀÖ´Â ¸Þ½ÃÁö°¡ »öÀÎÀÇ ·Î±× Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù. ±×·¡¼ ¸Þ½ÃÁö¸¦ ÀÌ¿ëÇÏ¿© »öÀÎÀÇ »óÅÂ¿Í »ç¿ë °¡´ÉÇÑ ¸Þ½ÃÁö°¡ ÀÖ´ÂÁö Á¡°ËÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½ ¿¹´Â °øÅë »öÀÎ Å×À̺íÀÇ »öÀο¡ ´ëÇÑ »öÀÎ »óŸ¦ Ç¥½ÃÇÕ´Ï´Ù.
db2tx GET INDEX STATUS db2tx.mytable
ÀÌ ±¸¹®À» »ç¿ëÇÏ¿© ƯÁ¤ÇÑ ÅØ½ºÆ® Ä÷³¿¡ ´ëÇÑ »öÀÎ »óŸ¦ Ç¥½ÃÇÕ´Ï´Ù. ´ÙÀ½ ¿¹´Â °øÅë »öÀÎ Å×À̺íÀÇ »öÀο¡ ´ëÇÑ »öÀÎ »óŸ¦ È®º¸ÇÕ´Ï´Ù.
db2tx GET INDEX STATUS db2tx.mytable HANDLE commenthandle
´ÙÀ½Àº GET INDEX STATUS¿¡ ÀÇÇØ Ç¥½ÃµÈ Ãâ·Â ¿¹°¡ ÀÖ½À´Ï´Ù.
Node 1 Search status = Search available Update status = Update available Reorg status = started 13.55 Scheduled documents = 0 Indexed documents = 187000 Primary index documents = 130000 Secondary index documents = 57000 Error events = No error events
»öÀÎÀÌ ¿©·¯ ³ëµå¿¡ ºÐ¸®µÇ¸é, ³ëµå Á¤º¸°¡ °¢ ³ëµåº°·Î Ç¥½ÃµË´Ï´Ù.
»öÀÎ ÀÛ¼º½Ã ¹®Á¦°¡ ¹ß»ýÇÒ °æ¿ì, ¿¹¸¦ µé¾î, »öÀÎ ÀÛ¼º½Ã ½ºÄÉÁÙµÈ ¹®¼¸¦ ãÀ» ¼ö ¾ø´Â °æ¿ì, ÀÌ·¯ÇÑ ¿À·ù À̺¥Æ®°¡ »öÀÎÀÇ ·Î±× ÆÄÀÏ¿¡ ±â·ÏµË´Ï´Ù.
À̺¥Æ® ¸®ÅÏ ÄÚµå´Â ¿À·ù À̺¥Æ® ÀÌÀ¯ Äڵ忡 ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.
db2tx.LOGIXnnnnnnÀ̶ó°í ÇÏ´Â ·Î±× Å×ÀÌºí ºä¿¡¼ ¿À·ù À̺¥Æ®¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖÀ¸¸ç, ¿©±â¼ IXnnnnnnÀº »öÀÎÀÇ À̸§À̰í īŻ·Î±× ºä¿¡¼ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.
»öÀθíÀ» È®º¸ÇÏ·Á¸é, ´ÙÀ½À» ½ÇÇàÇϽʽÿÀ.
DB2 SELECT TABLENAME, HANDLENAME, INDEXNAME FROM DB2TX.TEXTCOLUMNS
¿À·ù À̺¥Æ® ºä´Â ´ÙÀ½ ¹èÄ¡¸¦ °®½À´Ï´Ù.
UPDATESTATUS SMALLINT EVENTREASON INTEGER EVENTMESSAGE VARCHAR(1024) UPDATETIME TIMESTAMP HANDLE DB2TEXTH or DB2TEXTFH NODENUMBER INTEGER
´ÙÀ½Àº »öÀÎ ·Î±×¿¡¼ Á¤º¸¸¦ ¾×¼¼½ºÇÏ´Â ¹æ¹ýÀ» ³ªÅ¸³»´Â ¿¹ÀÔ´Ï´Ù.
DB2 SELECT EVENTREASON, EVENTMESSAGE, UPDATETIME, HANDLE FROM DB2TX.LOGIXNNNNNN
¿ä¾à |
---|
00½Ã±â 000»öÀÎ ¼³Á¤¿¡ ´ëÇÑ Á¤º¸°¡ ÇÊ¿äÇÑ °æ¿ì. 000¸í·É 000GET INDEX SETTINGS 000±ÇÇÑ ºÎ¿© 000¾øÀ½ 00 |
´ÙÀ½ ¿¹´Â °øÅë »öÀÎ Å×À̺íÀÇ »öÀο¡ ´ëÇÑ »öÀÎ ¼³Á¤À» È®º¸ÇÕ´Ï´Ù.
db2tx GET INDEX SETTINGS db2tx.mytable
´ÙÀ½ ¿¹´Â ´ÙÁß »öÀÎ Å×À̺í Ä÷³ÀÇ »öÀο¡ ´ëÇÑ »öÀÎ ¼³Á¤À» È®º¸ÇÕ´Ï´Ù.
db2tx GET INDEX SETTINGS db2tx.mytable HANDLE commenthandle
Å×À̺íÀÌ ´ÙÁß »öÀÎ Å×À̺í·Î »ç¿ë °¡´ÉÇÑ °æ¿ì, ÀÌ ¸í·ÉÀº Å×À̺íÀÇ ¸ðµç »ç¿ë °¡´ÉÇÑ ÅØ½ºÆ® Ä÷³ÀÇ »öÀÎ ¼³Á¤À» Ç¥½ÃÇÕ´Ï´Ù.
´ÙÀ½Àº GET INDEX SETTINGS¿¡ ÀÇÇØ °øÅë »öÀÎ Å×ÀÌºí¿¡ ´ëÇØ Ç¥½ÃµÈ Ãâ·ÂÀÇ ¿¹ÀÔ´Ï´Ù. ´ÙÁß »öÀÎ Å×À̺íÀÇ Ãâ·ÂÀº °¢ »öÀο¡ ´ëÇÑ À¯»çÇÑ Á¤º¸¸¦ º¸¿©ÁÝ´Ï´Ù. ÀÌ ±¸¹®À» »ç¿ëÇÏ¿© ƯÁ¤ÇÑ ÅØ½ºÆ® Ä÷³¿¡ ´ëÇÑ »öÀÎ ¼³Á¤À» ¿äûÇÕ´Ï´Ù.
Current index settings: Index type (INDEXTYPE) = LINGUISTIC Update index option (UPDATEINDEX) = UPDATE Update frequency (UPDATEFREQ) = NONE Node 1 Index directory (DIRECTORY) = /home/user1/db2tx/indices
»öÀÎÀÌ ¿©·¯ ³ëµå¿¡ ºÐ¸®µÇ¸é, ÇØ´ç »öÀÎ µð·ºÅ丮ÀÇ ³ëµå Á¤º¸°¡ Ç¥½ÃµË´Ï´Ù.
¿ä¾à |
---|
|
´ÙÀ½ ¿¹´Â °øÅë »öÀÎ Å×À̺íÀÇ »öÀο¡ ´ëÇÑ ÅØ½ºÆ® ¼³Á¤À» È®º¸ÇÕ´Ï´Ù.
db2tx GET TEXT INFO db2tx.mytable
´ÙÀ½ ¿¹´Â ´ÙÁß »öÀÎ Å×À̺í Ä÷³ÀÇ »öÀο¡ ´ëÇÑ ÅØ½ºÆ® Á¤º¸¸¦ È®º¸ÇÕ´Ï´Ù.
db2tx GET TEXT INFO db2tx.mytable HANDLE commenthandle
ÀÌ ±¸¹®À» »ç¿ëÇÏ¿© Å×À̺í À̸§°ú ÇÚµé Ä÷³ À̸§À» ÁöÁ¤ÇÕ´Ï´Ù.
¸í·É¿¡ ÇϳªÀÇ Å×À̺í À̸§¸¸ ÁöÁ¤ÇÏ´Â °æ¿ì, ÀÌ Å×À̺íÀÇ »ç¿ë °¡´ÉÇÑ °¢ Ä÷³¿¡ ´ëÇÑ ÅØ½ºÆ® Á¤º¸°¡ Ç¥½ÃµË´Ï´Ù. ¶ÇÇÑ ÇÚµé Ä÷³ À̸§À» ÁöÁ¤Çϸé, ÇØ´ç Ä÷³¿¡ ´ëÇÑ ÅØ½ºÆ® Á¤º¸¸¸ Ç¥½ÃµË´Ï´Ù.
´ÙÀ½ ÀÌ ¸í·É¿¡ ÀÇÇØ ´ÙÁß »öÀÎ Å×ÀÌºí¿¡ ´ëÇØ Ç¥½ÃµÈ Ãâ·ÂÀÇ ¿¹ÀÔ´Ï´Ù.
Text information for column ABSTRACT1 with handle column ABSTRACT1HANDLE: Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS Text information for column ABSTRACT2 with handle column ABSTRACT2HANDLE: Coded character set ID (CCSID) = 850 Language (LANGUAGE) = US_ENGLISH Format (FORMAT) = TDS