Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Question Unanswered: 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.

  2. #2
    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

  3. #3
    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.

  4. #4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •