¿¬°á¼º º¸Ãæ ¼³¸í¼­

AS/400¿ë DB2 Universal Database DRDA TCP/IP ¼­¹ö¿¡ ´ëÇÑ ¼³Á¤ ¹× »ç¿ë»óÀÇ °í·Á»çÇ×

AS/400¿ë DB2 Universal Database DRDA TCP/IP ¼­¹ö¸¦ ¼³Á¤ÇÒ ¶§ °í·ÁÇØ¾ß ÇÒ »çÇ×Àº ¼­¹ö°¡ ½ÃÀ۵Ǿú´ÂÁö È®ÀÎÇÏ´Â °ÍÀÔ´Ï´Ù. DRDA ¼­¹ö(DDM ¼­¹ö¶ó°íµµ ÇÔ)¸¦ ½ÃÀÛÇϱâ À§ÇÑ CL ¸í·ÉÀº ´ÙÀ½°ú °°½À´Ï´Ù.

   STRTCPSVR SERVER(*DDM)

DRDA ¼­¹ö´Â ¸Å°³º¯¼ö ¾øÀÌ TCP/IP ¼­¹ö ½ÃÀÛ(STRTCPSVR) ¸í·ÉÀ» »ç¿ëÇϰųª SERVER ¸Å°³º¯¼ö¿¡ ´ëÇØ *ALLÀ» ÁöÁ¤ÇÏ¿© ½ÃÀÛÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÌ CL ¸í·ÉÀÌ ¹ßÇàµÈ °æ¿ì DRDA ¼­¹ö´Â TCP/IP°¡ ½ÃÀÛµÉ ¶§ ÀÚµ¿À¸·Î ½ÃÀ۵˴ϴÙ.

   CHGDDMTCPA AUTOSTART(*YES)

´ÙÀ½°ú °°ÀÌ CL ¸í·ÉÀ» ¹ßÇàÇÏ¿© ¼­¹ö°¡ ½ÃÀ۵Ǿú´ÂÁö È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.

   WRKUSRJOB USER(QUSER) STATUS(*ACTIVE)

ÀÌ ¸í·ÉÀº È®´ë/Ãà¼Ò °¡´ÉÇÑ ÀÛ¾÷ ¸ñ·ÏÀ» Ç¥½ÃÇÕ´Ï´Ù. ÇÑ ÆäÀÌÁö ÀÌ»óÀ» ¾Æ·¡·Î ½ºÅ©·ÑÇÏ´Â °æ¿ì, ´ÙÀ½ Á¤º¸°¡ µé¾î ÀÖ´Â µÎ °³ÀÇ ÇàÀÌ Ç¥½ÃµÇ¾î¾ß ÇÕ´Ï´Ù.

   __   QRWTLSTN    QUSER       BATCH    ACTIVE
   __   QRWTSRVR    QUSER       PJ       ACTIVE

½ÇÇàÁßÀÎ »çÀü ½ÃÀÛ ¼­¹ö ÀÛ¾÷ÀÇ ¼ö¿¡ µû¶ó QRWTSRVR ÇàÀÌ ¹Ýº¹ÀûÀ¸·Î ³ªÅ¸³¯ ¼öµµ ÀÖ½À´Ï´Ù.

QRWTLSTN ÇàÀÌ ÀÖÀ¸¸é DRDA ¹× DDM ¿¬°á ¿äûÀ» ±â´Ù¸®´Â ÀÛ¾÷ÀÌ ½ÇÇàÁßÀÓÀ» ÀǹÌÇÕ´Ï´Ù. ÀÌ ÀÛ¾÷Àº ¿¬°á ¿äûÀÌ ¼ö½ÅµÉ ¶§ ÀÛ¾÷À» QRWTSRVR ÀÛ¾÷¿¡ ¹ß¼ÛÇÕ´Ï´Ù.

DRDA ¼­¹ö°¡ ½ÃÀ۵Ǿú´ÂÁö È®ÀÎÇÏ´Â ´Ù¸¥ ¹æ¹ýÀº STRTCPSVR SERVER(*DDM) ¸í·ÉÀ» ¹ßÇàÇϰí 'DDM TCP/IP server already active' ¸Þ½ÃÁö¸¦ »ìÆìº¸´Â °ÍÀÔ´Ï´Ù.

ƯÁ¤ ¿¬°á¿¡ »ç¿ëµÇ´Â »çÀü ½ÃÀÛ ÀÛ¾÷ À̸§Àº ´ÙÀ½°ú °°ÀÌ DSPLOG ¸í·ÉÀ» ¹ßÇàÇϸé ãÀ» ¼ö ÀÖ½À´Ï´Ù.

   DSPLOG PERIOD(('15:55'))

¿©±â¼­, ÁöÁ¤µÈ ½Ã°£Àº ¿¬°áÀÌ ÀÌ·ç¾îÁø °Íº¸´Ù ÀÌÀü ½Ã°£ÀÔ´Ï´Ù. À̰ÍÀÌ ½ºÅ©·ÑÀÌ °¡´ÉÇÑ ½ÇÇà±â·Ï ·Î±× Ç׸ñ ¸ñ·ÏÀÌ µË´Ï´Ù. ¼­¹ö ÀÛ¾÷ À̸§ÀÌ µé¾î ÀÖ´Â ¾Æ·¡¿Í °°Àº Ç׸ñÀ» »ìÆìº¸½Ê½Ã¿À.

   DDM job 039554/QUSER/QRWTSRVR servicing user SRR on 03/30/98 at 15:57:38.

