·Î±× ÆÄÀÏÀ» »ý¼ºÇϵµ·Ï ÀÀ¿ëÇÁ·Î±×·¥ ±¸¼º

·Î±× ±¸¹® ºÐ¼®±â·Î ±¸¹®À» ºÐ¼®ÇÏ´Â µ¥ Àû´çÇÑ Çü½ÄÀ¸·Î ·Î±×¸¦ »ý¼ºÇϵµ·Ï Apache HTTP Server, IBM WebSphere Application Server, IBM DB2 Universal Database ¹× IBM HTTP Server¿Í °°Àº ÀÀ¿ëÇÁ·Î±×·¥À» ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

´ÙÀ½Àº Åø¿¡ Á¦°øµÈ ±¸¹® ºÐ¼®±â·Î ±¸¹®À» ºÐ¼®ÇÒ ¼ö ÀÖµµ·Ï ·Î±×¸¦ Çü½ÄÈ­ÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥ ±¸¼º ¸ñ·ÏÀÔ´Ï´Ù.

Âü°í: ¾Ë·ÁÁø À̺¥Æ® ¹× ¿À·ù Á¶°Ç ÇØ¼®À» À§ÇÑ Áõ»ó µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ¿© ÀÌ·¯ÇÑ ·Î±× ÆÄÀÏ¿¡ Æ÷ÇԵǾî ÀÖ´Â ·Î±× À̺¥Æ®¸¦ ºÐ¼®ÇÒ ¼ö ÀÖ½À´Ï´Ù. Áõ»ó µ¥ÀÌÅͺ£À̽º´Â ¿À·ù ºÐ¼® ¹× À̺¥Æ® Á߿䵵¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸¸¦ ã´Â µ¥ »ç¿ëµË´Ï´Ù. Áõ»ó µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸¿Í ÀÌ µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿Í¼­ »ç¿ëÇÏ´Â Áö½Ã»çÇ×Àº ÀÌ ÆÄÀÏÀÇ ³¡¿¡¼­ °ü·ÃµÈ ÁÖÁ¦¸¦ ÂüÁ¶ÇϽʽÿÀ.

iSeries¿ë Apache HTTP Server Ȱµ¿ ¹× ÃßÀû ·Î±× ÆÄÀÏ¿ë ±¸¼º

iSeries ¼­¹öÀÇ °æ¿ì Apache ±¸¼º ÆÄÀÏÀÇ À̸§Àº /www/apachedft/conf/httpd.confÀÔ´Ï´Ù. ¾×¼¼½º ·Î±× ¹× ¿À·ù ·Î±×¸¦ ÀûÀýÈ÷ »ç¿ëÇÏ·Á¸é ´ÙÀ½ Áö½Ã¹®ÀÌ µé¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.

# ErrorLog: The location of the error log file. If this does not start
   # with /, ServerRoot is prepended to it.

ErrorLog ./logs/error.log

   # LogLevel: Control the number of messages logged to the error.log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.

   LogLevel warn

# The following directives define some format nicknames for use with
# a CustomLog directive (see below).

LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

# The location of the access logfile (Common Logfile Format).
   # If this does not start with /, ServerRoot is prepended to it.


CustomLog ./logs/access.log common

À§¿¡¼­ ±½ÀºÃ¼·Î µÇ¾î ÀÖ´Â µÎ ¼½¼ÇÀº Apache ¿À·ù ·Î±× ¹× ¾×¼¼½º ·Î±×ÀÇ À§Ä¡¸¦ Á¤ÀÇÇÕ´Ï´Ù. ¿¹¸¦ µé¾î ServerRoot°¡ /www/apachedftÀÌ¸é ·Î±×´Â /www/apachedft/logs/ ¼­ºêµð·ºÅ丮¿¡ ÀÖÀ¸¸ç À̸§Àº °¢°¢ error.log.* ¹× access.log.*·Î ÁöÁ¤µË´Ï´Ù. ÆÄÀÏ À̸§¿¡¼­ ÃÖÁ¾ Á¢¹ÌºÎ´Â ³¯Â¥¿¡ µû¶ó º¯°æµË´Ï´Ù(¿¹: 2003³â 12¿ù 31ÀÏ¿¡ ´ëÇÑ Ã¹ ¹øÂ° error.log´Â Q103123100¿Í °°½À´Ï´Ù).

Apache ±¸¼º ÆÄÀÏ º¯°æ ÈÄ ÀÌ º¯°æ»çÇ×À» ¹Ý¿µÇÏ·Á¸é Apache ¼­¹ö¸¦ ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù. OS400 ¸í·ÉÇà¿¡¼­ STRTCPSVR SERVER(*HTTP) INSTANCE(APACHEDFT)¸¦ ÀÔ·ÂÇϽʽÿÀ.

¹Ý´ë·Î, Apache ¼­¹ö Á¾·á´Â OS400 ¸í·ÉÇà¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ¼öÇàµÉ ¼ö ÀÖ½À´Ï´Ù. ENDTCPSVR SERVER(*HTTP) INSTANCE(APACHEDFT)

