°ü¸® ¾È³»¼­


°¨»ç ±â´É ·¹ÄÚµå ·¹À̾ƿô

DELASC ¹ßÃé ¿É¼ÇÀ» »ç¿ëÇÏ¿© °¨»ç ·Î±×¿¡¼­ °¨»ç ·¹Äڵ尡 ¹ßÃéµÇ¸é, °¢ ·¹ÄÚµå´Â ´ÙÀ½ Å×ÀÌºí¿¡ Ç¥½ÃµÈ Çü½Ä Áß Çϳª¸¦ °¡Áý´Ï´Ù. °¢ Å×À̺íÀº »ùÇà ·¹ÄÚµåÀÇ ³»¿ëÀ» Ç¥½ÃÇÏ¿© ½ÃÀÛÇÕ´Ï´Ù. ·¹ÄÚµåÀÇ °¢ Ç׸ñ ¼³¸íÀÌ ÇØ´ç Å×ÀÌºí¿¡¼­ ÇÑ ¹ø¿¡ ÇϳªÀÇ Çà¿¡ Ç¥½ÃµË´Ï´Ù. Ç׸ñÀÌ Áß¿äÇϸé, ÇØ´ç Ç׸ñÀÇ À̸§ÀÌ °­Á¶Ç¥½Ã(±½ÀºÃ¼·Î Ç¥½Ã)µË´Ï´Ù. À̵é Ç׸ñ¿¡´Â »ç¿ëÀÚ¿¡°Ô °¡Àå °ü½É ÀÖ´Â Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù.

ÁÖ:

  1. »ùÇà ·¹ÄÚµåÀÇ ¸ðµç Çʵ尡 °ªÀ» °®Áö´Â ¾Ê½À´Ï´Ù.

  2. "¾×¼¼½º°¡ ½ÃµµµÊ"°ú °°Àº ÀϺΠÇʵå´Â ºñÆ®¸ÊÀ¸·Î¼­ Ä÷³ ½Äº°ÀÚ°¡ ÀÖ´Â ASCII Çü½ÄÀ¸·Î ÀúÀåµË´Ï´Ù. ±×·¯³ª, ÀÌ Ç÷§ º¸°í¼­ ÆÄÀÏ¿¡¼­ À̵é Çʵå´Â ºñÆ®¸Ê °ªÀ» Ç¥ÇöÇÏ´Â ¹®ÀÚ¿­ ¼¼Æ®·Î¼­ ³ªÅ¸³³´Ï´Ù.

Ç¥ 27. AUDIT À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-11.54.05.151232;category=AUDIT;audit event=START;
  event correlator=0;event status=0;
  userid=boss;authid=BOSS;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


AUDIT

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº CONFIGURE, DB2AUD, EXTRACT, FLUSH, PRUNE, START, STOP ¹× UPDATE_ADMIN_CFGÀÔ´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID

Ç¥ 28. CHECKING À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-08.42.11.622984;category=CHECKING;audit event=CHECKING_OBJECT;
  event correlator=2;event status=0;
  database=FOO;userid=boss;authid=BOSS;
  application id=*LOCAL.newton.980624124210;application name=testapp;
  object name=FOO;object type=DATABASE;
  access approval reason=DATABASE; access attempted=CONNECT;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


CHECKING

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº CHECKING_OBJECT ¹× CHECKING_FUNCTIONÀÔ´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£
¿ÀºêÁ§Æ® ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ ½ºÅ°¸¶
¿ÀºêÁ§Æ® À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À̸§
¿ÀºêÁ§Æ® À¯Çü VARCHAR(32) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À¯Çü. °¡´ÉÇÑ °ªÀº TABLE, VIEW, ALIAS, FUNCTION, INDEX, PACKAGE, DATA_TYPE, NODEGROUP, SCHEMA, STORED_PROCEDURE, BUFFERPOOL, TABLESPACE, EVENT_MONITOR, TRIGGER, DATABASE, INSTANCE, FOREIGN_KEY, PRIMARY_KEY, UNIQUE_CONSTRAINT, CHECK_CONSTRAINT, WRAPPER, SERVER, NICKNAME, USER MAPPING, SERVER OPTION, TRANSFORM, TYPE MAPPING, FUNCTION MAPPING, SUMMARY TABLES ¹× NONEÀÔ´Ï´Ù.
¾×¼¼½º ½ÂÀÎ ÀÌÀ¯ CHAR(18) ¾×¼¼½º°¡ ÀÌ °¨»ç À̺¥Æ®¿¡ ½ÂÀÎµÈ ÀÌÀ¯¸¦ ³ªÅ¸³À´Ï´Ù. °¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â ù¹øÂ° ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù.
¾×¼¼½º°¡ ½ÃµµµÊ CHAR(18) ½ÃµµµÈ ¾×¼¼½º À¯ÇüÀ» ³ªÅ¸³À´Ï´Ù. °¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â µÎ¹øÂ° ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù.

