¸ê®Æ­ÜÀx¤¤¤ßºÞ²z¤â¥U

³]©w DB2 for AS/400 ­ÜÀx

±z¥i¥H¨Ï¥Î DB2 Connect ©Î Client Access/400 (CA/400) ¨Ó¦s¨ú DB2 for AS/400­ÜÀx¡C

¨Ï¥Î DB2 Connect

­Y­n¥H DB2 Connect ³]©w DB2 for AS/400 ­ÜÀxªº¦s¨ú§@·~¡G

  1. ÅçÃÒ¹h¹D¦øªA¾¹¤w¦w¸Ë¦n¥²³Æ²£«~¡C
  2. ©w¸q¦s¨ú­ÜÀxªº±M¥ÎÅv¡C
  3. ³]©w DB2 Connect ¹h¹DºÝ¡C
  4. «Ø¥ß»P¨ì­ÜÀxªº³s±µ¡C

¥²³Æ²£«~

¦pªG±z­n±q DB2 for AS/400 ­ÜÀx¦s¨ú¸ê®Æ¡A±z»Ý­n¦³¤@­Ó¹h¹DºÝ¡C½Ð¦w¸Ë DB2 Connect ¨Ó°t¸m DRDA ªº¹h¹DºÝ¡C

¦pªG»Ý­n DRDA ªº¸Ô²Ó¸ê°T¡A½Ð°Ñ¾\ Distributed Relational Database Architecture Connectivity Guide¡C

¦pªG»Ý­n DB2 Connect ªº¬ÛÃö¸ê°T¡A½Ð°Ñ¾\¤U¦C®ÑÄy¡G

©w¸q DB2 for AS/400 ­ÜÀxªº±M¥ÎÅv

¥Ø¼Ð¨t²Îªº¨t²ÎºÞ²zªÌ¥²¶·³]©w¤@­Ó¨Ï¥ÎªÌ ID¡AÅý¥¦¦b NULLID ¶°¦X¤W¡A¾Ö¦³ CHANGE ©Î¥H¤WªºÅv­­¡C

¦¹¥~¡A¹ï¤U¦C¨t²Îªí®æ»Ý­n¦³©ú½Tªº SELECT ±M¥ÎÅv¡G

¨Ï¥ÎªÌ ID ¤]»Ý¦³ ALLOBJ ±M¥ÎÅv¡A¤~¯à«Ø¥ß AS/400 ¶°¦X¡C

³]©w DB2 Connect ¹h¹DºÝ

©w¸q¥²­nªº±M¥ÎÅv¤§«á¡A½Ð¦b¹h¹DºÝ°õ¦æ¤U¦C§@·~¡G

  1. ¦w¸Ë DB2 Connect¡C
  2. °t¸m DB2 Connect ¨t²Î¡A¥H«K©M¥Ø¼Ð¸ê®Æ®w³q«H¡C
  3. §ó·s DB2 ¸`ÂI¥Ø¿ý¡B¨t²Î¸ê®Æ®w¥Ø¿ý¥H¤Î DCS ¥Ø¿ý¡C

«Ø¥ß»P DB2 for AS/400 ­ÜÀxªº³s±µ

½Ð¦b¥N²zµ{¦¡ºÝ°õ¦æ¤U¦C§@·~¡G

  1. ³]©w»P DB2 Connect ºÝªº³q«H¡C
  2. ½s¿ý DB2 Connect ºÝªº¸`ÂI¡C
  3. ½s¿ý¸ê®Æ®w¡C
  4. ¨Ï¥Î¡uODBC ºÞ²z­û¡v¡A±N¸ê®Æ®wµn°O¬°¡u¨t²Î DSN¡v¡C
  5. ½Ð¨Ì·Ó DB2 Connect User's Guideªº»¡©ú¡A±N DB2 Connect ¤½¥Îµ{¦¡³s±µ¨ì DRDA ¦øªA¾¹¡ ¨C¤@ºØÃþ«¬ªº±qÄݯ¸¡A¥u¶·°õ¦æ¤@¦¸³sµ²§@·~¡C

¨Ï¥Î CA/400