IBM WebSphere Application Server V4.0 Ȱµ¿ ·Î±× ÆÄÀÏ¿ë ±¸¼º

  1. <WAS_HOME>\properties\logging.properties ·Î±ë ±¸¼º ÆÄÀÏ¿¡¼­ ´ÙÀ½ Ç׸ñÀ» ÆíÁýÇϽʽÿÀ.
     #-----------------------------------------------------------------------------------------------
     # Activity Log Properties
     #
     # WARNING Before changing any of the Activity Log properties, all servers on the physical
     # node, including AdminServers must be stopped. 
     #
     # com.ibm.ws.ras.AcvitityLogEnabled : A property used to determine whether or not the servers on 
     # this node will write Ras events to the activity log or not. Valid values are true and false, 
     # with true the default. Turning off this logging may have serious serviceability impacts.
     #
     # com.ibm.ws.ras.ActivityLogSize : Size of the activity log in kilobytes. The default value
     # is 1024, which yields a log size of 1 megabyte. See the Problem Determination guide for
     # guidelines on setting the size of this log.
     #------------------------------------------------------------------------------------------------
    

    com.ibm.ws.ras.ActivityLogEnabled=true
    com.ibm.ws.ras.ActivityLogSize=1024


  2. ±¸¼º ÆÄÀÏ¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  3. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

Âü°í:

IBM WebSphere Application Server V4.0 ÃßÀû ·Î±× ÆÄÀÏ¿ë ±¸¼º(µ¶¸³Çü °ü¸® ÄܼÖ)

  1. IBM WebSphere Application Server °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. WebSphere °ü¸® µµ¸ÞÀÎ > ³ëµå > node_name > Application Server > server_name > ¼­ºñ½º > ÃßÀû ¼­ºñ½º¸¦ ¼±ÅÃÇϽʽÿÀ. ¿©±â¼­, node_nameÀº ³ëµåÀÇ À̸§À̰í server_nameÀº ÃßÀû ·Î±× ±¸¼ºÀ» Àû¿ëÇÒ ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
  3. server_nameÀ» µÎ ¹ø ´©¸£°í ¼­ºñ½º¸¦ ¼±ÅÃÇϽʽÿÀ.
  4. ÃßÀû ¼­ºñ½º¸¦ °­Á¶Ç¥½ÃÇÑ ÈÄ µî·Ï Á¤º¸ ÆíÁýÀ» ´©¸£½Ê½Ã¿À.
  5. ã¾Æº¸±â¸¦ ´©¸¥ ´ÙÀ½, ÃßÀûÇÒ ±×·ì ¶Ç´Â ÄÄÆ÷³ÍÆ®¸¦ ¼±ÅÃÇϰųª µÑ·Î ÀÌ·ç¾îÁø Á¶ÇÕÀ» ¼±ÅÃÇϽʽÿÀ.
  6. ´ÙÀ½ ÄÄÆ÷³ÍÆ®°¡ Ç¥½ÃµÈ ´ë·Î »ç¿ë °¡´ÉÇÑÁö È®ÀÎÇϽʽÿÀ.

    com.ibm.ws.http.HttpConnection=entry
    Exit=enabled:
    com.ibm.ws.webcontainer.srp.ServletRequestProcessor=entry
    Exit=enabled,
    event=enabled


  7. È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  8. ÃßÀû ÆÄÀÏÀ» ·ÎÄà ÆÄÀÏ °æ·Î·Î ¼³Á¤ÇϽʽÿÀ.
  9. È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  10. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  11. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

IBM WebSphere Application Server V4.0 ÃßÀû ·Î±× ÆÄÀÏ¿ë ±¸¼º(Servlet ±â¹Ý °ü¸® ÄܼÖ)

  1. IBM WebSphere Application Server °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. WebSphere °ü¸® µµ¸ÞÀÎ > ³ëµå > node_name > Application Server > server_name > ÃßÀû ¼­ºñ½º¸¦ ¼±ÅÃÇϽʽÿÀ. ¿©±â¼­, node_nameÀº ³ëµåÀÇ À̸§À̰í server_nameÀº ÃßÀû ·Î±× ±¸¼ºÀ» Àû¿ëÇÒ ¼­¹öÀÇ À̸§ÀÔ´Ï´Ù.
  3. ÃßÀû ¹®ÀÚ¿­À» »ç¿ë °¡´ÉÇÏ°Ô ÇÑ ÈÄ ÃßÀûÇÒ ¿øÇÏ´Â ÄÄÆ÷³ÍÆ®¸¦ Ãß°¡ÇϽʽÿÀ.
  4. ´ÙÀ½ ÄÄÆ÷³ÍÆ®°¡ Ç¥½ÃµÈ ´ë·Î »ç¿ë °¡´ÉÇÑÁö È®ÀÎÇϽʽÿÀ.

    com.ibm.ws.http.HttpConnection=entry
    Exit=enabled:
    com.ibm.ws.webcontainer.srp.ServletRequestProcessor=entry
    Exit=enabled,
    event=enabled


  5. ÃßÀû ÆÄÀÏÀ» ·ÎÄà ÆÄÀÏ °æ·Î·Î ¼³Á¤ÇϽʽÿÀ.
  6. È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  7. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  8. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

