【正文】 ynamic Scalable Architecture），適用于單機系統(tǒng)，包括 SMP 結(jié)構(gòu)的機器。值得注意的是，再對觸發(fā)器的處理中，不應(yīng)再執(zhí)行觸發(fā)觸發(fā)器自身的操作，這用會造成死循環(huán)，其次觸發(fā)器中要特別謹慎執(zhí)行引起事務(wù)提交的動作，這樣易造成事務(wù)的不完整性。OnExceptionProcess 處理意外事件。一個表最多只能有一個聚族索引，但 Alter Index IndexName To [Not] Cluster 語句可以將聚族屬性移到另外一個索引上。 物理日志物理日志保存數(shù)據(jù)被修改前的映象。若某一個 dbspace 的空間耗盡了（即所有指定給他的 chunk 都滿了），您可另外再指定 chunk 給他。 by CINtel Intelligent Network System Co.,Ltd. [ Informix 數(shù)據(jù)庫手冊 ]共 74 頁 第 1 頁目目 錄錄1． 基礎(chǔ)知識和概念 ................................................................................................................................4 INFORMIX 動態(tài)服務(wù)器的基本術(shù)語 .......................................................................................................4 chunk ..............................................................................................................................................4 dbspace 數(shù)據(jù)庫空間 ......................................................................................................................4 page 數(shù)據(jù)頁 ...................................................................................................................................4 tblspace ..........................................................................................................................................4 extent ..............................................................................................................................................4 物理日志 ........................................................................................................................................5 邏輯日志 ........................................................................................................................................5 常用的數(shù)據(jù)庫概念基礎(chǔ) ......................................................................................................................5 數(shù)據(jù)庫 (Database)..........................................................................................................................5 數(shù)據(jù)表 (Table)................................................................................................................................5 索引 (Index) ....................................................................................................................................5 視圖 (View).....................................................................................................................................6 查詢 (Query)...................................................................................................................................6 存儲過程 (Procedure) ....................................................................................................................6 觸發(fā)器 (Tigger) ..............................................................................................................................7 事務(wù) Transaction ...........................................................................................................................7 數(shù)據(jù)的完整性控制 ........................................................................................................................7 并發(fā)控制 ......................................................................................................................................82． 數(shù)據(jù)庫的安裝與配置 ........................................................................................................................9 單機數(shù)據(jù)庫的安裝 ..............................................................................................................................9 簡介 ................................................................................................................................................9 準備 Informix 所需的硬盤空間 ....................................................................................................9 創(chuàng)建 informix 組和用戶 (開始 ) ...................................................................................................10 安裝 informix 產(chǎn)品 ......................................................................................................................11 修改內(nèi)核參數(shù) (一定要小心 ).......................................................................................................12 修改 chunk 的屬性 ......................................................................................................................13 修改 sqlhosts 文件 .......................................................................................................................14 修改 onconfig 文件 ......................................................................................................................15 初始化 OnLine（基本成功） .....................................................................................................21 創(chuàng)建其他 dbspace......................................................................................................................21 將邏輯日志移到 logdbs（別忘了做） ....................................................................................22 檢查 ESQL/C 是否安裝成功 ....................................................................................................23 修改 Client 的 login script(成功 )..............................................................................................23 在二臺機器上搭建 INFORMIX HDR 環(huán)境(無 CLUSTER軟件) ..............................................................24 配置需求說明 ..............................................................................................................................24 修改兩個 onconfig 文件 ..............................................................................................................25 Sqlhosts 文件示例： ...................................................................................................................25 /etc/services:................................................................................................................................25 做主從機 .....................................