´ÙÀ½Àº °¡´ÉÇÑ CHECKING ¾×¼¼½º ½ÂÀÎ ÀÌÀ¯ÀÇ ¸ñ·ÏÀÔ´Ï´Ù.

0x0000000000000001 ACCESS DENIED
¾×¼¼½º°¡ ½ÂÀεÇÁö ¾Ê°í °ÅºÎµÇ¾ú½À´Ï´Ù.

0x0000000000000002 SYSADM
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ SYSADM ±ÇÇÑÀ» °¡Áý´Ï´Ù.

0x0000000000000004 SYSCTRL
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ SYSCTRL ±ÇÇÑÀ» °¡Áý´Ï´Ù.

0x0000000000000008 SYSMAINT
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ SYSMAINT ±ÇÇÑÀ» °¡Áý´Ï´Ù.

0x0000000000000010 DBADM
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ DBADM ±ÇÇÑÀ» °¡Áý´Ï´Ù.

0x0000000000000020 DATABASE PRIVILEGE
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ µ¥ÀÌÅͺ£À̽º¿¡¼­ ¸í½ÃÀû Ư±ÇÀ» °¡Áý´Ï´Ù.

0x0000000000000040 OBJECT PRIVILEGE
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ ¿ÀºêÁ§Æ® ¶Ç´Â ±â´É¿¡¼­ ¸í½ÃÀû Ư±ÇÀ» °¡Áý´Ï´Ù.

0x0000000000000080 DEFINER
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ ¿ÀºêÁ§Æ® ¶Ç´Â ±â´ÉÀÇ Á¤ÀÇÀÚÀÔ´Ï´Ù.

0x0000000000000100 OWNER
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ ¿ÀºêÁ§Æ® ¶Ç´Â ±â´ÉÀÇ ¼ÒÀ¯ÀÚÀÔ´Ï´Ù.

0x0000000000000200 CONTROL
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ ¿ÀºêÁ§Æ® ¶Ç´Â ±â´É¿¡¼­ CONTROL Ư±ÇÀ» °¡Áý´Ï´Ù.

0x0000000000000400 BIND
¾×¼¼½º°¡ ½ÂÀεǾúÀ¸¸ç, ÀÀ¿ëÇÁ·Î±×·¥/»ç¿ëÀÚ°¡ ÆÐŰÁö¿¡¼­ ¹ÙÀÎµå Æ¯±ÇÀ» °¡Áý´Ï´Ù.

´ÙÀ½Àº °¡´ÉÇÑ CHECKING ¾×¼¼½º°¡ ½ÃµµµÊ À¯ÇüÀÇ ¸ñ·ÏÀÔ´Ï´Ù.

0x0000000000000002 ALTER
¿ÀºêÁ§Æ® º¯°æ ½Ãµµ

0x0000000000000004 DELETE
¿ÀºêÁ§Æ® »èÁ¦ ½Ãµµ

0x0000000000000008 INDEX
»öÀÎ »ç¿ë ½Ãµµ

0x0000000000000010 INSERT
¿ÀºêÁ§Æ®·Î »ðÀÔ ½Ãµµ

0x0000000000000020 SELECT
Å×ÀÌºí ¶Ç´Â ºäÀÇ Á¶È¸ ½Ãµµ

0x0000000000000040 UPDATE
¿ÀºêÁ§Æ®¿¡¼­ÀÇ µ¥ÀÌÅÍ °»½Å ½Ãµµ

0x0000000000000080 REFERENCE
¿ÀºêÁ§Æ®°£ÀÇ ÂüÁ¶ Á¦ÇÑÁ¶°Ç ¼³Á¤ ½Ãµµ

0x0000000000000100 CREATE
¿ÀºêÁ§Æ® ÀÛ¼º ½Ãµµ

0x0000000000000200 DROP
¿ÀºêÁ§Æ® »èÁ¦ ½Ãµµ