IBM WebSphere Application Server V5.0 ¶Ç´Â V6.0 Ȱµ¿ ·Î±× ÆÄÀÏ¿¡ ´ëÇÑ ±¸¼º

  1. IBM WebSphere Application Server °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. ¹®Á¦Á¡ ÇØ°á > ·Î±× ¹× ÃßÀû > ¼­¹ö À̸§ > IBM ¼­ºñ½º ·Î±×¸¦ ¼±ÅÃÇϽʽÿÀ. ¿©±â¼­, server_nameÀº Ȱµ¿ ·Î±× ±¸¼ºÀ» Àû¿ëÇÒ ³ëµåÀÇ À̸§ÀÔ´Ï´Ù.
  3. ¼­ºñ½º ·Î±×¸¦ »ç¿ë °¡´ÉÇÏ°Ô ÇϽʽÿÀ.
  4. ÆÄÀÏ À̸§ ·ÎÄà ÆÄÀÏ °æ·Î·Î ¼³Á¤ÇϽʽÿÀ.
  5. Àû¿ë ¶Ç´Â È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  6. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  7. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

Âü°í: ±âº»ÀûÀ¸·Î ${LOG_ROOT}´Â WAS_HOME\logs\ÀÔ´Ï´Ù. ¿©±â¼­ WAS_HOMEÀº ´ÙÀ½°ú °°½À´Ï´Ù.

IBM WebSphere Application Server V5.0 ¶Ç´Â V6.0 ÃßÀû ·Î±× ÆÄÀÏ¿¡ ´ëÇÑ ±¸¼º

  1. IBM WebSphere Application Server °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. ¹®Á¦Á¡ ÇØ°á > ·Î±× ¹× ÃßÀû > server_name > Áø´Ü ÃßÀûÀ» ¼±ÅÃÇϽʽÿÀ. ¿©±â¼­, server_nameÀº ÃßÀû ·Î±× ±¸¼ºÀ» Àû¿ëÇÒ ³ëµåÀÇ À̸§ÀÔ´Ï´Ù.
  3. ÃßÀûÀ» »ç¿ë °¡´ÉÇÏ°Ô ÇÑ ÈÄ ¿øÇÏ´Â ÃßÀû ½ºÆåÀ» Ãß°¡ÇϽʽÿÀ.
  4. ´ÙÀ½ ÄÄÆ÷³ÍÆ®°¡ Ç¥½ÃµÈ ´ë·Î »ç¿ë °¡´ÉÇÑÁö È®ÀÎÇϽʽÿÀ.

    V5.0ÀÇ °æ¿ì,

    com.ibm.ws.http.HttpConnection=entry
       Exit=enabled:
       com.ibm.ws.webcontainer.srp.ServletRequestProcessor=entry
       Exit=enabled,
    event=enabled

    V6.0ÀÇ °æ¿ì,

    com.ibm.ws.http.HttpConnection=entry
       Exit=enabled:
       com.ibm.ws.webcontainer.srp.ServletRequestProcessor=entry
       Exit=enabled,
    event=enabled
    com.ibm.ws.http.HttpConnection=finer:com.ibm.ws.webcontainer.srp.ServletRequestProcessor=finer
  5. ÃßÀû Ãâ·Â ÆÄÀÏÀ» ·ÎÄà ÆÄÀÏ °æ·Î·Î ¼³Á¤ÇϽʽÿÀ.
  6. Àû¿ë ¶Ç´Â È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  7. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  8. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

Âü°í: ±âº»ÀûÀ¸·Î ${SERVER_LOG_ROOT}´Â WAS_HOME\logs\server_name\ÀÔ´Ï´Ù. ¿©±â¼­ server_nameÀº ÃßÀû ·Î±× ±¸¼ºÀÌ Àû¿ëµÉ ³ëµåÀÇ À̸§À̰í WAS_HOMEÀº ´ÙÀ½°ú °°½À´Ï´Ù.

WebSphere Application Server ÃßÀû ·Î±× ÆÄÀÏÀÇ Å©±â ±¸¼º

  1. IBM WebSphere Application Server °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. ¹®Á¦Á¡ ÇØ°á > ·Î±× ¹× ÃßÀû > server_name > Áø´Ü ÃßÀûÀ» ¼±ÅÃÇϽʽÿÀ.
  3. ÃßÀû Ãâ·Â¿¡¼­ ÆÄÀÏÀ» ¼±ÅÃÇÑ ÈÄ ¿øÇÏ´Â ÃÖ´ë ÆÄÀÏ Å©±â¸¦ ÀÔ·ÂÇϽʽÿÀ. ±ÇÀåÇÏ´Â ÃßÀû ·Î±× ÆÄÀÏÀÇ Å©±â´Â 10MB ÀÌÇÏÀÔ´Ï´Ù.
  4. º¯°æ»çÇ×À» ÀúÀåÇÏ·Á¸é Àû¿ëÀ» ´©¸£½Ê½Ã¿À.
  5. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