ÀÌ ÀÛ¾÷ À̸§Àº ¾ÆÁ÷ ½ÇÇàÁßÀÎ ÀÛ¾÷ÀÇ ÀÛ¾÷ ·Î±×¸¦ »ìÆìº¼ ¶§ À¯¿ëÇÕ´Ï´Ù. ¶ÇÇÑ, ¹®Á¦Á¡ ÆÇº°À» À§ÇØ ½ÇÇàÁßÀÎ ÀÛ¾÷¿¡¼­ ¼­ºñ½º ÀÛ¾÷À» ½ÃÀÛÇϰųª Á¶È¸ ÃÖÀûÈ­ ¾Ë°í¸®Áò ¸Þ½ÃÁö¸¦ º¼ ¶§¿¡µµ À¯¿ëÇÕ´Ï´Ù. À§ Á¤º¸¸¦ ÀÌ¿ëÇÏ¿© ¼­ºñ½º ÀÛ¾÷À» ½ÃÀÛÇÏ´Â CL ¸í·ÉÀÇ ¿¹´Â ´ÙÀ½°ú °°½À´Ï´Ù.

   STRSRVJOB 039554/QUSER/QRWTSRVR

ó¸®µÈ ÀÛ¾÷À» µð¹ö±× ¸ðµå¿¡ ³õÀ¸·Á¸é STRDBG ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

   STRDBG UPDPROD(*YES)

¾î¶² °æ¿ì DRDA ¼­¹ö´Â ÀÛ¾÷À» ÀçȰ¿ëÇϰí ÀÛ¾÷ ·Î±×¸¦ Áö¿ì±â Àü¿¡ »çÀü ½ÃÀÛ ÀÛ¾÷ÀÇ ÀÛ¾÷ ·Î±×¸¦ ÀúÀåÇÕ´Ï´Ù. ÀÌ·¯ÇÑ »óȲÀº ½É°¢ÇÑ Àå¾Ö°¡ °ËÃâµÈ °æ¿ì³ª ó¸®Áß¿¡ ÀÛ¾÷ÀÌ Á¾·áµÇ´Â °æ¿ì(STRSRVJOB ¸í·É »ç¿ë) ¹ß»ýµË´Ï´Ù.

ÀÛ¾÷ÀÌ Á¾·áµÈ ÈÄ ÀúÀåµÈ ÀÛ¾÷ ·Î±×¸¦ ãÀ¸·Á¸é ´ÙÀ½ ¸í·ÉÀ» ¹ßÇàÇϽʽÿÀ.

   WRKJOB userid/QPRTJOB

¿©±â¼­, userid´Â ¿¬°áÀÌ ÀÌ·ç¾îÁø »ç¿ëÀÚ ID À̸§ÀÔ´Ï´Ù(À§ÀÇ ¿¹¿¡¼­ SRR).

ÀÌ ¸í·ÉÀº ÀÛ¾÷À» ¼±ÅÃÇÒ ¼ö ÀÖ´Â ÀÛ¾÷ ¸ñ·ÏÀ̳ª ´ÜÀÏ ÀÛ¾÷¿¡ ´ëÇÑ ¿É¼Ç ¸Þ´º¸¦ Ç¥½ÃÇÕ´Ï´Ù. ÀúÀåµÈ ÀÛ¾÷ ·Î±×¸¦ ãÀ¸·Á¸é ¿É¼Ç 4 'Work with spooled files'À» ¼±ÅÃÇϽʽÿÀ. ¿©·¯ °³ÀÇ ÆÄÀÏÀÌ ½ºÇ®µÈ °æ¿ì ÀÛ¾÷ ·Î±×´Â ÆÄÀÏ À̸§ QPJOBLOG¸¦ °®½À´Ï´Ù. ¿É¼Ç 5¸¦ ¼±ÅÃÇϸé ÀÛ¾÷ ·Î±× ÆÄÀÏÀ» ¿­¶÷ÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÀÛ¾÷ÀÌ ¼öÁ¤Áß¿¡ ¼öÇàµÈ °æ¿ì, ¼­¹ö ÀÛ¾÷ ·Î±×¿¡¼­ º¼ ¼ö ÀÖ´Â Á¶È¸ ÃÖÀûÈ­ ¾Ë°í¸®Áò ¸Þ½ÃÁö À¯ÇüÀÇ ¿¹´Â ´ÙÀ½°ú °°½À´Ï´Ù.

   CPI4329    Information   00    03/30/98   16:14:57   QQQIMPLE
               QSYS        3911     QSQOPEN      QSYS         09C4
   Message . . . . :   Arrival sequence access was used for file TBL2.
   Cause . . . . . :   Arrival sequence access was used to select
     records from member TBL2 of file TBL2 in library SR. If file TBL2
     in library SR is a logical file then member TBL2 of physical file
     TBL2 in library SR is the actual file from which records are
     being selected. A file name of *N for the file indicates it is a
     temporary file. Recovery  . . . :   The use of an access path may
     improve the performance of the query if record selection is
     specified. If an access path does not exist, you may want to
     create one whose left-most key fields match fields in the record
     selection.  Matching more key fields in the access path with
     fields in the record selection will result in improved
     performance. Generally, to force the use of an existing access
     path, specify order by fields that match the left-most key fields
     of that access path. For more information refer to the DB2 for
     AS/400 SQL Programming book.


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