0x0000000000000400 CREATEIN
´Ù¸¥ ½ºÅ°¸¶ ³»¿¡¼­ ¿ÀºêÁ§Æ® ÀÛ¼º ½Ãµµ

0x0000000000000800 DROPIN
´Ù¸¥ ½ºÅ°¸¶ ³»¿¡¼­ ¹ß°ßµÈ ¿ÀºêÁ§Æ® »èÁ¦ ½Ãµµ

0x0000000000001000 ALTERIN
´Ù¸¥ ½ºÅ°¸¶ ³»¿¡¼­ ¹ß°ßµÈ ¿ÀºêÁ§Æ® º¯°æ ¶Ç´Â ¼öÁ¤ ½Ãµµ

0x0000000000002000 EXECUTE
ÀÀ¿ëÇÁ·Î±×·¥ ½ÇÇà ¶Ç´Â ¼öÇà ½Ãµµ

0x0000000000004000 BIND
ÀÀ¿ëÇÁ·Î±×·¥ ¹ÙÀÎµå ¶Ç´Â Áغñ ½Ãµµ

0x0000000000008000 SET EVENT MONITOR
À̺¥Æ® ¸ð´ÏÅÍ ½ºÀ§Ä¡ ¼³Á¤ ½Ãµµ

0x0000000000010000 SET CONSTRAINTS
¿ÀºêÁ§Æ®¿¡¼­ Á¦ÇÑÁ¶°Ç ¼³Á¤ ½Ãµµ

0x0000000000020000 COMMENT ON
¿ÀºêÁ§Æ®¿¡¼­ ÁÖ¼® ÀÛ¼º ½Ãµµ

0x0000000000040000 GRANT
¿ÀºêÁ§Æ®ÀÇ Æ¯±ÇÀ» ¶Ç´Ù¸¥ »ç¿ëÀÚ ID·Î ±ÇÇÑ ºÎ¿© ½Ãµµ

0x0000000000080000 REVOKE
»ç¿ëÀÚ ID¿¡¼­ ¿ÀºêÁ§Æ®ÀÇ Æ¯±Ç ±ÇÇÑ Ãë¼Ò ½Ãµµ

0x0000000000100000 LOCK
¿ÀºêÁ§Æ® Àá±Ý ½Ãµµ

0x0000000000200000 RENAME
¿ÀºêÁ§Æ® À̸§ ¹Ù²Ù±â ½Ãµµ

0x0000000000400000 CONNECT
¿ÀºêÁ§Æ® ¿¬°á ½Ãµµ

0x0000000000800000 Member of SYS Group
SYS ±×·ìÀÇ ±¸¼º¿ø¿¡ ¾×¼¼½ºÇϰųª »ç¿ëÇÏ·Á°í ½Ãµµ

0x0000000001000000 Access All
º¸À¯µÈ ¿ÀºêÁ§Æ®¿¡¼­ ¸ðµç Çʼö Ư±ÇÀ¸·Î ¸í·É¹® ½ÇÇà ½Ãµµ (DBADM/SYSADM¿¡¸¸ »ç¿ë).

0x0000000002000000 Drop All
´ÙÁß ¿ÀºêÁ§Æ® »èÁ¦ ½Ãµµ

0x0000000004000000 LOAD
Å×ÀÌºí °ø°£¿¡¼­ Å×ÀÌºí ·Îµå ½Ãµµ

0x0000000008000000 USE
Å×ÀÌºí °ø°£¿¡¼­ Å×À̺í ÀÛ¼º ½Ãµµ

Ç¥ 29. OBJMAINT À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-08.42.41.957524;category=OBJMAINT;audit event=CREATE_OBJECT;
  event correlator=3;event status=0;
  database=FOO;userid=boss;authid=BOSS;
  application id=*LOCAL.newton.980624124210;application name=testapp;
  package schema=NULLID;package name=SQLC28A1;
  package section=0;object schema=BOSS;object name=AUDIT;object type=TABLE;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


