Amber wrote:
Here is the error:
Command to be run: "cd /opt/ibm/db2/V9.1/;/opt/ibm/db2/V9.1/instance/
db2icrt -a server -s wse -u db2fenc1 -p db2c_db2inst1 db2inst1".
ERROR:An error occurred while creating the instance "db2inst1". The
return code
is "1". Create the instance manually using the command "db2icrt".
ERROR:DBI1135E The primary group db2instgrp of user ID
db2inst1 is invalid.
Explanation:
The primary group name of the instance user ID cannot:
1. be one of "guests", "admins", "users" or "local".
2. start with "sql" or "ibm".
3. start with a numeral or contain characters other than a-z, $,
#, @, or 0-9.
I have fixed,^_^
Amber,
I suspect the problem is that you've created the user db2inst1 in a group
with a name longer than 8 characters. The "standard" group name for
db2inst1 is db2grp1, for db2fenc1 is db2fgrp1 and for dasusr1 is dasadm1.
Did you create the users manually yourself and then specify to use existing
users as part of the install ?
Suggest you rework to the above and try again.
It looks like the software install went fine, so you should be OK to set up
the instance manually using commands. After creating the instance there
are a couple of additional steps you'll need to perform -
Run as db2inst1 -
db2set DB2COMM=TCPIP
db2set DB2AUTOSTART=YES
Run as root -
/opt/ibm/db2/V9.1/cfg/db2ln
In the .profile of db2inst1 and any users you are going to access DB2 from
the command line you will want to put the following lines, if they don't
already exist -
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi
You should then be able to start the instance, from db2inst1, by running -
db2start
DB2 should start automatically at boot time since we added the parameter to
autostart the instance.
Any more problems give me a shout. I've done this so many times now I can
virtually do it in my sleep. I even wrote an article for IDUG Solutions
Journal on installing DB2 V8 without the GUI way back in 2003 !!!
HTH
Phil Nelson
ScotDB Limited
(te*****@scotdb.com)