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---+-------------------------------------><
¸í·É ¸Å°³º¯¼ö
¿¹
ÇöÀç µ¥ÀÌÅͺ£À̽º¿ëÀ¸·Î À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.
reorg database for db2image
anita ±ÔÁ¤ÀÚ¸¦ °¡Áø ¸ðµç Å×À̺íÀÇ À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.
reorg database user anita for db2image
employee Å×À̺í¿ë À̹ÌÁö °ü¸® Å×À̺íÀ» À籸¼ºÇϰí Á¤¸®ÇÕ´Ï´Ù.
reorg table employee for db2image
»ç¿ë¹ý Âü°í
ÀÌ ¸í·ÉÀ» »ç¿ëÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.