OBJMAINT

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº CREATE_OBJECT, RENAME_OBJECT ¹× DROP_OBJECTÀÔ´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£
¿ÀºêÁ§Æ® ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ ½ºÅ°¸¶
¿ÀºêÁ§Æ® À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À̸§
¿ÀºêÁ§Æ® À¯Çü VARCHAR(32) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À¯Çü. °¡´ÉÇÑ °ªÀº TABLE, VIEW, ALIAS, FUNCTION, INDEX, PACKAGE, DATA_TYPE, NODEGROUP, SCHEMA, STORED_PROCEDURE, BUFFERPOOL, TABLESPACE, EVENT_MONITOR, TRIGGER, DATABASE, INSTANCE, FOREIGN_KEY, PRIMARY_KEY, UNIQUE_CONSTRAINT, CHECK_CONSTRAINT, WRAPPER, SERVER, NICKNAME, USER MAPPING, SERVER OPTION, TRANSFORM, TYPE MAPPING, FUNCTION MAPPING, SUMMARY TABLES ¹× NONEÀÔ´Ï´Ù.

Ç¥ 30. SECMAINT À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-11.57.45.188101;category=SECMAINT;audit event=GRANT;
  event correlator=4;event status=0;
  database=FOO;userid=boss;authid=BOSS;
  application id=*LOCAL.boss.980624155728;application name=db2bp;
  package schema=NULLID;package name=SQLC28A1;
  package section=0;object schema=BOSS; object name=T1;object type=TABLE;
  grantor=BOSS;grantee=WORKER;grantee
type=USER;privilege=SELECT;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


SECMAINT

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº GRANT, REVOKE, IMPLICIT_GRANT, IMPLICIT_REVOKE ¹× UPDATE_DBM_CFGÀÔ´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£
¿ÀºêÁ§Æ® ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ ½ºÅ°¸¶
¿ÀºêÁ§Æ® À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À̸§
¿ÀºêÁ§Æ® À¯Çü VARCHAR(32) °¨»ç À̺¥Æ®°¡ »ý¼ºµÈ ¿ÀºêÁ§Æ®ÀÇ À¯Çü. °¡´ÉÇÑ °ªÀº TABLE, VIEW, ALIAS, FUNCTION, INDEX, PACKAGE, DATA_TYPE, NODEGROUP, SCHEMA, STORED_PROCEDURE, BUFFERPOOL, TABLESPACE, EVENT_MONITOR, TRIGGER, DATABASE, INSTANCE, FOREIGN_KEY, PRIMARY_KEY, UNIQUE_CONSTRAINT, CHECK_CONSTRAINT, WRAPPER, SERVER, NICKNAME, USER MAPPING, SERVER OPTION, TRANSFORM, TYPE MAPPING, FUNCTION MAPPING, SUMMARY TABLES ¹× NONEÀÔ´Ï´Ù.
±ÇÇÑ ÁØ »ç¿ëÀÚ VARCHAR(128) ±ÇÇÑÀ» ºÎ¿©ÇÑ »ç¿ëÀÚ ID
±ÇÇÑ ¹ÞÀº »ç¿ëÀÚ VARCHAR(128) Ư±Ç ¶Ç´Â ±ÇÇÑÀÌ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ±ÇÇÑ ¹ÞÀº »ç¿ëÀÚ ID
±ÇÇÑ ¹ÞÀº »ç¿ëÀÚ À¯Çü VARCHAR(32) ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ±ÇÇÑ ¹ÞÀº »ç¿ëÀÚÀÇ À¯Çü. °¡´ÉÇÑ °ªÀº USER, GROUP ¶Ç´Â BOTHÀÔ´Ï´Ù.
Ư±Ç ¶Ç´Â ±ÇÇÑ CHAR(18) Ư±Ç ¶Ç´Â ±ÇÇÑ À¯ÇüÀÌ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÇ¾úÀ½À» ³ªÅ¸³À´Ï´Ù. °¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù.

´ÙÀ½Àº °¡´ÉÇÑ SECMAINT Ư±Ç ¶Ç´Â ±ÇÇÑÀÇ ¸ñ·ÏÀÔ´Ï´Ù.

0x0000000000000001 Control Table
Å×ÀÌºí¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç Á¦¾î

0x0000000000000002 ALTER TABLE
Å×À̺íÀ» º¯°æÇϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000004 GRANT¸¦ °¡Áø ALTER TABLE
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀ» º¯°æÇϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000008 DELETE TABLE
Å×À̺íÀ» »èÁ¦Çϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000010 DELETE TABLE with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀ» »èÁ¦Çϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000020 Table Index
»öÀο¡¼­ ±ÇÇÑ ºÎ¿©Çϰųª ±ÇÇÑ Ãë¼ÒÇÑ Æ¯±Ç