z/OS¿ë IBM WebSphere Application Server ¿À·ù ·Î±× ÆÄÀÏ¿ë ±¸¼º

WebSphere Application Server MVS ÀÛ¾÷ÀÇ SYSOUT µ¥ÀÌÅͼ¼Æ® ¶Ç´Â ·Î±× ½ºÆ®¸²¿¡ ¿À·ù ·Î±× À̺¥Æ®¸¦ ¾²µµ·Ï z/OS¿ë IBM WebSphere Application Server¸¦ ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ±¸¹®À» ºÐ¼®ÇÏ¿© ·Î±× ºÐ¼®±â·Î °¡Á®¿Ã ¼ö ÀÖ´Â ÆÄÀÏ·Î ¿À·ù ·Î±× À̺¥Æ®¸¦ º¹»çÇÏ·Á¸é ´ÙÀ½ÀÇ Áö½Ã»çÇ×À» µû¸£½Ê½Ã¿À. ·Î±× ºÐ¼®±â´Â V4.0 ¹× V5.0 z/OS¿ë WebSphere Application Server ¿À·ù ·Î±× ÆÄÀÏÀ» ±¸¹® ºÐ¼®ÇÏ¿© °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù.

Âü°í: MVS µ¥ÀÌÅÍ ¼¼Æ®·ÎºÎÅÍ´Â z/OS¿ë IBM WebSphere Application Server ¿À·ù ·Î±× ÆÄÀÏÀ» °¡Á®¿Ã ¼ö ¾ø½À´Ï´Ù. ÀÌ ÆÄÀϵéÀº UNIX ½Ã½ºÅÛ ¼­ºñ½º ÆÄÀÏ ½Ã½ºÅÛ¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.

Âü°í: ¿À·ù ·Î±× À̺¥Æ®ÀÇ ½Ã°£Àº GMT ½Ã°£À¸·Î ±¸¹® ºÐ¼®µË´Ï´Ù. ¿À·ù ·Î±× À̺¥Æ®¿¡ GMT ½Ã°£À» ¾²µµ·Ï z/OS¿ë WebSphere Application Server¸¦ ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù. À̰ÍÀÌ ±âº» ±¸¼ºÀÔ´Ï´Ù. ¿À·ù ·Î±× À̺¥Æ®¿¡ ·ÎÄà ½Ã°£À» ¾²µµ·Ï ±¸¼ºµÈ °æ¿ì, ·Î±× º¸±â¿¡ ÀÖ´Â ·Î±× À̺¥Æ®ÀÇ creationTime µî·Ï Á¤º¸¿¡ Ç¥½ÃµÈ ½Ã°£´ë Á¤º¸´Â ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù.

Âü°í:z/OS¿ë IBM WebSphere Application Server ¿À·ù ·Î±× ÆÄÀÏÀº ½Ã°£¿¡ ÀÇÇØ¼­¸¸ ¿¬°üµÉ ¼ö ÀÖ½À´Ï´Ù.

IBM HTTP Server V1.3.19.3 - V2.0.42.1 ¾×¼¼½º ·Î±× ÆÄÀÏ¿ë ±¸¼º

  1. IHS_HOME\conf\httpd.conf HTTP ¼­¹ö ±¸¼º ÆÄÀÏ¿¡¼­ ´ÙÀ½ Ç׸ñÀ» ÆíÁýÇϽʽÿÀ.

       # The location of the access logfile (Common Logfile Format).
       # If this does not start with /, ServerRoot is prepended to it.
       CustomLog logs/access.log common
  2. ±¸¼º ÆÄÀÏ¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  3. HTTP Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

Âü°í:

IBM HTTP Server V1.3.19.3 - V2.0.42.1 ¿À·ù ·Î±× ÆÄÀÏ¿ë ±¸¼º

  1. IHS_HOME\conf\httpd.conf HTTP ¼­¹ö ±¸¼º ÆÄÀÏ¿¡¼­ ´ÙÀ½ Ç׸ñÀ» ÆíÁýÇϽʽÿÀ.
       # ErrorLog: The location of the error log file. If this does not start
       # with /, ServerRoot is prepended to it.
       ErrorLog logs/error.log
       # LogLevel: Control the number of messages logged to the error.log. 
       # Possible values include: debug, info, notice, warn, error, crit, alert, emerg. 
       LogLevel warn
  2. ±¸¼º ÆÄÀÏ¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  3. HTTP Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