­Y­n³]©w CA/400 ¨Ó¦s¨ú DB2 for AS/400 ¸ê®Æ®w¡G

  1. ¦b AS/400 ¤W¦w¸Ë³Ì·sªº Client Access PTF¡C

    ­Y­n¬d¾\³Ì·s APAR ¸ê°Tªº§¹¾ã²M³æ¡A¥HÀò±o±z AS/400 »Ý­nªº PTF Ãþ«¬¸ê°T¡A½Ð³X°Ý¤U¦Cºô­¶¡G

    http://www.as400.ibm.com/clientaccess/
    
  2. ¦b¤ä´©¸ê°T¤U¤è¡A¿ï¨ú Service Packs¡C

    ¦b¡u±qÄݯ¸¦s¨ú Service Packs¡vºô­¶¤¤¡A±z¥i¥H§ä¨ì¦³Ãö³Ì·s¤u§@¯¸ Service Packs ¤Î¥D¹q¸£ PTF ªº¸ê°T¡C

    ­Y­nÀˬd±zªº§@·~¨t²Îªº¥Ø«e¼h¦¸¡G

    1. Áä¤J¤U¦C«ü¥O¡G
      GO LICPGM
      
    2. ¿ï¨ú¡u¿ï¶µ 10¡v¡C
    3. «ö F11¡C
  3. ½T©w¤w³]©w AS/400 QUSER ³q¦æ½X (¥¼¹L´Á)¡C¦pªG¥²­n¡A±z¥i¥H³]©w¤£¨Ï¥Î³q¦æ½X¡C
  4. ¦b WINNT\SYSTEM32\DRIVERS\ETC\HOSTS Àɮפ¤¿é¤J AS/400 ¨t²Î©M Windows NT ¤u§@¯¸ªº TCP/IP ¥D¹q¸£¦WºÙ¡C¨Ò¦p¡G
    9.123.456.7   demo400
    9.123.456.8   mypc
    
  5. ¦b Windows NT ¤u§@¯¸¤W¦w¸Ë CA/400¡C
  6. ÅçÃÒ AS/400 ¨t²Î¤Wªº©Ò¦³¦øªA¾¹¬O§_³£¤w¦b°õ¦æ¡C½Ð¦b Windows NT ¤u§@¯¸ªº DOS «ü¥O´£¥Ü¤U¡A¿é¤J¤U¦C«ü¥O¡G
    cwbping hostname ip
    

    ±z±N±µ¦¬¨ì¦p¤Uªº¦^À³¡G

    C:\>cwbping demo400 ip
    IBM AS/400 Client Access for Windows 95/NT
    Version 3  Release 1  Level 2
    (C) Copyright IBM Corporation and Others 1984, 1995.
    All rights reserved.
    U.S. Government Users Restricted Rights - Use, duplication or
    disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
    Licensed Materials - Property of IBM
    [9.180.160.17]
    pinging server Port Mapper successful
    pinging server as-central successful
    pinging server as-database successful
    pinging server as-dtaq successful
    pinging server as-file successful
    pinging server as-netprt successful
    pinging server as-rmtcmd successful
    pinging server as-signon successful
    

    ¦pªG¦øªA¾¹©|¥¼±Ò°Ê¡A½Ð¦b AS/400 ¨t²Î¤W¿é¤J¤U¦C«ü¥O¨Ó±Ò°Ê¦øªA¾¹¡G

    STRHOSTSVR SERVER (*ALL)
    
  7. ÅçÃÒ AS/400 ¬O§_¦³©w¸q¦nªº DB2 ¸ê®Æ®w¦WºÙ¡C±z¥i¥H¦b AS/400 ¤Wµo¥X¡u¨Ï¥ÎÃöÁp¦¡¸ê®Æ®w¥Ø¿ýµn¿ý (WRKRDBDIRE)¡v«ü¥O¨ÓÀˬd¦¹¶µ¥Ø¡C

    ¦pªG AS/400 ¨S¦³ DB2 ¸ê®Æ®w¦WºÙ¡A·í±z¸Õ¹Ï¦s¨ú¸ê®Æ®w®É¡A·|¥X²{ SQL0114 ¿ù»~¡C

  8. ¦b Windows NT ¨t²ÎÅÜ¼Æ (¤£¬O¨Ï¥ÎªÌÅܼÆ) ¤¤¡A±N DB2CODEPAGE Àô¹ÒÅܼƳ]¦¨ 850¡C
  9. ±q Web ºô¯¸¤U¸ü³Ì·sªº CA/400 Service Pack ©M CWBCFG ¤½¥Îµ{¦¡¡C±z¥i¥H±q¤U¦C Web ºô­¶¤¤¡A¨ú±o¦p¦ó¤U¸ü SP45545 ©M cwbcfg.exe ªº§¹¾ã©ú²Ó¡G
    http://www.as400.ibm.com/clientaccess/service.htm
    
  10. ¤Þ¥Î³o­Ó Service Pack¡A¨Ã°õ¦æ CWBCFG ¤½¥Îµ{¦¡¡AÅý CA/400 ³Q·í§@ Windows NT ¤Wªº¨t²Î§@·~¨Ó°õ¦æ¡C

    ¦pªG±z¥¼¤Þ¥Î Service Pack SP45545 ¥B¥¼°õ¦æ CWBCFG ¤½¥Îµ{¦¡¡A«hµe­±¤¤·|¥X²{¤U¦C¿ù»~°T®§¡G

    "IBM.[Client Access ODBC Driver (32 bit)][DB2/400 SQL] Communications  
    failure. COMM RC=0x3" 
    CAUSE: according to the Rochester lab. the CA/400 connection    
    was registered under the "current user" (HKEY_CURRENT_USERS) but    
    should be under HKEY_USERS (.Default). 
    SOLUTION: you need to register the connection in the correct register,
    using the stand-alone utility cwbcfg.exe, which can be used to
    configure a session for the HKEY_USERS.Default user.
    The correct syntax for cwbcfg is:
    cwbcfg  /host HOSTNAME /s
    where HOSTNAME is the AS/400 name in your HOSTS file, (see step 3).
    NOTE: the "/s" option is important.  After this command you can verify
    that the NT registry is set up by running regedt32 and browse
    HKEY_USERS (.Default)
    
  11. ¨Ï¥Î CA/400 ODBC ÅX°Êµ{¦¡¡A±N AS/400 ¸ê®Æ®wµn°O¬°¨t²Î DSN¡C¦A¨Ì·Ó»Ý­n¡A·s¼W¨ä¥¦ÀÉ®×®w¡A¨Ò¦p¡ADORMERK¡BQGPL¡BMYLIBRARY
  12. ¥Î Lotus Approach(R) ©Î Microsoft Query ¨Ó´ú¸Õ»P AS/400 ¸ê®Æ®wªº³s±µ¡C

    ¦pªG¥X²{ CA/400 ¿ù»~¡A±z¥i¥H«ö¤@¤U¸Ñ»¡¡A¨ú±o¿ù»~ªº¸Ô²Ó»¡©ú¡C


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