Installing db2 7.2 on Linux kernel 2.4.9-21 
Author Message
 Installing db2 7.2 on Linux kernel 2.4.9-21

I am trying to install DB2 on Red Hat kernel 2.4.9-21 and it keeps on
failing during the creation of the database Instances.  Is this due to
the 2.4.9*** kernel.  I have no problems with 2.4.2** Kernel.  Any
Info?

The error is below -->

       Program name = db2idbm
Instance home dir = /home/db2inst1,   Sysadm group = db2iadm1
Instance type = 4,  Auth type = CLIENT

SQL5005C  System Error.
Update DBM cfg SYSADM_GROUP errcode = 8
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 Version 7 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.12764.



Sun, 15 Aug 2004 06:07:51 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21

Hello Michael,

Have you compared the instance home directory ownership and rights ?

Sylvain



Sun, 15 Aug 2004 17:18:49 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
Try installing using the 'db2setup' without creating the instances.
Then use the process for manually creating an instance to validate that it
is isolated to the instance creation.
The suggestion of write privilege on instance home directory missing is
also something to check.
Since the UPDATE DBM CFG command (part of the instance creation)  is what
seems to be failing I would suspect your kernel parameters may not have
been set to allow sufficient resources to complete the task.
Quote:

> I am trying to install DB2 on Red Hat kernel 2.4.9-21 and it keeps on
> failing during the creation of the database Instances.  Is this due to
> the 2.4.9*** kernel.  I have no problems with 2.4.2** Kernel.  Any
> Info?

> The error is below -->

>        Program name = db2idbm
> Instance home dir = /home/db2inst1,   Sysadm group = db2iadm1
> Instance type = 4,  Auth type = CLIENT

> SQL5005C  System Error.
> Update DBM cfg SYSADM_GROUP errcode = 8
> 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 Version 7 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.12764.



Mon, 16 Aug 2004 11:27:10 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
Before attempting to reinstall uninstall it removing users/group home
directory, installed directory.
Then make sure you have pdksh and ncurses installed prior to
reinstallation.
Quote:

> I am trying to install DB2 on Red Hat kernel 2.4.9-21 and it keeps on
> failing during the creation of the database Instances.  Is this due to
> the 2.4.9*** kernel.  I have no problems with 2.4.2** Kernel.  Any
> Info?

> The error is below -->

>        Program name = db2idbm
> Instance home dir = /home/db2inst1,   Sysadm group = db2iadm1
> Instance type = 4,  Auth type = CLIENT

> SQL5005C  System Error.
> Update DBM cfg SYSADM_GROUP errcode = 8
> 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 Version 7 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.12764.



Tue, 17 Aug 2004 05:34:25 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21

Quote:

> Try installing using the 'db2setup' without creating the instances.
> Then use the process for manually creating an instance to validate that it
> is isolated to the instance creation.
> The suggestion of write privilege on instance home directory missing is
> also something to check.
> Since the UPDATE DBM CFG command (part of the instance creation)  is what
> seems to be failing I would suspect your kernel parameters may not have
> been set to allow sufficient resources to complete the task.

Hi,

I'm having a similar problem.  I get the same error msg during
instance creation using DB2 7.2 on RH 7.2 (with both the default
2.4.7-10 kernel and the 2.4.9-21 kernel).

Instance creation fails when using db2setup.  Instance creation also
fails if I try 'db2icrt ...' from the cmd line.

What is boggling is that I was able to create 2 instances without any
problems, then this error started occuring on the third instance.

The error log lists 'SQL10003C There are not enough system resources
to process the request...' - is there any way to tweak kernel
parameters (mentioned above) to prevent this error?
Thanks in advance for any help,
Jon Allen



Tue, 17 Aug 2004 07:57:05 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
I suspect you are having a problem with MSGMNI (one of the kernel
parameters).  There is some information about this in the DB2-HOWTO on
http://www.linuxdoc.org.

