1. 將aix 64 上db2資料庫移植到windows上可以用以下方法
1.安裝db2 9.7資料庫
2.建立資料庫所有資料庫列表右鍵建立乙個標準資料庫
選擇標準資料庫可以更改緩衝池和表空間頁大小
預設為4k
下一步再下一步次步驟是選擇資料庫儲存位置選擇d盤
選擇資料庫的語言環境為
如果為windows則選擇中華人民共和國**集選擇ibm-1381aix則選擇1252
點選完成
在 windows下的本地資料庫建好庫後,再將原來aix庫中的庫的資料結構匯出來生成ddl或者sql
在你想要取得該sql的路徑下
執行語句db2look – d 『資料庫名字』 -l -x -a -e -o 『資料庫名字.sql』
在該路徑下就會出現資料庫名字.sql
? sql+state查詢錯誤原因,此時就用普通的導表方法expert to 』表名.del』 of del select * from 『表名』
寫乙個connect to gsposp;
export to ad_ of del select * from ad_message;
export to area_ of del select * from area_code;
export to of del select * from authgroup;
export to authgroup_ of del select * from authgroup_fun;
export to of del select * from authmenu;
export to of del select * from authuser;
export to of del select * from bankinfo;
export to cbs_ic_ of del select * from cbs_ic_tranc;
export to coms_ of del select * from coms_syspara;
--export to coms_ of del select * from coms_tranc;
--export to core_htc_ of del select * from core_htc_tranc;
--export to core_hth_ of del select * from core_hth_tranc;
export to cup_trade_ of del select * from cup_trade_caculate;
export to cup_ of del select * from cup_tranc;
export to cup_ of del select * from cup_tranerr;
export to cups_ of del select * from cups_djbin;
--export to cups_htc_ of del select * from cups_htc_tranc;
export to dev_ of del select * from dev_key;
export to of del select * from dictodic;
export to emv_ of del select * from emv_tranc;
export to emv_ of del select * from emv_tranc1;
export to err_ of del select * from err_message;
export to error_code_ of del select * from error_code_desc;
export to of del select * from fileupload;
export to of del select * from fublist;
export to of del select * from funcregister;
--export to h_core_htc_ of del select * from h_core_htc_tranc;
--export to h_core_hth_ of del select * from h_core_hth_tranc;
--export to h_cups_htc_ of del select * from h_cups_htc_tranc;
--export to h_pos_ of del select * from h_pos_register;
--export to h_pos_ of del select * from h_pos_tranc;
--export to h_posc_ of del select * from h_posc_termc;
--export to h_posc_ of del select * from h_posc_tranc;
export to hist_cup_ of del select * from hist_cup_tranc;
export to hist_cup_ of del select * from hist_cup_tranerr;
export to hist_host_ of del select * from hist_host_tranc;
export to hist_host_ of del select * from hist_host_tranerr;
export to hist_posc_ of del select * from hist_posc_tranc;
export to host_ic_ of del select * from host_ic_tranc;
export to host_trade_ of del select * from host_trade_caculate;
export to host_ of del select * from host_tranc;
export to host_ of del select * from host_tranerr;
export to ic_ of del select * from ic_control;
export to ic_ of del select * from ic_tranc;
export to ic_tranc_ of del select * from ic_tranc_err;
export to j_ of del select * from j_award;
export to j_ of del select * from j_awardbox;
export to j_ of del select * from j_awardlist;
export to j_ of del select * from j_awardput;
export to j_ of del select * from j_awardtime;
export to j_ of del select * from j_projdef;
export to j_ of del select * from j_project;
export to j_ of del select * from j_projpara;
export to j_ of del select * from j_projrule;
export to j_ of del select * from j_rate;
export to j_ of del select * from j_rulepara;
export to j_ of del select * from j_ruleprog;
export to mechant_ of del select * from mechant_charge;
export to mechant_ of del select * from mechant_graylist;
export to mechant_ of del select * from mechant_income;
AIX作業系統使用心得
aix是ibm公司開發的業界領先的優秀商務unix作業系統,在可靠性 可用性 開放性 擴充套件性 高效能 安全性等方面都非常突出,尤其是在internet的關鍵應用領域以及系統和硬體管理能力方面,其效能表現更為出色,受到了業界的普遍認可和廣泛使用。以下是筆者幾年來使用aix系統的一點心得,茲供使用該...
Windows 各種作業系統的安裝方法 到win
windows 98篇 一 準備工作 1.首先當然是要準備好windows 98的系統安裝光碟。2.在可能的情況下,可以在執行安裝程式之前用磁碟掃瞄程式將所有硬碟掃瞄一遍,檢查硬碟錯誤並進行修復,否則安裝程式執行時如果檢查到有硬碟錯誤就會很麻煩。3.如果安裝過程中需要用產品密匙 安裝序列號 的,用紙...
作業系統複習
一 什麼是作業系統 在回答這個問題之前,我們先來了解一下什麼是計算機系統。計算機系統是按使用者的要求接收和儲存資訊 自動進行資料處理並輸出結果資訊的系統。計算機系統由硬體系統和軟體系統組成。軟硬體系統的組成部分就是計算機系統的資源,當不同的使用者使用計算機時都要占用系統資源並且有不同的控制需求。作業...