◆1、Win下打開(kāi)DB2 CLP，連接到AIX上數(shù)據(jù)庫(kù)（ZJGL）db2 connect to zjgl user zjgl using zjgl

◆2、用db2look導(dǎo)出建庫(kù)表的SQL腳本。

db2 db2look -d 數(shù)據(jù)庫(kù) -i 用戶 -w 密碼 -e -c -o c:zjgllook.sql；不指定路徑,默認(rèn)保存在..SQLLIBin下

更改zjgllook.sql腳本，更改連接數(shù)據(jù)庫(kù)名，去掉IN 'DMS_DATA' INDEX IN 'DMS_IDX' 和IN 'DMS_DATA' 內(nèi)容，把腳本中數(shù)據(jù)庫(kù)名兩邊雙引號(hào)去掉。

◆3、在Win下DB2建立數(shù)據(jù)庫(kù)ZJDEP，采用AIX上ZJGL的腳本保存未zjdep.sql

CREATE DATABASE zjdep

ON 'd:'

ALIAS zjdep

USING CODESET ISO8859-1

TERRITORY US

COLLATE USING Compatibility

NUMSEGS 1

DFT_EXTENT_SZ 32

CATALOG TABLESPACE MANAGED BY SYSTEM

USING

('d:db2NODE0000SQL00001SQLT0000.0'

)

EXTENTSIZE 32

PREFETCHSIZE 32

OVERHEAD 24.10

TRANSFERRATE 0.90

USER TABLESPACE MANAGED BY SYSTEM

USING

('d:db2NODE0000SQL00001SQLT0002.0'

)

EXTENTSIZE 32

PREFETCHSIZE 32

OVERHEAD 24.10

TRANSFERRATE 0.90

TEMPORARY TABLESPACE MANAGED BY SYSTEM

USING

('d:db2NODE0000SQL00001SQLT0001.0'

)

EXTENTSIZE 32

PREFETCHSIZE 32

OVERHEAD 24.10

TRANSFERRATE 0.90;

◆4、在DB2 CLP下

執(zhí)行:db2 connect to zjdep

而后執(zhí)行:db2 -tvf d:zjgllook.sql （在批處理中執(zhí)行DB2的SQL腳本文件）