If I remember the value set by RH7.2 by default is something like 64 (an
increase from the default in the kernel source which I think is 16).  For
some reason this value is a lot less that was the default on V2.2
kernels.

I've got mine set to 1024.

Try :-

echo 1024 >/proc/sys/kernel/msgmni

and then try creating the new instance again.

To set this permananently, you can either issue this command at system
boot or you can recompile your own kernel, changing the appropriate
source file (linux/include/linux/msg.h and then find MSGMNI).

HTH

Phil Nelson
Database Consultant
ScotDB Limited

Quote:



>> Try installing using the 'db2setup' without creating the instances.
>> Then use the process for manually creating an instance to validate that
>> it is isolated to the instance creation. The suggestion of write
>> privilege on instance home directory missing is also something to
>> check.
>> Since the UPDATE DBM CFG command (part of the instance creation)  is
>> what seems to be failing I would suspect your kernel parameters may not
>> have been set to allow sufficient resources to complete the task.

> Hi,

> I'm having a similar problem.  I get the same error msg during instance
> creation using DB2 7.2 on RH 7.2 (with both the default 2.4.7-10 kernel
> and the 2.4.9-21 kernel).

> Instance creation fails when using db2setup.  Instance creation also
> fails if I try 'db2icrt ...' from the cmd line.

> What is boggling is that I was able to create 2 instances without any
> problems, then this error started occuring on the third instance.

> The error log lists 'SQL10003C There are not enough system resources to
> process the request...' - is there any way to tweak kernel parameters
> (mentioned above) to prevent this error? Thanks in advance for any help,
> Jon Allen



Thu, 19 Aug 2004 01:23:17 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
Check /etc/sysctl.conf for msgmni setting.
Are you able to 'create' two instances but cannot 'create' the 3rd one or are
you able 'start' two instances and cannot 'start' the 3rd one?
'create' = db2icrt
'start' = db2start

See http://www.linux.org/docs/ldp/howto/DB2-HOWTO/index.html

Ro

Quote:


> > Try installing using the 'db2setup' without creating the instances.
> > Then use the process for manually creating an instance to validate that it
> > is isolated to the instance creation.
> > The suggestion of write privilege on instance home directory missing is
> > also something to check.
> > Since the UPDATE DBM CFG command (part of the instance creation)  is what
> > seems to be failing I would suspect your kernel parameters may not have
> > been set to allow sufficient resources to complete the task.

> Hi,

> I'm having a similar problem.  I get the same error msg during
> instance creation using DB2 7.2 on RH 7.2 (with both the default
> 2.4.7-10 kernel and the 2.4.9-21 kernel).

> Instance creation fails when using db2setup.  Instance creation also
> fails if I try 'db2icrt ...' from the cmd line.

> What is boggling is that I was able to create 2 instances without any
> problems, then this error started occuring on the third instance.

> The error log lists 'SQL10003C There are not enough system resources
> to process the request...' - is there any way to tweak kernel
> parameters (mentioned above) to prevent this error?
> Thanks in advance for any help,
> Jon Allen



Thu, 19 Aug 2004 05:29:44 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
The MSGMNI parameter was it.  I set it to 1024 (via Phil's recommended
echo cmd below) and then installed db2, and created as many instances
as I needed.  Each instance created ok and auto-started ok as well.
Thanks a lot for the tip, I'll custom-build a kernel with this
setting.  This was a real lifesaver!

Jon Allen

Quote:

> I suspect you are having a problem with MSGMNI (one of the kernel
> parameters).  There is some information about this in the DB2-HOWTO on
> http://www.linuxdoc.org.

> If I remember the value set by RH7.2 by default is something like 64 (an
> increase from the default in the kernel source which I think is 16).  For
> some reason this value is a lot less that was the default on V2.2
> kernels.

> I've got mine set to 1024.

> Try :-

> echo 1024 >/proc/sys/kernel/msgmni

> and then try creating the new instance again.

> To set this permananently, you can either issue this command at system
> boot or you can recompile your own kernel, changing the appropriate
> source file (linux/include/linux/msg.h and then find MSGMNI).