0x0000000000000040 Table Index with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î »öÀο¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000080 Table INSERT
Å×À̺íÀÇ »ðÀÔ¿¡¼­ ±ÇÇÑ ºÎ¿©Çϰųª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000100 Table INSERT with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀÇ »ðÀÔ¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000200 Table SELECT
Å×À̺íÀÇ ¼±Åÿ¡¼­ ±ÇÇÑ ºÎ¿©Çϰųª ±ÇÇÑ Ãë¼ÒÇÑ Æ¯±Ç

0x0000000000000400 Table SELECT with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀÇ ¼±Åÿ¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000000800 Table UPDATE
Å×À̺íÀÇ °»½Å¿¡¼­ ±ÇÇÑ ºÎ¿©Çϰųª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000001000 Table UPDATE with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀÇ °»½Å¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000002000 Table REFERENCE
Å×À̺íÀÇ ÂüÁ¶¿¡¼­ ±ÇÇÑ ºÎ¿©Çϰųª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000004000 Table REFERENCE with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î Å×À̺íÀÇ ÂüÁ¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000000008000 Package BIND
ÆÐŰÁö¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ¹ÙÀÎµå Æ¯±Ç

0x0000000000010000 Package EXECUTE
ÆÐŰÁö¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ½ÇÇà Æ¯±Ç

0x0000000000020000 CREATEIN Schema
½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Createin Ư±Ç

0x0000000000040000 CREATEIN Schema with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î ½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Createin Ư±Ç

0x0000000000080000 DROPIN Schema
½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Dropin Ư±Ç

0x0000000000100000 DROPIN Schema with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î ½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Dropin Ư±Ç

0x0000000000200000 ALTERIN Schema
½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Alterin Ư±Ç

0x0000000000400000 ALTERIN Schema with GRANT
Çã¿ëµÈ Ư±Ç ±ÇÇÑ ºÎ¿©·Î ½ºÅ°¸¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Alterin Ư±Ç

0x0000000000800000 DBADM Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ DBADM ±ÇÇÑ

0x0000000001000000 CREATETAB Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Createtab ±ÇÇÑ

0x0000000002000000 BINDADD Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Bindadd ±ÇÇÑ

0x0000000004000000 CONNECT Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Connect ±ÇÇÑ

0x0000000008000000 Create not fenced Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ºÐ¸®(fenced) ±ÇÇÑÀ» ÀÛ¼ºÇÏÁö ¾ÊÀ½

0x0000000010000000 Implicit Schema Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ ³»ÀçµÈ ½ºÅ°¸¶

0x0000000020000000 Server PASSTHRU
ÀÌ ¼­¹ö¿¡ ´ëÇØ pass-through ±â´ÉÀ» »ç¿ëÇϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç(¿¬ÇÕ µ¥ÀÌÅͺ£À̽º µ¥ÀÌÅÍ ¼Ò½º)

0x0000000100000000 Table Space USE
Å×ÀÌºí °ø°£¿¡¼­ Å×À̺íÀ» ÀÛ¼ºÇϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000200000000 Table Space USE with GRANT
Ư±ÇÀÌ Çã¿ëµÈ Å×ÀÌºí °ø°£¿¡¼­ Å×À̺íÀ» ÀÛ¼ºÇϱâ À§ÇØ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000400000000 Column UPDATE
Å×ÀÌºí¿¡ ÀÖ´Â Çϳª ÀÌ»óÀÇ Æ¯Á¤ Ä÷³¿¡ ´ëÇÑ °»½Å¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000000800000000 Column UPDATE with GRANT
Ư±ÇÀÌ Çã¿ëµÈ Å×À̺íÀÇ Çϳª ÀÌ»óÀÇ Æ¯Á¤ Ä÷³¿¡ ´ëÇÑ °»½Å¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000001000000000 Column REFERENCE
Å×ÀÌºí¿¡¼­ Çϳª ÀÌ»óÀÇ Æ¯Á¤ Ä÷³¿¡ ´ëÇÑ ÂüÁ¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000002000000000 Column REFERENCE with GRANT
Ư±ÇÀÌ Çã¿ëµÈ Å×À̺íÀÇ Çϳª ÀÌ»óÀÇ Æ¯Á¤ Ä÷³¿¡ ´ëÇÑ ÂüÁ¶¿¡¼­ ±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ Ư±Ç

