DB2 V8.2 under SUSE11 創(chuàng)建實(shí)例失敗及解決的辦法

sunlan

最近做的一個(gè)項(xiàng)目，操作系統(tǒng)使用的是SUSE 11sp1、數(shù)據(jù)庫(kù)是由客戶(hù)提供的DB2 V8.2。如往常一樣裝好數(shù)據(jù)庫(kù)軟件，在使用db2icrt創(chuàng)建實(shí)例的時(shí)候始終報(bào)錯(cuò)。日志中報(bào)了以下內(nèi)容：

1.        Program name = db2idbm
   
2. Instance home dir = /home/db2,   Sysadm group = db2admin
   
3. Instance type = 1,  Auth type = SERVER
   
4. 
   
5. SQL6048N  A communication error occurred during START or STOP DATABASE MANAGER
   
6. processing.
   
7. Update DBM cfg SYSADM_GROUP errcode = 8
   
8. DBI1281E The database manager configuration file could not be
   
9.           initialized.
   
10. 
    
11. Explanation:
    
12. 
    
13. An error occurred when attempting to initialize the database
    
14. manager configuration file. A DB2 instance could not be created
    
15. or migrated.
    
16. 
    
17. User Response:
    
18. 
    
19. Refer to the log file for problem determination. Resolve the
    
20. problem and try the command again. If the problem persists,
    
21. please contact IBM Support.
    

復(fù)制代碼

起初百思不得其解，同樣的方法，為什么在其他的操作系統(tǒng)（包括SUSE 10）上是正常的、而在SUSE 11上會(huì)出差呢？起初懷疑是SUSE 11的某些運(yùn)行環(huán)境與DB2 V8.2不兼容，后來(lái)經(jīng)檢查發(fā)現(xiàn)，問(wèn)題出在hosts文件中。大多數(shù)的linux操作系統(tǒng)會(huì)自動(dòng)將主機(jī)的名稱(chēng)（$HOSTNAME）自動(dòng)添加到/etc/hosts中，而SUSE 11的/etc/hosts文件中僅有l(wèi)ocalhost項(xiàng)。而DB2創(chuàng)建實(shí)例時(shí)需要使用hostname項(xiàng)。在手動(dòng)將hostname添加到hosts文件中后，創(chuàng)建實(shí)例、啟動(dòng)實(shí)例等操作一切正常。