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.