SEO

The installer tells it faild to config db2inst1, the db2setup.err is
as following:

/usr/share/themes/Clearlooks/gtk-2.0/gtkrc:60: Engine "clearlooks" is
unsupporte
d, ignoring
Jun 15, 2007 6:32:36 PM java.util.prefs.FileSystemPreferences$3 run
INFO: Created system preferences directory in java.home.

There is dbsetup.log:


DB2 Setup log file started at: Fri Jun 15 18:32:33 2007 HKT
================================================== ==========

Operating system information: Linux 2.6.18-1.2798.fc6.#1 SMP Mon Oct
16 14:54:20 EDT 2006 i686
Product to install: IBM DB2 Express Edition
Installation type: Custom
Previously Installed Components:
Selected Components:
GSKit support
Product Messages - English
Base client support
IBM Software Development Kit (SDK) for Java(TM)
Java Help (HTML) - English
Replication with MQ Server
Run-time Environment
Java support
SQL procedures
ICU Utilities
SQL Replication Support
Java Common files
Base server support
Control Center Help (HTML) - English
Configuration Assistant
Spatial Extender client
Base application development tools
Administration Server
Communication support - TCP/IP
Control Center
Replication tools
DB2 data source support
DB2 LDAP support
DB2 Instance Setup wizard
Product Signature for DB2 Express Server Edition
XML Extender
First Steps
DB2 Web Tools
XML Extender samples
ADT sample programs
Sample database source
Spatial Extender samples
Languages:
English
All Products
Target directory: /opt/ibm/db2/V9.1

Space required: 466 MB

New instances:
Instance name: db2inst1
Start instance on reboot: Yes
TCP/IP configuration:
Service name: db2c_db2inst1
Port number: 50000
Instance user information:
User name: db2inst1
Group name: db2instgrp
Home directory: /home/db2inst1
Fenced user information:
User name: db2fenc1
Group name: db2fgrp1
Home directory: /home/db2fenc1

DB2 Administration server:
Instance user information:
User name: dasusr1
Group name: dasadm1
Home directory: /home/dasusr1



Response file name: /root/db2exp.rsp

Checking license agreement acceptance:.......Success
Command to be run: "/bin/rpm -ivh '/software/db2exc/exp/disk1/db2/
linux/FILES/gsk7bas-7.0-3.18'.i386.rpm".
ERROR:Preparing...
##################################################

ERROR: package gsk7bas-7.0-3.18 is already installed

WARNING:GSKit installation on the system failed. Return code from "/
bin/rpm
-ivh '/software/db2exc/exp/disk1/db2/linux/FILES/
gsk7bas-7.0-3.18'.i386.rpm" is
"1". Possible causes for this failure include: GSKit is already
installed on
the system, insufficient space, image is corrupted, or other system
errors.
Check for possible causes and run "/bin/rpm -ivh
'/software/db2exc/exp/disk1/db2/linux/FILES/
gsk7bas-7.0-3.18'.i386.rpm" again
to install GSKit if needed.

Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_PRODUCT_MESSAGES_EN_9.1.0.2_linux_i386
..tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
BASE_CLIENT_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/JDK_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_JAVA_HELP_EN_9.1.0.2_linux_i386.tar.gz
)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
REPL_QSERVER_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
BASE_DB2_SERVER_9.1.0.2_linux_i386.tar.gz)
".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
JAVA_SUPPORT_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
SQL_PROCEDURES_9.1.0.2_linux_i386.tar.gz)"
..
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/ICU_SUP_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
REPL_SERVER_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
JAVA_COMMON_FILES_9.1.0.2_linux_i386.tar.g
z)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
BASE_DB2_ENGINE_9.1.0.2_linux_i386.tar.gz)
".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_CONTROL_CENTER_HELP_EN_9.1.0.2_linux_i
386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
CONFIGURATION_ASSISTANT_9.1.0.2_linux_i386
..tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
SPATIAL_EXTENDER_CLIENT_SUPPORT_9.1.0.2_li
nux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
APPLICATION_DEVELOPMENT_TOOLS_9.1.0.2_linu
x_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
ADMINISTRATION_SERVER_9.1.0.2_linux_i386.t
ar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
COMMUNICATION_SUPPORT_TCPIP_9.1.0.2_linux_
i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
CONTROL_CENTER_9.1.0.2_linux_i386.tar.gz)"
..
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
REPL_CLIENT_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_DATA_SOURCE_SUPPORT_9.1.0.2_linux_i386
..tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
LDAP_EXPLOITATION_9.1.0.2_linux_i386.tar.g
z)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
INSTANCE_SETUP_SUPPORT_9.1.0.2_linux_i386.
tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
EXPRESS_PRODUCT_SIGNATURE_9.1.0.2_linux_i3
86.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
XML_EXTENDER_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
FIRST_STEPS_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_WEB_TOOLS_9.1.0.2_linux_i386.tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
XML_EXTENDER_SAMPLES_9.1.0.2_linux_i386.ta
r.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_SAMPLE_APPLICATIONS_9.1.0.2_linux_i386
..tar.gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
DB2_SAMPLE_DATABASE_9.1.0.2_linux_i386.tar
..gz)".
Command to be run: "(cd /opt/ibm/db2/V9.1; /bin/tar xzvf /software/
db2exc/exp/disk1/db2/linux/FILES/
SPATIAL_EXTENDER_SAMPLES_9.1.0.2_linux_i38
6.tar.gz)".
Installing DB2 file sets:.......Success
Setting DB2 library path:.......Success
Executing control tasks:.......Success
Updating global registry:.......Success
Starting DB2 Fault Monitor:.......Success
Updating the db2ls link:.......Success
Registering DB2 licenses:.......Success
Setting default global profile registry variables:.......Success
Creating the DB2 Administration Server:.......Success
Initializing instance list:.......Success
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".

ERRORBI1135E 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.



User Response:

Change the primary group of the instance user ID to a group with
a valid name and then try the command again.


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

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.



ERROR:An error occurred while configuring the instance "db2inst1".

Configuring DB2 instances:.......Failure
Configuring the DB2 Administration Server:.......Success
Updating global profile registry:.......Success
WARNING:A minor error occurred while installing "IBM DB2 Express
Edition" on
this computer. Some features may not function correctly.


Post Install Recommendations
----------------------------

Verify that you have access to the DB2 Information Center based on the
choices you made during this installation. If you performed a typical
o
r a compact installation, verify that you can access the IBM Web site
using the internet. If you performed a custom installation, verify
that
you can access the DB2 Information Center location specified during
the installation.

Run First Steps (db2fs) as a regular, non-privileged userid. You will
need a supported web browser in the path of this userid and you must
ex
ecute the db2profile script from the instance to be administered.

Install DB2 Developer Workbench. The DB2 Developer Workbench replaces
the Development Center from DB2 UDB Version 8 on Windows. It is on a
sep
arate CD in your DB2 package. The Developer Workbench is a
comprehensive development environment for creating, editing,
debugging, deploying,
and testing DB2 stored procedures and user-defined functions. You can
also use this tool to create, edit and run SQL statements and XML
querie
s, and develop SQLJ applications.

Review the response file created at /root/db2exp.rsp. Additional
information about response file installation is available in the DB2
documen
tation under "Installing DB2 using a response file".


DB2 Setup log file finished at: Fri Jun 15 18:44:15 2007 HKT
================================================== ==========

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".


ERRORBI1135E 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 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".
>
>
> ERRORBI1135E 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
(teamdba@scotdb.com)

Thanks Phil, it works now.