[原创]DB2 UDB V8.2 Access to Informix Dynamic Server

大梦

DB2 UDB V8.2 Access to Informix Dynamic Server

Login As informix:
      export DB_LOCALE=en_us.utf8
      export CLIENT_LOCALE=en_us.utf8
      dbaccessdemo stores_demo -log -dbspace workdbs

Login As db2inst1:
      su
      export INFORMIXDIR=/home2/informix
      /opt/IBM/db2/V8.1/bin/djxlinkInformix
      /opt/IBM/db2/V8.1/instance/db2iupdt db2inst1
      vi sqllib/cfg/db2dj.ini
         INFORMIXDIR=/home2/informix
         INFORMIXSERVER=ids940uc5_tcp
         DB_LOCALE=en_us.utf8
         CLIENT_LOCALE=en_us.utf8
      db2start
      db2 "update dbm cfg using FEDERATED YES"
      db2stop
      db2start
      db2 "create db storesdb using codeset UTF-8 territory US"
      db2 "connect to storesdb"
      db2 "create wrapper informix"
      db2 "CREATE SERVER stores TYPE informix VERSION 9 WRAPPER informix OPTIONS(NODE 'ids940uc5_tcp',DBNAME 'stores_demo',IUD_APP_SVPT_ENFORCE 'N',FOLD_ID 'N',FOLD_PW 'N')"
      db2 "CREATE USER MAPPING FOR db2inst1 SERVER stores OPTIONS (REMOTE_AUTHID 'informix',REMOTE_PASSWORD 'dba')"
      db2 "set passthru stores"
      db2 "select count(*) from informix.systables"
      db2 "set passthru reset"
      db2set DB2_DJ_COMM='libdb2informix.a,libdb2informixF.a,libdb2informixU.a'
      db2stop
      db2start
      db2 'create nickname tab1 for stores."informix"."testtbl"'
      db2 'create nickname customer for stores."informix"."customer"'

Other Operation:
      DROP SERVER server_name
      DROP USER MAPPING FOR authorization_name SERVER server_name
      DROP NICKNAME nickname
      DROP WRAPPER wrapper_name

mymm

GOOD!