Âü°í:

IBM DB2 Universal Database V8.1 - V8.2 Áø´Ü ·Î±× ÆÄÀÏ¿¡ ´ëÇÑ ±¸¼º

DB2ÀÇ ±âº» ±¸¼ºÀº ¸ðµç ¿À·ù ¹× °æ°í ¸Þ½ÃÁö¸¦ db2diag.log¶ó´Â ·Î±× ÆÄÀÏ¿¡ ¾¹´Ï´Ù. ÀÌ ÆÄÀÏÀÇ À§Ä¡´Â ´ÙÀ½°ú °°½À´Ï´Ù.

Áö¿øµÇ´Â Windows ȯ°æ:

UNIX ±â¹Ý ȯ°æ: INSTHOME/sqllib/db2dump. ¿©±â¼­ INSTHOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.

µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±¸¼º¿¡ ÁöÁ¤µÈ DIAGPATH º¯¼ö´Â FFDC(First Failure Data Capture) ÀúÀ念¿ª µð·ºÅ丮¿¡ ´ëÇÑ ¿ÏÀüÇÑ °æ·Î¸¦ Á¦°øÇÕ´Ï´Ù. DIAGPATHÀÇ ±âº»°ªÀº ³Î(null) ¹®ÀÚ¿­ÀÔ´Ï´Ù. DIAGPATH °ªÀ» º¯°æÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

DB2 UPDATE DBM CFG USING DIAGPATH path

ÇöÀç Áø´Ü ¿À·ù ĸó ·¹º§ È®ÀÎ

´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

  1. DB2 ¸í·É âÀ» ¿©½Ê½Ã¿À.
  2. ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
    db2 get dbm cfg
  3. "Áø´Ü ¿À·ù ĸó ·¹º§(DIAGLEVEL)" °ªÀ» ÀÐÀ¸½Ê½Ã¿À.

À̺¥Æ®È­µÇ´Â Á¤º¸ÀÇ ¾ç ±¸¼º

´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇÏ¿© Áø´Ü ·Î±× ÆÄÀÏ(db2diag.log)¿¡ ¾²¿©Áö´Â Á¤º¸ÀÇ ¾çÀ» ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

  1. DB2 ¸í·É âÀ» ¿©½Ê½Ã¿À.
  2. ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
    db2 update dbm cfg using DIAGLEVEL [level]
    ¿©±â¼­ [level]Àº ¾²¿©Áö´Â Á¤º¸ÀÇ ¾çÀ» Á¦¾îÇÏ´Â °ªÀÔ´Ï´Ù. ±âº»°ªÀº 3ÀÔ´Ï´Ù. ¿Ã¹Ù¸¥ °ª ¹× Àǹ̴ ´ÙÀ½°ú °°½À´Ï´Ù.
    0 = ĸóµÇ´Â Áø´Ü µ¥ÀÌÅͰ¡ ¾øÀ½
    1 = ½É°¢ÇÑ ¿À·ù¸¸
    2 = ¸ðµç ¿À·ù
    3 = ¸ðµç ¿À·ù ¹× °æ°í
    4 = ¸ðµç ¿À·ù, °æ°í ¹× Á¤º¸ ¸Þ½ÃÁö
  3. °ªÀÌ °»½ÅµÉ °æ¿ì º¯°æ»çÇ×Àº Áï½Ã À¯È¿ÇØÁý´Ï´Ù.

IBM DB2 Universal Database V8.1.2 ¶Ç´Â V8.2 JCC ÃßÀû ·Î±× ÆÄÀÏ¿¡ ´ëÇÑ ±¸¼º( WebSphere Application Server¿¡¼­ ½ÇÇàÇÏ´Â À¥ ÀÀ¿ëÇÁ·Î±×·¥)

WebSphere Application Server °ü¸® ÄܼÖÀ» »ç¿ëÇÏ¿© JDBC¿¡ °ü·ÃµÈ Á¤º¸¸¦ À̺¥Æ®È­ÇÏ´Â ¹æ¹ýÀ» ±¸¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. JCC ·Î±× ¸Þ½ÃÁö¸¦ À̺¥Æ®È­ÇÏ´Â ¹æ½Ä¿¡´Â µÎ °¡Áö°¡ ÀÖ½À´Ï´Ù.

  1. ¸ðµç JCC ¸Þ½ÃÁö¸¦ WAS V5.0 ÃßÀû ·Î±× ÆÄÀÏ¿¡ ÁöÁ¤ÇÕ´Ï´Ù.
  2. ¸ðµç JCC ¸Þ½ÃÁö¸¦ º°µµÀÇ ·Î±× ÆÄÀÏ¿¡ ÁöÁ¤ÇÕ´Ï´Ù.

JCC ¸Þ½ÃÁö¸¦ WAS V5.0 ÃßÀû ÆÄÀÏ¿¡ ÁöÁ¤

