應(yīng)用啟動(dòng)時(shí)報(bào)錯(cuò):
<Sep 14, 2009 8:42:19 AM GMT+08:00> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "test": [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.128.44". Communication function detecting the error: "recv". Protocol specific error code(s): "*", "*", "0". SQLSTATE=08001
這個(gè)錯(cuò)誤,網(wǎng)上一般都是說(shuō)的DB2環(huán)境配置問(wèn)題:DB2COMM和SVCNAME變量設(shè)置不對(duì),但是這個(gè)環(huán)境下使用的是type2的驅(qū)動(dòng),本地catalog的數(shù)據(jù)庫(kù)是可以連通的,遠(yuǎn)程java連接數(shù)據(jù)庫(kù)也可以成功,最后,只好向客戶要了機(jī)器的口令和weblogic控制臺(tái)口令,結(jié)果進(jìn)去一看,狂汗,有3,4個(gè)jdbc pool的初始連接數(shù)都是150,加起來(lái)超過(guò)默認(rèn)的數(shù)據(jù)庫(kù)代理數(shù)目了,改到25,重啟,一切ok!
tivoli數(shù)據(jù)庫(kù)數(shù)據(jù)不斷增大,90G的空間也只剩下2G了,ibm的工程師說(shuō)沒(méi)有清理數(shù)據(jù)的腳本,但是又說(shuō)數(shù)據(jù)庫(kù)里面各歷史數(shù)據(jù)表沒(méi)有關(guān)聯(lián),可以清除,于是SELECT TABSCHEMA,TABNAME,CARD,NPAGES,FPAGES,OVERFLOW,CLUSTERED,ACTIVE_BLOCKS FROM SYSSTAT.TABLES order by card desc了一把,找到最上面一個(gè)表,看看里面的數(shù)據(jù)有500多w條,用sql語(yǔ)句delete卻總是刪除不掉,搜索了一把,alter table tblname activate not logged initially with empty table可以清除,測(cè)試了下確實(shí)可以.
另外還發(fā)現(xiàn)數(shù)據(jù)庫(kù)中好多表名是用"開頭和結(jié)尾的,有些數(shù)據(jù)庫(kù)客戶端工具卻不能正確讀取表名,不知道為什么.