IBM Books

Image, Audio, Video Extender °ü¸® ¹× ÇÁ·Î±×·¡¹Ö

REORG


Image Audio Video
X X X

ƯÁ¤ Å×À̺í°ú ¿¬°üµÈ °ü¸® Å×À̺í(°ü¸® Å×ÀÌºí ¹× ¼Ó¼º Å×À̺í) ¶Ç´Â ƯÁ¤ ±ÔÁ¤ÀÚ¸¦ °¡Áø Å×ÀÌºí ¶Ç´Â ÇöÀç µ¥ÀÌÅͺ£À̽º ³»ÀÇ ¸ðµç Å×À̺íÀ» Á¤¸®ÇÕ´Ï´Ù.

񀀥

ƯÁ¤ Å×À̺í(REORG TABLEÀ» ¼öÇàÇÏ´Â °æ¿ì) ¶Ç´Â ƯÁ¤ ±ÔÁ¤ÀÚ¸¦ °¡Áø Å×À̺í(REORG DATABASE¸¦ ¼öÇàÇÏ´Â °æ¿ì)ÀÇ °æ¿ì: SYSADM, SYSCTRL, SYSMAINT, DBADM, Control.

µ¥ÀÌÅͺ£À̽º ³»ÀÇ ¸ðµç Å×À̺í(REORG DATABASE¸¦ ¼öÇàÇÏ´Â °æ¿ì)ÀÇ °æ¿ì: SYSADM, SYSCTRL, SYSMAINT, DBADM.

¸í·É ±¸¹®

>>-REORG----+-DATABASE--+----------------+-+--FOR--------------->
            |           '-USER--user_ID--' |
            '-TABLE--table_name------------'
 
      .-,----------------.
      V                  |
>--------extender_name---+-------------------------------------><
 

¸í·É ¸Å°³º¯¼ö

user_ID
Å×À̺íÀÇ ±ÔÁ¤ÀÚ.

table_name
±× °ü¸® Å×À̺íÀ» Á¤¸®ÇϰíÀÚ ÇÏ´Â ÇöÀç µ¥ÀÌÅͺ£À̽º ³»ÀÇ Å×À̺í À̸§.

extender_name
ExtenderÀÇ À̸§. À¯È¿ÇÑ Extender À̸§Àº db2image, db2audio ¹× db2videoÀÔ´Ï´Ù.

¿¹

ÇöÀç µ¥ÀÌÅͺ£À̽º¿ëÀ¸·Î À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.

reorg database for db2image

anita ±ÔÁ¤ÀÚ¸¦ °¡Áø ¸ðµç Å×À̺íÀÇ À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.

reorg database user anita for db2image

employee Å×À̺í¿ë À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.

reorg table employee for db2image

»ç¿ë¹ý Âü°í

ÀÌ ¸í·ÉÀ» »ç¿ëÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]