±z¥i¥H¨Ï¥Î DB2 Connect ©Î Client Access/400 (CA/400) ¨Ó¦s¨ú DB2 for AS/400ÜÀx¡C
Yn¥H DB2 Connect ³]©w DB2 for AS/400 ÜÀxªº¦s¨ú§@·~¡G
¦pªG±zn±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
¥Ø¼Ð¨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¸q¥²nªº±M¥ÎÅv¤§«á¡A½Ð¦b¹h¹DºÝ°õ¦æ¤U¦C§@·~¡G
½Ð¦b¥N²zµ{¦¡ºÝ°õ¦æ¤U¦C§@·~¡G
Yn³]©w CA/400 ¨Ó¦s¨ú DB2 for AS/400 ¸ê®Æ®w¡G
Yn¬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/
¦b¡u±qÄݯ¸¦s¨ú Service Packs¡vºô¶¤¤¡A±z¥i¥H§ä¨ì¦³Ãö³Ì·s¤u§@¯¸ Service Packs ¤Î¥D¹q¸£ PTF ªº¸ê°T¡C
YnÀˬd±zªº§@·~¨t²Îªº¥Ø«e¼h¦¸¡G
GO LICPGM
9.123.456.7 demo400 9.123.456.8 mypc
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)
¦pªG AS/400 ¨S¦³ DB2 ¸ê®Æ®w¦WºÙ¡A·í±z¸Õ¹Ï¦s¨ú¸ê®Æ®w®É¡A·|¥X²{ SQL0114 ¿ù»~¡C
http://www.as400.ibm.com/clientaccess/service.htm
¦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)
¦pªG¥X²{ CA/400 ¿ù»~¡A±z¥i¥H«ö¤@¤U¸Ñ»¡¡A¨ú±o¿ù»~ªº¸Ô²Ó»¡©ú¡C