°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
µ¥ÀÌÅͺ£À̽º ³»¿¡¼ ÇöÀç ÅØ½ºÆ® À妽º¿¡ ´ëÇÑ Á¤º¸¸¦ °¡Á®¿À·Á¸é, ºä¸¦ »ç¿ëÇϽʽÿÀ. ¿¹¸¦ µé¾î, ÇöÀç µ¥ÀÌÅͺ£À̽º µðÆúÆ®¿¡ ´ëÇØ ¾Ë·Á¸é, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2 "select * from db2ext.dbdefaults"
ÇöÀç »ç¿ë °¡´ÉÇÑ À妽º, ÇØ´çµÇ´Â Å×ÀÌºí ¹× Àε¦½ÌµÈ ¹®¼ ¼ö¿¡ ´ëÇÑ Á¤º¸¸¦ º¸·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2 "select indschema, indname, tabschema, tabname, number_docs from db2ext.textindexes"ƯÁ¤ À妽º Çü½Ä¿¡ ´ëÇØ¼´Â ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2 "select format, modelname from db2ext.textindexformats where indschema = 'DB2EXT' and indname = 'TITLE'"
ÀÚ¼¼ÇÑ Á¤º¸´Â ºÎ·Ï C, Net Search Extender Á¤º¸ īŻ·Î±×¸¦ ÂüÁ¶ÇϽʽÿÀ.
commitcount°¡ ¼³Á¤µÇÁö ¾ÊÀ¸¸é, db2ext.textindexesÀÇ number_docs ¸Å°³º¯¼ö°¡ °»½ÅµÇÁö ¾Ê½À´Ï´Ù. °»½Å ÇÁ·Î¼¼½º Áß¿¡ °»½ÅµÈ ¹®¼ÀÇ ¼ö¸¦ º¸·Á¸é, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2text CONTROL LIST ALL LOCKS FOR DATABASE sample INDEX db2ext.title
ÀÚ¼¼ÇÑ Á¤º¸´Â CONTROLÀ» ÂüÁ¶ÇϽʽÿÀ.