資源大。664.43 KB |
資源類型:文檔 |
下載積分: 0 |
|
|
|
資源介紹 |
|
目 錄
第 1 篇 異地容災(zāi)配置方案 ................................................................................ 3
1.硬件系統(tǒng)環(huán)境 ........................................................................................................................... 3
1.1設(shè)備情況介紹 ............................................................................................................................ 3
2.實(shí)施方案 ................................................................................................................................... 3
2.1安裝DB2 ................................................................................................................................... 3
2.2HADR配置 ................................................................................................................................ 3
3.HADR日常維護(hù)命令介紹 ....................................................................................................... 7
3.1正常工作時(shí)的切換命令: ........................................................................................................ 7
3.2DB2_1工作不正常時(shí)的切換命令:注意在備庫運(yùn)行機(jī)上執(zhí)行: ......................................... 7
3.3獲知HADR狀態(tài)的命令: ....................................................................................................... 7
3.4獲知HADR配置參數(shù)的命令: ............................................................................................... 7
3.5停止HADR命令: .................................................................................................................. 7
3.6啟動(dòng)HADR命令 ...................................................................................................................... 8
第 2 篇 標(biāo)準(zhǔn)版項(xiàng)目實(shí)施說明 ................................................................................... 9
1. 實(shí)施前工作 ............................................................................................................................. 9
2.更新維護(hù)數(shù)據(jù)庫........................................................................................................................ 9
2.1 數(shù)據(jù)初始化 ............................................................................................................................... 9
2.2 代碼和數(shù)據(jù)維護(hù) ....................................................................................................................... 9
2.3藥典維護(hù) .................................................................................................................................... 9
2.4注冊軟件并測試程序,及時(shí)備份數(shù)據(jù)庫,記錄操作過程。 .............................................. 11
2.5 調(diào)整發(fā)票和報(bào)表。 ................................................................................................................. 12
3. 項(xiàng)目啟動(dòng)工作........................................................................................................................ 12
3.1 召開協(xié)調(diào)會(huì)商討啟動(dòng)當(dāng)天的問題,確定具體使用流程。 ................................................. 12
4. 正式啟動(dòng)并處理使用中的問題 ............................................................................................ 12
第 3 篇 SQL 之游標(biāo)詳解 ........................................................................................ 13
1.為何使用游標(biāo):...................................................................................................................... 13
2.如何使用游標(biāo):...................................................................................................................... 13
2.1. 聲明游標(biāo) ................................................................................................................................ 13
2.2 打開游標(biāo) ............................................................................................................................... 13
2.3 使用游標(biāo)操作數(shù)據(jù) ................................................................................................................ 14
2.4 關(guān)閉游標(biāo) ............................................................................................................................... 14
3. FETCH操作的簡明語法如下: ........................................................................................... 14
第 4 篇 數(shù)據(jù)庫質(zhì)疑 ................................................................................................. 16
第 5 篇 藥庫庫存數(shù)據(jù)初始化 ................................................................................. 19
第 6 篇 表大小的查看方法 ..................................................................................... 24
第 7 篇 2003網(wǎng)絡(luò)負(fù)載均衡(NLB)配置實(shí)例 ......................................................... 25
一、網(wǎng)絡(luò)負(fù)載平衡的優(yōu)點(diǎn) ......................................................................................................... 25
天網(wǎng)軟件客服中心
第 3 頁 共 32 頁
二、用IIS服務(wù)驗(yàn)證網(wǎng)絡(luò)負(fù)載平衡 ......................................................................................... 27
第 8 篇 某某醫(yī)院V11版出院問題處理實(shí)錄 ......................................................... 30
1、 問題用戶描述 ................................................................................................................ 30
2、 問題處理基本思路 ........................................................................................................ 30 |
|
下載地址 |
|
|
|