´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

  1. IBM WebSphere Application Server V5.0 °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. ¹®Á¦Á¡ ÇØ°á > ·Î±× ¹× ÃßÀû> server_name > Áø´Ü ÃßÀûÀ» ¼±ÅÃÇϽʽÿÀ.
  3. ÃßÀû ½ºÆå¿¡¼­ ¼öÁ¤ ´ÜÃ߸¦ ´©¸£½Ê½Ã¿À. âÀÌ ¿­¸³´Ï´Ù.
  4. ±×·ì ÅÇ¿¡¼­ ´ÙÀ½ ±×·ìÀÌ ¼±ÅõǾî ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
    1. WAS.database
    2. WAS.j2c
    3. RRA
  5. Àû¿ë ´ÜÃ߸¦ ´©¸£½Ê½Ã¿À. âÀÌ ´ÝÈü´Ï´Ù.
  6. ±âº» âÀÇ ±¸¼º ÅÇ¿¡¼­ Àû¿ëÀ» ´©¸£½Ê½Ã¿À.
  7. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  8. ÀÚ¿ø > JDBC ÇÁ·Î¹ÙÀÌ´õ > DB2 Universal JDBC µå¶óÀ̹ö ÇÁ·Î¹ÙÀÌ´õ > µ¥ÀÌÅÍ ¼Ò½º > data_source_name > µî·Ï Á¤º¸ »ç¿ëÀÚ Á¤ÀǸ¦ ¼±ÅÃÇϽʽÿÀ.
  9. µî·Ï Á¤º¸ »ç¿ëÀÚ Á¤ÀÇ Å×ÀÌºí¿¡¼­ traceFile µî·Ï Á¤º¸°¡ ¼±ÅõǾî ÀÖÁö ¾ÊÀºÁö È®ÀÎÇϽʽÿÀ.
  10. ÆÄÀÏ À̸§ÀÌ traceFile ¾Æ·¡¿¡ ÁöÁ¤µÇ¾î ÀÖÀ¸¸é traceFileÀ» ´©¸£½Ê½Ã¿À. °ª Çʵ忡¼­ ÅØ½ºÆ®¸¦ Á¦°ÅÇÑ ÈÄ È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  11. »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º¿¡ ´ëÇÑ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  12. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

JCC ¸Þ½ÃÁö¸¦ º°µµÀÇ ·Î±× ÆÄÀÏ¿¡ ÁöÁ¤

´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

  1. IBM WebSphere Application Server V5.0 °ü¸® ÄܼÖÀ» ¿©½Ê½Ã¿À.
  2. ¹®Á¦Á¡ ÇØ°á > ·Î±× ¹× ÃßÀû > server_name > Áø´Ü ÃßÀûÀ» ¼±ÅÃÇϽʽÿÀ
  3. ÃßÀû ½ºÆå¿¡¼­ ¼öÁ¤ ´ÜÃ߸¦ ´©¸£½Ê½Ã¿À. âÀÌ ¿­¸³´Ï´Ù. ÀÛÀº âÀÇ ±×·ì ÅÇ¿¡¼­ RRA ±×·ìÀÌ ¼±ÅõǾî ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
  4. Àû¿ë ´ÜÃ߸¦ ´©¸£½Ê½Ã¿À. âÀÌ ´ÝÈü´Ï´Ù.
  5. ±âº» âÀÇ ±¸¼º ÅÇ¿¡¼­ Àû¿ëÀ» ´©¸£½Ê½Ã¿À.
  6. ±¸¼º¿¡ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  7. ÀÚ¿ø > JDBC ÇÁ·Î¹ÙÀÌ´õ > DB2 Universal JDBC µå¶óÀ̹ö ÇÁ·Î¹ÙÀÌ´õ > µ¥ÀÌÅÍ ¼Ò½º > data_source_name > µî·Ï Á¤º¸ »ç¿ëÀÚ Á¤ÀǸ¦ ¼±ÅÃÇϽʽÿÀ.
  8. µî·Ï Á¤º¸ »ç¿ëÀÚ Á¤ÀÇ Å×À̺íÀÇ À̸§ ¿­¿¡¼­ traceFileÀ» ´©¸£½Ê½Ã¿À.
  9. °ª Çʵ忡 ÃßÀû ÆÄÀÏÀÇ Àý´ë °æ·Î¸¦ ÀÔ·ÂÇϰí È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  10. µî·Ï Á¤º¸ »ç¿ëÀÚ Á¤ÀÇ Å×À̺íÀÇ À̸§ ¿­¿¡¼­ traceLevelÀ» ´©¸£½Ê½Ã¿À.
  11. °ª Çʵ忡¼­ ÇØ´ç traceLevel °ªÀ» ÀÔ·ÂÇϽʽÿÀ °¡´ÉÇÑ ÃßÀû ·¹º§ ¹× ÇØ´ç Àǹ̰¡ °ª ÇÊµå ¹Ù·Î ¾Æ·¡ ¼³¸í Ư¼º¿¡ ¹®¼­È­µÇ¾î ÀÖ½À´Ï´Ù
  12. È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
  13. »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º¿¡ ´ëÇÑ º¯°æ»çÇ×À» ÀúÀåÇϽʽÿÀ.
  14. Application Server¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

