|³oÓ¤å¥ó¤¤¦³¤°»ò©O¡H¦w¸Ë OS/390 »P¨ä¯S©Ê
|¥»¤å´£¨Ñ¦p¦ó¦w¸Ë OS/390 ¥N²zµ{¦¡ªº«ü¥Ü¤Î¨ä¯S©Êªº¬ÛÃö¸ê°T¡C |Ãö©ó¦w¸Ëµ{§Çªº§Ö³t½Æ¬d¡A½Ð°Ñ¾\¡u¦w¸Ë·§Æ[¡v¡A |Ãö©ó¸Ô²Óªº«ü¥Ü¡A½Ð°Ñ¾\¡u¦w¸Ë²Ó¸`¡v¡C |Ãö©ó¥N²zµ{¦¡¯S©Êªº¬ÛÃö¸ê°T¡A½Ð°Ñ¾\¡u³]¸mÃB¥~ªº¥N²zµ{¦¡¥\¯à¡v¡B¡uÂà´«µ{¦¡¡v¤Î¡u¦s¨ú DB2 ¨t¦C¥H¥~ªº¸ê®Æ®w¡v¡C
|·§Æ[
|DB2¡uÜÀx¤¤¤ß¡v¥]¬A OS/390 ¥N²zµ{¦¡¡C±z¥i¥H¦b DB2 Universal Database for OS/390 ¤Î¨ä¥¦¸ê®Æ®w¤§¶¡¨Ï¥Î¥N²zµ{¦¡¨Ó³q«H¡A |¥]¬A¨ä¥¦¥¥x¤Wªº DB2 ¸ê®Æ®w¤Î«D DB2 ¸ê®Æ®w¡C¥N²zµ{¦¡¥i»P¨Ï¥Î ODBC ³s½uªº¸ê®Æ¨Ó·½³q«H¡C |¥N²zµ{¦¡¦b OS/390 UNIX ¨t²ÎªA°È¤W°õ¦æ¡C¥¦»Ýn OS/390 V2R6 ©Î¥H¤Wª©¥»¡A¨Ã¥B»P DB2 for OS/390 ª©¥» 5¡B6 ¤Î 7 ¬Û®e¡C
|OS/390 ¥N²zµ{¦¡¤ä´©¤U¦C§@·~¡G |
|³o¨Ç¨BÆJ·§n»¡©ú¦w¸Ëµ{§Ç¡C¦b¡u¦w¸Ë©ú²Ó¡v¤@¸`¤¤´£¨Ñ¤F¦³Ãö³o¨Ç¨BÆJªº§ó¦h¸ê°T¡C
|
|¦w¸Ë OS/390 ¥N²zµ{¦¡
|OS/390 ¥N²zµ{¦¡ªþÀH©ó DB2 Universal Database for OS/390 ª©¥» 7 ºÏ±a¤¤¡C½Ð°Ñ¾\ºÏ±a©Òªþªºµ{¦¡¥Ø¿ý¡A |¥H¨ú±o¦w¸Ë OS/390 ¥N²zµ{¦¡ªº¸Ô²Ó¸ê°T¡C
|¦b¦w¸Ë OS/390 ¥N²zµ{¦¡¤§«e¡A±z¥²¶·¥ý¦b DB2 ¤l¨t²Î¤W¤Þ¥Î APAR PQ36585 ©Î PQ36586¡C
|§ó·s±z³]©wÀɤ¤ªºÀô¹ÒÅܼÆ
|ÅܼƷ|±N¥N²zµ{¦¡«ü¦V¦hºØ DB2 ÀÉ®×®w¡B¿é¥X¥Ø¿ýµ¥µ¥¡C
|¤U¦C½d¨Ò¬O½d¨Ò .profile Àɮתº¤º®e¡C.profile ÀÉ®×·|©w¸qÀô¹ÒÅܼơA |¥B¥¦¥²¶·¦b±Ò°Ê¥N²z±`¾nµ{¦¡ªº¨Ï¥ÎªÌªº°_©l¥Ø¿ý¤¤¡G
|export VWS_LOGGING=/usr/lpp/DWC/logs |export VWP_LOG=/usr/lpp/DWC/vwp.log |export VWS_TEMPLATES=usr/lpp/DWC/ |export DSNAOINI=/usr/lpp/DWC/dsnaoini |export LIBPATH=usr/lpp/DWC/:$LIBPATH |export PATH=/usr/lpp/DWC/:$PATH |export STEPLIB=DSN710.SDSNEXIT:DSN710.SDSNLOAD
|³]¸m³s½u
|Yn³]©w®Ö¤ß¤Î±`¾nµ{¦¡³s½u¡A½Ð±N¤U±³o¦æ¥[¤J /etc/services ÀɮשΠTCPIP.ETC.SERVICES ÀɮסG
|vwkernal 11000/tcp |vwd 11001/tcp |vwlogger 11002/tcp
|Yn¦b OS/390 ¥N²zµ{¦¡¤Î¸ê®Æ®w¶¡³]©w³s½u¡A±N¥ô¦ó»·ºÝ¸ê®Æ®w·s¼W¨ì OS/390 ³q«H¸ê®Æ®w (CDB)¡C³o¸Ì¬O³¡¥÷½d¨Ò CDB INSERT¡G
|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');
|Y»Ý³]¸m³s½uªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\ DB2 UDB for OS/390 Installation Guide (GC26-9008-00) |¤¤ªº¡uConnecting Distributed Database Systems¡v³¹¸`¡C
|³sµ² CLI
|¦]¬° OS/390 ¥N²zµ{¦¡¨Ï¥Î CLI ¨Ó»P DB2 ·¾³q¡A |±z¥²¶·±N CLI ³W¹º³sµ²¨ì©Ò¦³±zªº¥N²zµ{¦¡n¦s¨úªº»·ºÝ¸ê®Æ®w¡C |³o¸Ì¬O¤@¨Ç¥»ºÝ DB2 for OS/390 ¸ê®Æ®wªº½d¨Ò³sµ²¸ê®Æ¥]³¯z¦¡¡G
|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(DSNCLIMS) |BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIC1) |BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIC2) |BIND PACKAGE (DWC6CLI) MEMBER(DSNCLIF4) |
|³o¸Ì¬O¤@¨Ç°õ¦æ¦b Windows NT ¤Wªº DB2 ¸ê®Æ®wªº½d¨Ò bind package ³¯z¦¡¡G
|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) |
|³o¸Ì¬O¤@Ó½d¨Ò bind ³¯z¦¡¡A±N CLI ¸ê®Æ¥]¤@°_³sµ²¨ì³W¹º¤¤¡G
|BIND PLAN(DWC6CLI) PKLIST(*.DWC6CLI.* )
|³]¸m ODBC °_©l³]©wÀÉ®×
|½d¨Ò ODBC °_©l³]©wÀÉ®× (inisamp) ¤º§t¦b usr/lpp/DWC/ ¥Ø¿ý¤¤¡C±z¥i¥H½s¿è¦¹ÀÉ®×¥H°t¦X±zªº¨t²Î¨Ï¥Î¡A©ÎªÌ«Ø¥ß±z¦Û¤vªºÀɮסCYn½T©wÀÉ®×¥¿½T¦a¹B§@¡A |½ÐÅçÃÒ¤w¾A·í¦a¬[ºc¡G |
|Y»Ý³sµ² CLI »P DSNAOINI Àɮתº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\ |DB2 UDB for OS/390 ODBC Guide and Reference(SC26-9005)¡C
|³]¸m±ÂÅv
|OS/390 ¥N²zµ{¦¡¬O¤@Ó±`¾nµ{¦¡µ{§Ç¡C±z¥i¥H¨Ï¥Î¤@¯ëªº UNIX ¦w¥þ©Ê©Î OS/390 UNIX ¦w¥þ©Ê¨Ó°õ¦æ¥N²z±`¾nµ{¦¡¡C
|¦]¬°¥N²zµ{¦¡»Ýn±`¾nµ{¦¡Åv¡A½Ð©w¸q³o¨Ç¥N²zµ{¦¡¥i°õ¦æÀɬ°¡uRACF µ{¦¡±±¨î¡v¡G |
|±ý¦b RACF µ{¦¡±±¨î¤¤©w¸q¥i°õ¦æªºµ{¦¡¡A |½Ð¤Á´«¦Ü¡u¸ê®ÆÜÀx¤¤¤ß¡v¥i°õ¦æÀɩҦbªº¥Ø¿ý¡A°õ¦æ¤U¦C«ü¥O¡G
|extattr +p libtls4d.dll |extattr +p iwhcomnt.dll |extattr +p vwd
|Yn¨Ï¥Î¦³ +p °Ñ¼Æªº extattr «ü¥O¡A |«h¹ï©ó BPX.FILEATTR.PROGCTL FACILITY Ãþ§O±z¦Ü¤Ö¥²¶·¾Ö¦³Åª¨úÅv¡C |¤U¦C½d¨ÒÅã¥Ü¥Î¨Ó±N¦¹³\¥iÅvµ¹¤©¨Ï¥ÎªÌ ID SMORG ªº RACF «ü¥O¡G
|RDEFINE FACILITY BPX.FILEATTR.PROGCTL UACC(NONE) |PERMIT BPX.FILEATTR.PROGCTL CLASS(FACILITY) ID(SMORG) ACCESS(READ) |SETROPTS RACLIST(FACILITY) REFRESH
|Ãö©ó±ÂÅvªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\ OS/390 UNIX System Services Planning (SC28-1890)¡C
|±Ò°Ê¥N²z±`¾nµ{¦¡
|¦b±z§¹¦¨¬[ºc¨t²Î¤§«á¡A½Ð±Ò°Ê¥N²z±`¾nµ{¦¡¡G |
|vwd>/usr/lpp/DWC/logs/vwd.log 2>&1 &
||YnÅçÃÒ OS/390 ¥N²z±`¾nµ{¦¡¬O§_¦b°õ¦æ¤¤¡A½Ð¦b UNIX Shell ©R¥O¦æ¿é¤J¤U¦C«ü¥O¡G
|ps -e | grep vwd
|©ÎªÌ¡A¦b OS/390 ¥D±±¥x¿é¤J D OMVS,a=all ¡A¨Ã·j´M¦r¦ê vwd
|DB2 Warehouse Manager ¸ê®Æ¥]¥]¬A¤U¦C¨Ï¥ÎªÌ©w¸qµ{¦¡¡G |
|°£¦¹¤§¥~¡A±z¥i¥H¦b¡u¸ê®ÆÜÀx¤¤¤ß¡v«Ø¥ß¨Ï¥ÎªÌ©w¸qµ{¦¡¤ÎÀx¦sµ{§Ç¡COS/390 ¥N²zµ{¦¡¤ä´©¥ô¦ó¥i¦b UNIX ¨t²ÎªA°È¤U°õ¦æªº¥i°õ¦æÀÉ¡C
|¤@ӨϥΪ̩w¸qµ{¦¡·|«ü©wµ¹¤@өΦhÓ¨BÆJ¡C·í±z°õ¦æ¨Ï¥ÎªÌ©w¸qµ{¦¡®É¡A·|µo¥Í¤U¦C°Ê§@¡G |
|¬°¤F¦b OS/390 ¤W°õ¦æ ETI¡A±z¥²¶·¥ý±N FixPack 2 ®M¥Î¨ì DB2 Universal Database ª©¥» 7.1¡C
|¨Ï¥Î VWP_LOG Àô¹ÒÅܼƨөw¸q¤@ӥؿý¡A¨Ñ¨Ï¥ÎªÌ©w¸qªºµ{¦¡¼g¤J¿é¥X¡C
|¦pªG±z¨Ï¥Î¨Ï¥ÎªÌ©w¸qµ{¦¡¨Ó¥Î FTP ´£¥X¤u§@¡A |±z¥²¶·¥ý«Ø¥ßn´£¥Xªº JCL ¤Î¸ê®Æ¡C JCL ¤¤ªº¤u§@¦WºÙ¥²¶·¬O USERIDx¡A |¨ä¤¤ x ¬O¤@Ó³æ¤@¦r¤¸ªº¦r¥À©Î¼Æ¦r (½d¨Ò¡GMYUSERA)¡C¥]§t¦b JCL ¤¤ªº MSGCLASS ¤Î SYSOUT Àɮתº¿é¥XÃþ§O¥²¶·«ü©w JES-held ¿é¥XÃþ§O¡C
|¨î¡G©Ò´£¥X¤u§@ªº³Ì¤j LRECL ¬O 254 Ó¦r¤¸¡CJES ¥u·|±½´y JCL ªº«e 72 Ó¦r¤¸¡C
|Åܧó¡u¸ê®ÆÜÀx¤¤¤ß¡vFTP ¤ä´©ªº¼ÒªO
|¡u¸ê®ÆÜÀx¤¤¤ß¡v¦w¸Ë¤F¤@Ó JCL ¼ÒªO¡A¨Ñ¨Ï¥Î FTP Âà°eÀɮסC¦pªG±zp¹ºÅý OS/390 ¥N²zµ{¦¡¨Ï¥Î FTP «ü¥O GET ©Î PUT |±q¬Y OS/390 ¥D¹q¸£¶Ç°eÀɮרì¥t¤@Ó»·ºÝ¥D¹q¸£¡A±z»Ýn¬° OS/390 ¨t²ÎÅܧó JCL ¼ÒªO¤¤ªº±b¤á¸ê°T¡G |
|¡u¸ê®ÆÜÀx¤¤¤ß¡v¥]§t¦¹½d¨Ò JCL ¼ÒªO¡G
|//[USERID]A JOB , 'PUT/GET', |// 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=*
|¨ú¼Ëªí®æ©ÎÀɮתº¤º®e
|±z¥i¨Ï¥Î OS/390 ¥N²zµ{¦¡¨Ó¨ú¼Ë DB2 ªí®æ»P¯Â¤å¦rÀɪº¤º®e¡A |¤ñ¦p UNIX ¨t²ÎªA°ÈÀɮפΠOS/390 ì¥Í¯Â¤å¦rÀÉ¡C±z¤]¥i¨Ï¥Î OS/390 |¥N²zµ{¦¡¥H Classic Connect ¨ú¼Ë IMS ©Î VSAM Àɮתº¤º®e¡C¹ï©ó¯Â¤å¦rÀÉ¡A¥N²zµ{¦¡·|¹î¬ÝÀɮשw¸qªº¤º®e¤¤ªº°Ñ¼Æ¨Ó§P©wÀɮ׮榡¡C
|¨Ï¥ÎIJµoµ{¦¡¥i±q OS/390 ¥¥x±Æµ{ÜÀx¨BÆJ¡C |±z©Î¬O OS/390 ¤u§@±Æµ{µ{¦¡¥i¥H´£¥X¤@Ó·|IJµo¡u¸ê®ÆÜÀx¤¤¤ß¡v¨BÆJªº¤u§@¡C¦pªG¨BÆJ¶¶§Q§¹¦¨¡AJCL |¤¤ªºÄ²µo¨ç¦¡¨BÆJ·|¶Ç¦^¦^ÂнX 0¡C
|¦b OS/390 UNIX ¨t²ÎªA°È¤W¥²¶·¦w¸Ë JDK 1.1.8 ©Î§ó·sª©¥»¥H¨Ï¥ÎIJµoµ{¦¡¡CYn±Ò°ÊIJµo¨ç¦¡¡A |½Ð¥ý¦b°õ¦æÜÀx¦øªA¾¹ªº¾÷¾¹¤W±Ò°Ê XTServer¡C¦¹µ{§Ç¥i¨£©ó¸ê®ÆÜÀx¤¤¤ßºÞ²z¤â¥Uªº²Ä 5 ³¹¡A |¼ÐÃD¬°¡u±q¸ê®ÆÜÀx¤¤¤ß¤§¥~±Ò°Ê¨BÆJ¡v¡CXTServer ±Ò°Ê¤§«á¡A½Ð¦b OS/390 ¤W±Ò°Ê |XTClient¡C¤U¦C½d¨ÒÅã¥Ü±Ò°ÊIJµo¨ç¦¡ªº JCL ½d¨Ò¡C
|//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 |//
|°Ñ¼Æ (cd /usr/lpp/DWC/;) ªº²Ä¤@Ó³¡¤À±N¥Ø¿ýÅܧó¨ì¦w¸Ë OS/390 ¥N²zµ{¦¡ªº¦ì¸m¡C |°Ñ¼Æªº²Ä¤G³¡¥÷±Ò°Ê XTClient ¨Ã¶Ç»¼¤U¦C 8 ӰѼơG |
|²¤¶
|³o 12 ÓÂà´«µ{¦¡¬O Java Àx¦sµ{§Ç¡A´£¨Ñ¤@¨Ç°ò¥»ªº¸ê®ÆÂà´«¡C |¬°¤F°õ¦æ³o¨ÇÂà´«µ{¦¡¡A±z¥²¶·¥ý¦b DB2 ¤l¨t²Î¤W³]©w Java Àx¦sµ{§Ç¡C |Ãö©ó³o¨ÇÂà´«µ{¦¡ªº¨ä¥L¸ê°T¡A |½Ð°Ñ¾\ IBM DB2 Universal |Database Data Warehouse Center ºÞ²z¤â¥U ª©¥» 7¡ASC40-0496-00¡C
|IWH.CLEAN |IWH.PERIODTABLE |IWH.KEYTABLE |IWH.CHISQUARE |IWH.CORRELATION |IWH.STATISTICS |IWH.INVERTDATA |IWH.PIVOTDATA |IWH.REGRESSION |IWH.ANOVA |IWH.SUBTOTAL |IWH.MOVINGAVERAGE
|³]¸m¡uJava Àx¦sµ{§Ç¡v
|³o¨Ç«ü¥O¬O§¹¾ã«ü¥Üªººë²ª©¡A»¡©ú¦p¦ó³]©w |Java Àx¦sµ{§Ç¡A½Ð°Ñ¾\ Application Programming Guide and Reference for Java(TM)¡ASC26-9018 |
|ÜÀxÂà´«µ{¦¡ªº³]¸m¨BÆJ
|³o¨Ç«ü¥O¬O§¹¾ã«ü¥Üªººë²ª©¡A½Ð°Ñ¾\IBM DB2 Universal Database Data Warehouse |Center ºÞ²z¤â¥U ª©¥» 7¡ASC40-0496-00 |
|±ý§ó·s¡uÜÀx±±¨î¸ê®Æ®w¡v¡A½Ð¦b |DB2 Universal Database ©R¥O¦æ³B²z¾¹¤W¿é¤J¤U¦C SQL¡G
|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'
|·í±z³]©w Java Àx¦sµ{§Ç®É¡A±z¨Ï¥Î WLM ¨Óµ²¦X Java WLM ±Ò°Êµ{§Ç©M¤@Ó WLM Àô¹Ò¦WºÙ¡CÀô¹Ò¦WºÙ«ü©w©ó |CREATE PROCEDURE ³¯z¦¡ªº WLM ENVIRONMENT ¿ï¶µ¤¤¡C |DSNWLMJ ¬O¤º§t©ó¤WzÂà´«µ{¦¡©w¸q¤¤ªº WLM Àô¹Ò¦WºÙ¡C |±z¥i·s¼W DSNWLMJ ªº WLM ÃöÁp¦WºÙ¡A©Î±N¨C¤@ÓÂà´«µ{¦¡©w¸qªº |WLM ENVIRONMENT ¿ï¶µÅܧ󬰱z¤wµ²¦X¦Ü±Ò°Êµ{§Çªº¦WºÙ¡C
|ln -e IWHXFV7 xf.jll;
|²¾°£²Ä¤@Äæªº # ²Å¸¹¨Ó²¾°£¦¹¦æªºµù¸Ñ¡C
|#ln -e IWHXF xf.jll;
|Àx¦s±zªºÅܧó¡C
|Java Àx¦sµ{§Çªº¨î
|¤@ÓÀx¦sµ{§Çªº¼Ð°O¤¤ªº Java ª«¥ó¶È©ó DB2 for OS/390 ª©¥» 7 ¤¤¤~¤ä´©¡C¦]¦¹¡AÂà´«µ{¦¡¦b |DB2 for OS/390 ª©¥» 5 ©Î 6 ªº°Ñ¼Æ¤¤¤£¤ä´© NULL È¡C¦b³o¨Çª©¥»¤¤¡AY±z¶Ç»¼ NULL È¡A«h·|µø¬°¹s¨Ó³B²z¡C |ª©¥» 5 ©M 6 Âà´«µ{¦¡±N¹s°Ñ¼Æµø¬°ªÅ¦r¦ê¡C
|DB2 ¶È©ó DB2 for OS/390 ª©¥» 7 ¤¤¤ä´© COMMIT SQL ³¯z¦¡¡CINVERTDATA Àx¦sµ{§Ç¥i¦bÀx¦sµ{§Ç¤º±Ë±ó¨Ã««Øªí®æ¡F |¦]¦¹»Ýn commit ³¯z¦¡¡C |°ò©ó¦¹²z¥Ñ¡ADB2 for OS/390 ª©¥» 5 ©Îª©¥» 6 ¤£¤ä´© IWH.INVERTDATA¡C
|DB2 for OS/390 ¤£¤ä´© Java ¨Ï¥ÎªÌ©w¸qªº¨ç¼Æ¡A©Ò¥H |390 ¥¥x¤W¤£¤ä´© IWH.FORMATDATE¡C
|Java Àx¦sµ{§Çªº½d¨Ò±Ò°Êµ{§Ç
|(»¡©ú©ó¡uDB2 for OS/390 Application Programming Guide and Reference for Java¡v)¡G
|//DSNWLMJ PROC DB2SSN=DSN,NUMTCB=5,APPLENV=DSNWLMJ <-- WLM ENVIRONMENT value in |CREATE PROC |//******************************************************************* |//* 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 <--This has the transformers in it |// DD DSN=DSN.HPJSP.PDSE.JDBC,DISP=SHR <--HPJ DLLs from HPJ setup |// DD DSN=SYS1.PP.PDSELINK,DISP=SHR <--HPJ runtime libraries |// DD DSN=DSN710.SDSNEXIT,DISP=SHR |// DD DSN=DSN710.SDSNLOAD,DISP=SHR |// DD DSN=SYS1.SCEERUN,DISP=SHR |// DD DSN=DSN.PDSE,DISP=SHR <--HPJ setup info |//JAVAENV DD DSN=DSN.WLMENVJ.JSPENV,DISP=SHR <--Environment variables, see below |//CEEDUMP DD SYSOUT=A |//DSSPRINT DD SYSOUT=A |//JSPDEBUG DD SYSOUT=A |//SYSABEND DD SYSOUT=A |//SYSPRINT DD SYSOUT=A |
|½d¨ÒÀô¹ÒÅÜ¼Æ¸ê®Æ¶°
|(»¡©ú©ó¡uDB2 for OS/390 Application Programming Guide and Reference for Java¡v)¡G
|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)
|Âà´«µ{¦¡ªº°ê®a»y¨¥¤ä´©
|OS/390 ¥N²zµ{¦¡²£¥Íªº¤j³¡¥÷°T®§¬Ò¶Ç°e¦Ü NT ¥¥x¨Ó¸ÑĶ¡A |©Ò¥H¤j¦h¼Æ±¡ªp¤U¡A°T®§»y¨¥¨t®Ú¾Ú UDB for NT ¦p¦ó¦w¸Ë¦Ó©w¡C |Âà´«µ{¦¡¬O¨Ò¥~¡COS/390 ¥N²zµ{¦¡´£¨Ñ¤U¦C°T®§ÀɮרÑÂà´«µ{¦¡¨Ï¥Î¡G
|File name: For language: |Xf.properties_Fi_FI Finnish in Finland |Xf.properties_No_NO Norwegian in Norway |Xf.properties_Ru_RU Russian in Russia |Xf.properties_Zh_CN Chinese in China (People's Republic of China) |Xf.properties_Zh_TW Chinese in Taiwan |Xf.properties_Da_DK Danish in Denmark |Xf.properties_De_DE German in Germany |Xf.properties_En_US English in U.S. |Xf.properties_Es_ES Spanish in Spain |Xf.properties_Fr_FR French in France |Xf.properties_It_IT Italian in Italy |Xf.properties_Ja_JP Japanese in Japan |Xf.properties_Ko_KR Korean in Korea |Xf.properties_Pt_BR Portugese in Brazil |Xf.properties_Sv_SE Swedish in Sweden
|Y±zªºÂà´«µ{¦¡°T®§¤£¬O^¤å¡A½Ð¿ï¨ú¤Wz¨ä¤¤¤@ÓÀɮסA±N¨ä¤º®e½Æ»s¨ì Xf.properties¡C
|Yn¦s¨ú«D DB2 Universal Database ¨t¦Cªº¸ê®Æ®w¡AOS/390 ¥N²zµ{¦¡¨Ï¥Î DataJoiner¡C |DataJoiner ¥iÅý¥N²zµ{¦¡¨Ï¥Î³q±`ªº DRDA ¦ê¬y¡A |§Ï©»¥¦´N¬O UDB ¸ê®Æ®w¡C¦pªG ODBC n¨D³Q¾É¤Þ¨ì¤@Ó«D DB2 ¨t¦C¸ê®Æ®w¨Ó·½¡ADataJoiner |·|©I¥sªþ¥[¼h¦¸ªºµ{¦¡½X¨Ó¦s¨ú¥~³¡ªº¸ê®Æ®w¡C
|DataJoiner ¥i¥H¦s¨ú Oracle¡BSybase¡BInformix¡BMicrosoft SQL Server¡BTeradata |¤Î¥ô¦ó¨ä¥¦°õ¦æ¦b Windows NT¡BAIX ©Î Sun Solaris §@·~Àô¹Ò¤W¦³ ODBC ÅX°Êµ{¦¡ªº¸ê®Æ®w¡COS/390 ¥N²zµ{¦¡¥i¦s¨ú§@¬°¨Ó·½ªº DataJoiner¡A |¦ý§@¬°¥Ø¼Ð´N¤£¥i¥H¡CDataJoiner ¤£¤ä´©¤G¶¥¬qªº COMMIT¡C |ÁöµM DataJoiner ¦bª©¥» 2.1 ¤Î 2.1.1 ¤¤¤ä´© TCP/IP §@¬°À³¥Îµ{¦¡n¨D¾¹¡A |¦ý¥¦¨Ã¨S¦³À³¥Îµ{¦¡¦øªA¾¹¡C¦]¬° OS/390 ¥N²zµ{¦¡ |»ÝnÀ³¥Îµ{¦¡¦øªA¾¹¨Ó¨Ï¥Î TCP/IP¡A |½Ð§ï¥Î SNA ³s½u¨Ó±q OS/390 ¦s¨ú DataJoiner¡C
|¦b OS/390 ¤W¦s¨ú IMS ¤Î VSAM
|Classic Connect ¥iÓ§O±qÜÀx¥N²zµ{¦¡ÁʶR¤Î¦w¸Ë¡C |OS/390 ¥N²zµ{¦¡³z¹L Classic Connect ODBC ÅX°Êµ{¦¡¨Ó¦s¨ú IMS ¤Î VSAM¡CClassic Connect ¥iÅý±z³]¸m IMS ¤Î VSAM ¸ê®Æ¶°ªº DB2-like ©w¸q¡A |µM«á¨Ï¥Î ODBC ¨Ó¦s¨ú¥¦Ì¡C
|OS/390 ¥N²zµ{¦¡·|®Ú¾Ún¨D¬O§_¾É¤Þ¨ì Classic Connect ©Î DB2¡A |¨Ó¸ü¤J¥¿½Tªº ODBC ÅX°Êµ{¦¡¡C¦pªG±zn¦s¨ú DB2 ¨Ó·½¡A |¥N²zµ{¦¡·|¸ü¤J DB2 ODBC ÅX°Êµ{¦¡¡C¦pªG±z¥¿¦b¦s¨ú VSAM ©Î IMS ¨Ó·½¡A |¥N²zµ{¦¡·|¸ü¤J Classic Connect ODBC ÅX°Êµ{¦¡¡CµM«á´N·|³B²z¥N²zµ{¦¡n¨D¡C
|³]¸m Classic Connect ODBC ÅX°Êµ{¦¡»PÜÀx¦s¨ú
|Classic Connect ¥iÓ§O±q OS/390 ¥N²zµ{¦¡ÁʶR¤Î¦w¸Ë¡C |Classic Connect ¥i±N³æ¤@ÀɮשΤ@ÓÀɮתº¤@³¡¥÷µø¬°¤@©Î¦hÓÃöÁp¦¡ªí®æ¡C |±z¥²¶·¹ï¬M IMS ©M VSAM ¸ê®Æ¡A¤~¯àÅý Classic Connect ¦s¨ú¡C |±z¥i¤â°Ê¹ï¬M¸ê®Æ©Î¨Ï¥Î Microsoft Windows Classic Connect «DÃöÁp¦¡¸ê®Æ¹ï¬Mµ{¦¡¡C |
|½d¨Ò Classic Connect À³¥Îµ{¦¡¬[ºcÀÉ cxa.ini ¦b /usr/lpp/DWC/ ¥Ø¿ý¤¤¡A¥B¥¦·|¦b³oùؽƻsµ¹±z¡G
|* 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¤£»Ýn¥h§ó·s dsnaoini ÀɮסA |¦]¬° DB2 for OS/390 ¨S¦³ÅX°Êµ{¦¡ºÞ²zû¡CClassic Connect ªºÅX°Êµ{¦¡ºÞ²zû¤º«Ø¦b OS/390 ¥N²zµ{¦¡¤¤¡C
|±z¥²¶·±N APAR PQ44904 ¤Þ¥Î¦Ü OS/390 ¥N²zµ{¦¡¡A¥H«K¨Ï¥Î¥N²zµ{¦¡¨Ó°õ¦æ¤½¥Îµ{¦¡¡C
|DSNUTILS ¬O¤@Ó¦b WLM »P RRS Àô¹Ò¤¤°õ¦æªº DB2 for OS/390 Àx¦sµ{§Ç¡C±z¥i¥H¥Î¥¦¨Ó°õ¦æ¥ô¦óÂǥѨϥΪ̩w¸qÀx¦sµ{§Ç¤¶±©Ò¦w¸Ëªº DB2 |¤½¥Îµ{¦¡¡CDB2 for OS/390 LOAD¡BREORG ¤Î RUNSTATS ¤½¥Îµ{¦¡´£¨Ñ¤º®eªí¡A¨Ñ±z¥Î¨ÓÅܧ󤽥ε{¦¡¦p¦ó°õ¦æ¡C |±ýÅܧ󤽥ε{¦¡ªº¤º®e¡A½Ð¦b¤½¥Îµ{¦¡ªº¡u³B²z¼Ò«¬²£¥Í¾¹¡vµøµ¡¤W«ö¤@¤U¥kÁä¡A¦A«ö¤@¤U¤º®e¡C
|Warehouse Manager ¥ç´£¨Ñ DSNUTILS ªº¤¶±¡AÅý±z¦b |Warehouse Manager ¨BÆJ¤¤¥i¨Ö¤J DB2 ¤½¥Îµ{¦¡¡C
|Yn³]©w DSNUTILS Àx¦sµ{§Ç¡G
|
| BIND PLAN(DSNAOCLI) PKLIST(*.DSNAOCLI.*, *.DSNUTILS.*)
|¨Ï¥Î LOAD ¤½¥Îµ{¦¡¦b DB2 for OS/390 ªí®æ¤§¶¡½Æ»s¸ê®Æ
|°²³]±z·Qn±Nªí®æ¨ø¸ü¦Ü¤@ӯ¤å¦rÀɨӽƻsªí®æ¡AµM«á±N¯Â¤å¦rÀɸü¤J¦Ü¥t¤@Óªí®æ¡C
|±z³q±`¥²¶·¨ø¸ü¸ê®Æ¡A½s¿è¸ü¤J±±¨î³¯z¦¡¨Ó¨ø¸ü²£¥Íªº¸ê®Æ¡A
|µM«á¸ü¤J¸ê®Æ¡C³z¹LÜÀx¡A±z¥i«ü©w±zn«·s¸ü¤J¦Ü¤£¦Pªºªí®æ¡A
|¤£¥²¦b¨BÆJ¤§¶¡°±¤î©M¤â°Ê½s¿è±±¨î³¯z¦¡¡C
|°µªk¦p¤U¡G¨Ï¥Î Reorg/Generic ¤¶±¨Ó«Ø¥ß¤@Ó¨BÆJ¡A
|¨ä¤¤¨Ï¥Î UNLOAD ¤½¥Îµ{¦¡©Î REORG TABLESPACE ¤½¥Îµ{¦¡¨Ó¨ø¸ü¤@ÓÀɮסC³o¨âÓ¤½¥Îµ{¦¡·|²£¥Í¨âÓ¿é¥X¸ê®Æ¶°¡A
|¨ä¤¤¤@Ó§t¦³ªí®æ¸ê®Æ¡A¥t¤@Ó§t¦³¥i¿é¤J¦Ü LOAD ªº¤½¥Îµ{¦¡±±¨î³¯z¦¡¡C
|¦b¤½¥Îµ{¦¡©Ò²£¥Íªº±±¨î³¯z¦¡¤¤¡A
|INTO TABLE ªí®æ¦WºÙ¬O¤w¨ø¸üªºªí®æ¦WºÙ¡C¥H¤UÅã¥Ü±z¥i¦b Reorg Unload
|¨BÆJ¤¤¨Ï¥Îªº DSNUTILS °Ñ¼Æ½d¨Ò¡G
|
|ªí 33. Reorg Unload ¨BÆJªº¤º®e
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 |
|¨Ï¥Î Reorg/Generic DSNUTILS ¤¶±¨Ó«Ø¥ß¤@Ó¸ü¤J¨BÆJ¡C |DSNUTILS ¤½¥Îµ{¦¡³¯z¦¡°Ñ¼Æ³q±`«ü©w¤@Ó¤½¥Îµ{¦¡±±¨î³¯z¦¡¡C |ÜÀx¤½¥Îµ{¦¡¤¶±¥ç®e³\¤½¥Îµ{¦¡³¯z¦¡Äæ¦ì¤¤¥X²{ÀɦW¡C |±z¥i¨Ï¥ÎÃöÁä¦r FILE ¨Ó«ü©w¥]§t¦³®Ä±±¨î³¯z¦¡ªºÀɮסA ¥H¤Î¨Ï¥ÎÃöÁä¦r TABLE ¨Ó«ü©w±zn¸ü¤Jªºªí®æ¦WºÙ¡C |Yn¨Ï¥Î LOAD ¤½¥Îµ{¦¡¨Ó¨Ï¥Î¥ý«e½d¨Òªº¿é¥X¡A |½Ð¦b LOAD ¤º®e¤¤¤Þ¥Î¤U¦C°Ñ¼ÆÈ¡G
|
UTILITY_ID | LOADREORG |
RESTART | NO |
UTSTMT | :FILE:DBVW.DSNURELD.PNCHDSN:TABLE:[DBVW].INVENTORY |
UTILITY_NAME | LOAD |
RECDSN | DBVW.DSNURELD.RECDSN |
RECDEVT | SYSDA |
|³o¹ï©ó¬Û¦P©Î¤£¦P DB2 ¤l¨t²Î¤Wªº¥ô¦ó DB2 for OS/390 ¨Ó·½©M¥Ø¼Ðªí®æ¬Ò¦³¥Î¡C |±±¨î³¯z¦¡¯Â¤å¦rÀÉ¥i¥H¬O HFS ©Îì©l MVS ÀɮסC
|Y»Ý§ó¦h¦³Ãö OS/390 ¤W¥i¥Îªº DSNUTILS »P DB2 ¤½¥Îµ{¦¡ªº¸Ô²Ó¸ê°T¡A |½Ð°Ñ¾\ DB2 for OS/390 Utility Guide and Reference¡C
|±z¥i¥H¨Ï¥Î OS/390 ¥N²zµ{¦¡¨Ó±N Data Propagator §Û¼g¤Þ¥Î¨BÆJ¦Û°Ê¤Æ¡C§Û¼g»Ýn¦³¤@Ó¨Ó·½¸ê®Æ®w¡B¤@Ó±±¨î¸ê®Æ®w¡A¥H¤Î¤@Ó¥Ø¼Ð¸ê®Æ®w¡C³o¨Ç¥i¥H¬O¤£¦P©Î¬Û¦Pªº¸ê®Æ®w¡C |¤@ÓÂ^¨ú¤uŪ¨ú DB2 ¤é»x¨Ó§PÂ_¨Ó·½¸ê®Æ®w¤¤¤w·s¼W¡B§ó·s©ÎÅܧ󪺦C¡C |µM«á¡A¦¹¤u§@±NÅܧó¼g¤J¤@ÓÅܧó¸ê®Æªí¡C |µM«á·|°õ¦æ¤Þ¥Î¤u§@±NÅܧó®M¥Î¨ì¥Ø¼Ð¸ê®Æ®w¤¤¡C |DB2 Warehouse Manager ¥i«Ø¥ß§Û¼g¨BÆJ¥H¦Û°Ê¤Æ¤Þ¥Î¤u§@¡C¨Ï¥Î Warehouse Manager ©w¸qn°õ¦æªº¤Þ¥Î¤u§@Ãþ«¬¤Î°õ¦æªº®É¶¡¡C±z¥²¶·±N SASNLINK ÀÉ®×®w¶×¥X¨ì steplib Àô¹ÒÅܼơC
|·s¼W§Û¼g¤ä´©¨ì¡u¸ê®ÆÜÀx¤¤¤ß¡v¼ÒªO
|¡u¸ê®ÆÜÀx¤¤¤ß¡v¥]¬A¤F¤@Ó JCL ¼ÒªOµ¹§Û¼g¤ä´©¡C |¦pªG±zp¹ºn¨Ï¥Î³oÓ OS/390 ¥N²zµ{¦¡¨Ó°õ¦æ¤Þ¥Îµ{¦¡¡A |«h±z¥²¶·¬°±zªº OS/390 ¨t²ÎÅܧ󦹼ҪO¤¤ªº±b¤á¤Î¸ê®Æ¶°¸ê°T¡CYnÅܧó¼ÒªO¡G |
|¤U¦C½d¨ÒÅã¥Ü¡u¸ê®ÆÜÀx¤¤¤ß¡v¤¤ªº JCL ¼ÒªO¡G
|¤Þ¥Î JCL ¼ÒªO¡G
|//[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=* |// |
|³\¦h DB2 Warehouse Manager ¤¸¥ó (¤ñ¦p¦øªA¾¹¡B¤é»x¾¹¡B¥N²zµ{¦¡¤Î³¡¥÷¡u¸ê®ÆÜÀx¤¤¤ß¡v) |·|±N¤é»x¼g¤J¨ì¤é»x¥Ø¿ý («ü©w¦b VWS_LOGGING Àô¹ÒÅܼƤ¤)¡C¤é»xÀɬ°¯Â¤å¦r¡C
|±z¥i±q¡u¸ê®ÆÜÀx¤¤¤ß¡v±Ò°Ê¥N²zµ{¦¡¤é»x¡C |¦b¥ªµ¡®æ¤¤¡A¥H·Æ¹«¥kÁä«ö¤@¤UÜÀx¡A¦A«ö¤@¤U¤º®e¡C¦b¡u°lÂܼh¦¸¡v¼ÐÅÒ¤W¡A±N³]©wÈÅܧ󦨱znªº°lÂܼh¦¸¡C |¥N²zµ{¦¡°lÂܤ䴩¼h¦¸ 0-4¡G |
|·í°lÂܪº³]©w°ª©ó¼h¦¸ 1¡A®Ä¯à±N·|¸ûºC¡C¥u¦³°£¿ù®É¤~À³¶}±Ò°lÂÜ¡C°lÂܸê°T·|Àx¦s¦b AGNTxxx.LOG Àɮפ¤¡AÀô¹Ò¸ê°T·|Àx¦s¦b |AGNTxxx.SET Àɮפ¤¡C