Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: UNIX
Expertise: Advanced
Nov 7, 2005

Resolve DB2 Instance Creation Failure on UNIX

On AIX, and UNIX in general, DB2 instance creation fails with vague errors:

Update DBM cfg SYSADM_GROUP errcode = 8
DBI1281E The database manager configuration file could not be 
          initialized.  

Explanation: 

An error occurred when attempting to initialize the database 
manager configuration file. A DB2 instance could not be created 
or migrated.  
One of the main reasons for DB2 instance creation to fail is that it is unable to resolve the hostname of the machine. Under the covers, DB2 instance creation would create a TCP/IP Service. It fails to do so if the hostname of the machine can't be resolved. But instead of throwing an understandable message informing the user the same, it throws the above vague/ambiguous error.

So the tip here is to run the command host and make sure the host is resolved before creating a DB2 instance.

For new UNIX users, the below info shows how to run the command host.

  • Command: host 'short hostname of the machine'
  • Successful Result : the host should be resolved to an IP.
  • Failure Case: If host can't be found, make sure the file /etc/resolv.conf exists with all the needed info.

R. Vijaya
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap