DELASC ¹ßÃé ¿É¼ÇÀ» »ç¿ëÇÏ¿© °¨»ç ·Î±×¿¡¼ °¨»ç ·¹Äڵ尡 ¹ßÃéµÇ¸é, °¢ ·¹ÄÚµå´Â ´ÙÀ½ Å×ÀÌºí¿¡ Ç¥½ÃµÈ Çü½Ä Áß Çϳª¸¦ °¡Áý´Ï´Ù. °¢ Å×À̺íÀº »ùÇà ·¹ÄÚµåÀÇ ³»¿ëÀ» Ç¥½ÃÇÏ¿© ½ÃÀÛÇÕ´Ï´Ù. ·¹ÄÚµåÀÇ °¢ Ç׸ñ ¼³¸íÀÌ ÇØ´ç Å×ÀÌºí¿¡¼ ÇÑ ¹ø¿¡ ÇϳªÀÇ Çà¿¡ Ç¥½ÃµË´Ï´Ù. Ç׸ñÀÌ Áß¿äÇϸé, ÇØ´ç Ç׸ñÀÇ À̸§ÀÌ °Á¶Ç¥½Ã(±½ÀºÃ¼·Î Ç¥½Ã)µË´Ï´Ù. À̵é Ç׸ñ¿¡´Â »ç¿ëÀÚ¿¡°Ô °¡Àå °ü½É ÀÖ´Â Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù.
ÁÖ:
Ç¥ 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº CONFIGURE, DB2AUD, EXTRACT, FLUSH, PRUNE, START, STOP ¹× UPDATE_ADMIN_CFGÀÔ´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
»ç¿ëÀÚ 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº CHECKING_OBJECT ¹× CHECKING_FUNCTIONÀÔ´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
µ¥ÀÌÅͺ£À̽º À̸§ | 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 ¾×¼¼½º ½ÂÀÎ ÀÌÀ¯ÀÇ ¸ñ·ÏÀÔ´Ï´Ù.
´ÙÀ½Àº °¡´ÉÇÑ CHECKING ¾×¼¼½º°¡ ½ÃµµµÊ À¯ÇüÀÇ ¸ñ·ÏÀÔ´Ï´Ù.
Ç¥ 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº CREATE_OBJECT, RENAME_OBJECT ¹× DROP_OBJECTÀÔ´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
µ¥ÀÌÅͺ£À̽º À̸§ | 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº GRANT, REVOKE, IMPLICIT_GRANT, IMPLICIT_REVOKE ¹× UPDATE_DBM_CFGÀÔ´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
µ¥ÀÌÅͺ£À̽º À̸§ | 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 Ư±Ç ¶Ç´Â ±ÇÇÑÀÇ ¸ñ·ÏÀÔ´Ï´Ù.
Ç¥ 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº ÀÌ Ç¥ ´ÙÀ½¿¡ ¿À´Â ¸ñ·Ï¿¡ Ç¥½ÃµË´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
µ¥ÀÌÅͺ£À̽º À̸§ | CHAR(8) | À̺¥Æ®°¡ »ý¼ºµÈ µ¥ÀÌÅͺ£À̽ºÀÇ À̸§. À̰ÍÀÌ ÀνºÅϽº ·¹º§ °¨»ç À̺¥Æ®ÀÎ °æ¿ì °ø¹éÀÔ´Ï´Ù. |
»ç¿ëÀÚ ID | VARCHAR(1024) | °¨»ç À̺¥Æ®½ÃÀÇ »ç¿ëÀÚ ID |
±ÇÇÑ ºÎ¿© ID | VARCHAR(128) | °¨»ç À̺¥Æ®½ÃÀÇ ±ÇÇÑ ºÎ¿© ID |
¿ø·¡ ³ëµå ¹øÈ£ | SMALLINT | °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÑ ³ëµå ¹øÈ£ |
Á¶Á¤ÀÚ ³ëµå ¹øÈ£ | SMALLINT | Á¶Á¤ÀÚÀÇ ³ëµå ¹øÈ£ |
ÀÀ¿ëÇÁ·Î±×·¥ ID | VARCHAR(255) | °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ ID |
ÀÀ¿ëÇÁ·Î±×·¥ À̸§ | VARCHAR(1024) | °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÀÀ¿ëÇÁ·Î±×·¥ À̸§ |
ÆÐŰÁö ½ºÅ°¸¶ | VARCHAR(128) | °¨»ç À̺¥Æ®½Ã »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ½ºÅ°¸¶ |
ÆÐŰÁö À̸§ | VARCHAR(128) | °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁö À̸§ |
ÆÐŰÁö ¼½¼Ç ¹øÈ£ | SMALLINT | °¨»ç À̺¥Æ®°¡ ¹ß»ýÇÒ ¶§ »ç¿ëÁßÀÎ ÆÐŰÁöÀÇ ¼½¼Ç ¹øÈ£ |
´ÙÀ½Àº °¡´ÉÇÑ 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | VARCHAR(32) | ƯÁ¤ °¨»ç À̺¥Æ®
°¡´ÉÇÑ °ªÀº GET_GROUPS, GET_USERID, AUTHENTICATE_PASSWORD ¹× VALIDATE_USERÀÔ´Ï´Ù. |
À̺¥Æ® »ó°üÀÚ | INTEGER | °¨»çµÇ´Â Á¶ÀÛ¿¡ ´ëÇÑ »ó°ü ½Äº°ÀÚ. ´ÜÀÏ À̺¥Æ®¿Í ¿¬°üµÈ °¨»ç ·¹Äڵ带 ½Äº°Çϱâ À§ÇØ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù. |
À̺¥Æ® »óÅ | INTEGER | SQLCODE°¡ Ç¥½ÃÇÏ´Â °¨»ç À̺¥Æ®ÀÇ »óÅÂ
|
µ¥ÀÌÅͺ£À̽º À̸§ | 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) | °¨»ç À̺¥Æ®ÀÇ ¹üÁÖ. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
°¨»ç À̺¥Æ® | 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 °¨»ç À̺¥Æ®ÀÇ ¸ñ·ÏÀÔ´Ï´Ù.
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 |