DB2 Extender·Î ÀÛ¾÷ÇÒ ¶§, »ç¿ëÇÏÁö ¾Ê´Â Ç׸ñµéÀÌ °ü¸® Áö¿ø Å×ÀÌºí¿¡ ¸ðÀÏ ¼ö ÀÖ½À´Ï´Ù. ´©±º°¡ µ¥ÀÌÅͺ£À̽º¿¡¼ ¹Ìµð¾î ÆÄÀÏÀº »èÁ¦ÇßÀ¸³ª ÀÌ¿¡ ´ëÇÑ ÂüÁ¶´Â »èÁ¦ÇÏÁö ¾Ê¾ÒÀ»Áö ¸ð¸¨´Ï´Ù. »ç¿ëÇÏÁö ¾Ê´Â ¸ÞŸµ¥ÀÌÅ͸¦ »èÁ¦ÇÏ¿© ¼º´ÉÀ» Çâ»ó½Ã۰í ÀúÀå °ø°£À» ȸ¼öÇÒ ¼ö ÀÖ½À´Ï´Ù.
API »ç¿ë: ´ÙÀ½ ¿¹½ÃÀÇ »ùÇà ÄÚµå´Â ANTITAS¿¡¼ ¼ÒÀ¯ÇÏ´Â ¸ðµç »ç¿ëÀÚ Å×ÀÌºí¿¡ ´ëÇÑ À̹ÌÁö ¸ÞŸµ¥ÀÌÅ͸¦ Á¤¸®ÇÕ´Ï´Ù. À̰ÍÀº ÀϺΠ¿À·ù Á¡°Ë Äڵ带 Æ÷ÇÔÇÕ´Ï´Ù. ¿ÏÀüÇÑ »ùÇà ÇÁ·Î±×·¥Àº SAMPLES ¼ºêµð·ºÅ丮ÀÇ API.C ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.
±×¸² 16. °ü¸® Áö¿ø Å×À̺íÀ» Á¤¸®ÇÏ´Â »ùÇà ÄÚµå
/*---- query database using DBiAdminReorgMetadata API ----*/ step="DBiAdminReorgMetadata API"; rc = DBiAdminReorgMetadata("anitas"); if (rc < 0) { printf("%s: %s FAILED!\n", argv[0], step); printMsg(rc); DBiGetError(&sqlcode, errorMsgText); printf("sqlcode=%i, errorMsgText=%s\n", sqlcode, errorMsgText); fail = TRUE; } else if (rc > 0) { printf("%s: %s, warning detected.\n", argv[0], step); printMsg(rc); DBiGetError(&sqlcode, errorMsgText); printf("sqlcode=%i, errorMsgText=%s\n", sqlcode, errorMsgText); } else printf("%s: %s PASSED\n\n", argv[0], step); /*---- end of query using DBiAdminReorgMetadata API ----*/ |
db2ext ¸í·ÉÇà »ç¿ë:
reorg database user anitas for db2image
DBA´Â ¾Æ´ÏÁö¸¸ CONTROL ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ¶ó¸é, DBxReorgMetadata API ¶Ç´Â REORG ¸í·ÉÀ» »ç¿ëÇÏ¿© ¼ÒÀ¯ÇÑ Å×ÀÌºí¿¡ ´ëÇÑ ¸ÞŸµ¥ÀÌÅ͸¦ Á¤¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù.