´ÙÀ½ ÅؽºÆ®´Â Á¦ 6 Àå ¼º´É Á¶Á¤ ³¡ºÎºÐ¿¡¼ ´Ù·ì´Ï´Ù.
BIND ¿É¼Ç, INSERT BUF¸¦ ÀÌ¿ëÇÑ DB2 Query Patroller ¼º´É Çâ»ó
±âº»ÀûÀ¸·Î DB2 Query Patroller´Â °á°ú Å×À̺íÀ» ÀÛ¼ºÇØ °ü¸®ÇÒ Á¶È¸ °á°ú¸¦ ÀúÀåÇÕ´Ï´Ù. ÀÌ °á°ú Å×À̺íÀÇ »ðÀÔ ¼º´ÉÀ» Çâ»ó½ÃÅ°·Á¸é DB2 Query Patroller ¹ÙÀεå ÆÄÀÏ Áß Çϳª¸¦ ¹ÙÀεùÇÒ ¶§ INSERT BUF ¿É¼ÇÀ» Æ÷ÇÔÇϽʽÿÀ.
´ÙÀ½°ú °°ÀÌ DB2 Query Patroller ¹ÙÀεå ÆÄÀÏÀ» µ¥ÀÌÅͺ£À̽º¿¡ ¹ÙÀεùÇϽʽÿÀ.
WindowsÀÇ DB2_RUNTIME\bnd µð·ºÅ丮 ¶Ç´Â UNIXÀÇ DB2_RUNTIME/bnd °æ·Î¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 connect to database user iwm using password db2 bind @db2qp.lst blocking all grant public db2 bind iwmsx001.bnd insert buf db2 bind @db2qp_sp.lst db2 commit
¿©±â¼, database´Â DB2 Query Patroller°¡ °ü¸®ÇÒ ´ëü µ¥ÀÌÅͺ£À̽ºÀÔ´Ï´Ù.
±×¸®°í password´Â °ü¸® »ç¿ëÀÚ °èÁ¤, iwmÀÇ ¾ÏÈ£¸¦ ³ªÅ¸³À´Ï´Ù.