0x0000004000000000 LOAD Authority
±ÇÇÑ ºÎ¿©µÇ°Å³ª ±ÇÇÑ Ãë¼ÒµÈ LOAD ±ÇÇÑ

Ç¥ 31. SYSADMIN À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-11.54.04.129923;category=SYSADMIN;audit event=DB2AUDIT;
  event correlator=1;event status=0;
  userid=boss;authid=BOSS;
  application id=*LOCAL.boss.980624155404;application name=db2audit;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


SYSADMIN

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£

´ÙÀ½Àº °¡´ÉÇÑ SYSADMIN °¨»ç À̺¥Æ®ÀÇ ¸ñ·ÏÀÔ´Ï´Ù.

Ç¥ 32. SYSADMIN °¨»ç À̺¥Æ®

START_DB2
STOP_DB2
CREATE_DATABASE
DROP_DATABASE
UPDATE_DBM_CFG
UPDATE_DB_CFG
CREATE_TABLESPACE
DROP_TABLESPACE
ALTER_TABLESPACE
RENAME_TABLESPACE
CREATE_NODEGROUP
DROP_NODEGROUP
ALTER_NODEGROUP
CREATE_BUFFERPOOL
DROP_BUFFERPOOL
ALTER_BUFFERPOOL
CREATE_EVENT_MONITOR
DROP_EVENT_MONITOR
ENABLE_MULTIPAGE
MIGRATE_DB_DIR
DB2TRC
DB2SET
ACTIVATE_DB
ADD_NODE
BACKUP_DB
CATALOG_NODE
CATALOG_DB
CATALOG_DCS_DB
CHANGE_DB_COMMENT
DEACTIVATE_DB
DROP_NODE_VERIFY
FORCE_APPLICATION
GET_SNAPSHOT
LIST_DRDA_INDOUBT_TRANSACTIONS
MIGRATE_DB
RESET_ADMIN_CFG
RESET_DB_CFG
RESET_DBM_CFG
RESET_MONITOR
RESTORE_DB


ROLLFORWARD_DB
SET_RUNTIME_DEGREE
SET_TABLESPACE_CONTAINERS
UNCATALOG_DB
UNCATALOG_DCS_DB
UNCATALOG_NODE
UPDATE_ADMIN_CFG
UPDATE_MON_SWITCHES
LOAD_TABLE
DB2AUDIT
SET_APPL_PRIORITY
CREATE_DB_AT_NODE
KILLDBM
MIGRATE_SYSTEM_DIRECTORY
DB2REMOT
DB2AUD
MERGE_DBM_CONFIG_FILE
UPDATE_CLI_CONFIGURATION
OPEN_TABLESPACE_QUERY
SINGLE_TABLESPACE_QUERY
CLOSE_TABLESPACE_QUERY
FETCH_TABLESPACE
OPEN_CONTAINER_QUERY
FETCH_CONTAINER_QUERY
CLOSE_CONTAINER_QUERY
GET_TABLESPACE_STATISTICS
DESCRIBE_DATABASE
ESTIMATE_SNAPSHOT_SIZE
READ_ASYNC_LOG_RECORD
PRUNE_RECOVERY_HISTORY
UPDATE_RECOVERY_HISTORY
QUIESCE_TABLESPACE
UNLOAD_TABLE
UPDATE_DATABASE_VERSION
CREATE_INSTANCE
DELETE_INSTANCE
SET_EVENT_MONITOR
GRANT_DBADM
REVOKE_DBADM
GRANT_DB_AUTHORITIES
REVOKE_DB_AUTHORITIES
REDIST_NODEGROUP


Ç¥ 33. VALIDATE À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-08.42.11.527490;category=VALIDATE;audit event=CHECK_GROUP_MEMBERSHIP;
  event correlator=2;event status=-1092;
  database=FOO;userid=boss;authid=BOSS;execution id=newton;
  application id=*LOCAL.newton.980624124210;application name=testapp;
  auth type=SERVER;

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


VALIDATE

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº GET_GROUPS, GET_USERID, AUTHENTICATE_PASSWORD ¹× VALIDATE_USERÀÔ´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
À̺¥Æ® »óÅ INTEGER SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ


¼º°ø À̺¥Æ® > = 0
½ÇÆÐ À̺¥Æ® < 0

µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
½ÇÇà ID VARCHAR(1024) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ½ÇÇà ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÀÎÁõ À¯Çü VARCHAR(32) °¨»ç À̺¥Æ®½Ã ÀÎÁõ À¯Çü
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£

