ÀÌ Àý¿¡´Â ´ÙÀ½ Á¤º¸°¡ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù.
z/OS ¹× OS/390¿ë DB2 Warehouse Manager¿¡´Â zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®°¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀÌ ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© z/OS ¹× OS/390¿ë DB2 Universal Database¿Í ±âŸ µ¥ÀÌÅͺ£À̽º(´Ù¸¥ ¿î¿µ üÁ¦ÀÇ DB2 µ¥ÀÌÅͺ£À̽º¿Í ºñDB2 µ¥ÀÌÅͺ£À̽º¿Í °°Àº) »çÀÌ¿¡ Åë½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â ODBC(Open Database Connectivity) ¿¬°áÀ» »ç¿ëÇÏ´Â Áö¿øµÇ´Â µ¥ÀÌÅÍ ¼Ò½º¿Í Åë½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â Unix Systems Services¿¡¼ ¼öÇàµÇ¸ç, OS/390 ¹öÀü 2 ¸±¸®½º 7 ÀÌ»óÀÌ ÇÊ¿äÇϰí, OS/390¿ë DB2 ¹öÀü 5 ¹× 6, z/OS ¹× OS/390¿ë DB2 ¹öÀü 7°ú ȣȯµË´Ï´Ù.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â ´ÙÀ½ Ÿ½ºÅ©¸¦ Áö¿øÇÕ´Ï´Ù.
ÀÌ Àý¿¡´Â zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ ¼³Ä¡Çϴµ¥ ÇÊ¿äÇÑ ¼ÒÇÁÆ®¿þ¾î, ±ÇÇÑ ¹× ÇÁ·Î±×·¥ Àӽà ¼öÁ¤(PTF)¿¡ ´ëÇÑ Á¤º¸°¡ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â z/OS ¹× OS/390¿ë DB2 Universal Database ¹öÀü 7 Á¦Ç°¿¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. DB2 Warehouse Manager ÇÁ·Î±×·¥ µð·ºÅ丮 ¿ª½Ã ÀÌ Á¦Ç°¿¡ Æ÷ÇԵǾî ÀÖÀ¸¸ç, ÀÌ µð·ºÅ丮¿¡´Â ÀúÀå ¿µ¿ª, ÇÁ·Î±×·¡¹Ö, ±×¸®°í »ç¿ëÀÚ ±¸µ¿ ½Ã½ºÅÛ ¹× ¸ñÇ¥ ½Ã½ºÅÛ¿¡ ´ëÇÑ ¿ä±¸»çÇ× Á¤º¸°¡ µé¾î ÀÖ½À´Ï´Ù.
Ç¥ 1Àº OS/390 ¿¡ÀÌÀüÆ®¸¦ ¼³Ä¡Çϱâ Àü¿¡ DB2 ¼ºê½Ã½ºÅÛ¿¡ Àû¿ëÇØ¾ß ÇÏ´Â APARÀÔ´Ï´Ù.
DB2 Universal Database ¹öÀü | ÀüÁ¦ APAR |
OS/390¿ë DB2 ¹öÀü 5 | PQ36586 |
OS/390¿ë DB2 ¹öÀü 6 | PQ36585 |
z/OS ¹× OS/390 DB2 ¹öÀü 7ÀÌ ½Ã½ºÅÛ¿¡ ¼³Ä¡µÇ¾î ÀÖÀ¸¸é APARÀÌ ÇÊ¿äÇÏÁö ¾Ê½À´Ï´Ù.
Ç¥ 2´Â Java ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇÒ °æ¿ì¿¡ DB2 ¼ºê½Ã½ºÅÛ¿¡ Àû¿ëÇØ¾ß ÇÏ´Â PTFÀÔ´Ï´Ù.
DB2 Universal Database ¹öÀü | ÀüÁ¦ PTF |
OS/390¿ë DB2 ¹öÀü 5 | UQ46170 |
OS/390¿ë DB2 ¹öÀü 6 | UQ46114 |
z/OS ¹× OS/390¿ë DB2 ¹öÀü 7 | UQ53028 |
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ ¼³Ä¡ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
SMP/E ¼³Ä¡·Î ¸¸µé¾îÁö´Â ¸ñÇ¥ ¶óÀ̺귯¸® Áß ÇϳªÀÎ Unix Systems Services µð·ºÅ丮¿¡´Â ±âº» À̸§ÀÌ /usr/lpp/DWCÀÎ ¿þ¾î ½ÇÇà ÇÁ·Î±×·¥ÀÌ ÀÖ½À´Ï´Ù. ÀÌ µð·ºÅ丮¿¡´Â ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿¡ ´ëÇÑ ½ÇÇà ÆÄÀϵéÀÌ ÀÖ½À´Ï´Ù.
´ÙÀ½ ¿¹´Â »ùÇà .profile ÆÄÀÏÀÇ ³»¿ëÀÔ´Ï´Ù.
export VWS_LOGGING=/usr/lpp/DWC/logs export VWP_LOG=/usr/lpp/DWC/vwp.log export VWS_TEMPLATES=usr/lpp/DWC export DSNAOINI=/u/userid/dsnaoini export LIBPATH=usr/lpp/DWC/ :$LIBPATH export PATH=/usr/lpp/DWC/ :$PATH export STEPLIB=DSN710.SDSNEXIT:DSN710.SDSNLOAD
.profile ÆÄÀÏÀº ȯ°æ º¯¼ö¸¦ Á¤ÀÇÇϸç, ¿¡ÀÌÀüÆ® µð¸ÕÀ» ½ÃÀÛÇÏ´Â »ç¿ëÀÚÀÇ È¨ µð·ºÅ丮¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
vwkernel 11000/tcp vwd 11001/tcp vwlogger 11002/tcpzSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿Í µ¥ÀÌÅͺ£À̽º »çÀÌÀÇ ¿¬°áÀ» ¼³Á¤ÇÏ·Á¸é, ¿ø°Ý µ¥ÀÌÅͺ£À̽º¸¦ z/OS ¹× OS/390 Åë½Å µ¥ÀÌÅͺ£À̽º¿¡ Ãß°¡ÇϽʽÿÀ.
´ÙÀ½ ¿¹´Â Windows NT¿¡¼ ¼öÇà ÁßÀÎ µ¥ÀÌÅͺ£À̽º¸¦ OS/390 ¿¡ÀÌÀüÆ®¿¡ ¿¬°áÇϱâ ÀÇÇÑ »ùÇà CDB »ðÀÔ¹®ÀÔ´Ï´Ù.
INSERT INTO SYSIBM.LOCATIONS (LOCATION, LINKNAME, PORT) VALUES ('NTDB','VWNT704','60002'); INSERT INTO SYSIBM.IPNAMES (LINKNAME, SECURITY_OUT, USERNAMES, IPADDR) VALUES ('VWNT704', 'P', 'O', 'VWNT704.STL.IBM.COM'); INSERT INTO SYSIBM.USERNAMES (TYPE, AUTHID, LINKNAME, NEWAUTHID, PASSWORD) VALUES ('O', 'MVSUID', 'VWNT704', 'NTUID', 'NTPW');
¿¬°á ¼³Á¤ ¹× Åë½Å µ¥ÀÌÅͺ£À̽º °»½Å¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â DB2 Universal Database for z/OS and OS/390 Installation Guide¸¦ ÂüÁ¶ÇϽʽÿÀ.
Áö¿ª ½Ã½ºÅÛ À̸§ÀÌ DWC6ÀÎ °æ¿ì, ´ÙÀ½ ¿¹´Â Áö¿ª z/OS ¹× OS/390¿ë DB2 µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ÀϺΠ»ùÇà ¹ÙÀÎµå ÆÐŰÁö ¸í·É¹®ÀÔ´Ï´Ù.
DSN SYSTEM(DWC6) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLICS) ISO(CS) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLINC) ISO(NC) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIRR) ISO(RR) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIRS) ISO(RS) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIUR) ISO(UR) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIQR) ISO(QR) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIMS) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIC1) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIC2) BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIF4)
´ÙÀ½ ¿¹´Â ¿ø°Ý z/OS ¶Ç´Â OS/390¿ë DB2 µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ÀϺΠ»ùÇà ¹ÙÀÎµå ÆÐŰÁö ¸í·É¹®ÀÔ´Ï´Ù. ¿©±â¼ REMLOC´Â Åë½Å µ¥ÀÌÅͺ£À̽º¿¡ µî·ÏµÈ ¿ø°Ý z/OS ¶Ç´Â OS/390 ½Ã½ºÅÛ¿ë DB2ÀÇ À§Ä¡ À̸§ÀÔ´Ï´Ù.
DSN SYSTEM(DWC6) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLICS) ISO(CS) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLINC) ISO(NC) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIRR) ISO(RR) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIRS) ISO(RS) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIUR) ISO(UR) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIQR) ISO(QR) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIMS) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIC1) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIC2) BIND PACKAGE (REMLOC.DWC6CLI) MEMBER(DSNCLIF4)
´ÙÀ½ ¿¹´Â Windows NT¿¡¼ ½ÇÇà ÁßÀÎ DB2 Universal Database¿¡ ´ëÇÑ ÀϺΠ»ùÇà ¹ÙÀÎµå ÆÐŰÁö ¸í·É¹®ÀÔ´Ï´Ù.
BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLICS) ISO(CS) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLINC) ISO(NC) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIRR) ISO(RR) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIRS) ISO(RS) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIUR) ISO(UR) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIC1) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIC2) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIQR) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIF4) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIV1) BIND PACKAGE (NTDB.DWC6CLI) MEMBER(DSNCLIV2)
´ÙÀ½Àº Ç÷£¿¡¼ ¸ðµç À§Ä¡¿¡ ´ëÇÑ CLI ÆÐŰÁöµéÀ» ÇÔ²² ¹ÙÀεåÇϱâ À§ÇÑ »ùÇà ¹ÙÀÎµå ¸í·É¹®ÀÔ´Ï´Ù.
DSN SYSTEM(DWC6) BIND PLAN(DWC6CLI) PKLIST(*.DWC6CLI.* )
CLI ÆÐŰÁö ¹ÙÀεùÀ» ¿Ï·áÇϸé, .profile ÆÄÀÏÀÇ DSNAOINI ȯ°æ º¯¼ö°¡ ¹æ±Ý ¹ÙÀεåÇÑ CLI Ç÷£À» »ç¿ëÇÏ´Â ODBC ÃʱâÈ ÆÄÀÏÀ» Áö½ÃÇÏ´ÂÁö °ËÁõÇØ¾ß ÇÕ´Ï´Ù.
¿¹¸¦ µé¾î, CLI Ç÷£ÀÇ À̸§ÀÌ DWC6CLIÀ̰í Áö¿ª ½Ã½ºÅÛÀÇ À̸§ÀÌ DWC6À̸é, ODBC ÃʱâÈ ÆÄÀÏ¿¡´Â ´ÙÀ½ Á¤º¸°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ;SUBSYSTEM stanza [DWC6] MVSATTACH=CAF PLANNAME=DWC6CLI
ÆÄÀÏÀÌ ¿Ã¹Ù¸£°Ô ÀÛµ¿ÇÏ´ÂÁö °ËÁõÇÏ·Á¸é, ±× ÆÄÀÏÀÌ ÀûÀýÇÏ°Ô ±¸¼ºµÇ¾î ÀÖ´ÂÁö °ËÁõÇϽʽÿÀ.
DB2 ½Ã½ºÅÛ¿¡ ´ëÇÑ µ¥ÀÌÅÍ ¼Ò½º ½ºÅÄÀÚ¸¦ °¡Áö°í ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ. Áö¿ª DB2 ½Ã½ºÅÛÀÇ À§Ä¡ À̸§À» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
´ÙÀ½Àº DSNAOINI ÆÄÀÏÀÇ ¿¹ÀÔ´Ï´Ù.
[COMMON] MVSDEFAULTSSID=DWC6 CONNECTTYPE=2 ;APPLTRACE=1 ;APPLTRACEFILENAME=/usr/lpp/DWC/logs/application.CLITRACE ;TRACEFLUSH=1 ;Example SUBSYSTEM stanza for V71A subsystem [DWC6] MVSATTACHTYPE=CAF PLANNAME=DWC6CLI ;DATA SOURCE stanza for ISC710P1 data source [ISC710P1]
ODBC ÃßÀûÀ» »ç¿ëÇÏ·Á¸é, COMMON ¼½¼Ç¿¡¼ ¼¼ °³ÀÇ ÁÖ¼® ÇàÀ» Á¦°ÅÇϽʽÿÀ. ODBC ¹× DSNAOINI ÆÄÀÏ ¹ÙÀεù¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â DB2 Universal Database for z/OS and OS/390 ODBC Guide and Reference¸¦ ÂüÁ¶ÇϽʽÿÀ.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â µð¸Õ ÇÁ·Î¼¼½ºÀÔ´Ï´Ù. ¿¡ÀÌÀüÆ® µð¸ÕÀº _password( ) ÇÔ¼ö¸¦ »ç¿ëÇϹǷΠRACF ÇÁ·Î±×·¥ Á¦¾î¿¡ ´ëÇÑ ¿¡ÀÌÀüÆ® ½ÇÇà ÇÁ·Î±×·¥À» Á¤ÀÇÇϽʽÿÀ.
libtls4d.dll iwhcomnt.dll vwd
RACF ÇÁ·Î±×·¥ Á¦¾î¿¡ ´ëÇÑ ½ÇÇà ÇÁ·Î±×·¥À» Á¤ÀÇÇÏ·Á¸é, Data Warehouse Center ½ÇÇà ÆÄÀÏÀÌ ÀúÀåµÇ¾î ÀÖ´Â µð·ºÅ丮·Î º¯°æÇÑ ÈÄ ´ÙÀ½ ¸í·ÉÀ» ¼öÇàÇϽʽÿÀ.
extattr +p libtls4d.dll extattr +p iwhcomnt.dll extattr +p vwd+p ¸Å°³º¯¼ö¿Í ÇÔ²² extattr ¸í·ÉÀ» »ç¿ëÇÏ·Á¸é, BPX.FILEATTR.PROGCTL FACILITY Ŭ·¡½º¿¡ ´ëÇØ ÃÖ¼ÒÇÑ Àб⠾׼¼½º¸¦ °¡Áö°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.
´ÙÀ½ ¿¹´Â ÀÌ »ç¿ë±ÇÇÑÀ» »ç¿ëÀÚ ID JOEUSER¿¡ Á¦°øÇϱâ À§ÇØ »ç¿ëµÇ´Â RACF ¸í·ÉÀÔ´Ï´Ù.
RDEFINE FACILITY BPX.FILEATTR.PROGCTL UACC(NONE) PERMIT BPX.FILEATTR.PROGCTL CLASS(FACILITY) ID(JOEUSER) ACCESS(READ) SETROPTS RACLIST(FACILITY) REFRESH
±ÇÇÑ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â z/OS and OS/390 UNIX System Services PlanningÀ» ÂüÁ¶ÇϽʽÿÀ.
Æ÷±×¶ó¿îµå¿¡¼ µð¸ÕÀ» ½ÃÀÛÇÏ·Á¸é, Unix Systems Services ½©ÀÇ ¸í·ÉÇà¿¡¼ vwd¸¦ ÀÔ·ÂÇϽʽÿÀ.
¹é±×¶ó¿îµå¿¡¼ µð¸ÕÀ» ½ÃÀÛÇÏ·Á¸é, Unix Systems Services ½©ÀÇ ¸í·ÉÇà¿¡¼ vwd>/usr/lpp/DWC/logs/vwd.log 2>&1 &¸¦ ÀÔ·ÂÇϽʽÿÀ.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ® µð¸ÕÀÌ ¼öÇà ÁßÀÎÁö °ËÁõÇÏ·Á¸é, UNIX ½© ¸í·ÉÇà¿¡¼ ps -e | grep vwd¸¦ ÀÔ·ÂÇϽʽÿÀ.
¶Ç´Â, z/OS ¶Ç´Â OS/390 Äֿܼ¡¼ D OMVS,a=allÀ» ÀÔ·ÂÇÏ°í ¹®ÀÚ¿ vwd¸¦ °Ë»öÇϽʽÿÀ.
DB2 Warehouse Manager ÆÐŰÁö¿¡´Â ´ÙÀ½ »ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥ÀÌ ÀÖ½À´Ï´Ù.
¶ÇÇÑ, Data Warehouse Center¿¡¼ »ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥ ¹× ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â UNIX Systems Services¿¡¼ ¼öÇàµÇ´Â ½ÇÇà ÇÁ·Î±×·¥À» Áö¿øÇÕ´Ï´Ù.
»ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥Àº Çϳª ÀÌ»óÀÇ ´Ü°è¿¡ ÁöÁ¤µË´Ï´Ù. »ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥À» ¼öÇàÇÒ ¶§, ´ÙÀ½°ú °°Àº Á¶Ä¡°¡ ¹ß»ýÇÕ´Ï´Ù.
z/OS ¶Ç´Â OS/390ÀÇ ETI ÇÁ·Î±×·¥Àº ÃÖ¼Ò ·¹º§ÀÇ DB2 Universal Database ¹öÀü 7.1, Fixpack 2¸¦ ¿ä±¸ÇÕ´Ï´Ù. »ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥ÀÌ Ãâ·ÂÀ» ¾µ ¼ö ÀÖ´Â µð·ºÅ丮¸¦ Á¤ÀÇÇÏ·Á¸é VWP_LOG ȯ°æ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ.
»ç¿ëÀÚ Á¤ÀÇ ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© FTP·Î ÀÛ¾÷À» Àü¼ÛÇÏ·Á¸é, ¸ÕÀú Á¦ÃâÇÒ µ¥ÀÌÅÍ¿Í JCLÀ» ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù. JCLÀÇ ÀÛ¾÷ À̸§Àº USERIDX¿©¾ß ÇÕ´Ï´Ù. ¿©±â¼ X´Â ÇÑ ÀÚ¸®ÀÇ ¹®ÀÚ ¶Ç´Â ¼ýÀÚÀÔ´Ï´Ù(¿¹: JOEUSERA). JCL¿¡ Æ÷ÇÔµÈ MSGCLASS ¹× SYSOUT ÆÄÀÏÀÇ Ãâ·Â Ŭ·¡½º´Â JES º¸À¯ Ãâ·Â Ŭ·¡½º¸¦ ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
Á¦ÃâµÈ ÀÛ¾÷¿¡ ´ëÇÑ ÃÖ´ë LRECLÀº 254ÀÚÀÔ´Ï´Ù. JES´Â JCLÀÇ Ã³À½ 72ÀÚ¸¸ ½ºÄµÇÕ´Ï´Ù.
Data Warehouse Center´Â FTP¸¦ »ç¿ëÇÏ¿© ÆÄÀÏÀ» Àü¼ÛÇϱâ À§ÇÑ JCL ÅÛÇø®Æ®¸¦ ¼³Ä¡ÇÕ´Ï´Ù. FTP ¸í·É GET ¶Ç´Â PUTÀ» »ç¿ëÇÏ¿© z/OS ¶Ç´Â OS/390 È£½ºÆ®¿¡¼ ´Ù¸¥ ¿ø°Ý È£½ºÆ®·Î ÆÄÀÏÀ» Àü¼ÛÇÏ·Á¸é, JCL ÅÛÇø®Æ®¿¡¼ z/OS ¶Ç´Â OS/390 ½Ã½ºÅÛ¿¡ ´ëÇÑ °èÁ¤ Á¤º¸¸¦ º¯°æÇØ¾ß ÇÕ´Ï´Ù.
JCL ÅÛÇø®Æ®¿¡¼ z/OS ¶Ç´Â OS/390 ½Ã½ºÅÛ¿¡ ´ëÇÑ °èÁ¤ Á¤º¸¸¦ º¯°æÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
¿¹¸¦ µé¾î, STLMVS1¿¡¼ ÀÌ ÇÁ·Î±×·¥ Áß Çϳª¸¦ ¼öÇàÇÏ·Á¸é, STLMVS1.ftp.jcl ÆÄÀÏ »çº»À» ÀÛ¼ºÇϽʽÿÀ.
Data Warehouse Center¿¡´Â ´ÙÀ½ JCL ÅÛÇø®Æ®°¡ ÀÖ½À´Ï´Ù.
//[USERID]A JOB , 'PUT/GET', //* THE NAME OF THE JOB MUST BE THE NAME OF THE //* MVS USER ID FOLLOWED BY ONE ALPHANUMERIC //* CHARACTER. THIS IS A RESTRICTION OF FTP/MVS. // CLASS=A, // USER=&SYSUID, // NOTIFY=&SYSUID, // TIME=(,30), // MSGCLASS=H //STEP1 EXEC PGM=FTP,PARM='( EXIT' //INPUT DD DSN=[FTPFILE],DISP=SHR //OUTPUT DD SYSOUT=* //SYSPRINT DD SYSOUT=*
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© OS/390 UNIX Systems Services ÆÄÀÏ ¹× z/OS ¶Ç´Â OS/390 ¿ø½Ã Ç÷§ ÆÄÀϰú °°Àº DB2 Å×ÀÌºí ¹× Ç÷§ ÆÄÀÏÀÇ »ùÇà ³»¿ëÀ» »ý¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ, zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© Classic Connect°¡ ÀÖ´Â IMS ¶Ç´Â VSM ÆÄÀÏÀÇ »ùÇà ³»¿ëµµ »ý¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù. Ç÷§ ÆÄÀÏ ³»¿ëÀ» »ùÇøµÇÏ´Â °ÍÀº Á¦ÇÑµÈ ¼º´ÉÀÔ´Ï´Ù. ¿þ¾îÇϿ콺´Â Ç÷§ ÆÄÀÏ¿¡¼ ¹®ÀÚ µ¥ÀÌÅ͸¸ Ç¥½ÃÇÕ´Ï´Ù. ¶ÇÇÑ, ÆÄÀÏÀ» ¼Ò½º·Î ¼³Á¤ÇÒ °æ¿ì ¿¡ÀÌÀüÆ®°¡ °¢ Çʵ忡 ´ëÇØ ¿Ã¹Ù¸¥ ¿ÀÇÁ¼Â ¹× ±æÀÌ·Î µ¥ÀÌÅ͸¦ Ç¥½ÃÇÒ ¼ö ÀÖµµ·Ï ÆÄÀÏ Á¤ÀÇÀÇ °³º° Çʵ带 Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù.
Æ®¸®°Å ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© z/OS ¶Ç´Â OS/390¿¡¼ ¿þ¾îÇϿ콺 ´Ü°èÀÇ ½ºÄÉÁÙÀ» ÁöÁ¤ÇϽʽÿÀ. »ç¿ëÀÚ³ª OS/390 ÀÛ¾÷ ½ºÄÉÁÙ ÀÛ¼ºÀÚ´Â Data Warehouse Center¿¡¼ ´Ü°è¸¦ Æ®¸®°ÅÇÏ´Â ÀÛ¾÷À» Á¦ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù. ´Ü°è¿¡ ¼º°øÇϸé, JCLÀÇ Æ®¸®°Å ´Ü°è´Â ¸®ÅÏ ÄÚµå 0À» ¸®ÅÏÇÕ´Ï´Ù.
Æ®¸®°Å ÇÁ·Î±×·¥À» »ç¿ëÇÏ·Á¸é Unix Systems Services¿¡ JDK(Java Development Kit) 1.1.8 ÀÌ»óÀÌ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
Æ®¸®°Å ÇÁ·Î±×·¥À» ½ÃÀÛÇÏ·Á¸é, ¿þ¾îÇϿ콺 ¼¹ö°¡ ¼öÇà ÁßÀÎ ÄÄÇ»ÅÍ¿¡¼ XTServer¸¦ ½ÃÀÛÇϽʽÿÀ. ÀÌ ÇÁ·Î¼¼½º´Â Data Warehouse Center °ü¸® ¾È³»¼¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.
XTServer°¡ Microsoft Windows NT¿¡¼ ½ÃÀÛµÈ °æ¿ì, Unix System Services¿¡¼ XTClient¸¦ ½ÃÀÛÇϽʽÿÀ.
´ÙÀ½Àº Æ®¸®°Å¸¦ ½ÃÀÛÇϱâ À§ÇÑ »ùÇà JCLÀÔ´Ï´Ù.
//DBA1A JOB 1,'XTCLIENT',CLASS=A,MSGCLASS=H, // MSGLEVEL=(1,1),REGION=4M,NOTIFY=&SYSUID //*********************************************** //* submit iwhetrig //*********************************************** //BRADS EXEC PGM=BPXBATCH, // PARM=('sh cd /usr/lpp/DWC/; java XTClient 9.317.171.133 1100x // 9 drummond pw bvmvs2nt 1 1 100') //STDOUT DD PATH='/tmp/xtclient.stdout', // PATHOPTS=(OWRONLY,OCREAT), // PATHMODE=SIRWXU //STDERR DD PATH='/tmp/xtclient.stderr', // PATHOPTS=(OWRONLY,OCREAT), // PATHMODE=SIRWXU //
ÀÌÀü »ùÇà JCLÀº ¸Å°³º¯¼ö°¡ ´ÙÀ½ ÇàÀ¸·Î °è¼ÓµÊÀ» º¸¿©ÁÝ´Ï´Ù. 71Ä÷³±îÁö ¸Å°³º¯¼ö¸¦ ÀÔ·ÂÇϰí 72Ä÷³¿¡ X¸¦ ÀÔ·ÂÇÑ ÈÄ ´ÙÀ½ ÇàÀÇ 16Ä÷³¿¡¼ °è¼Ó ÀÔ·ÂÇϽʽÿÀ. ¸Å°³º¯¼öÀÇ Ã¹ ¹øÂ° ºÎºÐ(cd /usr/lpp/DWC/;)Àº zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®°¡ ¼³Ä¡µÇ´Â µð·ºÅ丮·Î º¯°æµÇ´Â ¸í·É¹®ÀÔ´Ï´Ù.
¸Å°³º¯¼öÀÇ µÎ ¹øÂ° ºÎºÐÀº XTClient¸¦ ½ÃÀÛÇÏ¿© ´ÙÀ½ ¸Å°³º¯¼ö¸¦ Àü´ÞÇÕ´Ï´Ù.
Data Warehouse Center´Â ÀϺΠ±âº»ÀûÀÎ µ¥ÀÌÅÍ º¯È¯À» Á¦°øÇÏ´Â Java ÀúÀå ÇÁ·Î½Ãµà¾î º¯È¯±â¸¦ Æ÷ÇÔÇÕ´Ï´Ù. º¯È¯±â¸¦ ¼öÇàÇÏ·Á¸é, ¸ÕÀú DB2 ¼ºê½Ã½ºÅÛ¿¡¼ Java ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù. º¯È¯±â¿¡ ´ëÇÑ Ãß°¡ Á¤º¸´Â IBM DB2 Universal Database Data Warehouse Center °ü¸® ¾È³»¼(SA30-1000)¸¦ ÂüÁ¶ÇϽʽÿÀ.
zSeries ¿¡ÀÌÀüÆ®¿¡¼ ´ÙÀ½ º¯È¯±â¸¦ ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½Àº Java ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ¿ÏÀüÇÑ Áö½Ã»çÇ×À» °£·«ÇÏ°Ô ¼³¸íÇÑ °ÍÀÔ´Ï´Ù. ¿ÏÀüÇÑ Áö½Ã»çÇ׿¡ ´ëÇØ¼´Â DB2 Universal Database for z/OS and OS/390 Application Programming Guide and Reference for Java(SC26-9932)¸¦ ÂüÁ¶ÇϽʽÿÀ.
DB2 ¼ºê½Ã½ºÅÛ¿¡¼ Java ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
´ÙÀ½ Áö½Ã»çÇ׿¡¼´Â z/OS ¹× OS/390¿ë DB2¿¡¼ ¿þ¾îÇϿ콺 º¯È¯±â¸¦ ¼³Á¤ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. º¯È¯±â¸¦ ¼³Á¤ÇÑ ÈÄ »ç¿ëÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ¿ÏÀüÇÑ Áö½Ã»çÇ×Àº Data Warehouse Center °ü¸® ¾È³»¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
z/OS ¹× OS/390¿ë DB2¿¡¼ ¿þ¾îÇϿ콺 º¯È¯±â¸¦ ¼³Á¤ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
¿þ¾îÇϿ콺 Á¦¾î µ¥ÀÌÅͺ£À̽º¸¦ °»½ÅÇÏ·Á¸é, DB2 ¸í·ÉÇà ÇÁ·Î¼¼¼¿¡¼ ´ÙÀ½ SQL¹®À» ÀÔ·ÂÇϽʽÿÀ.
CONNECT TO your_vw_control_database UPDATE IWH.INFORESOURCE SET TRANSREGISTERED = '1' WHERE SUBDBTYPE = 'DB2 MVS' UPDATE IWH.INFORESOURCE SET TRANSFENCED = '1' WHERE SUBDBTYPE = 'DB2 MVS'
¿©±â¼ your_vw_control_database´Â DWC Á¦¾î µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù.
Ç¥ 3. DB2 Universal Database ¹öÀü¿¡ ÇØ´çµÇ´Â SQL¹® À§Ä¡
DB2 Universal Database ¹öÀü | SQL¹® À§Ä¡ |
OS/390¿ë DB2 ¹öÀü 5 | /usr/lpp/DWC/createXfSQL µð·ºÅ丮¿¡ ÀÖ´Â ÁÖ¼® ó¸®µÈ SQL¹® »ç¿ë(¸ðµç CREATE PROCEDURE ¸í·É¹®À» ÁÖ¼® ó¸®ÇÑ ÈÄ ÁÖ¼®À» Á¦°ÅÇÑ ´ÙÀ½ INSERT INTO SYSIBM.SYSPROCEDURES ¸í·É¹®À» »ç¿ëÇÏ¿© OS/390¿ë DB2 ¹öÀü 5¿¡ ´ëÇØ º¯È¯±â¸¦ Á¤ÀÇÇÔ) |
OS/390¿ë DB2 ¹öÀü 6 | /usr/lpp/DWC/createXfSQL µð·ºÅ丮ÀÇ SQL¹® »ç¿ë |
z/OS ¹× OS/390¿ë DB2 ¹öÀü 7 | /usr/lpp/DWC/createXfSQLV7 µð·ºÅ丮ÀÇ SQL¹® »ç¿ë |
Java ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇÒ ¶§, WLMÀ» »ç¿ëÇÏ¿© Java WLM ½Ãµ¿ ÇÁ·Î½Ãµà¾î¸¦ WLM ȯ°æ À̸§°ú ¿¬°ü½ÃŰ½Ê½Ã¿À. ȯ°æ À̸§Àº CREATE PROCEDURE ¸í·É¹®ÀÇ WLM ENVIRONMENT ¿É¼Ç¿¡ ÁöÁ¤µË´Ï´Ù. DSNWLMJ´Â º¯È¯±â Á¤ÀÇ¿Í ÇÔ²² Æ÷ÇԵǴ WLM ȯ°æ À̸§ÀÔ´Ï´Ù. DSNWLMJÀÇ WLM ¿¬°ü À̸§À» Ãß°¡Çϰųª °¢ º¯È¯±â Á¤ÀÇ¿¡ ´ëÇÑ WLM ENVIRONMENT ¿É¼ÇÀ» ÀÌ¹Ì ½Ãµ¿ ÇÁ·Î½Ãµà¾î¿Í ¿¬°üµÇ¾î ÀÖ´Â À̸§À¸·Î º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.
JDBC¸¦ ¼³Ä¡ÇÒ ¶§, installVAJDLL ¸í·ÉÀ» ¼öÇàÇÕ´Ï´Ù. ÀÌ ¸í·ÉÀº JDBC µå¶óÀ̹ö¿¡ ´ëÇÑ sqlj.jll ¸µÅ©¸¦ ÀÛ¼ºÇÕ´Ï´Ù. sqlj.jll ¸µÅ©¸¦ ¼³Ä¡ÇÑ µð·ºÅ丮ÀÇ À̸§Àº ȯ°æ º¯¼ö µ¥ÀÌÅÍ ¼¼Æ®¿¡¼ CLASSPATH ¹× LIBPATH ¸í·É¹®¿¡ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù.
SQLJ´Â /COM/ibm/db2os390/ Java ÆÐŰÁö¿¡ Æ÷ÇԵ˴ϴÙ. ¿¹¸¦ µé¾î, sqlj.jll ¸µÅ©°¡ /usr/lpp/db2710/COM/ibm/db2os390/ µð·ºÅ丮¿¡ ÀÖÀ¸¸é, /usr/lpp/db2710/À» CLASSPATH ¹× LIBPATH ¸í·É¹®¿¡ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù.
ȯ°æ º¯¼ö µ¥ÀÌÅÍ ¼¼Æ®´Â 244ÀÚ¸¦ ÃʰúÇÒ ¼ö ¾ø½À´Ï´Ù.
ȯ°æ º¯¼ö µ¥ÀÌÅÍ ¼¼Æ®ÀÇ ¹®ÀÚ ¼ö¸¦ ÁÙÀÌ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
/u/userid/links/com/ibm/data/xf.jll /u/userid/links/COM/ibm/db2os390/sqlj.jll
¸µÅ©¸¦ À̵¿ÇÑ °æ¿ì, .jll ÆÄÀÏ¿¡ ´ëÇØ ±ÇÇÑÀ» ´Ù½Ã ½ÇÇàÇØ¾ß È®Àå ºñÆ®°¡ ¼³Á¤µË´Ï´Ù.
È®Àå ºñÆ®ÀÇ ¼³Á¤ ¿©ºÎ¸¦ ÆÇº°ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
»ç¿ë±ÇÇÑ ºñÆ®¿¡´Â »óÀ§ ¼ø¼ ºñÆ® À§Ä¡¿¡ e°¡ ÀÖ½À´Ï´Ù(¿¹: erwxrwxrwx).
ln -e DSNAQJLL sqlj.jll ln -e IWHXF xf.jll
»óÀ§ ¼ø¼ ºñÆ®°¡ lÀ̰í z/OS ¹× OS/390¿ë DB2 ¹öÀü 7À» ¼öÇà ÁßÀ̸é, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© ¸µÅ©¸¦ ´Ù½Ã ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù.
ln -e IWHXFV7 xf.jl
ÀúÀå ÇÁ·Î½Ãµà¾îÀÇ ¼¸í¿¡ ÀÖ´Â Java ¿ÀºêÁ§Æ®´Â z/OS ¹× OS/390¿ë DB2 ¹öÀü 7¿¡¼¸¸ Áö¿øµË´Ï´Ù. OS/390¿ë DB2 ¹öÀü 5 ¹× ¹öÀü 6¿¡¼´Â º¯È¯±â°¡ ±×·¯ÇÑ ¸Å°³º¯¼öÀÇ ³Î(Null) °ªÀ» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ ¹öÀü¿¡¼ ³Î(NULL) ¸Å°³º¯¼ö¸¦ Àü´ÞÇϸé 0À¸·Î °£Áֵ˴ϴÙ. DB2 ¹öÀü 5 ¹× ¹öÀü 6 º¯È¯±â´Â ¸Å°³º¯¼ö 0À» ³Î(NULL) ¹®ÀÚ¿·Î ó¸®ÇÕ´Ï´Ù.
DB2´Â z/OS ¹× OS/390¿ë DB2 ¹öÀü 7ÀÇ ÀúÀå ÇÁ·Î½Ãµà¾î¿¡¼¸¸ COMMIT SQL¹®À» Áö¿øÇÕ´Ï´Ù. INVERTDATA ÀúÀå ÇÁ·Î½Ãµà¾î´Â ÀúÀå ÇÁ·Î½Ãµà¾î ³»¿¡¼ Å×À̺íÀ» »èÁ¦ÇÑ ´ÙÀ½ ÀçÀÛ¼ºÇϹǷÎ, COMMIT¹®ÀÌ ÇÊ¿äÇÕ´Ï´Ù. IWH.INVERTDATA´Â OS/390¿ë DB2 ¹öÀü 5 ¶Ç´Â ¹öÀü 6¿¡¼ Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
z/OS ¹× OS/390¿ë DB2´Â Java »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö(UDF)¸¦ Áö¿øÇÏÁö ¾ÊÀ¸¹Ç·Î, IWH.FORMATDATE´Â S/390 Ç÷§Æû¿¡¼ Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
´ÙÀ½Àº Java ÀúÀå ÇÁ·Î½Ãµà¾î¿¡ ´ëÇÑ »ùÇà ½Ãµ¿ ÇÁ·Î½Ãµà¾îÀÔ´Ï´Ù.
//DSNWLMJ PROC DB2SSN=DSN,NUMTCB=5,APPLENV=DSNWLMJ //************************************************* //* THIS PROC IS USED TO START THE WLM-ESTABLISHED SPAS * //* ADDRESS SPACE FOR THE DSNWLMJ APPLICATION ENVIRONMENT * //* V WLM,APPLENV=DSNWLMJ,RESUME * //************************************************* //DSNWLMJ EXEC PGM=DSNX9WLM,TIME=1440,REGION=0M, // PARM='&DB2SSN, &NUMTCB, &APPLENV' //STEPLIB DD DSN=DSN.TESTLIB,DISP=SHR // DD DSN=IWH710.SIWHPDSE,DISP=SHR // DD DSN=DSN.HPJSP.PDSE.JDBC,DISP=SHR // DD DSN=SYS1.PP.PDSELINK,DISP=SHR // DD DSN=DSN710.SDSNEXIT,DISP=SHR // DD DSN=DSN710.SDSNLOAD,DISP=SHR // DD DSN=SYS1.SCEERUN,DISP=SHR // DD DSN=DSN.PDSE,DISP=SHR //JAVAENV DD DSN=DSN.WLMENVJ.JSPENV,DISP=SHR //CEEDUMP DD SYSOUT=A //DSSPRINT DD SYSOUT=A //JSPDEBUG DD SYSOUT=A //SYSABEND DD SYSOUT=A //SYSPRINT DD SYSOUT=A
ÀÌ ¿¹¿¡¼, IWH710.SIWHPDSE ¶óÀ̺귯¸®¿¡´Â º¯È¯±â ·Îµå ¸ðµâÀÌ ÀÖ½À´Ï´Ù. DSN.HPJSP.PDSE.JDBC¿¡´Â HPJ(High Performance Java) ¼³Á¤ÀÇ HPJ DLLÀÌ ÀÖ½À´Ï´Ù. zSeries¿ë DB2 ¹öÀü 7¿¡¼ ÀÌ ¶óÀ̺귯¸®ÀÇ À̸§Àº DSN710.SDSNLOD2ÀÔ´Ï´Ù. SYS1.PP.PDSELINK¿¡´Â HPJ ·±Å¸ÀÓ ¶óÀ̺귯¸®°¡ ÀÖ°í, DSN.PDSE¿¡´Â HPJ ¼³Á¤ Á¤º¸°¡ ÀÖÀ¸¸ç, DSN.WLMENVJ.JSPENV¿¡´Â ȯ°æ º¯¼ö°¡ ÀÖ½À´Ï´Ù.
´ÙÀ½Àº ȯ°æ º¯¼ö µ¥ÀÌÅÍ ¼¼Æ®ÀÔ´Ï´Ù.
ENVAR("TZ=PST07", "DB2SQLJPROPERTIES=/usr/lpp/db2/jdbc/db2710/classes/db2sqljjdbc.properties", "LIBPATH=/usr/lpp/DWC", "VWSPATH=/usr/lpp/DWC", "CLASSPATH=/usr/lpp/db2/jdbc/db2710/classes:/usr/lpp/DWC:/usr/lpp/hpj/lib"), MSGFILE(JSPDEBUG)
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿¡ ÀÇÇØ »ý¼ºµÇ´Â ´ëºÎºÐÀÇ ¸Þ½ÃÁö´Â ÇØ¼®À» À§ÇØ Windows NT ½Ã½ºÅÛ¿¡ º¸³»Áö¹Ç·Î, ´ëºÎºÐÀÇ °æ¿ì ÀÌ·¯ÇÑ ¸Þ½ÃÁö ¾ð¾î´Â Windows NT¿ë DB2 Universal Database°¡ ¼³Ä¡µÈ ¹æ¹ý¿¡ µû¶ó °áÁ¤µË´Ï´Ù.
º¯È¯±â´Â ¿¹¿ÜÀÔ´Ï´Ù. º¯È¯±âÀÇ °æ¿ì, ¸Þ¼¼Áö ¾ð¾î´Â Windows NT¿ë DB2 Universal Database°¡ ¼³Ä¡µÈ ¹æ¹ý°ú ¹«°üÇÕ´Ï´Ù. zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿¡´Â ´ÙÀ½°ú °°Àº º¯È¯±â¿ë ¸Þ½ÃÁö ÆÄÀÏÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.
Ç¥ 4. º¯È¯±â¿ë ÀÚ±¹¾î Áö¿ø ¸Þ½ÃÁö ÆÄÀÏ
ÆÄÀÏ À̸§ | ¾ð¾î |
Xf.properties_Fi_FI | Çɶõµå¾î |
Xf.properties_No_NO | ³ë¸£¿þÀ̾î |
Xf.properties_Ru_RU | ·¯½Ã¾Æ¾î |
Xf.properties_Zh_CN | Áß±¹¾î |
Xf.properties_Zh_TW | ´ë¸¸¾î |
Xf.properties_Da_DK | µ§¸¶Å©¾î |
Xf.properties_De_DE | µ¶ÀϾî |
Xf.properties_En_US | ¹Ì±¹ ¿µ¾î |
Xf.properties_Es_ES | ½ºÆäÀξî |
Xf.properties_Fr_FR | ÇÁ¶û½º¾î |
Xf.properties_It_IT | ÀÌÅ»¸®¾Æ¾î |
Xf.properties_Ja_JP | ÀϺ»¾î |
Xf.properties_Ko_KR | Çѱ¹¾î |
Xf.properties_Pt_BR | ºê¶óÁú Æ÷¸£Åõ°¥¾î |
Xf.properties_Sv_SE | ½º¿þµ§¾î |
º¯È¯±â ¸Þ½ÃÁö°¡ ¿µ¾î°¡ ¾Æ´Ñ ´Ù¸¥ ¾ð¾î·Î µÇ¾î ÀÖÀ¸¸é, Ç¥ 4¿¡¼ ÆÄÀÏ Áß Çϳª¸¦ ¼±ÅÃÇÑ ÈÄ ±× ³»¿ëÀ» Xf.properties ÆÄÀÏ¿¡ º¹»çÇϽʽÿÀ.
ºñDB2 Universal Database ½Ã½ºÅÛ¿¡ ¾×¼¼½ºÇÒ °æ¿ì, zSeries ¿¡ÀÌÀüÆ®´Â DataJoiner¸¦ »ç¿ëÇÕ´Ï´Ù. DataJoiner´Â ¿¡ÀÌÀüÆ®°¡ ±× ½Ã½ºÅÛÀ» DB2 Universal Database µ¥ÀÌÅͺ£À̽ºÀÎ °Íó·³ º¸ÅëÀÇ DRDA(Distributed Relational Database Architecture) È帧À» »ç¿ëÇϵµ·Ï ÇÕ´Ï´Ù. ODBC ¿äûÀÌ ºñDB2 °è¿ µ¥ÀÌÅͺ£À̽º ¼Ò½º¿¡ º¸³»Áö¸é, DataJoiner´Â ÄÚµåÀÇ Ãß°¡ °èÃþÀ» È£ÃâÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÕ´Ï´Ù.
DataJoiner´Â Oracle, Sybase, Informix, Microsoft SQL Server, Teradata, ±×¸®°í Windows NT, AIX ¶Ç´Â Solaris ¿î¿µ ȯ°æ¿¡¼ ¼öÇàÇÏ´Â ODBC µå¶óÀ̹ö°¡ ÀÖ´Â ±âŸ µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. zSeries ¿¡ÀÌÀüÆ®´Â ¼Ò½º·Î DataJoiner¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖÁö¸¸, ¸ñÇ¥·Î¼ ¾×¼¼½ºÇÒ ¼ö´Â ¾ø½À´Ï´Ù. DataJoiner´Â 2´Ü°è È®¾àÀ» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù. DataJoiner ¹öÀü 2.1 ¹× 2.1.1ÀÌ ÀÀ¿ëÇÁ·Î±×·¥ ¸®Äù½ºÅͷμ TCP/IP¸¦ Áö¿øÇصµ, ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¸¦ ¼ö¹ÝÇÏÁö´Â ¾Ê½À´Ï´Ù. zSeries ¿¡ÀÌÀüÆ®´Â TCP/IP¸¦ »ç¿ëÇϱâ À§ÇØ ÀÀ¿ëÇÁ·Î±×·¥ ¼¹ö¸¦ ÇÊ¿ä·Î ÇϹǷÎ, OS/390 ¶Ç´Â z/OS¿¡¼ DataJoiner¿¡ ¾×¼¼½ºÇÏ´Â ´ë½Å SNA ¿¬°áÀ» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â Classic Connect ODBC µå¶óÀ̹ö¸¦ ÅëÇØ IMS ¹× VSAM¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. Classic Connect¸¦ »ç¿ëÇÏ¿©, IMS ¹× VSAM µ¥ÀÌÅÍ ¼¼Æ®ÀÇ DB2 À¯»ç Á¤ÀǸ¦ ¼³Á¤ÇÑ ´ÙÀ½ ODBC¸¦ »ç¿ëÇÏ¿© ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®·ÎºÎÅÍ º°µµ·Î Classic Connect¸¦ ±¸ÀÔÇÏ¿© ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®´Â ¿äûÀÌ Classic Connect¿Í DB2 Áß¿¡¼ ¾îµð·Î º¸³»Áö´Â Áö¿¡ µû¶ó ÇØ´çµÇ´Â ODBC µå¶óÀ̹ö¸¦ ·ÎµåÇÕ´Ï´Ù. DB2 ¼Ò½º¿¡ ¾×¼¼½ºÇÒ °æ¿ì, ¿¡ÀÌÀüÆ®´Â DB2 ODBC µå¶óÀ̹ö¸¦ ·ÎµåÇÕ´Ï´Ù. VSAM ¶Ç´Â IMS ¼Ò½º¿¡ ¾×¼¼½º ÁßÀ̸é, ¿¡ÀÌÀüÆ®°¡ Classic Connect ODBC µå¶óÀ̹ö¸¦ ·ÎµåÇÕ´Ï´Ù. ±×¸®°í ³ª¼, ¿¡ÀÌÀüÆ® ¿äûÀÌ Ã³¸®µË´Ï´Ù.
Classic Connect¸¦ »ç¿ëÇÏ¸é ´ÜÀÏ ÆÄÀÏÀ̳ª ÆÄÀÏÀÇ ÀϺθ¦ Çϳª ÀÌ»óÀÇ °ü°è Å×À̺í·Î º¼ ¼ö ÀÖ½À´Ï´Ù. Classic ConnectÀÇ IMS ¹× VSAM µ¥ÀÌÅÍ ¼¼Æ®¸¦ ¸ÊÇÎÇÏ¿© ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. ¼öµ¿À¸·Î µ¥ÀÌÅ͸¦ ¸ÊÇÎÇϰųª Microsoft Windows Classic Connect ºñ°ü°è µ¥ÀÌÅÍ ¸ÊÆÛ¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
Classic Connect ODBC µå¶óÀ̹ö ¹× ¿þ¾îÇϿ콺 ¾×¼¼½º¸¦ ¼³Á¤ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
* national language for messages NL = US English * resource master file NL CAT = usr/lpp/DWC/v4r1m00/msg/engcat FETCH BUFFER SIZE = 32000 DEFLOC = CXASAMP USERID = uid USERPASSWORD = pwd DATASOURCE = DJX4DWC tcp/9.112.46.200/1035 MESSAGE POOL SIZE = 1000000
z/OS ¹× OS/390¿ë DB2¿¡´Â µå¶óÀ̹ö °ü¸® ÇÁ·Î±×·¥ÀÌ ¾øÀ¸¹Ç·Î dsnaoini ÆÄÀÏÀ» °»½ÅÇÏÁö ¾Ê¾Æµµ µË´Ï´Ù. Classic Connect¿¡ ´ëÇÑ µå¶óÀ̹ö °ü¸® ÇÁ·Î±×·¥Àº zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿¡ ºôµåµË´Ï´Ù.
¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇϱâ Àü¿¡ APAR PQ44904¸¦ zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¿¡ Àû¿ëÇØ¾ß ÇÕ´Ï´Ù. DSNUTILS´Â WLM ¹× RRS ȯ°æ¿¡¼ ¼öÇàÇÏ´Â z/OS ¹× OS/390¿ë DB2 ÀúÀå ÇÁ·Î½Ãµà¾îÀÔ´Ï´Ù. DB2 Warehouse Manager´Â Data Warehouse Center ´Ü°è¿¡ DB2 À¯Æ¿¸®Æ¼¸¦ Æ÷ÇÔÇÒ ¼ö ÀÖµµ·Ï DSNUTILS¿¡ ´ëÇÑ ÀÎÅÍÆäÀ̽º¸¦ Á¦°øÇÕ´Ï´Ù. DSNUTILS¸¦ »ç¿ëÇÏ¿©, »ç¿ëÀÚ°¡ Á¤ÀÇÇÑ ÀúÀå ÇÁ·Î½Ãµà¾î ÀÎÅÍÆäÀ̽º¸¦ ÅëÇØ ¼³Ä¡µÈ DB2 À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù. z/OS ¹× OS/390¿ë DB2 LOAD, REORG ¹× RUNSTATS À¯Æ¿¸®Æ¼¿¡´Â À¯Æ¿¸®Æ¼ ¼öÇà ¹æ¹ýÀ» º¯°æÇϱâ À§ÇØ »ç¿ëÇÒ ¼ö ÀÖ´Â µî·Ï Á¤º¸ ½¬Æ®°¡ ÀÖ½À´Ï´Ù.
À¯Æ¿¸®Æ¼ÀÇ µî·Ï Á¤º¸¸¦ º¯°æÇÏ·Á¸é, ÇÁ·Î¼¼½º ¸ðµ¨ ÆíÁý±â â¿¡¼ À¯Æ¿¸®Æ¼¸¦ ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃß·Î ´©¸£°í µî·Ï Á¤º¸¸¦ ´©¸£½Ê½Ã¿À.
DSNUTILS ÀúÀå ÇÁ·Î½Ãµà¾î¸¦ ¼³Á¤ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
BIND PLAN(DSNAOCLI) PKLIST(*.DSNAOCLI.*, *.DSNUTILS.*)
DSNUTILS ¼³Á¤¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â DB2 Universal Database for OS/390 Version 6 Management Tools Package¸¦ ÂüÁ¶ÇϽʽÿÀ.
Å×À̺íÀ» Ç÷§ ÆÄÀÏ·Î ¾ð·ÎµåÇÑ ´ÙÀ½ ±× Ç÷§ ÆÄÀÏÀ» ´Ù¸¥ Å×À̺í·Î ·ÎµåÇÏ´Â ¹æ¹ýÀ¸·Î Å×À̺íÀ» º¹»çÇÏ·Á¸é, ÀϹÝÀûÀ¸·Î µ¥ÀÌÅ͸¦ ¾ð·ÎµåÇϰí, »ý¼ºµÈ »çÇ×À» ¾ð·ÎµåÇÏ´Â ·Îµå Á¦¾î ¸í·É¹®À» ÆíÁýÇÑ ´ÙÀ½ µ¥ÀÌÅ͸¦ ·ÎµåÇØ¾ß ÇÕ´Ï´Ù. zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇϸé, ´Ü°èµé »çÀÌ¿¡ ÁßÁöÇÏÁö ¾Ê°í ´Ù¸¥ Å×À̺í·Î µ¥ÀÌÅ͸¦ ´Ù½Ã ·ÎµåÇÏ°í ¼öµ¿À¸·Î Á¦¾î ¸í·É¹®À» ÆíÁýÇϵµ·Ï ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
LOAD À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÏ¿© z/OS ¹× OS/390¿ë DB2 Å×ÀÌºí »çÀÌ¿¡ µ¥ÀÌÅ͸¦ º¹»çÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
´ÙÀ½Àº ¾ð·Îµå Reorg ´Ü°è¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â DSNUTILS ¸Å°³º¯¼öÀÇ ¿¹ÀÔ´Ï´Ù.
UTILITY_ID REORGULX RESTART NO UTSTMT REORG TABLESPACE DBVW.USAINENT UNLOAD EXTERNAL UTILITY_NAME REORG TABLESPACE RECDSN DBVW.DSNURELD.RECDSN RECDEVT SYSDA RECSPACE 50 PNCHDSN DBVW.DSNURELD.PNCHDSN PNCHDEVT SYSDA PNCHSPACE 3
UTILITY_ID LOADREORG RESTART NO UTSTMT :FILE:DBVW.DSNURELD.PNCHDSN:TABLE:[DBVW].INVENTORY UTILITY_NAME LOAD RECDSN DBVW.DSNURELD.RECDSN RECDEVT SYSDA
OS/390 ¶Ç´Â z/OS¿¡ ´ëÇØ »ç¿ë °¡´ÉÇÑ DSNUTILS ¹× DB2 À¯Æ¿¸®Æ¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 for z/OS and OS/390 Utility Guide and Reference¸¦ ÂüÁ¶ÇϽʽÿÀ.
zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© Data Propagator º¹Á¦ Àû¿ë ´Ü°è¸¦ ÀÚµ¿ÈÇÒ ¼ö ÀÖ½À´Ï´Ù. º¹Á¦¿¡´Â ¼Ò½º µ¥ÀÌÅͺ£À̽º, Á¦¾î µ¥ÀÌÅͺ£À̽º ¹× ¸ñÇ¥ µ¥ÀÌÅͺ£À̽º°¡ ÇÊ¿äÇÕ´Ï´Ù. ÀÌ µ¥ÀÌÅͺ£À̽ºµéÀº ¼·Î ´Ù¸£°Å³ª °°Àº µ¥ÀÌÅͺ£À̽ºÀÏ ¼ö ÀÖ½À´Ï´Ù. ĸÃÄ ÀÛ¾÷Àº DB2 ·Î±×¸¦ ÀÐ¾î¼ Ãß°¡, °»½Å ¶Ç´Â º¯°æµÉ ¼Ò½º µ¥ÀÌÅͺ£À̽ºÀÇ ÇàÀ» ÆÇº°ÇÕ´Ï´Ù. ±×·± ´ÙÀ½, º¯°æ»çÇ×À» change-data Å×ÀÌºí¿¡ ¾¹´Ï´Ù. ±×·¯¸é, Àû¿ë ÀÛ¾÷ÀÌ ¼öÇàµÇ¾î º¯°æ»çÇ×À» ¸ñÇ¥ µ¥ÀÌÅͺ£À̽º¿¡ Àû¿ëÇÕ´Ï´Ù. DB2 Warehouse Manager ÆÐŰÁö´Â º¹Á¦ ´Ü°è¸¦ ÀÛ¼ºÇÏ¿© Àû¿ë ÀÛ¾÷À» ÀÚµ¿ÈÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2 Warehouse Manager¸¦ »ç¿ëÇÏ¿© ¼öÇàÇÒ Àû¿ë ÀÛ¾÷ÀÇ À¯Çü°ú ¼öÇàÇÒ ½Ã±â¸¦ Á¤ÀÇÇϽʽÿÀ. SASNLINK ¶óÀ̺귯¸®¸¦ steplib ȯ°æ º¯¼ö¿¡ ³»º¸³»¾î¾ß ÇÕ´Ï´Ù.
Data Warehouse Center¿¡´Â º¹Á¦ Áö¿ø¿¡ ´ëÇÑ JCL ÅÛÇø®Æ®°¡ Æ÷ÇԵ˴ϴÙ. zSeries ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®¸¦ »ç¿ëÇÏ¿© Àû¿ë ÇÁ·Î±×·¥À» ¼öÇàÇÒ °èȹÀ̸é, ÀÌ ÅÛÇø®Æ®¿¡¼ OS/390 ¶Ç´Â z/OS ½Ã½ºÅÛ¿¡ ¸Â°Ô °èÁ¤ ¹× µ¥ÀÌÅÍ ¼¼Æ® Á¤º¸¸¦ º¯°æÇØ¾ß ÇÕ´Ï´Ù.
ÅÛÇø®Æ®¸¦ º¯°æÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
¿¹¸¦ µé¾î, STLMVS1¿¡¼´Â STLMVS1.apply.jcl ÆÄÀÏÀÇ »çº»À» ÀÛ¼ºÇϽʽÿÀ.
´ë°ýÈ£¿¡ Æ÷ÇÔµÈ ¸Å°³º¯¼ö(¿¹: [USERID] ¹× [APPLY_PARMS])´Â º¯°æÇÏÁö ¸¶½Ê½Ã¿À. ´ë°ýÈ£´Â °¢°¢ 16Áø¼ö X'AD'¿Í X'BD'ÀÔ´Ï´Ù. TSO Å͹̳ΠÀ¯ÇüÀÌ SPF ¿É¼Ç 0¿¡¼ 3278A·Î ¼³Á¤µÇÁö ¾ÊÀ¸¸é, ÀÌ °ªµéÀº ´ë°ýÈ£°¡ ¾Æ´Ñ ´Ù¸¥ Ư¼ö ¹®ÀڷΠǥ½ÃµÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ´Â X'AD' ¶Ç´Â X'BD'¸¦ º¯°æÇÏÁö ¾Ê°Å³ª, ÀÌ ¹®ÀÚµé »çÀÌÀÇ µ¥ÀÌÅ͸¦ º¯°æÇÏÁö ¾ÊÀ» °æ¿ì¿¡´Â ¹®Á¦°¡ µÇÁö ¾Ê½À´Ï´Ù.
´ÙÀ½Àº Data Warehouse Center¿¡ Æ÷ÇÔµÈ JCL ÅÛÇø®Æ®ÀÔ´Ï´Ù.
//[USERID]A JOB ,MSGCLASS=H,MSGLEVEL=(1,1), // REGION=2M,TIME=1440,NOTIFY=&SYSUID //* DON'T CHANGE THE FIRST LINE OF THIS TEMPLATE. //* THE REMAINING JCL SHOULD BE MODIFIED FOR YOUR SITE. //********************************************** //* RUN APPLY/MVS ON OS/390 DB2 6.1 * //********************************************** //ASNARUN EXEC PGM=ASNAPV66,REGION=10M, // [APPLY_PARMS] //STEPLIB DD DISP=SHR,DSN=DPROPR.V6R1M0.SASNLINK // DD DISP=SHR,DSN=DSN610.SDSNLOAD //MSGS DD DSN=DPROPR.V2R1M0A.MSGS,DISP=SHR //ASNASPL DD DSN=&ASNASPL ,DISP=(NEW,DELETE,DELETE), // UNIT=SYSDA,SPACE=(CYL,(10,1)), // DCB=(RECFM=VB,BLKSIZE=6404) //SYSTERM DD SYSOUT=* //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //
¼¹ö, ·Î±× ÇÁ·Î±×·¥, ¿¡ÀÌÀüÆ® ¹× ÀϺΠData Warehouse Center ÇÁ·Î±×·¥°ú °°Àº ¸¹Àº DB2 Warehouse Manager ±¸¼º¿ä¼ÒµéÀº VWS_LOGGING ȯ°æ º¯¼ö¿¡ ÁöÁ¤µÈ ·Î±ë µð·ºÅ丮¿¡ ·Î±×¸¦ ±â·ÏÇÕ´Ï´Ù. ÀÌ ·Î±× ÆÄÀϵéÀº ÀÏ¹Ý ÅØ½ºÆ® ÆÄÀÏÀÔ´Ï´Ù.
Data Warehouse Center¿¡¼ ¿¡ÀÌÀüÆ® ·Î±ëÀ» ½ÃÀÛÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
¿¡ÀÌÀüÆ® ÃßÀûÀº ·¹º§ 0-4¸¦ Áö¿øÇÕ´Ï´Ù.
·¹º§ 1 - ÃßÀû ÁøÀÔ/Á¾·á
·¹º§ 2 - ·¹º§ 1 + ÃßÀû µð¹ö±ë
·¹º§ 3 - ·¹º§ 2 + µ¥ÀÌÅÍ ÃßÀû
·¹º§ 4 - ³»ºÎ ¹öÆÛ ÃßÀû
ÃßÀûÀÌ 1º¸´Ù ³ôÀº ·¹º§·Î ¼³Á¤µÇ¸é, ¼º´ÉÀÌ ¶³¾îÁý´Ï´Ù. µð¹ö±ë ¸ñÀûÀÌ ÀÖÀ» °æ¿ì¿¡¸¸ ÃßÀûÀ» ¼³Á¤ÇϽʽÿÀ. ÃßÀû Á¤º¸´Â AGNTxxx.LOG ÆÄÀÏ¿¡ ÀúÀåµË´Ï´Ù. ȯ°æ Á¤º¸´Â AGNTxxx.SET ÆÄÀÏ¿¡ ÀúÀåµË´Ï´Ù.