IBM DB2 Universal Database V8.1.2 ¶Ç´Â V8.2 JCC ÃßÀû ·Î±× ÆÄÀÏ¿¡ ´ëÇÑ ±¸¼º(µ¶¸³Çü ÀÀ¿ëÇÁ·Î±×·¥)

µ¥ÀÌÅÍ ¼Ò½ºÀÇ JDBC 2 ¿¬°á¼ºÀÇ °æ¿ì, com.ibm.db2.jcc.DB2SimpleDataSource ¿ÀºêÁ§Æ®¿¡¼­ setLogWriter() ¹× setTraceLevel() ¸Þ¼Òµå¸¦ »ç¿ëÇϽʽÿÀ. ÀÌ ¸Þ¼Òµå´Â ±âº» ÃßÀû ·¹º§À» ¿ÏÀüÈ÷ »ç¿ë °¡´ÉÇÏ°Ô ÇÕ´Ï´Ù.

µå¶óÀ̹ö °ü¸®ÀÚ java.sql.DriverManager.setLogWriter()·Î JDBC 1 ÃßÀûÀ» »ç¿ë °¡´ÉÇÏ°Ô Çϰųª, traceFileÀÌ JDBC 1 µ¥ÀÌÅͺ£À̽º URL¿¡ ÀÓº£µåµÉ ¼ö ÀÖ½À´Ï´Ù.
¿¹¸¦ µé¾î, ´ÙÀ½°ú °°½À´Ï´Ù.
String databaseURL = "jdbc:db2://hal:50000/sample:traceFile=c:/temp/foobar.txt;traceLevel=" + (com.ibm.db2.jcc.DB2BaseDataSource.TRACE_DRDA_FLOWS | com.ibm.db2.jcc.DB2BaseDataSource.TRACE_CONNECTS) + ";";


 

JDBC 1 ¹× JDBC 2 ¿¬°á¼º µÑ ´ÙÀÇ °æ¿ì, µ¶Á¡ÀûÀÎ ¸Þ¼Òµå DB2Connection.setJCCLogWriter(java.io.PrintWriter logWriter, int traceLevel)¸¦ »ç¿ëÇÏ¿© ¿¬°á¿¡¼­ ÃßÀûÀ» ¼³Á¤ ¶Ç´Â ÇØÁ¦½Ãų ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ ÀÌ ¸Þ¼Òµå¸¦ »ç¿ëÇÏ¿© ·Î±× ÀÛ¼º±â¸¦ º¯°æÇϰųª Ȱ¼º ¿¬°á¿¡¼­ ÃßÀû ·¹º§À» Á¶Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. Ç¥ÁØ javax.sql.DataSource.setLogWriter(java.io.PrintWriter logWriter) ¸Þ¼Òµå¸¦ »ç¿ëÇÏ´Â °æ¿ì ±âº»(¿ÏÀüÈ÷ »ç¿ë °¡´ÉÇÑ) ÃßÀû ·¹º§ÀÌ »ç¿ëµË´Ï´Ù. ·Î±× ÀÛ¼º±â¸¦ ³Î(null)·Î ¼³Á¤ÇÏ¿© ÃßÀûÀ» »ç¿ë ºÒ°¡´ÉÇÏ°Ô ÇÒ ¼ö ÀÖ½À´Ï´Ù.

Universal JDBC µå¶óÀ̹öÀÇ ÃßÀû Á¤º¸ ÀÛ¼º¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº DB2 ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.

ÀÏ´Ü À§ÀÇ Å¸½ºÅ© ¼¼Æ®¸¦ ¿Ï·áÇÏ°í ³ª¸é, ƯÁ¤ ·Î±× ÆÄÀÏÀ» »ç¿ëÀÚ Á¦Ç°À¸·Î °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù(ÆÄÀÏ > °¡Á®¿À±â...).

iSeries¿ë IBM WebSphere Application Server Ȱµ¿ ¹× ÃßÀû ·Î±× ÆÄÀÏ¿ë ±¸¼º

iSeries¿ë IBM WebSphere Application Server¿¡¼­´Â ±× °íÀ¯ÀÇ ±¸¼ºÀ¸·Î °¢°¢ ¿©·¯ ¼­¹ö ÀνºÅϽº¸¦ Çã¿ëÇÕ´Ï´Ù. ÀνºÅϽº°¡ Á¤ÀÇµÈ ¼­ºêµð·ºÅ丮´Â ¼­¹ö ¹× ¼­¹ö ÀνºÅϽº À̸§¿¡ ¼³Ä¡µÈ IBM WebSphere Application Server ¹öÀü µÑ ¸ðµÎ¿¡ ÀÇÁ¸ÇÕ´Ï´Ù.

