ª©¦¸ª`·N¨Æ¶µ


|42.27 OS/390 ¥N²zµ{¦¡

|³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 |

|42.27.1 ¦w¸Ë·§Æ[

|³o¨Ç¨BÆJ·§­n»¡©ú¦w¸Ëµ{§Ç¡C¦b¡u¦w¸Ë©ú²Ó¡v¤@¸`¤¤´£¨Ñ¤F¦³Ãö³o¨Ç¨BÆJªº§ó¦h¸ê°T¡C

|

  1. |±q DB2 Universal Database for OS/390 ºÏ±a¦w¸Ë OS/390 ¥N²zµ{¦¡¡C
  2. |§ó·s±z³]©wÀɤ¤ªºÀô¹ÒÅܼơC
  3. |³]©w³s½u¡G
  4. |¥»ºÝ³sµ² CLI¡A³sµ²¨ì¥ô¦ó»·ºÝ¸ê®Æ®w¡C
  5. |³]¸m±zªº ODBC °_©l³]©wÀɮסC
  6. |³]¸m±ÂÅv¡A«h¨Ï¥ÎªÌ¡G |
  7. |±Ò°Ê¥N²z±`¾nµ{¦¡¡C |

|42.27.2 ¦w¸Ë©ú²Ó

|¦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

|­Y­n³]©w®Ö¤ß¤Î±`¾nµ{¦¡³s½u¡A½Ð±N¤U­±³o¦æ¥[¤J /etc/services ÀɮשΠTCPIP.ETC.SERVICES ÀɮסG

|vwkernal 11000/tcp
|vwd 11001/tcp
|vwlogger 11002/tcp

|­Y­n¦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ªºÀɮסC­Y­n½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

|­Y­n¨Ï¥Î¦³ +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 |

  1. |Telnet ¨ì OS/390 ¤Wªº UNIX Systems Services¡A³z¹L OS/390 host ¤Î USS °ð¡C
  2. |±Ò°Ê¥N²z±`¾nµ{¦¡¡G | |

|­Y­nÅçÃÒ 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

|42.27.3 ³]¸mÃB¥~ªº¥N²zµ{¦¡¨ç¼Æ

|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±z­p¹ºÅý 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 |

  1. |¥H¤@­Ó¦³Åv­­¦b /usr/lpp/DWC ¥Ø¿ý¤¤½Æ»s¤Î§ó·sÀɮתº ID µn¤J¡C
  2. |´M§ä ftp.jcl¡A¨Ã¥Î·sªºÀɦW systemname.ftp.jcl ½Æ»sÀɮסA |¨ä¤¤ systemname ¬O OS/390 ¨t²Îªº¦WºÙ¡C
  3. |«Ø¥ß¦¹Àɮתº°Æ¥»µ¹¨C¤@­Ó±z­n¦b¨ä¤W°õ¦æÂà´«µ{¦¡ vwpmvs |©Î ETI extract ªº OS/390 ¨t²Î¡C¨Ò¦p¡A |¦pªG±z­n¦b STLMVS1 ¤W°õ¦æ¥ô¤@­Óµ{¦¡¡A |«Ø¥ß¤@­Ó¦WºÙ¬° STLMVS1.ftp.jcl ªºÀÉ®×°Æ¥»¡C
  4. |¨Ï¥Î¤å¦r½s¿èµ{¦¡¨Ó¦Û­q JCL¡A¥H²Å¦X±z¯¸¥xªº»Ý¨D¡C |Åܧó±b¤á¸ê°T¥H²Å¦X±zªº MVS ¨t²Îªº¼Ð·Ç±b¤á¸ê°T¡C½Ð¤ÅÅܧó¥ô¦ó¤è¬A©· ([) ¤ºªº°Ñ¼Æ¡A |¤ñ¦p [USERID] ¤Î [FTPFILE]¡C(¤è¬A©·¤À§O¬°¤Q¤»¶i¦ì¦r¤¸ x'AD' ¤Î x'BD'¡C­Y±zªº TSO ²×ºÝ¾÷Ãþ«¬¦b SPF ¿ï¶µ 0 ¤¤¥¼³]¦¨ |3278A¡A³o¨Ç­È¥i¯à·|Åã¥Ü¦¨¯S®í¦r¤¸¡A¦Ó¤£¬O¤è¬A©·¡C |³o¨Ã¤£·|¬O°ÝÃD¡A |¦pªG±z¨S¦³Åܧó x'AD' ©Î x'BD'¡A©ÎªÌ¥ô¦ó¦r¤¸¤§¶¡ªº¸ê®Æ¡C)
  5. |§ó·sÀô¹ÒÅÜ¼Æ VWS_TEMPLATES¡A«ü¦V½Æ»sªº¼ÒªOÀɮתº¥Ø¿ý¡C |

|¡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

|42.27.4 ¥ÎIJµoµ{¦¡±Æµ{­ÜÀx¨BÆJ (XTClient)

|¨Ï¥Î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µ{¦¡¡C­Y­n±Ò°Ê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
|// 
|µù:
¤W­z½d¨Ò JCL ½XÅã¥Ü¦p¦óÄ~Äò°Ñ¼Æ¨ì¤U¤@¦æ¡C¤èªk¬OÁä¤J°Ñ¼Æ¡A¤@ª½¨ì²Ä 71 ­Óª½Äæ¡A¦b²Ä 72 ­Óª½Äæ©ñ¤@­Ó 'X'¡A |µM«á¦b¤U¤@¦æªº²Ä 16 ­Óª½ÄæÄ~Äò¡C |

|°Ñ¼Æ (cd /usr/lpp/DWC/;) ªº²Ä¤@­Ó³¡¤À±N¥Ø¿ýÅܧó¨ì¦w¸Ë OS/390 ¥N²zµ{¦¡ªº¦ì¸m¡C |°Ñ¼Æªº²Ä¤G³¡¥÷±Ò°Ê XTClient ¨Ã¶Ç»¼¤U¦C 8 ­Ó°Ñ¼Æ¡G |

|42.27.5 Âà´«µ{¦¡

|²¤¶

|³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 |

  1. |¦b DB2 ¤l¨t²Î¤W¤Þ¥Î PTFs UQ46170 ©M UQ46114¡C
  2. |¦b OS/390 ¨t²Î¤W¦w¸Ë Visual Age for Java 2.0 ©Î¥H¤Wª©¥»¡C
  3. |¦b DB2 ¤W¦w¸Ë JDBC¡A±N JDBC ®M¥ó³sµ²¦Ü DB2 ¤l¨t²Î¡C
  4. |¦b DB2 ¤l¨t²Î¤W³]©w RRS ©M DB2 WLM Àx¦sµ{§Ç¡C
  5. |³]©w±z DB2 ªº Java Àx¦sµ{§Ç¡C¥]¬A¬° Java Àx¦sµ{§Ç¦ì§}ªÅ¶¡«Ø¥ß¤@­Ó Java WLM ±Ò°Êµ{§Ç¡C
  6. |¦b WLM ¤§¤U¡A±z¥²¶·±N Java WLM ±Ò°Êµ{§Çµ²¦X¤@­Ó WLM Àô¹Ò¦WºÙ¡C½Ð¨Ï¥Î WLM À³¥Îµ{¦¡Àô¹Òµe­±¡u«Ø¥ßÀ³¥Îµ{¦¡Àô¹Ò¡v¨Óµ²¦XÀô¹Ò¦WºÙ©M JCL µ{§Ç¡C
  7. |¦b CREATE PROCEDURE ©Î ALTER PROCEDURE ªº WLM_ENVIRONMENT ¿ï¶µ¤W«ü©w WLM À³¥Îµ{¦¡Àô¹Ò¦WºÙ¡A±NÀx¦sµ{§Ç©Î¨Ï¥ÎªÌ©w¸qªº¨ç¼Æµ²¦X¤@­ÓÀ³¥Îµ{¦¡Àô¹Ò¡C
  8. |½T©w±zªº DB2 ±Ò°Ê§@·~ªº¾Ö¦³ªÌ¨ã³Æ¦s¨úÅv¨Ó¦s¨ú Java WLM ±Ò°Êµ{§Ç¤¤ªºÀÉ®×®w¡C |

|­ÜÀxÂà´«µ{¦¡ªº³]¸m¨BÆJ

|³o¨Ç«ü¥O¬O§¹¾ã«ü¥Üªººë²ª©¡A½Ð°Ñ¾\IBM DB2 Universal Database Data Warehouse |Center ºÞ²z¤â¥U ª©¥» 7¡ASC40-0496-00 |

  1. |±N Fixpack 3 ¤Þ¥Î¦Ü DB2 Universal Database for NT ª©¥» 7¡A |©Î±N¡u­ÜÀx±±¨î¸ê®Æ®w¡v§ó·s¦¨ TRANSREGISTERED = 1 ©M TRANSFENCED=1¡C

    |±ý§ó·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'
  2. |©w¸qÂà´«µ{¦¡¨ì DB2 |

    |·í±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©ó¤W­zÂà´«µ{¦¡©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

  3. |±q UNIX ¨t²ÎªA°È³]©wÃìµ²¨Ó³sµ² |IWH710.SIWHLOAD ¤¤ªºÂà´«µ{¦¡¸ü¤J¼Ò²Õ¡C |
  4. |³z¹L APF ±ÂÅv IWH710.SIWHPDSE¡AµM«á·s¼W¦Ü DB2 Java Àx¦sµ{§Ç±Ò°Êµ{§Çªº STEPLIB ³s±µ¡C
  5. |±N±zªº xf.jll Ãìµ²©Ò¦bªº¥Ø¿ý (¹w³]­È¡G/usr/lpp/DWC) ·s¼W¦Ü WLM Àô¹Ò¸ê®Æ¶°¤¤ªº CLASSPATH ©M LIBPATH Àô¹ÒÅܼơC |
  6. |±Ò°ÊÀx¦sµ{§Ç¡AµM«á«Ø¥ß¨Ã°õ¦æ­ÜÀx¨BÆJ¡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¨Çª©¥»¤¤¡A­Y±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½Ð¿ï¨ú¤W­z¨ä¤¤¤@­ÓÀɮסA±N¨ä¤º®e½Æ»s¨ì Xf.properties¡C

|42.27.6 ¦s¨ú DB2 ¨t¦C¤§¥~ªº¸ê®Æ®w

|­Y­n¦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±z­n¦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 |

  1. |¦b OS/390 ¤W¦w¸Ë Classic Connect Data Server¡C
  2. |¿ï¥Î©Ê¡G¦b NT ¤W¦w¸Ë Classic Connect Data Mapper ²£«~¡C
  3. |©w¸q Classic Connect ªºÅÞ¿èªí©w¸q¡AÅý Classic Connect |¥i¨ÌÃö«Y¨Ó¦s¨ú¸ê®Æ¡C±z¥i¨Ï¥Î¸ê®Æ¹ï¬Mµ{¦¡¨Ó«Ø¥ß IMS ©M VSAM µ²ºcªº©w¸q¡A©Î¤â°Ê«Ø¥ß©w¸q¡C
  4. |¦b±z³]©w Classic Connect ¤§«á¡A±z¥i³]©w¹ï©ó­ÜÀxªº¦s¨úÅv­­¡G |
    1. |«Ø¥ß¤@­Ó Classic Connect .ini Àɮס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
    2. |§ó·s .ini Àɤ¤ªº DATASOURCE ¦æ¡C³o¤@¦æ¥]§t¤@­Ó¸ê®Æ¨Ó·½¦WºÙ¤Î¤@­Ó³q«H¨ó©w¦ì§}¡C ¸ê®Æ¨Ó·½¦WºÙ¥²¶·»P Classic Connect |¸ê®Æ¦øªA¾¹¤W©w¸qªº Query Processor ¦WºÙ¬Û¹ïÀ³¡A |¦ì¸m¦b¸ê®Æ¦øªA¾¹ªº°t¸mÀɤ¤ªº QUERY PROCESSOR SERVICE INFO ENTRY¡C³q«H¨ó©w¦ì§}¥i¦b¦P¤@­ÓÀɮפ¤ªº TCP/IP SERVICE INFO µn¿ý§ä¨ì¡C³o­ÓÀɮ׸̪º USERID ¤Î USERPASSWORD |·|¦b©w¸q­ÜÀx¸ê®Æ¨Ó·½®É¥Î¨ì¡C
    3. |¶×¥X CXA_CONFIG Àô¹ÒÅܼƨì Classic Connect µ{¦¡ÀÉ¡A |¥¦­Ì³q±`»P .ini Àɮצì¦b¬Û¦Pªº¥Ø¿ý¡C
    4. |§ó·s LIBPATH Àô¹ÒÅܼơA±N¸ô®|¥[¨ì Classic Connect µ{¦¡ÀÉ¡A |³q±`©M .ini Àɮצb¬Û¦Pªº¥Ø¿ý¤¤¡C
    5. |¿ï¥Î©Ê¡G¨Ï¥Î´ú¸Õµ{¦¡ cxasamp ¨ÓÅçÃÒ¦w¸Ë¡G¦b±zªº.ini ÀɮשҦbªº¥Ø¿ý¤¤¿é¤J cxasamp¡C |location/uid/pwd ¬O©w¸q©ó .ini Àɮפ¤ªº |data source name/userid/userpassword¡C
    6. |©w¸q¸ê®Æ¨Ó·½¨ì­ÜÀx¡A´N¦p¦P±z©w¸q¥ô¦ó DB2 ¸ê®Æ¨Ó·½¡C |
    |

|±z¤£»Ý­n¥h§ó·s dsnaoini ÀɮסA |¦]¬° DB2 for OS/390 ¨S¦³ÅX°Êµ{¦¡ºÞ²z­û¡CClassic Connect ªºÅX°Êµ{¦¡ºÞ²z­û¤º«Ø¦b OS/390 ¥N²zµ{¦¡¤¤¡C

|42.27.7 °õ¦æ DB2 for OS/390 ¤½¥Îµ{¦¡

|±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

|­Y­n³]©w DSNUTILS Àx¦sµ{§Ç¡G

|

  1. |·í¦w¸Ë DB2 ®É¡A°õ¦æ DSNTIJSG ¤u§@¨Ó³]©w©M³sµ² DSNUTILS |Àx¦sµ{§Ç¡C½Ð½T©w DSNUTILS ªº©w¸q¦³ PARAMETER STYLE GENERAL¡C
  2. |±Ò¥Î WLM ºÞ²zªºÀx¦sµ{§Ç¡C
  3. |³]©w RRS ¤Î WLM Àô¹Ò¡C
  4. |°õ¦æ DB2 ´£¨Ñªº½d¨Ò§å¦¸ DSNUTILS µ{¦¡¡C(¦¹¨BÆJ«D¥²­n¡A¦ý«ØÄ³°õ¦æ¡C)
  5. |±N DSNUTILS ³W¹º»P DSNCLI ³W¹º§@³sµ²¡A¦p¦¹ CLI ´N¥i¥H©I¥sÀx¦sµ{§Ç¡G
    |		BIND PLAN(DSNAOCLI) PKLIST(*.DSNAOCLI.*, *.DSNUTILS.*)
  6. |¨Ï¥Î Warehouse Manager ³]©w¨BÆJ¨Ã°õ¦æ¸Ó¨BÆJ¡C¥ÀÅéÃþ«¬À³¸Ó¬O APPEND¡C­Y¤£¬O¡A«h°õ¦æ¤½¥Îµ{¦¡¤§«e¡AWarehouse Manager ·|§R°£ªí®æ¤¤ªº©Ò¦³¶µ¥Ø¡C |

|¨Ï¥Î LOAD ¤½¥Îµ{¦¡¦b DB2 for OS/390 ªí®æ¤§¶¡½Æ»s¸ê®Æ

|°²³]±z·Q­n±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±z­n­«·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±z­n¸ü¤Jªºªí®æ¦WºÙ¡C |­Y­n¨Ï¥Î LOAD ¤½¥Îµ{¦¡¨Ó¨Ï¥Î¥ý«e½d¨Òªº¿é¥X¡A |½Ð¦b LOAD ¤º®e¤¤¤Þ¥Î¤U¦C°Ñ¼Æ­È¡G

|µù:
¦b UTSTMT Äæ¦ì¤¤¡AÁä¤J¤@­Ó¸ü¤J³¯­z¦¡¡A©ÎÁä¤J REORG ¤½¥Îµ{¦¡©M |UNLOAD EXTERNAL ¿ï¶µ©Ò¿é¥XªºÀɮצWºÙ¡C |


|

|ªí 34. LOAD ¨BÆJ¤º®e
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

|42.27.8 §Û¼g

|±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¸q­n°õ¦æªº¤Þ¥Î¤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±z­p¹º­n¨Ï¥Î³o­Ó OS/390 ¥N²zµ{¦¡¨Ó°õ¦æ¤Þ¥Îµ{¦¡¡A |«h±z¥²¶·¬°±zªº OS/390 ¨t²ÎÅܧ󦹼ҪO¤¤ªº±b¤á¤Î¸ê®Æ¶°¸ê°T¡C­Y­nÅܧó¼ÒªO¡G |

  1. |¥H¤@­Ó¦³Åv­­¦b /usr/lpp/DWC/ ¥Ø¿ý¤¤½Æ»s¤Î§ó·sÀɮתº ID µn¤J¡C
  2. |´M§ä apply.jcl¡A¨Ã±N¦¹ÀÉ®×¥t¦s¬° systemname.apply.jcl¡A |¨ä¤¤ systemname ¬O MVS ¨t²Îªº¦WºÙ¡C |¨Ò¦p¡A¦pªG¦b STLMVS1 ¤W¡A«Ø¥ßªºÀÉ®×°Æ¥»¦W¬° STLMVS1.apply.jcl¡C
  3. |¨Ï¥Î¤å¦r½s¿èµ{¦¡¨Ó¦Û­q JCL¡A¥H²Å¦X±z¯¸¥xªº»Ý¨D¡C |Åܧó±b¤á¸ê°T¥H²Å¦X±zªº MVS ¨t²Îªº¼Ð·Ç±b¤á¸ê°T¡A |¨ÃÅܧó STEPLIB DD ªº¸ê®Æ¶°¤Î MSGS DD¡C
  4. |¦pªG»Ý­n¡AÅܧó EXEC ¥d¤Wªºµ{¦¡¦WºÙ¡C ­Y»ÝÅܧóµ{¦¡¦WºÙªº¸Ô²Ó¸ê°T¡A |½Ð°Ñ¾\ DB2 «ü«n»P°Ñ¦Ò¤â¥U¡C½Ð¤ÅÅܧó¥ô¦ó¤è¬A©·([) ¤ºªº°Ñ¼Æ¡A |¤ñ¦p [USERID] ¤Î [APPLY_PARMS]¡C(¤è¬A©·¤À§O¬°¤Q¤»¶i¦ì¦r¤¸ x'AD' ¤Î x'BD'¡C­Y±zªº TSO ²×ºÝ¾÷Ãþ«¬¦b SPF ¿ï¶µ 0 |¤¤¥¼³]¦¨ 3278A¡A³o¨Ç­È¥i¯à·|Åã¥Ü¦¨¯S®í¦r¤¸¡A¦Ó¤£¬O¤è¬A©·¡C³o¨Ã¤£·|¬O°ÝÃD¡A |¦pªG±z¨S¦³Åܧó x'AD' ©Î x'BD'¡A©ÎªÌ¥ô¦ó¦r¤¸¤§¶¡ªº¸ê®Æ¡C)
  5. |§ó·sÀô¹ÒÅÜ¼Æ VWS_TEMPLATES¡A«ü¦V½Æ»sªº¼ÒªOÀɮתº¥Ø¿ý¡C |

|¤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=*
|//
| 

|42.27.9 ¥N²zµ{¦¡°O¸ü

|³\¦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­ÈÅܧ󦨱z­nªº°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


[ ­¶­±³»ºÝ | «e¤@­¶ | ¤U¤@­¶ | ¥Ø¿ý | ¯Á¤Þ ]