IBM DB2 UDB EEE for Linux 
Author Message
 IBM DB2 UDB EEE for Linux

Hi everybody,

I having serious problems trying to use this software.
I trying to install it on two nodes. I would like that it work with 2
database
partitions, one on each machine.
The machines works with NIS and NFS and the /home directories are seen
by both
machines.
My sqllib/db2nodes.cfg is like this:
0 comp1 0
1 comp2 0

I followed the instructions of the Quick Beginnings EEE but it did not
work out.
The problem start already when I launch INSTHOME/sqllib/adm/db2start
The error message is:

SQL5043N  Support for one or more communications protocols failed to
start
successfully. However, core database manager functionality started
successfully.

After this, when I see which ports are open, the port 523 is open only
in the
machine I lauched the command. I don't know if it's normal.

I read IBM's Message Reference and that tips didn't help. The only one
that I
couldn't check is the environment variables that I don't know which
ones ought to be set.

Another thing that doesn't work is db2cclst. The deamon just don't
start. At
least it seems so.

When I try to create a sample database more errors come again:

SQL0901N  The SQL statement failed because of a non-severe system
error.
Subsequent SQL statements can be processed.  (Reason "Invalid Request
type for DB2 Admin Server".)

I really don't know what to do. I hope to get some help.
Thanks in advance,

Gabriela Jacques



Tue, 14 Sep 2004 02:58:23 GMT
 IBM DB2 UDB EEE for Linux

Hello Gabriella,
1, is you see port 523, you're probably seeing the port for the db2
administration
instance. This instance is not supposed to host databases.

2, you have to let the instance launch rsh cmds to the other nodes (logical
partitions).
Try rsh loopback ls -a. if nothing or an error returns, then add +
db2_you_instance_name in
the .rhosts file (also make sure that linux as the rsh daemon started, not
default on Linux).

3, you need to have DB2COMM=TCPIP  (db2set -all)

4, You don't need to launch INSTHOME/sqllib/adm/db2start
    You just have to run " . $HOME/sqllib/db2profile " (add it to .profile)
    then db2start

Hope this help , Sylv1.



Tue, 14 Sep 2004 04:22:56 GMT
 IBM DB2 UDB EEE for Linux
Gabriela,

the error you see is related to the SVCENAME parameter. Please check "db2
get dbm cfg | grep SVCENAME" for the settings and update accordingly in the
/etc/services and in the dbm with "db2 update dbm cfg using SVCENAME foobar"
where foobar is the port entry in /etc/services (eg. "xmydbport 9988/tcp" ).
This solves the first error and has nothing to do with the 523.

Then try to start and stop the database instance with "db2start". This
should work now without an error.

The next thing is tyo make sure that host file etc are clean. E.g. RedHat
adds the local machine name to 127.0.0.1 under some conditions (which is
total garbage). Remove that and leave the classic 127.0.01 localhost as a
clean entry.

bcb


Quote:
> Hi everybody,

> I having serious problems trying to use this software.
> I trying to install it on two nodes. I would like that it work with 2
> database
> partitions, one on each machine.
> The machines works with NIS and NFS and the /home directories are seen
> by both
> machines.
> My sqllib/db2nodes.cfg is like this:
> 0 comp1 0
> 1 comp2 0

> I followed the instructions of the Quick Beginnings EEE but it did not
> work out.
> The problem start already when I launch INSTHOME/sqllib/adm/db2start
> The error message is:

> SQL5043N  Support for one or more communications protocols failed to
> start
> successfully. However, core database manager functionality started
> successfully.

> After this, when I see which ports are open, the port 523 is open only
> in the
> machine I lauched the command. I don't know if it's normal.

> I read IBM's Message Reference and that tips didn't help. The only one
> that I
> couldn't check is the environment variables that I don't know which
> ones ought to be set.

> Another thing that doesn't work is db2cclst. The deamon just don't
> start. At
> least it seems so.

> When I try to create a sample database more errors come again:

> SQL0901N  The SQL statement failed because of a non-severe system
> error.
> Subsequent SQL statements can be processed.  (Reason "Invalid Request
> type for DB2 Admin Server".)

> I really don't know what to do. I hope to get some help.
> Thanks in advance,

> Gabriela Jacques



Wed, 15 Sep 2004 21:58:17 GMT
 IBM DB2 UDB EEE for Linux
Hello!

I tried both solutions, but neither of them worked. (unfunfortunatly)
another sugestion?
thanks again.

Gabriela

Quote:

> Gabriela,

> the error you see is related to the SVCENAME parameter. Please check "db2
> get dbm cfg | grep SVCENAME" for the settings and update accordingly in the
> /etc/services and in the dbm with "db2 update dbm cfg using SVCENAME foobar"
> where foobar is the port entry in /etc/services (eg. "xmydbport 9988/tcp" ).
> This solves the first error and has nothing to do with the 523.

> Then try to start and stop the database instance with "db2start". This
> should work now without an error.

> The next thing is tyo make sure that host file etc are clean. E.g. RedHat
> adds the local machine name to 127.0.0.1 under some conditions (which is
> total garbage). Remove that and leave the classic 127.0.01 localhost as a
> clean entry.

> bcb



> > Hi everybody,

> > I having serious problems trying to use this software.
> > I trying to install it on two nodes. I would like that it work with 2
> > database
> > partitions, one on each machine.
> > The machines works with NIS and NFS and the /home directories are seen
> > by both
> > machines.
> > My sqllib/db2nodes.cfg is like this:
> > 0 comp1 0
> > 1 comp2 0

> > I followed the instructions of the Quick Beginnings EEE but it did not
> > work out.
> > The problem start already when I launch INSTHOME/sqllib/adm/db2start
> > The error message is:

> > SQL5043N  Support for one or more communications protocols failed to
> > start
> > successfully. However, core database manager functionality started
> > successfully.

> > After this, when I see which ports are open, the port 523 is open only
> > in the
> > machine I lauched the command. I don't know if it's normal.

> > I read IBM's Message Reference and that tips didn't help. The only one
> > that I
> > couldn't check is the environment variables that I don't know which
> > ones ought to be set.

> > Another thing that doesn't work is db2cclst. The deamon just don't
> > start. At
> > least it seems so.

> > When I try to create a sample database more errors come again:

> > SQL0901N  The SQL statement failed because of a non-severe system
> > error.
> > Subsequent SQL statements can be processed.  (Reason "Invalid Request
> > type for DB2 Admin Server".)

> > I really don't know what to do. I hope to get some help.
> > Thanks in advance,

> > Gabriela Jacques



Sat, 18 Sep 2004 22:56:05 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. ibm.software.db2.udb.eee

2. DB2 EEE / Linux cluster, DB2 instance creation problem...

3. Performance Tuning for DB2 UDB EEE.

4. Tools to convert DB2/390 ddl to UDB EEE V7 or V8

5. DB2 UDB EEE Questions!

6. Installing Fixpack 6 for 32 version on Db2 Udb EEE v7.1 on solaris

7. UDB EEE on a LInux Cluster

8. DB2 UDB EEE v7.2 vs Oracle Real Application Clusters

9. UDB EEE on SUSE LINUX

10. DB2 UDB 6.1 EEE

11. DB2 UDB EEE on multiple platform

12. DB2 UDB 5.0 EEE on AIX 4.2.1 Snapshot Monitor Problem


 
Powered by phpBB® Forum Software