> HTH

> Phil Nelson
> Database Consultant
> ScotDB Limited



Sat, 21 Aug 2004 01:52:22 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
Ro,

I have gotten this to work by setting MSGMNI to 1024 (please see my
response to Phil's post).  Can this be set in /etc/sysctl.conf?  I
will try to find out.  When I had the problem, I was creating and
autostarting instances via the db2setup utility.  At the point where I
couldn't create a third instance, I couldn't start any instances
either.  Db2 was effectively unusable at this point.

Jon

Quote:

> Check /etc/sysctl.conf for msgmni setting.
> Are you able to 'create' two instances but cannot 'create' the 3rd one or are
> you able 'start' two instances and cannot 'start' the 3rd one?
> 'create' = db2icrt
> 'start' = db2start

> See http://www.linux.org/docs/ldp/howto/DB2-HOWTO/index.html

> Ro




Sat, 21 Aug 2004 01:56:12 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21
Nevermind, I found the setting in the HOWTO (before installing db2
section).  Another case of RTFM.  Thanks.
Quote:

> Check /etc/sysctl.conf for msgmni setting.
> Are you able to 'create' two instances but cannot 'create' the 3rd one or are
> you able 'start' two instances and cannot 'start' the 3rd one?
> 'create' = db2icrt
> 'start' = db2start

> See http://www.linux.org/docs/ldp/howto/DB2-HOWTO/index.html



Sat, 21 Aug 2004 01:59:35 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21

Quote:

> I am trying to install DB2 on Red Hat kernel 2.4.9-21 and it keeps on
> failing during the creation of the database Instances.  Is this due to
> the 2.4.9*** kernel.  I have no problems with 2.4.2** Kernel.  Any
> Info?

I installed DB2 7.1 PDE and all the fixpacks on RHL 7.2 with all the
updates (including kernel-2.4.9-31).  So, yes, it did install with no
problems by following the DB2 HowTo document for RHL7.1 with only a
few variations (such as installing the ncurses4 package instead of
compat-libs to get the required libncurses.so.4 file, and installing
the *real* Korn shell from kornshell.com).

--
Forte International, P.O. Box 1412, Ridgecrest, CA  93556-1412

President, CEO                             Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084  4A88 8851 E6C8 69E3 B00B



Tue, 24 Aug 2004 06:03:19 GMT
 Installing db2 7.2 on Linux kernel 2.4.9-21

Quote:

> Thanks a lot for the tip, I'll custom-build a kernel with this
> setting.

Egads, no!  Just put "kernel.msgmni = 1024" in /etc/sysctl.conf like
RedHat was designed to do...  Then you can continue to apply kernel
security updates and never have to worry about it again!

--
Forte International, P.O. Box 1412, Ridgecrest, CA  93556-1412

President, CEO                             Fax: (760) 499-9152
My GPG fingerprint: C3AF 4BE9 BEA6 F1C2 B084  4A88 8851 E6C8 69E3 B00B



Tue, 24 Aug 2004 06:06:47 GMT
 
 [ 12 post ] 

 Relevant Pages 

1. DB2 UDB PE for Linux 7.2 install problems (segfaults)

2. Oracle installation pb on Suse Linux 7.2 (Kernel 2.4.4) : ORA-24323, ORA-03113

3. Oracle 8.1.7 on Linux Redhat 7.2 or whatever kernel 2.4

4. ASE 12.5 installation on Linux 7.2 kernel 2.4

5. Red Hat Linux 7.2 auto login user does not know db2 environment

6. Problem with Linux DB2 7.2 installation

7. DB2 UDB 7.2 and RedHat Linux

8. Need Urgent Help on UDFs of DB2 7.2 on Linux

9. db2 7.2 installer hanges on linux mandrake

10. UDF error on DB2 7.2 on Linux 7.1

11. Calculating the space utilised by each user in db2 7.2 on Linux 7.1

12. db2 version 7.2 on Linux


 
Powered by phpBB® Forum Software