Ç¥ 34. CONTEXT À̺¥Æ®¿¡ ´ëÇÑ °¨»ç ·¹ÄÚµå ·¹À̾ƿô
timestamp=1998-06-24-08.42.41.476840;category=CONTEXT;audit event=EXECUTE_IMMEDIATE;
  event correlator=3;
  database=FOO;userid=boss;authid=BOSS;
  application id=*LOCAL.newton.980624124210;application name=testapp;
  package schema=NULLID;package name=SQLC28A1;
  package section=203;text=create table audit(c1 char(10), c2 integer);

NAME FORMAT DESCRIPTION
½Ã°£¼ÒÀÎ CHAR(26) °¨»ç À̺¥Æ®ÀÇ ³¯Â¥ ¹× ½Ã°£
¹üÁÖ CHAR(8) °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


CONTEXT

°¨»ç À̺¥Æ® VARCHAR(32) ƯÁ¤ °¨»ç À̺¥Æ®

°¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù.

À̺¥Æ® »ó°üÀÚ INTEGER °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º À̸§ CHAR(8) À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù.
»ç¿ëÀÚ ID VARCHAR(1024) °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID
±ÇÇÑ ºÎ¿© ID VARCHAR(128) °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID
¿ø·¡ ³ëµå ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ SMALLINT Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£
ÀÀ¿ëÇÁ·Î±×·¥ ID VARCHAR(255) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ VARCHAR(1024) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§
ÆÐŰÁö ½ºÅ°¸¶ VARCHAR(128) °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶
ÆÐŰÁö À̸§ VARCHAR(128) °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§
ÆÐŰÁö ¼½¼Ç ¹øÈ£ SMALLINT °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£
¸í·É¹® ÅØ½ºÆ®(¸í·É¹®) CLOB(32K) Àû¿ë °¡´ÉÇÑ °æ¿ì SQL¹®ÀÇ ÅØ½ºÆ®. SQL¹®ÀÌ »ç¿ë °¡´ÉÇÏÁö ¾ÊÀº °æ¿ì ³Î(NULL)ÀÔ´Ï´Ù.

´ÙÀ½Àº °¡´ÉÇÑ CONTEXT °¨»ç À̺¥Æ®ÀÇ ¸ñ·ÏÀÔ´Ï´Ù.

Ç¥ 35. CONTEXT °¨»ç À̺¥Æ®

CONNECT
CONNECT_RESET
ATTACH
DETACH
DARI_START
DARI_STOP
BACKUP_DB
RESTORE_DB
ROLLFORWARD_DB
OPEN_TABLESPACE_QUERY
FETCH_TABLESPACE
CLOSE_TABLESPACE_QUERY
OPEN_CONTAINER_QUERY
CLOSE_CONTAINER_QUERY
FETCH_CONTAINER_QUERY
SET_TABLESPACE_CONTAINERS
GET_TABLESPACE_STATISTIC
READ_ASYNC_LOG_RECORD
QUIESCE_TABLESPACE
LOAD_TABLE
UNLOAD_TABLE
UPDATE_RECOVERY_HISTORY
PRUNE_RECOVERY_HISTORY
SINGLE_TABLESPACE_QUERY
LOAD_MSG_FILE
UNQUIESCE_TABLESPACE
ENABLE_MULTIPAGE
DESCRIBE_DATABASE
DROP_DATABASE
CREATE_DATABASE
ADD_NODE
FORCE_APPLICATION


SET_APPL_PRIORITY
RESET_DB_CFG
GET_DB_CFG
GET_DFLT_CFG
UPDATE_DBM_CFG
SET_MONITOR
GET_SNAPSHOT
ESTIMATE_SNAPSHOT_SIZE
RESET_MONITOR
OPEN_HISTORY_FILE
CLOSE_HISTORY_FILE
FETCH_HISTORY_FILE
SET_RUNTIME_DEGREE
UPDATE_AUDIT
DBM_CFG_OPERATION
DISCOVER
OPEN_CURSOR
CLOSE_CURSOR
FETCH_CURSOR
EXECUTE
EXECUTE_IMMEDIATE
PREPARE
DESCRIBE
BIND
REBIND
RUNSTATS
REORG
REDISTRIBUTE
COMMIT
ROLLBACK
REQUEST_ROLLBACK
IMPLICIT_REBIND


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