If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 instance creating failed (Solaris)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-22-04, 05:25
Amun Amun is offline
Registered User
 
Join Date: Jan 2004
Posts: 2
Question DB2 instance creating failed (Solaris)

Hi everybody,

I'm trying now several days to get DB2 v8.1 up and running. Guess the installation was successful. But I'm not able to create an instance. I'm receiving always the same error independent from what I'm trying.

During the setup (db2setup) the creation already failed therefore I've tried it manually with the command (as root):

./db2icrt -a SERVER -s ese -u db2fenc1 -w 32 -p db2_db2inst1 db2inst1

Then I see the following lines:
Segmentation Fault - core dumped
Segmentation Fault - core dumped

Which doesn't looks too got to me. Don't know if this has an influence to the 'real' problem.

The log file looks like this:
--->
Program name = db2idbm
Instance home dir = /export/home/db2inst1, Sysadm group = root
Instance type = 1, Auth type = SERVER


Update DBM cfg SYSADM_GROUP errcode = 139
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.

User Response:

Refer to the log file for problem determination. Resolve the
problem and try the command again. If the problem persists,
please contact IBM Support.


DBI1079I Output is saved in the log file /tmp/db2icrt.log.455.

Explanation:

All processed and failed operations have been saved into this log
file.

User Response:

Do not modify this file in any way. This file is for IBM
Technical Support reference.
<---

Of course I've searched through the internet and this forum but I wasn't able to figure out my problem.

I've also de-installed DB2 and then tried to install it again and I've used different users, etc. but always with the error mentioned above.

BTW, my knowledge of UNIX and DB2 is low but I need to get it running.

Please give me some advice to solve the problem.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 01-22-04, 14:09
kuckoo kuckoo is offline
Registered User
 
Join Date: Sep 2002
Posts: 41
Have you modified Solaris Kernal paramters prior to install DB2 ?
You will find details in Db2 install guide. Usually after making kernal changes you require to reboot server and then install db2 and create instance.

Hope this will help.
Kuckoo
Reply With Quote
  #3 (permalink)  
Old 01-23-04, 03:10
Amun Amun is offline
Registered User
 
Join Date: Jan 2004
Posts: 2
My kernel parameter should be fine. I've double checked this already.

--->
* Recommended kernel parameters for "DB2 for Solaris"
* for systems with more than 512MB of physical memory
*
set msgsys:msginfo_msgmax = 65535
set msgsys:msginfo_msgmnb = 65535
set msgsys:msginfo_msgmap = 258
set msgsys:msginfo_msgmni = 256
set msgsys:msginfo_msgssz = 16
set msgsys:msginfo_msgtql = 1024
set msgsys:msginfo_msgseg = 32768
*
set shmsys:shminfo_shmmax = 536870912
set shmsys:shminfo_shmseg = 16
set shmsys:shminfo_shmmni = 300
*
set semsys:seminfo_semmni = 1024
set semsys:seminfo_semmap = 1026
set semsys:seminfo_semmns = 2048
set semsys:seminfo_semmnu = 2048
<---

Are there any other paramter that need to be set? Where else could the problem be? What do yot think I should do next to get around this problem?

BTW, I'd already installed v7.1 on that system and this worked fine.

Thanks.
Reply With Quote
  #4 (permalink)  
Old 01-23-04, 13:58
kuckoo kuckoo is offline
Registered User
 
Join Date: Sep 2002
Posts: 41
It looks like permission problem. Check following before creating instance.

(1)The permission of /dev/null is incorrect. The instance owner needs to have write authority for /dev/null.

(2)The /tmp directory can't be written to by the instance owner.

(3) Make sure Instance home directory have enough space and read-write permission by instance owner.

(3)Log on as root rather than switching user as root and then rerun the db2icrt command.


Kuckoo
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On