Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2010
    Posts
    31

    Unanswered: Instance Owner creation error for DB2 V9.5

    Hi,

    I am trying to create the instance owner after installing DB2 V9.5 ESE 64 bits on VMWare ESX 3.5 server. I used the following steps.

    1. Install DB2 V9.5 ESE (the message says it is successful)
    2. Apply the latest fix pack 5 for DB2 V9.5. (it was successful)

    Then tried to create the instance by issuing the following command.
    /opt/ibm/db2/instance/db2icrt -u db2fence dwapinst

    There was error in creating the instance. When I checked the log file it says

    SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code
    "11".
    Update DBM cfg SYSADM_GROUP errcode = 8
    >>>>> Error message = SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code
    "11". <<<<<
    DBI1703E No valid service name or port number found.

    ---

    So I checked the services file and the tcp/ip ports were not entered at the end of this file. The SQLLIB is not also created.

    Can someone please tell me how to fix this problem.

    Thanks a lot

    Nav

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I believe that in creating an instance on a DB server, you must specify the port with the -p option.

    Andy

  3. #3
    Join Date
    Jan 2010
    Posts
    31
    I used the same steps to install DB2 V9.5 ESE on another physical server and used the same command to create instance.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What port did it use for the server that worked?

    Andy

  5. #5
    Join Date
    Jan 2010
    Posts
    31
    It is 6000. But I can not use db2 command on the server.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    My guess is that the same port on the other server is already in use. What do you mean when you say that you cannot use DB2 command on the server?

    Andy

  7. #7
    Join Date
    Jan 2010
    Posts
    31
    These are 2 separate servers. For db2 command, for example if I use db2set or db2 get dbm cfg comand, these comands do not work.

    Nav

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am assuming the the DB2 commands are not working on the server you are having problems with. That is because you need to issue those commands as the instance owner, and you are having problems setting it up. What happens if you issue the db2icrt command with the -p 55000 option added?

    Andy

Posting Permissions

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