¿¹¸¦ µé¾î, ±âº»°ªÀ¸·Î À̸§ÀÌ ÁöÁ¤µÈ ¼­¹ö ÀνºÅϽº À̸§¿¡ ´ëÇØ IBM WebSphere Application Server Express V5.0À» ½ÇÇà ÁßÀÎ iSeries ½Ã½ºÅÛÀÇ ·Î±ë ¼³Á¤À» º¸·Á¸é, server.xml ÆÄÀÏÀº ´ÙÀ½ À§Ä¡¿¡ ÀúÀåµË´Ï´Ù.

/QIBM/UserData/WebASE/ASE5/default/config/cells/myhostname/nodes/mynodename/servers/server1/server.xml. 

ÀÌ server.xml ÆÄÀÏ¿¡´Â ·Î±ë ½ºÆåÀÌ µé¾î ÀÖ½À´Ï´Ù.

  1. Ȱµ¿ ·Î±× »ý¼º Äѱâ
    ´ÙÀ½ Àý¿¡¼­ Ȱµ¿ ·Î±ëÀº ±âº»ÀûÀ¸·Î ÄÑÁ® ÀÖ½À´Ï´Ù.
    <services xmi:type="loggingservice.ras:RASLoggingService" xmi:id="RASLoggingService_1" enable="true" messageFilterLevel="NONE" enableassociationId="true">
    <serviceLog xmi:id="ServiceLog_1" name="${LOG_ROOT}/activity.log" size="2" enabled="true"/>
    </services>
    

    Ȱµ¿ ·Î±×(À§ÀÇ ¿¹Á¦¿¡ µû¶ó)´Â /QIBM/UserData/WebASE/ASE5/default/logs/activity.log ÆÄÀÏ¿¡ ³ªÅ¸³³´Ï´Ù.

  2. IBM WebSphere Application Server ÃßÀû ·Î±×¸¦ ÄѽʽÿÀ.
    ±âº»ÀûÀ¸·Î ÃßÀû ·Î±ëÀº ÄÑÁ® ÀÖÁö ¾Ê½À´Ï´Ù. ´ÙÀ½ 3ÇàÀ» Ãß°¡ÇÏ¿© ÃßÀûÀ» Äѱâ À§ÇØ server.xml ÆÄÀÏÀ» ÆíÁýÇØ¾ß ÇÒ ¼ö ÀÖ½À´Ï´Ù.
    <services xmi:type="traceservice:TraceService" xmi:id="TraceService_1" enable="true" startupTraceSpecification="com.ibm.ws.http.HttpConnection=entryExit=enabled:com.ibm.ws.webcontainer.srp.ServletRequestProcessor=entryExit=enabled,event=enabled" traceOutputType="SPECIFIED_FILE" traceFormat="BASIC" memoryBufferSize="8">
    <traceLog xmi:id="TraceLog_1" fileName="${SERVER_LOG_ROOT}/trace.log" rolloverSize="20" maxNumberOfBackupFiles="1"/>
    </services>
    

    À§ÀÇ ¿¹Á¦¿¡ µû¶ó, /QIBM/UserData/WebASE/ASE5/default/logs/server1/trace.log ÆÄÀÏ¿¡ ÃßÀû ·Î±×¸¦ ÀÛ¼ºÇÏ°Ô µË´Ï´Ù.

  3. º¯°æ»çÇ×À» È®¾àÇÒ IBM WebSphere Application Server ÀνºÅϽº ÁßÁö ¹× Àç½ÃÀÛÀº
    ¸í·ÉÇà¿¡¼­ ¶Ç´Â IBM WebSphere Application Server °ü¸® Äֿܼ¡¼­ ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸í·ÉÇà¿¡¼­ ¼­¹ö¸¦ ÁßÁöÇÏ·Á¸é, iSeries QShell ÀÎÅÍÇÁ¸®ÅÍ¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. 1. ÇöÀç µð·ºÅ丮¸¦ Àû¿ë °¡´ÉÇÑ IBM WebSphere Application Server bin µð·ºÅ丮 2·Î º¯°æÇϽʽÿÀ. 2. ¼­¹ö¸¦ ÁßÁöÇϽʽÿÀ.
    stopServer -instance default

    3. ¼­¹ö¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ.

    startServer -instance default

°ü·Ã °³³ä
·Î±× ¹× ÃßÀû ºÐ¼®±â¸¦ »ç¿ëÇÏ¿© ºÐ»ê ÀÀ¿ëÇÁ·Î±×·¥ÀÇ ¹®Á¦Á¡ ÆÇº°
AC(Autonomic Computing) Áõ»ó µ¥ÀÌÅͺ£À̽º

°ü·Ã Ÿ½ºÅ©
·Î±× ÆÄÀÏ °¡Á®¿À±â
AC Áõ»ó µ¥ÀÌÅͺ£À̽º °¡Á®¿À±â ¹× »ç¿ë