【正文】 TIBASE安裝 ...............................................................................................6 AIX下的ALTIBASE安裝 ...........................................................................................................................................6 系 統(tǒng)需求 ................................................................................................................................................................6 安裝 過程 ................................................................................................................................................................9 創(chuàng) 建數(shù)據(jù)庫 .........................................................................................................................................................11 HPUX下的ALTIBASE安裝 ..................................................................................................................................12 系 統(tǒng)需求 .............................................................................................................................................................12 安裝 過程 .............................................................................................................................................................14 創(chuàng) 建數(shù)據(jù)庫 .........................................................................................................................................................17 部署多套數(shù)據(jù)庫 ........................................................................................................................................................17 升級(jí) ...............................................................................................................................................................................18 目錄結(jié)構(gòu)說明 .............................................................................................................................................................19第二部分 ALTIBASE維護(hù) ............................................................................................22 啟動(dòng)和停止 .................................................................................................................................................................22 啟動(dòng)過 程 .............................................................................................................................................................22 啟動(dòng)階 段 .............................................................................................................................................................23 停止 過程 .............................................................................................................................................................24 停止方式 .............................................................................................................................................................24 Server腳本 .........................................................................................................................................................25 參數(shù)配置說明 .............................................................................................................................................................25 系統(tǒng)表說明 .................................................................................................................................................................33 性能視圖 ......................................................................................................................................................................34 日常監(jiān)控 ......................................................................................................................................................................36 進(jìn) 程監(jiān)控 .............................................................................................................................................................36 系 統(tǒng)資源 .............................................................................................................................................................36 Session...............................................................................................................................................................42 Statement...........................................................................................................................................................43 Lock......................................................................................................................................................................43 Long Term Transaction................................................................................................................................44ALTIBASE維護(hù)手冊 3 Logfile Space amp。確認(rèn)方法：oslevel r注：ALTIBASE AIX ，而在AIX 6下由于相關(guān)案例較少，不建議使用AIX 6 版本。即應(yīng)用和數(shù)據(jù)庫通信的網(wǎng)卡和主庫和備庫之間復(fù)制用的網(wǎng)卡是獨(dú)立的。ls alt39。vi $ALTIBASE_HOME/conf/39。MIN_LOG_RECORD_SIZE_FOR_COMPRESS = 128MULTIPLEXING_MANAGER_INTERVAL = 1000默認(rèn)為10000 ，根據(jù)情況設(shè)置為1000 或 10000 或100000。iSQL(sysdba)create database mydb initsize=10M noarchivelog。 swlist l patch | grep pthread PHCO_38050 pthread librarycumulative patch要求PHCO_38050 以上 系統(tǒng)要求? 創(chuàng)建用戶創(chuàng)建用于ALTIBASE安裝和日常登錄、維護(hù)的操作系統(tǒng)擁護(hù)，如ALTIBASE ，建議采用sam工具創(chuàng)建? HPUX Kernal 參數(shù)修改修改下列參數(shù)： shmmax = physical memory sizeshmmni 500 or more.ALTIBASE維護(hù)手冊 13shmseg 200 or moresemmap semmni + 1semmni 1000semmns 4096semmnu = semmnisemume = semmnimax_thread_proc 600 or moremaxusers 64 or moremaxdxiz 1G 。 文件系統(tǒng)需要保證下表所有目錄的所屬用戶為altibase ，并具有完全操作權(quán)限。即應(yīng)用和數(shù)據(jù)庫通信的網(wǎng)卡和主庫和備庫之間復(fù)制用的網(wǎng)卡是獨(dú)立的。alias findword=39。alias att=39。MULTIPLEXING_MAX_ELAPSE_TIME = 10MULTIPLEXING_POLL_TIMEOUT = 50000QP_MSGLOG_FLAG = 2 的部分內(nèi)容可以通過 alter system or alter session 命令語修改，但重起數(shù)據(jù)庫時(shí)，重新讀 ，并反映到系統(tǒng)表。iSQL(sysdba)startup ser